11.2 Excel Activity 1 - Hypothesis Test for Two Population Variances (Freeform)

See attached for data

Most individuals are aware of the fact that the average annual repair cost for an automobile depends on the age of the automobile. A researcher is interested in finding out whether the variance of the annual repair costs also increases with the age of the automobile. A sample of 26 automobiles 4 years old showed a sample standard deviation for annual repair costs of $171.94 and a sample of 23 automobiles 2 years old showed a sample standard deviation for annual repair costs of $119.27. Let 4 year old automobiles be represented by population 1. The data is located in the Microsoft Excel Online file below.

File Home Insert Draw Page Layout Formulas Data Review View Arial 10 B A . . Ev ab C2 V X V fx A B C D E F G H Car Age and Repair Cost ($) W N - 4 years 2 years 791 643 839 431 778 454 791 404 891 395 791 713 775 573 10 943 469 11 1013 155 12 953 436 13 1060 399 14 405 24 15 955 396 16 874 548 17 899 398 18 336 598 19 733 391 20 654 336 21 507 370 22 823 455 23 708 356 24 808 365 25 898 569 26 790 27 801 28 612 29 30 31 32cl p I : CENGAGE I MINDTAP Q Search this coursc 0 ' 4 Question 1 0110 Submit Most individuals are aware of the fact that the average annual repair cost for an automobile depends on the age of the automobile. A researcher is interested in nding out whether the variance of the annual repair costs also increases with the age of the automobile. A sample of 26 automobiles 4 years old showed a sample standard deviation for annual repair costs of $171.94 and a sample of 23 automobiles 2 years old showed a sample standard deviation for annual repair costs of $119.27. Let 4 year old automobiles be represented by population 1. The data is located in the Microsoft Excel Online le below. Open spreadsheet 1. State the null and alternative versions of the research hypothesis that the variance in annual repair costs is larger for the older automobiles. Ho: 21 522 Ha= 021 22 2. Conduct the hypothesis test at a 0.10 level of signicance. Calculate the value of the test statistic (2 decimals). Calculate the critical value (2 decimals). Calculate the p-value (4 decimals). Reject null hypothesis? 3 What is your conclusion