Syllabus topics (RTMNU)
- Introduction to Advanced Statistics in Business Analytics
- Role of Statistics in Business Decision-Making
- Descriptive vs. Inferential Statistics
- Applications of Advanced Statistics in Business
- Data Types, Measurement Scales, and Data Collection
- Qualitative vs. Quantitative Data
- Levels of Measurement (Nominal, Ordinal, Interval, Ratio)
- Data Collection Techniques in Business Analytics
- Exploratory Data Analysis (EDA)
- Measures of Central Tendency (Mean, Median, Mode)
- Measures of Dispersion (Variance, Standard Deviation, IQR)
- Detecting Outliers using Boxplots and Z-scores
- Skewness and Kurtosis
- Graphical Representation of Data
- Histograms, Bar Charts, and Pie Charts
- Scatter Plots for Correlation Analysis
- Heatmaps, Treemaps, and Bubble Charts
- Box-and-Whisker Plots for Distribution Analysis
- Introduction to SPSS for EDA
- IBM SPSS Interface and Data Import
- Data Cleaning and Handling Missing Values
- Generating Summary Statistics and Charts in SPSS
Introduction to Advanced Statistics in Business Analytics – Role of Statistics in Business Decision-Making
Statistics is the science of collecting, organising, analysing and interpreting numerical data to take decisions under uncertainty. Advanced statistics goes beyond averages to probability, testing, regression, multivariate and non-parametric methods.
Role in business decisions:
- Planning and forecasting – estimating next year's sales or demand.
- Quality control – checking whether a product meets standards (control charts).
- Market research – understanding customer likes through surveys.
- Finance – risk, return and credit analysis in banks and mutual funds.
- HR – salary structure, performance and attrition analysis.
- Testing ideas – checking if a new advertisement really increased sales (hypothesis testing).
Descriptive vs. Inferential Statistics
| Basis | Descriptive statistics | Inferential statistics |
|---|---|---|
| Meaning | Summarises and describes the data in hand | Draws conclusions about a population from a sample |
| Tools | Mean, median, SD, charts, tables | Estimation, confidence intervals, hypothesis tests, regression |
| Uncertainty | No probability involved | Uses probability; results have a margin of error |
| Example | Average sales of 50 outlets last month = ₹4.2 lakh | From 50 outlets, estimating average sales of all 2,000 outlets |
Applications of Advanced Statistics in Business
Demand forecasting (time series), customer segmentation (cluster analysis), credit scoring (logistic regression), A/B testing of websites (t-test), quality improvement (Six Sigma), product preference studies (chi-square), and risk modelling (Monte Carlo simulation) – used by banks, FMCG companies like HUL, e-commerce firms and insurers.
Data Types, Measurement Scales and Data Collection – Qualitative vs. Quantitative Data
- Qualitative (categorical) data – describe qualities or categories: gender, brand used, city, satisfaction level.
- Quantitative (numerical) data – measured in numbers: income, sales, age. They are discrete (countable: number of customers) or continuous (any value: weight, time).
Levels of Measurement (Nominal, Ordinal, Interval, Ratio)
| Scale | Meaning | Example | Valid statistics |
|---|---|---|---|
| Nominal | Names/labels only, no order | Gender, PIN code, bank name | Count, mode |
| Ordinal | Categories with order, gaps not equal | Rank, rating: poor/good/excellent | Median, percentiles |
| Interval | Equal gaps, no true zero | Temperature °C, calendar year | Mean, SD |
| Ratio | Equal gaps and true zero | Sales, income, weight, age | All, including ratios |
Data Collection Techniques in Business Analytics
- Primary data – collected first-hand: surveys/questionnaires (Google Forms), interviews, observation, experiments (A/B tests), focus groups.
- Secondary data – already collected by others: company records, RBI and SEBI publications, Census, NSO reports, websites.
- Digital/automatic – POS billing systems, website and app logs, social media, sensors (IoT), web scraping.
Exploratory Data Analysis (EDA) – Measures of Central Tendency and Dispersion
EDA means first examining data with summaries and graphs to find patterns, errors and outliers before formal analysis (idea of J.W. Tukey).
- Mean = Σx/n; Median = middle value; Mode = most frequent value.
- Variance σ² = Σ(x − x̄)²/n (sample: ÷ n − 1); SD = √variance; IQR = Q₃ − Q₁.
Detecting Outliers using Boxplots and Z-scores
An outlier is a value far away from the rest. Boxplot rule: outlier if below Q₁ − 1.5×IQR or above Q₃ + 1.5×IQR. Z-score rule: z = (x − x̄)/σ; |z| > 3 is usually an outlier (for small samples |z| > 2 is treated as unusual).
Illustration 1: Monthly sales (₹ thousand) of 10 salesmen: 22, 25, 27, 28, 30, 30, 31, 33, 35, 60. Find mean, median, mode, variance, SD, IQR; check outliers and skewness.
| Sales x (₹ thousand) | x − x̄ | (x − x̄)² | z = (x − x̄)/σ |
|---|---|---|---|
| 22 | −10.1 | 102.01 | −1.01 |
| 25 | −7.1 | 50.41 | −0.71 |
| 27 | −5.1 | 26.01 | −0.51 |
| 28 | −4.1 | 16.81 | −0.41 |
| 30 | −2.1 | 4.41 | −0.21 |
| 30 | −2.1 | 4.41 | −0.21 |
| 31 | −1.1 | 1.21 | −0.11 |
| 33 | 0.9 | 0.81 | 0.09 |
| 35 | 2.9 | 8.41 | 0.29 |
| 60 | 27.9 | 778.41 | 2.80 |
| 321 | 0 | 992.90 |
- Mean = 321/10 = 32.1; Median = (30 + 30)/2 = 30; Mode = 30.
- Variance = 992.90/10 = 99.29; SD = √99.29 = 9.96.
- Q₁ (2.75th value) = 25 + 0.75(27 − 25) = 26.5; Q₃ (8.25th value) = 33 + 0.25(35 − 33) = 33.5; IQR = 7.
- Fences: 26.5 − 10.5 = 16 and 33.5 + 10.5 = 44. 60 > 44, so 60 is an outlier. Its z-score is 2.80 (above 2, unusual for a sample of 10).
- Karl Pearson's skewness = 3(Mean − Median)/SD = 3(32.1 − 30)/9.96 = +0.63 → positively skewed (long right tail, caused by 60).
Illustration 2 (comparing with z-scores): A student scored 72 in Accounts (class mean 60, SD 8) and 65 in Statistics (mean 50, SD 5). z(Accounts) = (72 − 60)/8 = 1.5; z(Statistics) = (65 − 50)/5 = 3.0. Relative performance is better in Statistics.
Skewness and Kurtosis
Skewness measures lack of symmetry. Symmetric: mean = median = mode. Positive skew: mean > median > mode (e.g. income). Negative skew: mean < median < mode. Bowley's coefficient = (Q₃ + Q₁ − 2Median)/(Q₃ − Q₁).
Kurtosis measures peakedness/tail heaviness compared to the normal curve: mesokurtic (normal, β₂ = 3), leptokurtic (tall peak, heavy tails, β₂ > 3), platykurtic (flat, β₂ < 3). β₂ = μ₄/μ₂². SPSS reports "excess kurtosis" = β₂ − 3.
Graphical Representation of Data – Histograms, Bar Charts and Pie Charts
- Histogram – adjoining bars for continuous class intervals; shows shape of distribution.
- Bar chart – separate bars for categories (sales by region).
- Pie chart – circle divided into sectors showing shares of a total (market share); angle = (value/total) × 360°.
Scatter Plots for Correlation Analysis
Points plotted for pairs (x, y). Upward pattern = positive correlation, downward = negative, no pattern = no correlation. Also shows outliers and non-linear patterns.
Heatmaps, Treemaps and Bubble Charts
- Heatmap – a grid where colour intensity shows value (sales by store × month, correlation matrix).
- Treemap – nested rectangles whose area shows size (sales by category and sub-category).
- Bubble chart – scatter plot where bubble size shows a third variable (x = price, y = sales, size = profit).
Box-and-Whisker Plots for Distribution Analysis
Shows the five-number summary: minimum, Q₁, median, Q₃, maximum. The box covers the IQR, whiskers extend to the last non-outlier values, and outliers appear as dots. Useful to compare branches or products side by side.
Introduction to SPSS for EDA – IBM SPSS Interface and Data Import
SPSS (Statistical Package for the Social Sciences, now IBM SPSS Statistics) is menu-driven software for analysis. Windows: Data View (rows = cases, columns = variables), Variable View (name, type, label, values, measure scale), Output Viewer (results) and Syntax Editor. Import: File → Open → Data (Excel, CSV, text).
Data Cleaning and Handling Missing Values
Check wrong codes and duplicates (Data → Identify Duplicate Cases), define missing values in Variable View, and treat them by deleting cases (listwise/pairwise) or replacing with mean/median (Transform → Replace Missing Values).
Generating Summary Statistics and Charts in SPSS
Analyze → Descriptive Statistics → Frequencies (tables, mode, percentiles, charts), Descriptives (mean, SD, z-scores via "Save standardized values"), Explore (boxplots, outliers, skewness, kurtosis). Graphs → Chart Builder for histograms, bar, pie and scatter charts.
Likely exam questions
- (Long, 8/16 marks) Explain the role of statistics in business decision-making. Distinguish between descriptive and inferential statistics, and explain the four levels of measurement with examples.
- (Long, 8/16 marks) What is Exploratory Data Analysis? Monthly sales (₹ thousand) of 10 salesmen are 22, 25, 27, 28, 30, 30, 31, 33, 35, 60. Calculate mean, median, standard deviation and IQR, detect outliers using the boxplot rule and z-scores, and comment on skewness.
- (Short, 4 marks) Distinguish between qualitative and quantitative data.
- (Short, 4 marks) Explain skewness and kurtosis with diagrams in words.
- (Short, 4 marks) Explain heatmaps, treemaps and bubble charts.