In: Statistics and Probability
Solution
Let X = Expenditure ($) on Valentine’s Day by male consumers
Y = Expenditure ($) on Valentine’s Day by female consumers
Let mean and standard deviation of X be respectively µ1 and σ1 and that of Y be µ2 and σ2 .
Given σ1 = 35 and σ2 = 20 ....................................................................................................................................... (1)
Hypotheses:
Null: H0: µ1 = µ2 Vs Alternative: HA: µ1≠ µ2
Test Statistic: = 10.110
Z = (Xbar - Ybar)/√{(σ12/n1)+(σ22/n2)} where
Xbar and Ybar are sample averages based on n1 observations on X and n2 observations on Y.
Calculations
Summary of Excel calculations is given below:
| 
 n1  | 
 40  | 
| 
 n2  | 
 30  | 
| 
 Xbar  | 
 135.67  | 
| 
 Ybar  | 
 68.64  | 
| 
 σ1  | 
 35  | 
| 
 σ2  | 
 20  | 
| 
 σ12  | 
 1225  | 
| 
 σ22  | 
 400  | 
| 
 Zcal  | 
 10.10994  | 
| 
 α  | 
 0.01  | 
| 
 Zcrit  | 
 2.575829  | 
| 
 p-value  | 
 0  | 
| 
 σ12/n1  | 
 30.625  | 
| 
 σ22/n2  | 
 13.33333  | 
| 
 Sum  | 
 43.95833  | 
| 
 Sqrt  | 
 6.630108  | 
| 
 1- (α/2)  | 
 0.995  | 
Distribution, Critical Value and p-value:
Under H0, Z ~ N(0, 1), where
Hence, for level of significance α%, Critical Value = upper (α/2)% point of N(0, 1) and
p-value = P(Z > | Zcal |).
Using Excel Functions, the above are found to be as shown in the above table:
Decision:
Since | Zcal | > Zcrit, or equivalently, since p-value < α, H0 is rejected.
Conclusion:
There is sufficient evidence to conclude that there is a difference in spending. Answer
DONE