6g 00 %24 LU You have attached in the MS-Excel file data on residential houses, their prices, facilities, locations, etc. The variables are PRICE (Price of each House), POOL (Whether the house has a swimming pool or not. Pool has a value of 1 if the house has a swimming pool and "0" if the house does not have a swimming pool) DISTANCE (Distance from the City in miles) SIZE (The amount of living space in the house in Square Feet) YOUR ASSIGNMENT Sort the data according to and separate houses that have a swimming pool from houses that do not have a 1. Calculate the mean and standard deviations for (Prices, Living Space, and Distance from the City) of the two categories of houses (Swimming pool vs. no swimming pool) 2. Calculate the Coefficients of Variations comparing the two categories of houses and present your results in tables and charts. Which category of houses has a wider variation in the values of the variables that you analyzed? 3. Construct a 97% Confidence Interval Estimate for each of the three variables and use your Confidence Intervals to compare the two categories of houses REAL ESTATE.xls REAL ESTATE.xls ASSIGNMENT SUBMISSION nere to search a 48 F Mostly cloudy dy 93 Oly f12 %23 3. 9. 6 R. } 7 N|2QN FNm N5 551t %24 12/2 N 6 t N3 4 5 m64t 23/3 43 业不 45 O 23 S. caps lock & tab % 3. # fs 米 f4 f3 f2 esc a. #五 1. 9 Type here to search 2.0 1.5 4. 4. 1. Ready REAL ESTATE 21 2 26 1. 1. 006 257.20 187.00 173.10 326.30 345.30 209.30 192.90 15 25 20. 2200 21 2100 9. 4. 11 28 1. 01 009 1. 4. 4. 14 8. 5. 41 201 006 25 1. 1. 151 009 24 4. 4. 2.5 0. 01 252.30 22 006 23 4. 3. 2. 9 3. 20. (0६ 60८ 198.90 207.50 172.70 21 2300 5. 4. 21 1. 20 2.0 1. 1. 1. 1. 20. 11 18. 281.30 17 3. 2.0 1. 1. 21 9- 194.40 7. 8. 4. 2100 9. 1.5 1. 4. 1. 1. 1. 246.10 270.80 13 15 2.0 3. 2 1 14 2.0 14 1 4. 13. 18. 9. 41 292.40 09 9967 1. 1.5 1. 2400 41 2.5 2.0 2. 3. 3. 221.10 6. 11 1. 2100 000 271.80 8. 1. 1. 2.0 1. 9. 1.5 2.5 2.0 12 28. 2. 2. 2. 3. 1. 327.20 1. 2. 06 69 9. 3. 20 12 1. 0000 4. 213.60 1. 2.0 5. 1. 4. DISTANCE TOWNSHI GARAGE BATHS D. 182.40 263.10 1 PRICE 000 4. 100d ROOMS SIZE B. C.
6g 00 %24 LU You have attached in the MS-Excel file data on residential houses, their prices, facilities, locations, etc. The variables are PRICE (Price of each House), POOL (Whether the house has a swimming pool or not. Pool has a value of 1 if the house has a swimming pool and "0" if the house does not have a swimming pool) DISTANCE (Distance from the City in miles) SIZE (The amount of living space in the house in Square Feet) YOUR ASSIGNMENT Sort the data according to and separate houses that have a swimming pool from houses that do not have a 1. Calculate the mean and standard deviations for (Prices, Living Space, and Distance from the City) of the two categories of houses (Swimming pool vs. no swimming pool) 2. Calculate the Coefficients of Variations comparing the two categories of houses and present your results in tables and charts. Which category of houses has a wider variation in the values of the variables that you analyzed? 3. Construct a 97% Confidence Interval Estimate for each of the three variables and use your Confidence Intervals to compare the two categories of houses REAL ESTATE.xls REAL ESTATE.xls ASSIGNMENT SUBMISSION nere to search a 48 F Mostly cloudy dy 93 Oly f12 %23 3. 9. 6 R. } 7 N|2QN FNm N5 551t %24 12/2 N 6 t N3 4 5 m64t 23/3 43 业不 45 O 23 S. caps lock & tab % 3. # fs 米 f4 f3 f2 esc a. #五 1. 9 Type here to search 2.0 1.5 4. 4. 1. Ready REAL ESTATE 21 2 26 1. 1. 006 257.20 187.00 173.10 326.30 345.30 209.30 192.90 15 25 20. 2200 21 2100 9. 4. 11 28 1. 01 009 1. 4. 4. 14 8. 5. 41 201 006 25 1. 1. 151 009 24 4. 4. 2.5 0. 01 252.30 22 006 23 4. 3. 2. 9 3. 20. (0६ 60८ 198.90 207.50 172.70 21 2300 5. 4. 21 1. 20 2.0 1. 1. 1. 1. 20. 11 18. 281.30 17 3. 2.0 1. 1. 21 9- 194.40 7. 8. 4. 2100 9. 1.5 1. 4. 1. 1. 1. 246.10 270.80 13 15 2.0 3. 2 1 14 2.0 14 1 4. 13. 18. 9. 41 292.40 09 9967 1. 1.5 1. 2400 41 2.5 2.0 2. 3. 3. 221.10 6. 11 1. 2100 000 271.80 8. 1. 1. 2.0 1. 9. 1.5 2.5 2.0 12 28. 2. 2. 2. 3. 1. 327.20 1. 2. 06 69 9. 3. 20 12 1. 0000 4. 213.60 1. 2.0 5. 1. 4. DISTANCE TOWNSHI GARAGE BATHS D. 182.40 263.10 1 PRICE 000 4. 100d ROOMS SIZE B. C.
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
Related questions
Question
I only need help with question 3 please
Transcribed Image Text:6g
00
%24
LU
You have attached in the MS-Excel file data on residential houses, their prices, facilities, locations, etc.
The variables are PRICE (Price of each House),
POOL (Whether the house has a swimming pool or not. Pool has a value of 1 if the house has a swimming
pool and "0" if the house does not have a swimming pool)
DISTANCE (Distance from the City in miles)
SIZE (The amount of living space in the house in Square Feet)
YOUR ASSIGNMENT
Sort the data according to and separate houses that have a swimming pool from houses that do not have a
1. Calculate the mean and standard deviations for (Prices, Living Space, and Distance from the City) of
the two categories of houses (Swimming pool vs. no swimming pool)
2. Calculate the Coefficients of Variations comparing the two categories of houses and present your
results in tables and charts. Which category of houses has a wider variation in the values of the
variables that you analyzed?
3. Construct a 97% Confidence Interval Estimate for each of the three variables and use your Confidence
Intervals to compare the two categories of houses
REAL ESTATE.xls
REAL ESTATE.xls
ASSIGNMENT SUBMISSION
nere to search
a
48 F Mostly cloudy
dy
93
Oly
f12
%23
3.
9.
6
R.
}
7
Transcribed Image Text:N|2QN FNm
N5
551t
%24
12/2
N 6 t N3 4 5 m64t
23/3
43
业不
45 O
23
S.
caps lock
&
tab
%
3.
#
fs
米
f4
f3
f2
esc
a.
#五
1.
9 Type here to search
2.0
1.5
4.
4.
1.
Ready
REAL ESTATE
21
2
26
1.
1.
006
257.20
187.00
173.10
326.30
345.30
209.30
192.90
15
25
20.
2200
21
2100
9.
4.
11
28
1.
01
009
1.
4.
4.
14
8.
5.
41
201
006
25
1.
1.
151
009
24
4.
4.
2.5
0.
01
252.30
22
006
23
4.
3.
2.
9
3.
20.
(0६ 60८
198.90
207.50
172.70
21
2300
5.
4.
21
1.
20
2.0
1.
1.
1.
1.
20.
11
18.
281.30
17
3.
2.0
1.
1.
21
9-
194.40
7.
8.
4.
2100
9.
1.5
1.
4.
1.
1.
1.
246.10
270.80
13
15
2.0
3.
2
1
14
2.0
14
1
4.
13.
18.
9.
41
292.40
09 9967
1.
1.5
1.
2400
41
2.5
2.0
2.
3.
3.
221.10
6.
11
1.
2100
000
271.80
8.
1.
1.
2.0
1.
9.
1.5
2.5
2.0
12
28.
2.
2.
2.
3.
1.
327.20
1.
2.
06 69
9.
3.
20
12
1.
0000
4.
213.60
1.
2.0
5.
1.
4.
DISTANCE TOWNSHI GARAGE BATHS
D.
182.40
263.10
1 PRICE
000
4.
100d
ROOMS SIZE
B.
C.
Expert Solution
Step by step
Solved in 10 steps with 10 images
Recommended textbooks for you
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman