You have attached in the MS-Excel file data on residential houses; their prices, facilities,...

Question

You have attached in the MS-Excel file data on residential houses; their prices, facilities, locations, etc.

The variables are PRICE (Price of the each House),

POOL (Whether the house has a swimming pool or not. Pool has a value 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 and separate houses that have a swimming pool from houses that do not have a swimming pool

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)
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?
Construct a 97% Confidence Interval Estimate for each of the three variables and use your Confidence Intervals to compare the two categories of houses

realestate-dkdeymbp.numbers

Sudharsan.J · Accepted Answer

Export Summary
		This document was exported from Numbers.  Each table was converted to an Excel worksheet. All other objects on each Numbers sheet were placed on separate worksheets. Please be aware that formula calculations may differ in Excel.
		Numbers Sheet Name	Numbers Table Name	Excel Worksheet Name
		REAL_ESTATE
			Table 1	REAL_ESTATE
		Sheet 1
			Table 1	Sheet 1
				Analysis
REAL_ESTATE
	PRICE	ROOMS	SIZE	POOL	DISTANCE	TOWNSHIP	GARAGE	BATHS
	263.10	4	2300	0	17	5	1	2.0
	182.40	4	2100	1	19	4	0	2.0
	242.10	3	2300	1	12	3	0	2.0
	213.60	2	2200	1	16	2	0	2.5
	139.90	2	2100	1	28	1	0	1.5
	245.40	2	2100	0	12	1	1	2.0
	327.20	6	2500	1	15	3	1	2.0
	271.80	2	2100	1	9	2	1	2.5
	221.10	3	2300	0	18	1	0	1.5
	266.60	4	2400	1	13	4	1	2.0
	292.40	4	2100	1	14	3	1	2.0
	209.00	2	1700	1	8	4	1	1.5
	270.80	6	2500	1	7	4	1	2.0
	246.10	4	2100	1	18	3	1	2.0
	194.40	2	2300	1	11	3	0	2.0
	281.30	3	2100	1	16	2	1	2.0
	172.70	4	2200	0	16	3	0	2.0
	207.50	5	2300	0	21	4	0	2.5
	198.90	3	2200	0	10	4	1	2.0
	209.30	6	1900	0	15	4	1	2.0
	252.30	4	2600	1	8	4	1	2.0
	192.90	4	1900	0	14	2	1	2.5
	209.30	5	2100	1	20	5	0	1.5
	345.30	8	2600	1	9	4	1	2.0
	326.30	6	2100	1	11	5	1	3.0
	173.10	2	2200	0	21	5	1	1.5
	187.00	2	1900	1	26	4	0	2.0
	257.20	2	2100	1	9	4	1	2.0
	233.00	3	2200	1	14	3	1	1.5
	180.40	2	2000	1	11	5	0	2.0
	234.00	2	1700	1	19	3	1	2.0
	207.10	2	2000	1	11	5	1	2.0
	247.70	5	2400	1	16	2	1	2.0
	166.20	3	2000	0	16	2	1	2.0
	177.10	2	1900	1	10	5	1	2.0
	182.70	4	2000	0	14	4	0	2.5
	216.00	4	2300	1	19	2	0	2.0
	312.10	6	2600	1	7	5	1	2.5
	199.80	3	2100	1	19	3	1	2.0
	273.20	5	2200	1	16	2	1	3.0
	206.00	3	2100	0	9	3	0	1.5
	232.20	3	1900	0	16	1	1	1.5
	198.30	4	2100	0	19	1	1	1.5
	205.10	3	2000	0	20	4	0	2.0
	175.60	4	2300	0	24	4	1	2.0
	307.80	3	2400	0	21	2	1	3.0
	269.20	5	2200	1	8	5	1	3.0
	224.80	3	2200	1	17	1	1	2.5
	171.60	3	2000	0	16	4	0	2.0
	216.80	3	2200	1	15	1	1	2.0
	192.60	6	2200	0	14	1	0	2.0
	236.40	5	2200	1	20	3	1	2.0
	172.40	3	2200	1	23	3	0	2.0
	251.40	3	1900	1	12	2	1	2.0
	246.00	6	2300	1	7	3	1	3.0
	147.40	6	1700	0	12	1	0	2.0
	176.00	4	2200	1	15	1	1	2.0
	228.40	3	2300	1	17	5	1	1.5
	166.50	3	1600	0	19	3	0	2.5
	189.40	4	2200	1	24	1	1	2.0
	312.10	7	2400	1	13	3	1	3.0
	289.80	6	2000	1	21	3	1	3.0
	269.90	5	2200	0	11	4	1	2.5
	154.30	2	2000	1	13	2	0	2.0
	222.10	2	2100	1	9	5	1	2.0
	209.70	5	2200	0	13	2	1	2.0
	190.90	3	2200	0	18	3	1	2.0
	254.30	4	2500	0	15	3	1	2.0
	207.50	3	2100	0	10	2	0	2.0
	209.70	4	2200	0	19	2	1	2.0
	294.00	2	2100	1	13	2	1	2.5
	176.30	2	2000	0	17	3	0	2.

You have attached in the MS-Excel file data on residential houses; their prices, facilities, locations, etc. The variables are PRICE (Price of the each House), POOL (Whether the house has a swimming...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment