Skip to Main Content
COM3MN210 • Data Analytics with Statistical Software
Module 2
Calicut University • B.Com • Semester 3

Data Analytics with Statistical Software (COM3MN210) — Module 2: Inferential Statistics

Lecture Notes • Complete Study Material

Executive Overview & Theoretical HorizonCALICUT UNIVERSITY • B.COM HONOURS

While descriptive statistics serve to organize, summarize, and tabulate the empirical properties of an observed sample, Inferential Statistics enables business researchers to make probabilistic deductions about an entire unobserved target population based on sample data. In corporate research, inferential analytics bridges the gap between limited empirical evidence and executive decision-making under uncertainty. This module examines the foundational architecture of hypothesis formulation, the formal mechanics of statistical significance testing in SPSS, the application and interpretation of the Non-Parametric Chi-Square (χ²) Test of Independence, and Bivariate Correlation Analysis spanning Pearson's parametric and Spearman's non-parametric formulations.

2.1 Hypothesis Formulation & Testing Architecture in SPSS

The Logic of Statistical Inference

In corporate commerce, surveying an entire consumer census is economically prohibitive. Instead, analysts draw a representative random sample of size n from a broader target population of size N. Sample statistics (such as the sample mean x̄ or sample proportion p) serve as point estimates of underlying population parameters (such as the true population mean μ or proportion P).

Because samples inevitably exhibit sampling error—natural random variation from one sample draw to another—inferential statistical testing provides a rigorous probabilistic framework to determine whether an observed business outcome reflects a genuine real-world effect or merely random sampling fluctuations.

[INFERENTIAL REASONING PIPELINE] Target Population (N) ---> Representative Random Sampling ---> Observed Sample (n) | Theoretical Deduction <--- Hypothesis Testing in SPSS <--- Compute Sample Statistics (Generalize to Population) (Compute Test Statistic & p-value) (Mean, Variance, Correlation)

Formulating the Null and Alternative Hypotheses

Every statistical investigation requires the formal specification of two mutually exclusive and exhaustive propositions:

The Null Hypothesis (H₀)

Represents the benchmark proposition of "no effect", "no difference", or "no association". It presumes that any observed difference in sample data is purely the artifact of chance and sampling error. In statistical modeling, H₀ is assumed true until empirical evidence demonstrates otherwise beyond a reasonable doubt.

Examples:
• H₀: μ₁ = μ₂ (No difference in mean sales between Region A and Region B).
• H₀: ρ = 0 (No linear correlation between advertising budget and revenue).

The Alternative Hypothesis (H₁ or Hₐ)

The research hypothesis that the investigator seeks to validate. It asserts the presence of a real relationship, treatment effect, or parameter divergence in the population.

Directional (One-Tailed) vs. Non-Directional (Two-Tailed):
Two-Tailed (Non-Directional): H₁: μ₁ ≠ μ₂ (Tests for any significant difference in either direction).
One-Tailed (Directional): H₁: μ₁ > μ₂ (Predicts specifically that Region A will outperform Region B). Standard corporate research defaults to two-tailed tests to remain objective.

The Decision Framework: Type I & Type II Errors and Significance Levels

Because statistical inference relies on probability rather than absolute certainty, decision-makers are exposed to two fundamental categories of decision error:

Reality in Population →
Statistical Decision ↓
Null Hypothesis (H₀) is TRUE
(No real business effect exists)
Null Hypothesis (H₀) is FALSE
(A real business effect exists)
Reject H₀
(Claim an effect exists)
Type I Error (α - Alpha)
"False Positive"
Rejecting a true null hypothesis. Example: Concluding a new ad campaign drives sales when it actually has no effect. Probability = Significance Level (α = 0.05).
Correct Decision (1 - β)
Statistical Power
Correctly detecting and validating a real market effect. Standard target power is 0.80 (80%).
Fail to Reject H₀
(Claim no effect detected)
Correct Decision (1 - α)
Confidence Level
Correctly maintaining the status quo when no real difference exists (typically 0.95 or 95%).
Type II Error (β - Beta)
"False Negative"
Failing to reject a false null hypothesis. Example: Abandoning a viable product launch because the sample was too small to detect the true positive effect.

The p-value Decision Rule in SPSS

In IBM SPSS, the analyst does not manually calculate critical rejection regions from statistical tables. Instead, SPSS outputs the exact p-value, labeled in output tables as "Sig. (2-tailed)" or "Asymptotic Significance".

The Fundamental p-value Decision Benchmark:
If p-value ≤ α (e.g., Sig. ≤ 0.05): Reject the Null Hypothesis (H₀). The result is Statistically Significant. There is sufficient empirical evidence to support the research hypothesis H₁.
If p-value > α (e.g., Sig. > 0.05): Fail to Reject the Null Hypothesis (H₀). The result is Not Statistically Significant. The observed difference can be reasonably attributed to random sampling variation.

2.2 The Chi-Square (χ²) Test of Independence in SPSS

Theoretical Framework & Business Scope

The Pearson Chi-Square (χ²) Test of Independence is a non-parametric statistical procedure used to evaluate whether a significant relationship exists between two categorical (nominal or ordinal) variables. In business research, it answers questions such as:

  • Is customer brand preference (Brand A vs. Brand B vs. Brand C) dependent on gender (Male vs. Female)?
  • Is customer loan default status (Default vs. Non-Default) associated with occupational category (Salaried vs. Self-Employed vs. Professional)?
  • Does consumer subscription churn depend on preferred payment method (Credit Card vs. UPI vs. Net Banking)?

Mathematical Foundation & Calculation of Expected Frequencies

The test compares the Observed Frequencies (O)—the actual case counts tallying in each cell of a cross-tabulation grid—against the Expected Frequencies (E)—the theoretical counts that would occur if the two variables were completely independent.

Formula for Expected Cell Frequency:
E = (Row Total × Column Total) / Grand Total (N)

Pearson Chi-Square Test Statistic:
χ² = ∑ [ (O - E)² / E ]

Degrees of Freedom (df):
df = (r - 1) × (c - 1)      (where r = number of rows, c = number of columns)

Underlying Assumptions and Special Adjustments

  • Categorical Data: Both variables must be nominal or ordinal. Continuous variables must be recoded into discrete bins before running Chi-Square.
  • Mutual Exclusivity: Each subject or observation belongs to one and only one cell.
  • Cochran's Minimum Cell Frequency Rule: For the test to be mathematically valid, no cell should have an expected frequency less than 1, and no more than 20% of the cells should have expected frequencies less than 5.
  • Continuity Correction (Yates' Correction): For 2 × 2 contingency tables, SPSS reports Continuity Correction, which subtracts 0.5 from the absolute difference |O - E| to adjust for the continuous approximation of a discrete distribution.
  • Fisher's Exact Test: Automatically computed by SPSS for 2 × 2 tables when expected cell counts violate the sample size assumption (E < 5).

Quantifying Effect Size: Phi and Cramér's V

A statistically significant Chi-Square test indicates that an association exists, but does not communicate the practical magnitude or strength of the relationship. SPSS computes normalized effect size metrics:

MetricTable GeometryInterpretation Scale
Phi (φ) CoefficientStrictly 2 × 2 contingency tablesRanges from 0 to 1.0. (0.10 = Small effect, 0.30 = Moderate effect, 0.50+ = Large effect).
Cramér's V (V)Tables larger than 2 × 2 (e.g., 3 × 3, 2 × 4)Adjusts for table dimensions. Ranges from 0 to 1.0. Serves as the universal standard for multi-category tables.

Step-by-Step SPSS Execution Protocol for Chi-Square

[SPSS NAVIGATION WORKFLOW: CHI-SQUARE TEST OF INDEPENDENCE] 1. Menu Path: Analyze -> Descriptive Statistics -> Crosstabs... 2. Variable Allocation: - Move the Independent/Predictor variable (e.g., "Customer_Gender") into the "Row(s)" box. - Move the Dependent/Outcome variable (e.g., "Product_Preference") into the "Column(s)" box. 3. Statistics Dialog: - Click the "Statistics..." button on the right panel. - Check the box for "Chi-square". - Check the box for "Phi and Cramer's V" under Nominal measures. - Click Continue. 4. Cells Display Dialog: - Click the "Cells..." button. - Under Counts: Check "Observed" AND "Expected". - Under Percentages: Check "Row", "Column", and "Total" (essential for reporting percentage breakdowns). - Click Continue. 5. Execution: Click "OK" (or click "Paste" to inspect command syntax).

Interpreting SPSS Chi-Square Output Tables

Reading the SPSS "Chi-Square Tests" Output:

Examine the table labeled Chi-Square Tests:

  • Locate the top row: Pearson Chi-Square.
  • Inspect the Value column (χ² statistic), the df column (degrees of freedom), and the Asymptotic Significance (2-sided) column (p-value).
  • Rule: If Asymp. Sig. < 0.05, we reject H₀ and conclude there is a statistically significant association between the two variables.
  • Inspect the footnote below the table: SPSS explicitly states: "0 cells (0.0%) have expected count less than 5. The minimum expected count is 14.20." If the percentage exceeds 20%, Cochran's assumption is violated, and the analyst should either combine categories or report Fisher's Exact Test.

2.3 Bivariate Correlation Analysis in SPSS

Theoretical Framework & Nature of Correlation

Correlation Analysis investigates the degree, strength, and direction of linear association between two numerical or ordinal variables. It does not imply cause-and-effect; rather, it quantifies co-variation—the tendency of two variables to vary systematically together.

Direction of Association

Positive Correlation (+): As variable X increases, variable Y increases systematically (e.g., Advertising expenditure and Total sales revenue).
Negative Correlation (-): As variable X increases, variable Y decreases systematically (e.g., Product price and Sales volume demanded; Employee stress and Job satisfaction).
Zero / Negligible Correlation (0): No systematic relationship exists (e.g., Employee shoe size and Annual sales volume).

Magnitude Benchmark Guidelines

The correlation coefficient (r) spans strictly from -1.00 to +1.00:
0.00 to ±0.29: Weak / Negligible association.
±0.30 to ±0.49: Moderate association.
±0.50 to ±0.69: Substantial / Strong association.
±0.70 to ±0.99: Very strong / Very high association.
±1.00: Perfect deterministic linear relationship.

Pearson's Product-Moment Correlation Coefficient (r)

Pearson's r is the premier parametric measure of linear association for two continuous, metric (Scale) variables. It requires that both variables exhibit bivariate normality, linearity, and homoscedasticity without influential multivariate outliers.

Pearson Correlation Mathematical Formula:
r = ∑ [ (X - X̄)(Y - Ȳ) ] / √[ ∑(X - X̄)² × ∑(Y - Ȳ)² ]

The Coefficient of Determination (r²):
Squaring Pearson's r yields , which quantifies the proportion of total variance in Y that is directly explained or accounted for by its linear relationship with X.
Example: If r = 0.80 between Training Hours and Employee Productivity, r² = (0.80)² = 0.64 (64% of the variance in productivity is explained by training).

Non-Parametric Alternatives: Spearman's Rank & Kendall's Tau-b

When research data fails the stringent parametric assumptions of normality, or when data is measured on an ordinal scale (such as Likert satisfaction ratings, rankings, or performance tiers), non-parametric correlation techniques are deployed:

  • Spearman's Rank-Order Correlation (ρ - Rho / rₛ): Computes Pearson's r on the converted rank orders of the data rather than raw scores. It evaluates monotonic relationships—whether variables change in the same general direction, even if non-linearly.
  • Kendall's Tau-b (τᵦ): A robust non-parametric measure based on concordant and discordant pairs of observations. It is mathematically superior to Spearman's rho when the dataset has a small sample size or a substantial number of tied ranks.

Step-by-Step SPSS Execution Protocol for Correlation

[SPSS NAVIGATION WORKFLOW: BIVARIATE CORRELATION] 1. Menu Path: Analyze -> Correlate -> Bivariate... 2. Variable Selection: - Select two or more continuous/ordinal variables (e.g., "Monthly_Advertising_Spend" and "Monthly_Revenue"). - Move them into the "Variables:" box. 3. Correlation Coefficients Selection: - Check "Pearson" for normal continuous scale variables. - Check "Spearman" and/or "Kendall's tau-b" for ranked/ordinal variables or skewed distributions. 4. Test of Significance: - Select "Two-tailed" (standard research convention). - Ensure "Flag significant correlations" is checked (automatically places * for p < 0.05 and ** for p < 0.01). 5. Options: Click "Options..." -> Check "Means and standard deviations" -> Select "Exclude cases pairwise" -> Click Continue. 6. Execution: Click "OK".

Interpreting the SPSS Correlation Matrix

Reading the SPSS "Correlations" Output Matrix:

The output presents a symmetric matrix where every variable is paired against every other variable:

  • The diagonal cells show the correlation of each variable with itself (always Pearson Correlation = 1.000).
  • Each off-diagonal cell displays three critical numbers:
    1. Pearson Correlation: The direction and magnitude of association (e.g., 0.732**).
    2. Sig. (2-tailed): The exact p-value (e.g., .000, which indicates p < 0.001).
    3. N: The total number of valid paired cases included in the computation.
  • Academic Interpretation: "A Pearson product-moment correlation was run to determine the relationship between advertising spend and revenue. There was a strong, positive, statistically significant linear correlation between the two variables, r(98) = .732, p < .001."

2.4 Comprehensive Review & Self-Assessment Exercises

Section A: Conceptual & Objective Review Questions
  1. Differentiate between a Null Hypothesis (H₀) and an Alternative Hypothesis (H₁). Why does statistical testing always focus on evaluating the plausibility of the Null Hypothesis?
  2. What is the formal definition of a Type I Error in business decision-making? How is its probability mathematically controlled by the researcher?
  3. Explain the exact mathematical rule used in SPSS to decide whether to reject or fail to reject the null hypothesis based on the reported Sig. (2-tailed) value.
  4. Under what circumstances must a researcher use Spearman's Rank Correlation instead of Pearson's Product-Moment Correlation?
  5. What does Cochran's Rule state regarding expected cell frequencies in a Chi-Square Test of Independence, and what corrective action is taken if the rule is violated?
Section B: Short Answer & Analytical Questions
  1. A marketing analyst finds a Pearson correlation of r = -0.68 (p = 0.002) between product price and customer repeat purchase rate. Calculate and interpret the Coefficient of Determination (r²) for this business scenario.
  2. Explain the conceptual difference between Statistical Significance (p < 0.05) and Practical Significance / Effect Size (Phi, Cramér's V, r²). Why can a tiny, practically trivial difference appear statistically significant in very large sample sizes?
  3. Describe the function and interpretation of Yates' Continuity Correction and Fisher's Exact Test in SPSS crosstabulation analysis.
  4. Detail the step-by-step navigation path in SPSS to perform a Bivariate Correlation analysis, specifying the settings required for descriptive statistics and significance flagging.
Section C: Practical Scenario & Data Interpretation Problems

Scenario Problem: A retail supermarket chain in Kozhikode surveys 300 customers to evaluate whether payment preference (Cash, Credit Card, Mobile UPI) is independent of customer age group (≤ 30 years, 31-50 years, > 50 years). The SPSS Chi-Square output reports:

Pearson Chi-Square Value: 24.852 Degrees of Freedom (df): 4 Asymptotic Significance (2-sided): .000 Cramér's V Value: .204, Approx. Sig.: .000 0 cells (0.0%) have expected count less than 5. Minimum expected count is 18.40.
  1. Formulate the appropriate Null (H₀) and Alternative (H₁) hypotheses for this business study.
  2. Evaluate whether the assumptions for the Chi-Square test are satisfied based on the reported output.
  3. Interpret the Pearson Chi-Square value and significance level. State your statistical decision and commercial conclusion for executive management.
  4. Interpret the magnitude of association using the reported Cramér's V value.
COM3MN210Data Analytics with Statistical Software

Download Module 2 Notes (PDF)

Calicut University • FYUGP 2024 Syllabus

Download PDF

Finished this module?

Continue reading the next module or return to the subject overview.