Homework Help is Here – Start Your Trial Now!
Math
Statistics
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: 0²1 € 0² 2 Ha: 0²1 2. Conduct the hypothesis test at a 0.10 level of significance. Calculate the value of the test statistic (2 decimals). Calculate the critical value (2 decimals). Calculate the p-value (4 decimals). 0²2 Reject null hypothesis? ©

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: 0²1 € 0² 2 Ha: 0²1 2. Conduct the hypothesis test at a 0.10 level of significance. Calculate the value of the test statistic (2 decimals). Calculate the critical value (2 decimals). Calculate the p-value (4 decimals). 0²2 Reject null hypothesis? ©

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.4: Distributions Of Data
Problem 19PFA
See similar textbooks
icon
Related questions
Question
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 $170.97 and a sample of 23 automobiles 2 years old showed a sample standard deviation for annual repair costs of $118.25. Let 4 year old automobiles be represented by population 1. The data is located in the Microsoft Excel Online file below. Due to a recent change by Microsoft you will need to open the XLMiner Analysis ToolPak add-in manually from the home ribbon. Screenshot of ToolPak X 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. ☺ 0² ₂ Ho: 0²1 Ha: 0² 1 0² 2. Conduct the hypothesis test at a 0.10 level of significance. Calculate the value of the test statistic (2 decimals). ↑ Calculate the critical value (2 decimals). Calculate the p-value (4 decimals). Reject null hypothesis? ↑ 2
Transcribed Image Text: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 $170.97 and a sample of 23 automobiles 2 years old showed a sample standard deviation for annual repair costs of $118.25. Let 4 year old automobiles be represented by population 1. The data is located in the Microsoft Excel Online file below. Due to a recent change by Microsoft you will need to open the XLMiner Analysis ToolPak add-in manually from the home ribbon. Screenshot of ToolPak X 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. ☺ 0² ₂ Ho: 0²1 Ha: 0² 1 0² 2. Conduct the hypothesis test at a 0.10 level of significance. Calculate the value of the test statistic (2 decimals). ↑ Calculate the critical value (2 decimals). Calculate the p-value (4 decimals). Reject null hypothesis? ↑ 2
Excel 5 027 1 File 23456789 29 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 25 template - Saved Home 4 years x ✓ fx A B C Car Age and Repair Cost ($) 2 years 778 630 839 431 778 454 791 404 886 393 791 713 775 573 943 469 1013 155 938 423 1060 399 405 524 396 548 955 874 888 412 336 598 733 391 654 336 507 823 708 808 898 790 801 612 Insert 370 455 356 365 569 Arial Sheet1 + Draw Page Layout ✓10 D Calculation Mode: Automatic Workbook Statistics E B Formulas F Search (Option + Q) G Data Αν Α H Review I View V J Help K General L M ←.0 .00 N .00 →.0 O V P R Editing Σ ✓ P S Ov T Give Feedback to Microsoft Comments | U > > 100% + V
Transcribed Image Text:Excel 5 027 1 File 23456789 29 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 25 template - Saved Home 4 years x ✓ fx A B C Car Age and Repair Cost ($) 2 years 778 630 839 431 778 454 791 404 886 393 791 713 775 573 943 469 1013 155 938 423 1060 399 405 524 396 548 955 874 888 412 336 598 733 391 654 336 507 823 708 808 898 790 801 612 Insert 370 455 356 365 569 Arial Sheet1 + Draw Page Layout ✓10 D Calculation Mode: Automatic Workbook Statistics E B Formulas F Search (Option + Q) G Data Αν Α H Review I View V J Help K General L M ←.0 .00 N .00 →.0 O V P R Editing Σ ✓ P S Ov T Give Feedback to Microsoft Comments | U > > 100% + V
Expert Solution
steps

Step by step

Solved in 3 steps with 5 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

test statistic and p value are incorrect. please provide correct solutions!!

Solution
Bartleby Expert
SEE SOLUTION
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
SEE MORE TEXTBOOKS