In terms of resale value, is remodeling a kitchen worth the cost? The following cost and resale figures were reported for 12 cities. Assuming the differences (cost – resale) are normally distributed in the population, test ifresale is significantly higher for remodeling a kitchen. Use the t-Test: Paired Two Sample for Means in Excel to perform the test at a 5% level of significance. What is the value of the test statistic as output by Excel? Answer as anumber, rounded to 3 decimal places.CityCostResaleAtlanta25163 20427Boston2462527255Dallas2312622563DesMoines1260022115Kansas City 24588 2325619267 21887LouisvillePortland20150 24255Raleigh2250019852Reno1666723624Ridgewood 26875 25885SanFrancisco35333 28999Tulsa16292 20836QUESTION 1oIn terms of resale value, is remodeling a kitchen worth the cost? At the 5% significance level, what can you conclude?O a. No, the resale value is not significantly higher than the cost of remodeling a kitchen based on the computed p-value of 0.42.O b. Yes, the resale value is significantly higher than the cost of remodeling a kitchen based on the computed p-value of 0.21.O c. Yes, the resale value is significantly higher than the cost of remodeling a kitchen based on the computed p-value of 0.42.O d. No, the resale value is not significantly higher than the cost of remodeling a kitchen based on the computed p-value of 0.21.

Null Hypothesis: Resale is not significantly higher for remodeling the kitchen. Alternative…

Ridgewood 26875 25885 San Francisco 35333 28999 Tulsa 16292 20836 QUESTION 10 In terms of resale value, is remodeling a kitchen worth the cost? At the 5% significance level, what can you conclude? O a. No, the resale value is not significantly higher than the cost of remodeling a kitchen based on the computed p-value of 0.42. Ob. Yes, the resale value is significantly higher than the cost of remodeling a kitchen based on the computed p-value of 0.21. O. Yes, the resale value is significantly higher than the cost of remodeling a kitchen based on the computed p-value of 0.42. O d. No. the resale value is not significantly bigher than the cost of remodeling a kitchen based on the computed n:value of 0 21

Ridgewood 26875 25885 San Francisco 35333 28999 Tulsa 16292 20836 QUESTION 10 In terms of resale value, is remodeling a kitchen worth the cost? At the 5% significance level, what can you conclude? O a. No, the resale value is not significantly higher than the cost of remodeling a kitchen based on the computed p-value of 0.42. Ob. Yes, the resale value is significantly higher than the cost of remodeling a kitchen based on the computed p-value of 0.21. O. Yes, the resale value is significantly higher than the cost of remodeling a kitchen based on the computed p-value of 0.42. O d. No. the resale value is not significantly bigher than the cost of remodeling a kitchen based on the computed n:value of 0 21

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018

18th Edition

ISBN:9780079039897

Author:Carter

Publisher:Carter

Chapter10: Statistics

Section10.6: Summarizing Categorical Data

Problem 30PPS

See similar textbooks