IT Skills and Data Analysis Course Notes

Introduction

  • IT Skills: Refers to the capabilities required to utilize computers for information processes.
  • Data Analysis: Involves examining data to discover insights, trends, or conclusions.

Course Overview

  • Type: Skill Enhancement Course (SEC)
  • Structure: 4 hours of practical sessions, 2 credits (2 lectures)
  • Assessment: Continuous assessment totalling 80 marks.

What is Data?

  • Definition: Data is a piece of information.
    • Examples:
      • Sun rises in the East.
      • Indian females are generally shorter than males.
      • Hansraj students score better on average compared to off-campus students.
  • Difference between Data and Facts:
    • Data can be incorrect, while facts are proven truths supported by data.

Data Analysis vs. Analytics

  • Analysis: Deeply studying data to extract facts, including:
    • Cleaning, organizing, storing, and governing.
  • Analytics: A broader discipline that includes:
    • Data management, tools, techniques, and data collection.
  • Key distinction: Analysis is a process; analytics encompasses processes and tools.

Data Analysis Course Focus

  • Scope: Focuses on understanding data, cleaning, organizing, representing, analyzing, and summarizing.
  • Difference from Statistics:
    • Data Analysis is beginner-oriented; Statistics is a more technical, theoretical discipline.

Important Concepts in Data

  1. Think Differently: Recognize that data encompasses various fields, not just economics.
  2. Variety of Data Types: Includes online reviews, survey data, etc.
  3. Essential Concepts: Understanding of variables, logical causality required.
  4. Use of Excel: Key for tasks like data cleaning, analysis, and graphical representation.

Syllabus Highlights

  • Two Units:
    • Statistics basics including datasets, variables, and frequency distribution.
    • Measures of central tendency (mean, median, mode) and dispersion (range, variance, standard deviation).
  • Application of statistical concepts using MS Excel.

DCOVA Strategy for Data

  1. Define: Identify the research question.
  2. Collect: Source required data.
  3. Organize: Develop data tables.
  4. Visualize: Create charts for data representation.
  5. Analyze: Draw conclusions from the data insights.

Understanding Variables

  • Definition: A variable is a piece of information with fluctuating values based on observation.
    • Examples: Breakfast habits, weight, names.
  • Types of Variables:
    • Numerical vs. Categorical
    • Discrete vs. Continuous.
  • Examples: Age in years (Discrete Numerical), ticking age categories (Categorical Discrete).

Levels of Measurement

  • Nominal: Categories without order.
  • Ordinal: Categories with order.
  • Interval: Numeric scale with equal distances, can go below zero.
  • Ratio: Numeric scale with an absolute zero, allows for the calculation of ratios.

Frequency and Distribution

  • Frequency: The count of observations appearing in a dataset.
  • Types of Frequency: Absolute, relative, percentage, and cumulative.
  • Constructing Frequency Distributions: Requires awareness of data range and class intervals.

Measures of Central Tendency and Dispersion

  1. Mean: Average value of a dataset.
    • Formula: extMean=extSumofObservationsextNumberofObservationsext{Mean} = \frac{ ext{Sum of Observations}}{ ext{Number of Observations}}
  2. Median: Middle value in an ordered dataset.
  3. Mode: Most frequently occurring value.
  4. Dispersion: Describes how data points vary from the mean.
    • Includes range, variance, and standard deviation.
    • Variance measures the average of squared deviations.
    • Standard deviation is the square root of variance.

Sampling Techniques

  • Types of Sampling:
    • Probability Sampling: Involves methods like simple random, stratified, and cluster sampling.
    • Non-Probability Sampling: Includes convenience sampling, quota sampling, and judgment sampling.
  • Importance: Sampling allows researchers to estimate population parameters effectively without exhaustive sampling.

Errors in Data Collection

  • Sampling Errors: Variability that occurs because a sample rather than the entire population is surveyed.
  • Non-Sampling Errors: Errors occurring at different study stages, potentially skewing results, including measurement errors and non-response bias.

Conducting a Primary Survey

  • Designing Questionnaires: Consider target populations, question types, and logical sequencing to ensure clarity and avoid fatigue.
  • Analysis: Use descriptive and inferential statistics to support conclusions drawn from the data surveyed.