Région de Montréal Région de Québec 2425 2522 2440 2656 2198 2200 2456 2678 2425 2520 2480 2712 2445 2530 2470 2690 2365 2434 2390 2586 2420 2510 2340 2515 2270 2298 2155 2245 2180 2720
According to an economist from a financial company, the average expenditures on "furniture and household appliances" have been lower for households in the Montreal area than those in the Quebec region.
A random sample of 14 households from the Montreal region and 16 households from the Quebec region was taken, providing the following data regarding expenditures in this economic sector.
It is assumed that the data from each population are distributed normally.
We are interested in knowing if the variances of the populations are equal. a) Perform the appropriate hypothesis test on two variances at a significance level of 1%. Include the following information:
i. Hypothesis / Identification of populations ii. Critical F-value(s) iii. Decision rule iv. F-ratio value v. Decision and conclusion
b) Based on the results obtained in a), is the hypothesis of equal variances for this socio-economic characteristic measured in these two populations upheld?
c) Based on the results obtained in a), provide the appropriate Excel report for a test on two means at a significance level of 1%. Based on this report, is the economist's claim valid? Explain. (Note: use the descriptive threshold to answer this question)
For question 3c) Excel Report, you must provide an Excel file with the appropriate Excel report.


Step by step
Solved in 2 steps with 3 images









