Skip to main content

CT1 Sample Questions — Batch 1: Descriptive Statistics & Correlation

This document provides rigorous, textbook-style solutions for the descriptive statistics and correlation questions (Q1, Q2, Q3, and Q14) from the IFS UNIT - 1 & 2 sample questions sheet. All formulas are rendered in LaTeX, with step-by-step mathematical derivations and formal academic inferences.


Question 1: Comprehensive Descriptive Statistics, Covariance & Correlation

Given Data

Let XX denote Sales and YY denote Expenditure. X={15,18,25,27,30,35},n=6X = \{15, 18, 25, 27, 30, 35\}, \quad n = 6 Y={50,65,82,95,110,120},n=6Y = \{50, 65, 82, 95, 110, 120\}, \quad n = 6


Step-by-Step Preliminary Calculations

First, we construct the summation and deviation tables for both variables to compute all subsequent metrics.

Table 1: Sales (XX) Deviations and Moments (Xˉ=25\bar{X} = 25)

iixix_i(xiXˉ)(x_i - \bar{X})(xiXˉ)2(x_i - \bar{X})^2(xiXˉ)3(x_i - \bar{X})^3(xiXˉ)4(x_i - \bar{X})^4
11510-101001001000-10001000010000
2187-74949343-34324012401
32500000000
4272244881616
530552525125125625625
6351010100100100010001000010000
\sum15015000278278210-2102304223042

Table 2: Expenditure (YY) Deviations and Moments (Yˉ=87\bar{Y} = 87)

iiyiy_i(yiYˉ)(y_i - \bar{Y})(yiYˉ)2(y_i - \bar{Y})^2(yiYˉ)3(y_i - \bar{Y})^3(yiYˉ)4(y_i - \bar{Y})^4
15037-371369136950653-5065318741611874161
26522-2248448410648-10648234256234256
3825-52525125-125625625
49588646451251240964096
511023235295291216712167279841279841
6120333310891089359373593711859211185921
\sum522522003560356012810-1281035789003578900

Table 3: Cross-Product of Deviations

ii(xiXˉ)(x_i - \bar{X})(yiYˉ)(y_i - \bar{Y})(xiXˉ)(yiYˉ)(x_i - \bar{X})(y_i - \bar{Y})
110-1037-37370370
27-722-22154154
3005-500
422881616
5552323115115
610103333330330
\sum0000985985

Part A: Central Tendency

1. Arithmetic Mean (Xˉ,Yˉ\bar{X}, \bar{Y})

Definition: The sum of all observations divided by the total number of observations. Xˉ=1ni=1nxi=1506=25\bar{X} = \frac{1}{n} \sum_{i=1}^n x_i = \frac{150}{6} = 25 Yˉ=1ni=1nyi=5226=87\bar{Y} = \frac{1}{n} \sum_{i=1}^n y_i = \frac{522}{6} = 87

2. Median (MM)

Definition: The value splitting the sorted dataset into two equal halves. Let the ordered (sorted) observations be x(1),x(2),,x(n)x_{(1)}, x_{(2)}, \dots, x_{(n)} in ascending order.

  • If nn is odd: The median is the single middle value located at the n+12\frac{n+1}{2}-th position: M=x(n+12)M = x_{\left(\frac{n+1}{2}\right)}
  • If nn is even: The median is the arithmetic mean of the two middle values located at the n2\frac{n}{2}-th and (n2+1)\left(\frac{n}{2}+1\right)-th positions: M=x(n2)+x(n2+1)2M = \frac{x_{\left(\frac{n}{2}\right)} + x_{\left(\frac{n}{2}+1\right)}}{2}

Since n=6n = 6 is even in our datasets:

  • For XX: Sorted X={15,18,25,27,30,35}X = \{15, 18, 25, 27, 30, 35\} MX=x(3)+x(4)2=25+272=26M_X = \frac{x_{(3)} + x_{(4)}}{2} = \frac{25 + 27}{2} = 26
  • For YY: Sorted Y={50,65,82,95,110,120}Y = \{50, 65, 82, 95, 110, 120\} MY=y(3)+y(4)2=82+952=88.5M_Y = \frac{y_{(3)} + y_{(4)}}{2} = \frac{82 + 95}{2} = 88.5

3. Mode

Definition: The value that occurs with the highest frequency. Since all observations in XX and YY are unique, there is no unique mode. Using the empirical relationship (Karl Pearson): Mode3(Median)2(Mean)\text{Mode} \approx 3(\text{Median}) - 2(\text{Mean})

  • For XX: ModeX=3(26)2(25)=7850=28\text{Mode}_X = 3(26) - 2(25) = 78 - 50 = 28
  • For YY: ModeY=3(88.5)2(87)=265.5174=91.5\text{Mode}_Y = 3(88.5) - 2(87) = 265.5 - 174 = 91.5

Academic Inference (Central Tendency): Both Sales (XX) and Expenditure (YY) exhibit stable, well-defined central locations. The average Sales is Xˉ=25\bar{X} = 25 with a median of 2626, and the average Expenditure is Yˉ=87\bar{Y} = 87 with a median of 88.588.5. For both variables, the mean is slightly less than the median (Xˉ<MX\bar{X} < M_X and Yˉ<MY\bar{Y} < M_Y). Under Karl Pearson's empirical approximation, the modes are located at 2828 and 91.591.5, meaning that the mean, median, and mode satisfy the relation Mean<Median<Mode\text{Mean} < \text{Median} < \text{Mode}. This consistent ordering suggests that both distributions are mildly left-skewed.


Part B: Measures of Dispersion

1. Range (RR)

Definition: The difference between the maximum and minimum values in the dataset. RX=XmaxXmin=3515=20R_X = X_{\text{max}} - X_{\text{min}} = 35 - 15 = 20 RY=YmaxYmin=12050=70R_Y = Y_{\text{max}} - Y_{\text{min}} = 120 - 50 = 70

2. Quartiles and Quartile Deviation (QD)

Using the standard interpolation formula for continuous position estimation, the pp-th percentile position is P=k(n+1)4P = \frac{k(n+1)}{4}:

  • First Quartile (Q1Q_1): Position =1.75= 1.75
    • For XX: Q1,X=x(1)+0.75(x(2)x(1))=15+0.75(1815)=17.25Q_{1,X} = x_{(1)} + 0.75(x_{(2)} - x_{(1)}) = 15 + 0.75(18 - 15) = 17.25
    • For YY: Q1,Y=y(1)+0.75(y(2)y(1))=50+0.75(6550)=61.25Q_{1,Y} = y_{(1)} + 0.75(y_{(2)} - y_{(1)}) = 50 + 0.75(65 - 50) = 61.25
  • Third Quartile (Q3Q_3): Position =3×1.75=5.25= 3 \times 1.75 = 5.25
    • For XX: Q3,X=x(5)+0.25(x(6)x(5))=30+0.25(3530)=31.25Q_{3,X} = x_{(5)} + 0.25(x_{(6)} - x_{(5)}) = 30 + 0.25(35 - 30) = 31.25
    • For YY: Q3,Y=y(5)+0.25(y(6)y(5))=110+0.25(120110)=112.5Q_{3,Y} = y_{(5)} + 0.25(y_{(6)} - y_{(5)}) = 110 + 0.25(120 - 110) = 112.5

Quartile Deviation (Semi-Interquartile Range): QD=Q3Q12QD = \frac{Q_3 - Q_1}{2}

  • For XX: QDX=31.2517.252=142=7QD_X = \frac{31.25 - 17.25}{2} = \frac{14}{2} = 7
  • For YY: QDY=112.561.252=51.252=25.625QD_Y = \frac{112.5 - 61.25}{2} = \frac{51.25}{2} = 25.625

3. Variance (σ2\sigma^2) & Standard Deviation (σ\sigma)

We compute the population parameters (σ2,σ\sigma^2, \sigma):

  • Population Variance (σ2\sigma^2): σX2=(xiXˉ)2n=278646.3333\sigma_X^2 = \frac{\sum (x_i - \bar{X})^2}{n} = \frac{278}{6} \approx 46.3333 σY2=(yiYˉ)2n=35606593.3333\sigma_Y^2 = \frac{\sum (y_i - \bar{Y})^2}{n} = \frac{3560}{6} \approx 593.3333
  • Population Standard Deviation (σ\sigma): σX=46.33336.8069\sigma_X = \sqrt{46.3333} \approx 6.8069 σY=593.333324.3584\sigma_Y = \sqrt{593.3333} \approx 24.3584

Academic Inference (Absolute Dispersion): The absolute spread of Expenditure (YY) is significantly wider than that of Sales (XX). The range of Expenditure (RY=70R_Y = 70) is 3.53.5 times wider than Sales (RX=20R_X = 20). Similarly, the Quartile Deviation (QDY=25.625QD_Y = 25.625 vs. QDX=7QD_X = 7) and standard deviation (σY24.36\sigma_Y \approx 24.36 vs. σX6.81\sigma_X \approx 6.81) are multiple times larger. This reflects the scale differences of the raw data values; Expenditure values are much larger and naturally vary over a wider absolute numeric range, whereas Sales values are clustered tightly around a much lower center.


Part C: Relative Dispersion & Coefficients

1. Coefficient of Quartile Deviation

Coeff of QD=Q3Q1Q3+Q1\text{Coeff of QD} = \frac{Q_3 - Q_1}{Q_3 + Q_1}

  • For XX: Coeff of QDX=1448.50.2887\text{Coeff of QD}_X = \frac{14}{48.5} \approx 0.2887
  • For YY: Coeff of QDY=51.25173.750.2950\text{Coeff of QD}_Y = \frac{51.25}{173.75} \approx 0.2950

2. Coefficient of Standard Deviation

Coeff of SD=σMean\text{Coeff of SD} = \frac{\sigma}{\text{Mean}}

  • For XX: Coeff of SDX=6.8069250.2723\text{Coeff of SD}_X = \frac{6.8069}{25} \approx 0.2723
  • For YY: Coeff of SDY=24.3584870.2800\text{Coeff of SD}_Y = \frac{24.3584}{87} \approx 0.2800

3. Coefficient of Variation (CV)

CV=(σMean)×100%\text{CV} = \left(\frac{\sigma}{\text{Mean}}\right) \times 100\%

  • For XX: CVX=27.23%\text{CV}_X = 27.23\%
  • For YY: CVY=28.00%\text{CV}_Y = 28.00\%

Academic Inference (Relative Dispersion): To eliminate the scale effect and compare the dispersion of the two variables on an equal, unitless basis, we analyze the Coefficient of Variation (CV) and other relative coefficients.

  • Coefficient of QD: Coeff of QDX0.2887\text{Coeff of QD}_X \approx 0.2887 vs. Coeff of QDY0.2950\text{Coeff of QD}_Y \approx 0.2950.
  • Coefficient of SD: Coeff of SDX0.2723\text{Coeff of SD}_X \approx 0.2723 vs. Coeff of SDY0.2800\text{Coeff of SD}_Y \approx 0.2800.
  • Coefficient of Variation: CVX=27.23%CV_X = 27.23\% vs. CVY=28.00%CV_Y = 28.00\%.

Since all relative coefficients for Expenditure (YY) are slightly larger than those for Sales (XX), the relative dispersion of Expenditure is slightly higher than that of Sales. This indicates that Sales (XX) represents a more stable and consistent dataset relative to its mean, while Expenditure (YY) shows slightly higher relative fluctuation and lower consistency.


Part D: Measures of Distribution (Skewness & Kurtosis)

1. Central Moments (μk\mu_k)

μk=1ni=1n(xiXˉ)k\mu_k = \frac{1}{n} \sum_{i=1}^n (x_i - \bar{X})^k

  • For XX: μ2=278646.3333,μ3=2106=35,μ4=2304263840.3333\mu_2 = \frac{278}{6} \approx 46.3333, \quad \mu_3 = \frac{-210}{6} = -35, \quad \mu_4 = \frac{23042}{6} \approx 3840.3333
  • For YY: μ2=35606593.3333,μ3=128106=2135,μ4=35789006596483.3333\mu_2 = \frac{3560}{6} \approx 593.3333, \quad \mu_3 = \frac{-12810}{6} = -2135, \quad \mu_4 = \frac{3578900}{6} \approx 596483.3333

2. Skewness

  • Karl Pearson's Coefficient of Skewness (Sk,PS_{k,P}): Sk,P=3(MeanMedian)σS_{k,P} = \frac{3(\text{Mean} - \text{Median})}{\sigma}
    • For XX: Sk,PX=3(2526)6.8069=36.80690.4407S_{k,P}^X = \frac{3(25 - 26)}{6.8069} = \frac{-3}{6.8069} \approx -0.4407 (Left-skewed)
    • For YY: Sk,PY=3(8788.5)24.3584=4.524.35840.1847S_{k,P}^Y = \frac{3(87 - 88.5)}{24.3584} = \frac{-4.5}{24.3584} \approx -0.1847 (Left-skewed)
  • Moment-based Skewness (γ1\gamma_1): γ1=μ3μ21.5\gamma_1 = \frac{\mu_3}{\mu_2^{1.5}}
    • For XX: γ1,X=35(46.3333)1.5=35315.5340.1109\gamma_{1,X} = \frac{-35}{(46.3333)^{1.5}} = \frac{-35}{315.534} \approx -0.1109
    • For YY: γ1,Y=2135(593.3333)1.5=213514452.7930.1477\gamma_{1,Y} = \frac{-2135}{(593.3333)^{1.5}} = \frac{-2135}{14452.793} \approx -0.1477

3. Kurtosis

  • Moment-based Kurtosis (β2\beta_2 & Excess Kurtosis γ2\gamma_2): β2=μ4μ22,γ2=β23\beta_2 = \frac{\mu_4}{\mu_2^2}, \quad \gamma_2 = \beta_2 - 3
    • For XX: β2,X=3840.33332146.77781.7889    γ2,X=1.78893=1.2111(Platykurtic)\beta_{2,X} = \frac{3840.3333}{2146.7778} \approx 1.7889 \implies \gamma_{2,X} = 1.7889 - 3 = -1.2111 \quad (\text{Platykurtic})
    • For YY: β2,Y=596483.3333352044.44441.6943    γ2,Y=1.69433=1.3057(Platykurtic)\beta_{2,Y} = \frac{596483.3333}{352044.4444} \approx 1.6943 \implies \gamma_{2,Y} = 1.6943 - 3 = -1.3057 \quad (\text{Platykurtic})

Academic Inference (Distribution Shape):

  • Skewness: Both Karl Pearson's coefficient (Sk,PX0.4407,Sk,PY0.1847S_{k,P}^X \approx -0.4407, S_{k,P}^Y \approx -0.1847) and moment-based skewness (γ1,X0.1109,γ1,Y0.1477\gamma_{1,X} \approx -0.1109, \gamma_{1,Y} \approx -0.1477) are strictly negative. This confirms that both datasets are left-skewed (negatively skewed). The left tail is slightly elongated, showing a small density of lower-value records dragging the mean slightly below the median.
  • Kurtosis: Both datasets exhibit an excess kurtosis significantly below zero (γ2,X1.2111,γ2,Y1.3057\gamma_{2,X} \approx -1.2111, \gamma_{2,Y} \approx -1.3057). This classifies both distributions as Platykurtic (thin-tailed, flatter peak than a standard normal curve), representing stable, bounded variables with very low outlier probability.

Part E: Covariance and Correlation Co-efficient

1. Covariance (Cov(X,Y)\text{Cov}(X,Y))

Definition: A measure of the joint variability of two random variables.

  • Population Covariance (σXY\sigma_{XY}): σXY=1ni=1n(xiXˉ)(yiYˉ)=9856164.1667\sigma_{XY} = \frac{1}{n} \sum_{i=1}^n (x_i - \bar{X})(y_i - \bar{Y}) = \frac{985}{6} \approx 164.1667

2. Pearson Correlation Coefficient (rr)

Definition: The normalized measure of linear relationship strength. r=(xiXˉ)(yiYˉ)(xiXˉ)2(yiYˉ)2=985278×3560=985989680985994.82660.9901r = \frac{\sum (x_i - \bar{X})(y_i - \bar{Y})}{\sqrt{\sum (x_i - \bar{X})^2 \sum (y_i - \bar{Y})^2}} = \frac{985}{\sqrt{278 \times 3560}} = \frac{985}{\sqrt{989680}} \approx \frac{985}{994.8266} \approx 0.9901

Exam tip: A value of r0.9901r \approx 0.9901 indicates an extremely strong, almost perfect positive linear correlation. When sales increase, expenditure increases in a highly predictable linear fashion.

Academic Inference (Bivariate Relationship): The large positive covariance (σXY164.17\sigma_{XY} \approx 164.17) and nearly perfect Pearson's correlation coefficient (r0.9901r \approx 0.9901) reveal an extremely strong, positive linear association between Sales (XX) and Expenditure (YY). This implies that 98.03%98.03\% of the variation in Expenditure can be linearly explained by Sales (coefficient of determination r20.9803r^2 \approx 0.9803). In a corporate context, this signifies that as Sales scale up, company Expenditures rise in a highly systematic, predictable, and tightly coupled linear trajectory.


Question 2: Five-Point Summary and IQR

Given Data

The dataset contains paired variables XX and YY. Since they are univariate sequences, we compute the 5-point summaries separately. X={1,3,5,7,8,10},n=6X = \{1, 3, 5, 7, 8, 10\}, \quad n = 6 Y={8,12,15,17,18,20},n=6Y = \{8, 12, 15, 17, 18, 20\}, \quad n = 6


Step-by-Step Calculation

1. Five-Point Summary for XX

  • Minimum: 11
  • Q1Q_1 (First Quartile): Position =1(n+1)4=1.75= \frac{1(n+1)}{4} = 1.75th item Q1=1+0.75×(31)=2.5Q_1 = 1 + 0.75 \times (3 - 1) = 2.5
  • Median (Q2Q_2): Position =2(n+1)4=3.5= \frac{2(n+1)}{4} = 3.5th item Median=5+72=6.0\text{Median} = \frac{5 + 7}{2} = 6.0
  • Q3Q_3 (Third Quartile): Position =3(n+1)4=5.25= \frac{3(n+1)}{4} = 5.25th item Q3=8+0.25×(108)=8.5Q_3 = 8 + 0.25 \times (10 - 8) = 8.5
  • Maximum: 1010

Five-Point Summary vector for XX: [MinQ1MedianQ3Max]=[1.02.56.08.510.0]\begin{bmatrix} \text{Min} & Q_1 & \text{Median} & Q_3 & \text{Max} \end{bmatrix} = \begin{bmatrix} 1.0 & 2.5 & 6.0 & 8.5 & 10.0 \end{bmatrix}

Interquartile Range (IQR): IQRX=Q3Q1=8.52.5=6.0IQR_X = Q_3 - Q_1 = 8.5 - 2.5 = 6.0

Quartile Range: The interval span is [Q1,Q3]=[2.5,8.5][Q_1, Q_3] = [2.5, 8.5].


2. Five-Point Summary for YY

  • Minimum: 88
  • Q1Q_1 (First Quartile): Position =1.75= 1.75th item Q1=8+0.75×(128)=11.0Q_1 = 8 + 0.75 \times (12 - 8) = 11.0
  • Median (Q2Q_2): Position =3.5= 3.5th item Median=15+172=16.0\text{Median} = \frac{15 + 17}{2} = 16.0
  • Q3Q_3 (Third Quartile): Position =5.25= 5.25th item Q3=18+0.25×(2018)=18.5Q_3 = 18 + 0.25 \times (20 - 18) = 18.5
  • Maximum: 2020

Five-Point Summary vector for YY: [MinQ1MedianQ3Max]=[8.011.016.018.520.0]\begin{bmatrix} \text{Min} & Q_1 & \text{Median} & Q_3 & \text{Max} \end{bmatrix} = \begin{bmatrix} 8.0 & 11.0 & 16.0 & 18.5 & 20.0 \end{bmatrix}

Interquartile Range (IQR): IQRY=Q3Q1=18.511.0=7.5IQR_Y = Q_3 - Q_1 = 18.5 - 11.0 = 7.5

Quartile Range: The interval span is [Q1,Q3]=[11.0,18.5][Q_1, Q_3] = [11.0, 18.5].

Academic Inference (Five-Point Summary): The five-point summary provides a complete, robust overview of the distribution boundaries and central half of the datasets. For XX, the middle 50%50\% of the data lies in a narrow span between 2.52.5 and 8.58.5 (IQRX=6.0IQR_X = 6.0). For YY, the central 50%50\% of the observations span a slightly wider range from 11.011.0 to 18.518.5 (IQRY=7.5IQR_Y = 7.5). This demonstrates that the core density of the Expenditure (YY) dataset is slightly more spread out in absolute terms than the core density of the Sales (XX) dataset.


Question 3: Spearman's Rank Correlation for Three Judges

Given Data

Three judges rank 10 competitors (N=10N = 10).

  • RAR_A: {6,5,3,10,2,4,9,7,8,1}\{6, 5, 3, 10, 2, 4, 9, 7, 8, 1\}
  • RBR_B: {5,8,4,7,10,2,1,6,9,3}\{5, 8, 4, 7, 10, 2, 1, 6, 9, 3\}
  • RCR_C: {4,9,8,1,2,3,10,5,7,6}\{4, 9, 8, 1, 2, 3, 10, 5, 7, 6\}

Spearman's rank correlation coefficient is given by: ρ=16i=1Ndi2N(N21)\rho = 1 - \frac{6 \sum_{i=1}^N d_i^2}{N(N^2 - 1)}


Step-by-Step Derivation

Let us construct the table of difference-squared (di2d_i^2) for all pairs:

Competitor iiRAR_ARBR_BRCR_CdAB2=(RARB)2d^2_{AB} = (R_A - R_B)^2dBC2=(RBRC)2d^2_{BC} = (R_B - R_C)^2dAC2=(RARC)2d^2_{AC} = (R_A - R_C)^2
1665544111144
255889999111616
33344881116162525
4101077119936368181
5221010226464646400
6442233441111
7991110106464818111
8776655111144
9889977114411
1011336644992525
\sum158158214214158158

Calculating Coefficients

1. Judges A and B (ρAB\rho_{AB})

ρAB=16×15810(1021)=1948990=10.9576=0.0424\rho_{AB} = 1 - \frac{6 \times 158}{10(10^2 - 1)} = 1 - \frac{948}{990} = 1 - 0.9576 = 0.0424

2. Judges B and C (ρBC\rho_{BC})

ρBC=16×21410(1021)=11284990=11.2970=0.2970\rho_{BC} = 1 - \frac{6 \times 214}{10(10^2 - 1)} = 1 - \frac{1284}{990} = 1 - 1.2970 = -0.2970

3. Judges A and C (ρAC\rho_{AC})

ρAC=16×15810(1021)=1948990=10.9576=0.0424\rho_{AC} = 1 - \frac{6 \times 158}{10(10^2 - 1)} = 1 - \frac{948}{990} = 1 - 0.9576 = 0.0424


Academic Inference

  • Judges A and B / Judges A and C: Show a very weak, positive rank correlation (ρ0.0424\rho \approx 0.0424). This suggests practically independent ranking scales with virtually no common pattern.
  • Judges B and C: Show a moderate negative rank correlation (ρ0.2970\rho \approx -0.2970). This reveals a systematic divergence in their musical preferences.
  • Conclusion: Judges A and B (as well as A and C) have more or less the same taste in music because their coefficient is positive (albeit very low), whereas Judges B and C have opposing rankings as indicated by their negative coefficient.

Question 14: Stronger Relationship: Calorie Intake vs Exercise Hours

Given Data

A nutritionist collects data for 4 individuals (n=4n = 4):

  • Calorie Intake (X1X_1): {2500,2200,2000,1800}\{2500, 2200, 2000, 1800\}
  • Exercise Hours (X2X_2): {2,4,6,8}\{2, 4, 6, 8\}
  • Weight Loss Progress (YY): {1,2,4,6}\{1, 2, 4, 6\}

We determine the strength of relationships by computing Pearson's correlation coefficient (rr) for both independent variables.


Step-by-Step Derivation

First, calculate the means: Xˉ1=2500+2200+2000+18004=2125\bar{X}_1 = \frac{2500+2200+2000+1800}{4} = 2125 Xˉ2=2+4+6+84=5\bar{X}_2 = \frac{2+4+6+8}{4} = 5 Yˉ=1+2+4+64=3.25\bar{Y} = \frac{1+2+4+6}{4} = 3.25

Table 4: Deviation Products for Calorie Intake (X1X_1) vs Weight Loss (YY)

ii(x1,iXˉ1)(x_{1,i} - \bar{X}_1)(yiYˉ)(y_i - \bar{Y})(x1,iXˉ1)2(x_{1,i} - \bar{X}_1)^2(yiYˉ)2(y_i - \bar{Y})^2(x1,iXˉ1)(yiYˉ)(x_{1,i} - \bar{X}_1)(y_i - \bar{Y})
13753752.25-2.251406251406255.06255.0625843.75-843.75
275751.25-1.25562556251.56251.562593.75-93.75
3125-1250.750.7515625156250.56250.562593.75-93.75
4325-3252.752.751056251056257.56257.5625893.75-893.75
\sum000026750026750014.7514.751925.0-1925.0

Table 5: Deviation Products for Exercise Hours (X2X_2) vs Weight Loss (YY)

ii(x2,iXˉ2)(x_{2,i} - \bar{X}_2)(yiYˉ)(y_i - \bar{Y})(x2,iXˉ2)2(x_{2,i} - \bar{X}_2)^2(yiYˉ)2(y_i - \bar{Y})^2(x2,iXˉ2)(yiYˉ)(x_{2,i} - \bar{X}_2)(y_i - \bar{Y})
13-32.25-2.25995.06255.06256.756.75
21-11.25-1.25111.56251.56251.251.25
3110.750.75110.56250.56250.750.75
4332.752.75997.56257.56258.258.25
\sum0000202014.7514.7517.017.0

Computing Pearson's Correlation Coefficient

1. Calorie Intake vs Weight Loss (rX1,Yr_{X_1, Y})

rX1,Y=(x1,iXˉ1)(yiYˉ)(x1,iXˉ1)2(yiYˉ)2=1925267500×14.75=19253945625=19251986.31440.9691r_{X_1, Y} = \frac{\sum (x_{1,i} - \bar{X}_1)(y_i - \bar{Y})}{\sqrt{\sum (x_{1,i} - \bar{X}_1)^2 \sum (y_i - \bar{Y})^2}} = \frac{-1925}{\sqrt{267500 \times 14.75}} = \frac{-1925}{\sqrt{3945625}} = \frac{-1925}{1986.3144} \approx -0.9691

2. Exercise Hours vs Weight Loss (rX2,Yr_{X_2, Y})

rX2,Y=(x2,iXˉ2)(yiYˉ)(x2,iXˉ2)2(yiYˉ)2=17.020×14.75=17.0295=17.017.17560.9898r_{X_2, Y} = \frac{\sum (x_{2,i} - \bar{X}_2)(y_i - \bar{Y})}{\sqrt{\sum (x_{2,i} - \bar{X}_2)^2 \sum (y_i - \bar{Y})^2}} = \frac{17.0}{\sqrt{20 \times 14.75}} = \frac{17.0}{\sqrt{295}} = \frac{17.0}{17.1756} \approx 0.9898


Academic Inference

  • Calorie Intake (X1X_1) vs Weight Loss (YY): Shows an exceptionally strong, negative linear correlation (r0.9691r \approx -0.9691). This indicates that as calorie intake decreases, weight loss progress increases, which aligns perfectly with standard thermodynamic models of energy balance.
  • Exercise Hours (X2X_2) vs Weight Loss (YY): Shows an exceptionally strong, positive linear correlation (r0.9898r \approx 0.9898). This indicates that as exercise hours increase, weight loss progress increases.
  • Strength Comparison: Comparing the magnitudes of the correlations: rX2,Y=0.9898>rX1,Y=0.9691\left|r_{X_2, Y}\right| = 0.9898 > \left|r_{X_1, Y}\right| = 0.9691
  • Conclusion: Exercise Hours (X2X_2) has a stronger relationship with Weight Loss Progress than Calorie Intake (X1X_1) for this cohort, although both are highly predictive factors.

Quick-Facts & Formula Sheet (Descriptive Statistics & Correlation - Population Model)

Metric / ParameterMathematical Formula
Arithmetic Meanμ=1Ni=1Nxi\mu = \frac{1}{N} \sum_{i=1}^N x_i
Median (NN is odd)M=x(N+12)M = x_{\left(\frac{N+1}{2}\right)}
Median (NN is even)M=x(N2)+x(N2+1)2M = \frac{x_{\left(\frac{N}{2}\right)} + x_{\left(\frac{N}{2}+1\right)}}{2}
Quartile PositionP(Qk)=k(N+1)4P(Q_k) = \frac{k(N+1)}{4}
Quartile Deviation (QD)QD=Q3Q12QD = \frac{Q_3 - Q_1}{2}
Coeff of QDCoeff of QD=Q3Q1Q3+Q1\text{Coeff of QD} = \frac{Q_3 - Q_1}{Q_3 + Q_1}
Varianceσ2=1Ni=1N(xiμ)2\sigma^2 = \frac{1}{N} \sum_{i=1}^N (x_i - \mu)^2
Standard Deviationσ=σ2\sigma = \sqrt{\sigma^2}
Coeff of SDCoeff of SD=σμ\text{Coeff of SD} = \frac{\sigma}{\mu}
Coeff of Variation (CV)CV=(σμ)×100%CV = \left( \frac{\sigma}{\mu} \right) \times 100\%
Pearson's Skewness (Sk,PS_{k,P})Sk,P=3(μMd)σS_{k,P} = \frac{3(\mu - M_d)}{\sigma}
Moment-Based Skewnessμk=1N(xiμ)k    γ1=μ3μ21.5\mu_k = \frac{1}{N}\sum(x_i-\mu)^k \implies \gamma_1 = \frac{\mu_3}{\mu_2^{1.5}}
Pearson's Kurtosis (β2\beta_2)β2=μ4μ22\beta_2 = \frac{\mu_4}{\mu_2^2}
Excess Kurtosis (γ2\gamma_2)γ2=β23\gamma_2 = \beta_2 - 3
CovarianceσXY=1N(xiμX)(yiμY)\sigma_{XY} = \frac{1}{N}\sum(x_i - \mu_X)(y_i - \mu_Y)
Pearson Correlation (rr)r=σXYσXσY=(xiμX)(yiμY)(xiμX)2(yiμY)2r = \frac{\sigma_{XY}}{\sigma_X \sigma_Y} = \frac{\sum(x_i-\mu_X)(y_i-\mu_Y)}{\sqrt{\sum(x_i-\mu_X)^2 \sum(y_i-\mu_Y)^2}}
Spearman's Rank Correlationρ=16di2N(N21)\rho = 1 - \frac{6 \sum d_i^2}{N(N^2 - 1)}