Skip to main content

Set A - Question 3

Question Details​

  • A. A data analyst is studying the factors affecting employee productivity in a technology company. The analyst collects the following data from 4 employees over a specific period:

    EmployeeTraining HoursBreak HoursProductivity Score
    15260
    210268
    315178
    420188

    Determine which independent variable - Training Hours or Break Hours - has a stronger relationship with the Productivity Score. Support your answer using an appropriate correlation measure. (10 marks)

  • B. A company has 8 employees and wants to select 3 employees to attend a training program. The order in which the employees are selected does not matter. How many different groups of 3 employees can be selected? (5 marks)

  • C. The daily water consumption of households in a city is normally distributed with a mean of 180 litres and a variance of 400 litres square. What is the probability that a randomly selected household consumes more than 215 litres in a day? Assume given P(Z ≤ 1.75) = 0.9599. (5 marks)


Model Answer​

A. Correlation Analysis: Training Hours vs. Break Hours on Productivity (10 Marks)​

1. Appropriate Measure of Correlation (1 Mark)​

The appropriate metric is Pearson's Product-Moment Correlation Coefficient (rr), which evaluates the strength and direction of the linear relationship between continuous/ratio scale quantitative variables: r=∑(Xi−Xˉ)(Yi−Yˉ)∑(Xi−Xˉ)2∑(Yi−Yˉ)2r = \frac{\sum (X_i - \bar{X})(Y_i - \bar{Y})}{\sqrt{\sum (X_i - \bar{X})^2 \sum (Y_i - \bar{Y})^2}}


2. Variable Definitions & Sample Means (2 Marks)​

Let:

  • X1X_1: Training Hours
  • X2X_2: Break Hours
  • YY: Productivity Score
  • Sample size: n=4n = 4
Calculating Means:​

Xˉ1=5+10+15+204=504=12.5\bar{X}_1 = \frac{5 + 10 + 15 + 20}{4} = \frac{50}{4} = \mathbf{12.5} Xˉ2=2+2+1+14=64=1.5\bar{X}_2 = \frac{2 + 2 + 1 + 1}{4} = \frac{6}{4} = \mathbf{1.5} Yˉ=60+68+78+884=2944=73.5\bar{Y} = \frac{60 + 68 + 78 + 88}{4} = \frac{294}{4} = \mathbf{73.5}


3. Step-by-Step Computation Table (3 Marks)​

EmpX1X_1X2X_2YY(X1−Xˉ1)(X_1 - \bar{X}_1)(X1−Xˉ1)2(X_1 - \bar{X}_1)^2(X2−Xˉ2)(X_2 - \bar{X}_2)(X2−Xˉ2)2(X_2 - \bar{X}_2)^2(Y−Yˉ)(Y - \bar{Y})(Y−Yˉ)2(Y - \bar{Y})^2(X1−Xˉ1)(Y−Yˉ)(X_1 - \bar{X}_1)(Y - \bar{Y})(X2−Xˉ2)(Y−Yˉ)(X_2 - \bar{X}_2)(Y - \bar{Y})
15260−7.5-7.556.2556.25+0.5+0.50.250.25−13.5-13.5182.25182.25+101.25+101.25−6.75-6.75
210268−2.5-2.56.256.25+0.5+0.50.250.25−5.5-5.530.2530.25+13.75+13.75−2.75-2.75
315178+2.5+2.56.256.25−0.5-0.50.250.25+4.5+4.520.2520.25+11.25+11.25−2.25-2.25
420188+7.5+7.556.2556.25−0.5-0.50.250.25+14.5+14.5210.25210.25+108.75+108.75−7.25-7.25
∑\sum5050662942940.00.0125.0125.00.00.01.01.00.00.0443.0443.0+235.0+235.0−19.0-19.0

4. Correlation 1: Training Hours (X1X_1) vs. Productivity Score (YY) (2 Marks)​

r(X1,Y)=∑(X1−Xˉ1)(Y−Yˉ)∑(X1−Xˉ1)2⋅∑(Y−Yˉ)2r(X_1, Y) = \frac{\sum (X_1 - \bar{X}_1)(Y - \bar{Y})}{\sqrt{\sum (X_1 - \bar{X}_1)^2 \cdot \sum (Y - \bar{Y})^2}} r(X1,Y)=235.0125.0×443.0=235.055375.0=235.0235.3189≈+0.9986r(X_1, Y) = \frac{235.0}{\sqrt{125.0 \times 443.0}} = \frac{235.0}{\sqrt{55375.0}} = \frac{235.0}{235.3189} \approx \mathbf{+0.9986}

  • Interpretation: There is an exceptionally strong, nearly perfect positive linear correlation between Training Hours and Productivity Score.

5. Correlation 2: Break Hours (X2X_2) vs. Productivity Score (YY) (1 Mark)​

r(X2,Y)=∑(X2−Xˉ2)(Y−Yˉ)∑(X2−Xˉ2)2⋅∑(Y−Yˉ)2r(X_2, Y) = \frac{\sum (X_2 - \bar{X}_2)(Y - \bar{Y})}{\sqrt{\sum (X_2 - \bar{X}_2)^2 \cdot \sum (Y - \bar{Y})^2}} r(X2,Y)=−19.01.0×443.0=−19.0443.0=−19.021.0476≈−0.9027r(X_2, Y) = \frac{-19.0}{\sqrt{1.0 \times 443.0}} = \frac{-19.0}{\sqrt{443.0}} = \frac{-19.0}{21.0476} \approx \mathbf{-0.9027}

  • Interpretation: There is a strong negative linear correlation between Break Hours and Productivity Score.

6. Determination of Stronger Relationship (1 Mark)​

The strength of a relationship is evaluated by comparing the absolute values of the correlation coefficients (∣r∣\lvert r \rvert):

Independent VariableCorrelation (rr)Absolute Strength (∣r∣\lvert r \rvert)Coefficient of Determination (R2R^2)Rank
Training Hours (X1X_1)+0.9986+0.99860.99860.9986(0.9986)2≈99.73%(0.9986)^2 \approx \mathbf{99.73\%}1 (Stronger)
Break Hours (X2X_2)−0.9027-0.90270.90270.9027(−0.9027)2≈81.49%(-0.9027)^2 \approx \mathbf{81.49\%}2
  • Final Decision: Training Hours has a stronger relationship with the Productivity Score than Break Hours because ∣r(X1,Y)∣=0.9986>∣r(X2,Y)∣=0.9027\lvert r(X_1, Y) \rvert = 0.9986 > \lvert r(X_2, Y) \rvert = 0.9027.
  • Statistical Rationale: Training Hours accounts for 99.73%99.73\% of the variance in productivity, compared to 81.49%81.49\% accounted for by Break Hours.

B. Combinatorics: Employee Selection (5 Marks)​

1. Concept Identification (1 Mark)​

Because the order of employee selection does not matter, the problem represents an unordered combination: (nr)=nCr\binom{n}{r} = {}^nC_r

2. Formula (1 Mark)​

(nr)=n!r!⋅(n−r)!\binom{n}{r} = \frac{n!}{r! \cdot (n - r)!}

3. Step-by-Step Calculation (3 Marks)​

  • Total available employees: n=8n = 8
  • Target group size: r=3r = 3

(83)=8!3!⋅(8−3)!=8!3!⋅5!\binom{8}{3} = \frac{8!}{3! \cdot (8 - 3)!} = \frac{8!}{3! \cdot 5!} (83)=8×7×6×5!(3×2×1)×5!\binom{8}{3} = \frac{8 \times 7 \times 6 \times 5!}{(3 \times 2 \times 1) \times 5!} (83)=8×7×66=8×7=56\binom{8}{3} = \frac{8 \times 7 \times 6}{6} = 8 \times 7 = \mathbf{56}

  • Result: 56 different groups of 3 employees can be selected.

C. Normal Distribution: Household Water Consumption (5 Marks)​

1. Given Parameters (1 Mark)​

Let XX denote the daily household water consumption in litres:

  • Distribution: X∼N(μ,σ2)X \sim \mathcal{N}(\mu, \sigma^2)
  • Population Mean: μ=180 litres\mu = 180 \text{ litres}
  • Population Variance: σ2=400 litres2\sigma^2 = 400 \text{ litres}^2
  • Population Standard Deviation: σ=400=20 litres\sigma = \sqrt{400} = \mathbf{20 \text{ litres}}
  • Consumption Threshold: x=215 litresx = 215 \text{ litres}
  • Given Standard Normal Cumulative Probability: P(Z≤1.75)=0.9599P(Z \le 1.75) = 0.9599

2. Standardization (ZZ-Score Transformation) (2 Marks)​

Converting the threshold value x=215x = 215 into the standard normal variable Z∼N(0,1)Z \sim \mathcal{N}(0, 1): Z=X−μσZ = \frac{X - \mu}{\sigma} Z=215−18020=3520=1.75Z = \frac{215 - 180}{20} = \frac{35}{20} = \mathbf{1.75}


3. Probability Calculation (2 Marks)​

We seek the probability of consuming more than 215 litres: P(X>215)=P(Z>1.75)P(X > 215) = P(Z > 1.75)

Applying the complement rule for cumulative probabilities: P(Z>1.75)=1−P(Z≤1.75)P(Z > 1.75) = 1 - P(Z \le 1.75)

Substituting the given value P(Z≤1.75)=0.9599P(Z \le 1.75) = 0.9599: P(X>215)=1−0.9599=0.0401P(X > 215) = 1 - 0.9599 = \mathbf{0.0401}

  • Final Result: The probability that a randomly selected household consumes more than 215 litres in a day is 0.04010.0401 (or 4.01%4.01\%).