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 are normally distributed in the population, enter the data into Excel and compute the standard deviation of the differences (cost - resale). Enter your answer as a number rounded to 2 decimal places. Do not include the $ sign in your answer. City Cost Resale Atlanta 25163 20427 Boston 24625 27255 Dallas 23126 22563 Des Moines 12600 22115 Kansas City 24588 23256 Louisville 19267 21887 Portland 20150 24255 Raleigh 22500 19852 Reno 16667 23624 Ridgewood 26875 25885 San Francisco 35333 28999 Tulsa 16292 20836

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
icon
Related questions
Topic Video
Question
QUESTION 8
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 are normally distributed in the population, enter the data into Excel and compute the standard deviation of the differences
(cost - resale). Enter your answer as a number rounded to 2 decimal places. Do not include the $ sign in your answer.
City
Cost
Resale
Atlanta
25163
20427
Boston
24625
27255
Dallas
23126
22563
Des Moines
12600
22115
Kansas City
24588
23256
Louisville
19267
21887
Portland
20150
24255
Raleigh
22500
19852
Reno
16667
23624
Ridgewood
26875
25885
San
Francisco
35333
28999
Tulsa
16292
20836
Transcribed Image Text:QUESTION 8 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 are normally distributed in the population, enter the data into Excel and compute the standard deviation of the differences (cost - resale). Enter your answer as a number rounded to 2 decimal places. Do not include the $ sign in your answer. City Cost Resale Atlanta 25163 20427 Boston 24625 27255 Dallas 23126 22563 Des Moines 12600 22115 Kansas City 24588 23256 Louisville 19267 21887 Portland 20150 24255 Raleigh 22500 19852 Reno 16667 23624 Ridgewood 26875 25885 San Francisco 35333 28999 Tulsa 16292 20836
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Hypothesis Tests and Confidence Intervals for Means
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill