spreadsheet

22-LIREStudy.xlsx

Home >Computer Science homework help >spreadsheet

Scatter Plot

Scatter Plot of Appraised Value (in K) based on House Size (Sq Ft)

AppraisedValue 2448 1942 2073 2707 2042 2089 1433 2991 1008 3202 2230 1848 2100 1846 1331 1344 1822 2479 1605 2080 2410 1753 1884 2050 2978 2132 1551 1129 1674 1184 2194 3032 1970 3356 2070 2826 1606 2063 1392 1120 1817 2496 1615 4067 3130 1423 1799 2936 1439 4065 2191 2008 2070 2710 1416 3244 2493 2473 1968 3136 3227 2618 1928 2145 1559 1550 1668 1423 1175 1214 1856 1223 961 1679 2316 1422 2399 1091 1225 1353 1680 1960 1916 1340 1394 1681 1468 3692 1456 1430 521.5 419.5 484.5 603.9 461.4 429.6 370.5 805.2 273.2 691.2 406.2 510.5 411.7 327.2 359.8 343.9 452.2 669 369.6 419 419.8 360.6 497.2 408.6 518.79999999999995 375.5 388.3 332.1 452.5 277.39999999999998 736.9 661.5 513.4 968.2 472.2 782.1 448.6 667.9 410.9 354.5 526.5 566.20000000000005 573.20000000000005 928.8 910.2 430.3 598.5 609.5 420.7 867.3 767.3 654.20000000000005 706.8 566.6 434.8 841.5 824.2 735.4 671.3 821.9 447.9 367.3 344.7 339.6 333.8 332.9 295.7 299.39999999999998 251.7 241 318.2 281.5 211.8 310.2 343.2 240.3 341.9 275.7 278.8 244.7 307.3 329.5 309.60000000000002 274.7 286.7 330.2 252.5 461.7 279 315.2

PlotData

	House Size(sq ft)	AppraisedValue
	2448	521.5
	1942	419.5
	2073	484.5
	2707	603.9
	2042	461.4
	2089	429.6
	1433	370.5
	2991	805.2
	1008	273.2
	3202	691.2
	2230	406.2
	1848	510.5
	2100	411.7
	1846	327.2
	1331	359.8
	1344	343.9
	1822	452.2
	2479	669
	1605	369.6
	2080	419
	2410	419.8
	1753	360.6
	1884	497.2
	2050	408.6
	2978	518.8
	2132	375.5
	1551	388.3
	1129	332.1
	1674	452.5
	1184	277.4
	2194	736.9
	3032	661.5
	1970	513.4
	3356	968.2
	2070	472.2
	2826	782.1
	1606	448.6
	2063	667.9
	1392	410.9
	1120	354.5
	1817	526.5
	2496	566.2
	1615	573.2
	4067	928.8
	3130	910.2
	1423	430.3
	1799	598.5
	2936	609.5
	1439	420.7
	4065	867.3
	2191	767.3
	2008	654.2
	2070	706.8
	2710	566.6
	1416	434.8
	3244	841.5
	2493	824.2
	2473	735.4
	1968	671.3
	3136	821.9
	3227	447.9
	2618	367.3
	1928	344.7
	2145	339.6
	1559	333.8
	1550	332.9
	1668	295.7
	1423	299.4
	1175	251.7
	1214	241
	1856	318.2
	1223	281.5
	961	211.8
	1679	310.2
	2316	343.2
	1422	240.3
	2399	341.9
	1091	275.7
	1225	278.8
	1353	244.7
	1680	307.3
	1960	329.5
	1916	309.6
	1340	274.7
	1394	286.7
	1681	330.2
	1468	252.5
	3692	461.7
	1456	279
	1430	315.2

SLRData

House Size(sq ft)	AppraisedValue
2448	521.5
1942	419.5
2073	484.5
2707	603.9
2042	461.4
2089	429.6
1433	370.5
2991	805.2
1008	273.2
3202	691.2
2230	406.2
1848	510.5
2100	411.7
1846	327.2
1331	359.8
1344	343.9
1822	452.2
2479	669
1605	369.6
2080	419
2410	419.8
1753	360.6
1884	497.2
2050	408.6
2978	518.8
2132	375.5
1551	388.3
1129	332.1
1674	452.5
1184	277.4
2194	736.9
3032	661.5
1970	513.4
3356	968.2
2070	472.2
2826	782.1
1606	448.6
2063	667.9
1392	410.9
1120	354.5
1817	526.5
2496	566.2
1615	573.2
4067	928.8
3130	910.2
1423	430.3
1799	598.5
2936	609.5
1439	420.7
4065	867.3
2191	767.3
2008	654.2
2070	706.8
2710	566.6
1416	434.8
3244	841.5
2493	824.2
2473	735.4
1968	671.3
3136	821.9
3227	447.9
2618	367.3
1928	344.7
2145	339.6
1559	333.8
1550	332.9
1668	295.7
1423	299.4
1175	251.7
1214	241
1856	318.2
1223	281.5
961	211.8
1679	310.2
2316	343.2
1422	240.3
2399	341.9
1091	275.7
1225	278.8
1353	244.7
1680	307.3
1960	329.5
1916	309.6
1340	274.7
1394	286.7
1681	330.2
1468	252.5
3692	461.7
1456	279
1430	315.2

SLR

Simple Linear Regression Analysis			Appraised Value (in K) based on House Size (Sq Ft)						Calculations
									b1, b0 Coefficients	0.2074	49.1023
Regression Statistics									b1, b0 Standard Error	0.0185	39.5025
Multiple R	0.7665								R Square, Standard Error	0.5875	121.2296
R Square	0.5875								F, Residual df	125.3187	88.0000
Adjusted R Square	0.5828								Regression SS, Residual SS	1841760.0995	1293302.0944
Standard Error	121.2296
Observations	90								Confidence level	95%
									t Critical Value	1.9873
ANOVA									Half Width b0	78.5029
	df	SS	MS	F	Significance F				Half Width b1	0.0368
Regression	1	1841760.0995	1841760.0995	125.3187	0.0000
Residual	88	1293302.0944	14696.6147
Total	89	3135062.1939
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95%	Upper 95%
Intercept	49.1023	39.5025	1.2430	0.2172	-29.4006	127.6052	-29.4006	127.60523
House Size(sq ft)	0.2074	0.0185	11.1946	0.0000	0.1706	0.2443	0.1706	0.24427

DataCopy3

House Size(sq ft)
2448
1942
2073
2707
2042
2089
1433
2991
1008
3202
2230
1848
2100
1846
1331
1344
1822
2479
1605
2080
2410
1753
1884
2050
2978
2132
1551
1129
1674
1184
2194
3032
1970
3356
2070
2826
1606
2063
1392
1120
1817
2496
1615
4067
3130
1423
1799
2936
1439
4065
2191
2008
2070
2710
1416
3244
2493
2473
1968
3136
3227
2618
1928
2145
1559
1550
1668
1423
1175
1214
1856
1223
961
1679
2316
1422
2399
1091
1225
1353
1680
1960
1916
1340
1394
1681
1468
3692
1456
1430

CompleteStatistics3

House Size
	House Size(sq ft)
Mean	2017.1
Median	1922
Mode	2070
Minimum	961
Maximum	4067
Range	3106
Variance	480882.1360
Standard Deviation	693.4567
Coeff. of Variation	34.38%
Skewness	0.9194
Kurtosis	0.5135
Count	90
Standard Error	73.0967

DataCopy2

Glen Cove or Roslyn	Freeport
521.5	447.9
419.5	367.3
484.5	344.7
603.9	339.6
461.4	333.8
429.6	332.9
370.5	295.7
805.2	299.4
273.2	251.7
691.2	241
406.2	318.2
510.5	281.5
411.7	211.8
327.2	310.2
359.8	343.2
343.9	240.3
452.2	341.9
669	275.7
369.6	278.8
419	244.7
419.8	307.3
360.6	329.5
497.2	309.6
408.6	274.7
518.8	286.7
375.5	330.2
388.3	252.5
332.1	461.7
452.5	279
277.4	315.2
736.9
661.5
513.4
968.2
472.2
782.1
448.6
667.9
410.9
354.5
526.5
566.2
573.2
928.8
910.2
430.3
598.5
609.5
420.7
867.3
767.3
654.2
706.8
566.6
434.8
841.5
824.2
735.4
671.3
821.9

CompleteStats 2 Gps

Appraised Value (in K) based on Town
	Glen Cove or Roslyn	Freeport
Mean	547.1966666667	308.2233333333
Median	503.85	308.45
Mode	ERROR:#N/A	ERROR:#N/A
Minimum	273.2	211.8
Maximum	968.2	461.7
Range	695	249.9
Variance	32292.1634	3022.7405
Standard Deviation	179.7002	54.9795
Coeff. of Variation	32.84%	17.84%
Skewness	0.6380	0.9965
Kurtosis	-0.6062	1.8778
Count	60	30
Standard Error	23.1992	10.0378

DataCopy

AppraisedValue
521.5
419.5
484.5
603.9
461.4
429.6
370.5
805.2
273.2
691.2
406.2
510.5
411.7
327.2
359.8
343.9
452.2
669
369.6
419
419.8
360.6
497.2
408.6
518.8
375.5
388.3
332.1
452.5
277.4
736.9
661.5
513.4
968.2
472.2
782.1
448.6
667.9
410.9
354.5
526.5
566.2
573.2
928.8
910.2
430.3
598.5
609.5
420.7
867.3
767.3
654.2
706.8
566.6
434.8
841.5
824.2
735.4
671.3
821.9
447.9
367.3
344.7
339.6
333.8
332.9
295.7
299.4
251.7
241
318.2
281.5
211.8
310.2
343.2
240.3
341.9
275.7
278.8
244.7
307.3
329.5
309.6
274.7
286.7
330.2
252.5
461.7
279
315.2

CompleteStats

Appraised Value (in K)
	AppraisedValue
Mean	467.5388888889
Median	419.25
Mode	ERROR:#N/A
Minimum	211.8
Maximum	968.2
Range	756.4
Variance	35225.4179
Standard Deviation	187.6844
Coeff. of Variation	40.14%
Skewness	0.9352
Kurtosis	-0.0522
Count	90
Standard Error	19.7837

FiveNumbers

Appraised Value
Five-Number Summary
Minimum	211.8
First Quartile	329.5
Median	419.25
Third Quartile	573.2
Maximum	968.2

BoxPlot

Appraised Value (in K)

AppraisedValue

211.8 211.8 211.8 0.5 1 1.5 329.5 329.5 329.5 0.5 1 1.5 419.25 419.25 419.25 0.5 1 1.5 573.20000000000005 573.20000000000005 573.20000000000005 0.5 1 1.5 968.2 968.2 968.2 0.5 1 1.5 211.8 968.2 1 1 329.5 573.20000000000005 0.5 0.5 329.5 573.20000000000005 1.5 1.5

ForBoxPlot

211.8	0.5
211.8	1
211.8	1.5
329.5	0.5
329.5	1
329.5	1.5
419.25	0.5
419.25	1
419.25	1.5
573.2	0.5
573.2	1
573.2	1.5
968.2	0.5
968.2	1
968.2	1.5
211.8	1
968.2	1
329.5	0.5
573.2	0.5
329.5	1.5
573.2	1.5

FiveNumbers 2

Appraised Value and Town
Five-Number Summary
	Glen Cove or Roslyn	Freeport
Minimum	273.2	211.8
First Quartile	410.9	275.7
Median	503.85	308.45
Third Quartile	671.3	333.8
Maximum	968.2	461.7

BoxPlot 2 Gps

Appraised Value (in K) based on Town

Glen Cove or Roslyn

273.2 273.2 273.2 0.5 1 1.5 410.9 410.9 410.9 0.5 1 1.5 503.85 503.85 503.85 0.5 1 1.5 671.3 671.3 671.3 0.5 1 1.5 968.2 968.2 968.2 0.5 1 1.5 273.2 968.2 1 1 410.9 671.3 0.5 0.5 410.9 671.3 1.5 1.5

Freeport

211.8 211.8 211.8 2 2.5 3 275.7 275.7 275.7 2 2.5 3 308.45000000000005 308.45000000000005 308.45000000000005 2 2.5 3 333.8 333.8 333.8 2 2.5 3 461.7 461.7 461.7 2 2.5 3 211.8 461.7 2.5 2.5 275.7 333.8 2 2 275.7 333.8 3 3

ForBoxPlot2

273.2	0.5	211.8	2
273.2	1	211.8	2.5
273.2	1.5	211.8	3
410.9	0.5	275.7	2
410.9	1	275.7	2.5
410.9	1.5	275.7	3
503.85	0.5	308.45	2
503.85	1	308.45	2.5
503.85	1.5	308.45	3
671.3	0.5	333.8	2
671.3	1	333.8	2.5
671.3	1.5	333.8	3
968.2	0.5	461.7	2
968.2	1	461.7	2.5
968.2	1.5	461.7	3
273.2	1	211.8	2.5
968.2	1	461.7	2.5
410.9	0.5	275.7	2
671.3	0.5	333.8	2
410.9	1.5	275.7	3
671.3	1.5	333.8	3

FiveNumbers3

House Size
Five-Number Summary
Minimum	961
First Quartile	1439
Median	1922
Third Quartile	2410
Maximum	4067

BoxPlot3

House Size

House Size(sq ft)

961 961 961 0.5 1 1.5 1439 1439 1439 0.5 1 1.5 1922 1922 1922 0.5 1 1.5 2410 2410 2410 0.5 1 1.5 4067 4067 4067 0.5 1 1.5 961 4067 1 1 1439 2410 0.5 0.5 1439 2410 1.5 1.5

ForBoxPlot3

961	0.5
961	1
961	1.5
1439	0.5
1439	1
1439	1.5
1922	0.5
1922	1
1922	1.5
2410	0.5
2410	1
2410	1.5
4067	0.5
4067	1
4067	1.5
961	1
4067	1
1439	0.5
2410	0.5
1439	1.5
2410	1.5

DataCopy4

Town

Glen Cove or Roslyn

Freeport

Bar Chart

Town

Freeport Glen Cove or Roslyn 30 60

Town

OneWayTable

Town
Count of Town
Town	Total
Freeport	30
Glen Cove or Roslyn	60
Grand Total	90

SideBySide

Pool based on Town

No Freeport Glen Cove or Roslyn 17 24 Yes Freeport Glen Cove or Roslyn 13 36

TwoWayTable

Pool based on Town
Count of Town	Pool
Town	No	Yes	Grand Total
Freeport	17	13	30
Glen Cove or Roslyn	24	36	60
Grand Total	41	49	90

Variable INFO

Long Island Real Estate
Random Sample of 90 Home Characteristics in 3 Long Island Communities
Variables
AppraisedValue	Value	in thousands of dollars (K)
Land		in acres
House Size		is square feet of living space
Rooms		total number of rooms in house
Bathrms		number of bathrooms in house
Town		the town	(Glen Cove or Roslyn, Freeport)
Pool		whether the property has a pool		(Yes, No)

DATA

Long Island Real Estate Data
AppraisedValue	Land (acres)	House Size(sq ft)	Rooms	Bathrms	Town	Pool
521.5	0.230	2448	7	3.5	Glen Cove or Roslyn	Yes
419.5	0.219	1942	7	2.5	Glen Cove or Roslyn	Yes
484.5	0.163	2073	5	3	Glen Cove or Roslyn	Yes
603.9	0.461	2707	8	2.5	Glen Cove or Roslyn	Yes
461.4	0.255	2042	7	1.5	Glen Cove or Roslyn	Yes
429.6	0.229	2089	7	2	Glen Cove or Roslyn	No
370.5	0.181	1433	7	2	Glen Cove or Roslyn	No
805.2	0.502	2991	9	2.5	Glen Cove or Roslyn	Yes
273.2	0.223	1008	5	1	Glen Cove or Roslyn	No
691.2	0.130	3202	8	2.5	Glen Cove or Roslyn	Yes
406.2	0.176	2230	8	2	Glen Cove or Roslyn	No
510.5	0.420	1848	7	2	Glen Cove or Roslyn	No
411.7	0.252	2100	6	2	Glen Cove or Roslyn	Yes
327.2	0.115	1846	5	3	Glen Cove or Roslyn	No
359.8	0.169	1331	5	1	Glen Cove or Roslyn	No
343.9	0.171	1344	8	1	Glen Cove or Roslyn	No
452.2	0.385	1822	6	2	Glen Cove or Roslyn	No
669	0.655	2479	6	2.5	Glen Cove or Roslyn	Yes
369.6	0.172	1605	6	3	Glen Cove or Roslyn	No
419	0.144	2080	11	2	Glen Cove or Roslyn	No
419.8	0.276	2410	6	1	Glen Cove or Roslyn	Yes
360.6	0.115	1753	8	2	Glen Cove or Roslyn	No
497.2	0.364	1884	7	2	Glen Cove or Roslyn	Yes
408.6	0.147	2050	10	2	Glen Cove or Roslyn	Yes
518.8	0.228	2978	6	2.5	Glen Cove or Roslyn	Yes
375.5	0.463	2132	7	1	Glen Cove or Roslyn	No
388.3	0.189	1551	6	2	Glen Cove or Roslyn	No
332.1	0.123	1129	5	1	Glen Cove or Roslyn	Yes
452.5	0.149	1674	7	2	Glen Cove or Roslyn	Yes
277.4	0.085	1184	5	1	Glen Cove or Roslyn	No
736.9	0.283	2194	7	2.5	Glen Cove or Roslyn	Yes
661.5	0.115	3032	8	2.5	Glen Cove or Roslyn	Yes
513.4	0.217	1970	6	3	Glen Cove or Roslyn	Yes
968.2	0.376	3356	9	4.5	Glen Cove or Roslyn	Yes
472.2	0.136	2070	10	2	Glen Cove or Roslyn	Yes
782.1	0.243	2826	8	2	Glen Cove or Roslyn	Yes
448.6	0.154	1606	9	2	Glen Cove or Roslyn	No
667.9	0.235	2063	6	2.5	Glen Cove or Roslyn	Yes
410.9	0.222	1392	7	1	Glen Cove or Roslyn	No
354.5	0.175	1120	6	1.5	Glen Cove or Roslyn	No
526.5	0.213	1817	6	2	Glen Cove or Roslyn	No
566.2	0.138	2496	7	2	Glen Cove or Roslyn	Yes
573.2	0.250	1615	7	2	Glen Cove or Roslyn	Yes
928.8	0.412	4067	8	4	Glen Cove or Roslyn	Yes
910.2	0.337	3130	8	3	Glen Cove or Roslyn	Yes
430.3	0.150	1423	6	2	Glen Cove or Roslyn	No
598.5	0.235	1799	6	2.5	Glen Cove or Roslyn	Yes
609.5	0.115	2936	8	2.5	Glen Cove or Roslyn	Yes
420.7	0.138	1439	7	1	Glen Cove or Roslyn	No
867.3	0.456	4065	7	2.5	Glen Cove or Roslyn	Yes
767.3	0.556	2191	8	3	Glen Cove or Roslyn	No
654.2	0.278	2008	7	2.5	Glen Cove or Roslyn	Yes
706.8	0.278	2070	6	2	Glen Cove or Roslyn	No
566.6	0.230	2710	7	2.5	Glen Cove or Roslyn	No
434.8	0.138	1416	7	1.5	Glen Cove or Roslyn	Yes
841.5	0.212	3244	6	2	Glen Cove or Roslyn	Yes
824.2	0.354	2493	6	3	Glen Cove or Roslyn	Yes
735.4	0.235	2473	6	2.5	Glen Cove or Roslyn	Yes
671.3	0.333	1968	6	2	Glen Cove or Roslyn	Yes
821.9	0.361	3136	9	3.5	Glen Cove or Roslyn	Yes
447.9	0.398	3227	13	1.5	Freeport	Yes
367.3	0.354	2618	9	3	Freeport	Yes
344.7	0.207	1928	8	2	Freeport	No
339.6	0.023	2145	8	2.5	Freeport	Yes
333.8	0.161	1559	6	3	Freeport	Yes
332.9	0.122	1550	5	2	Freeport	No
295.7	0.172	1668	6	2	Freeport	Yes
299.4	0.131	1423	7	1.5	Freeport	No
251.7	0.115	1175	4	2	Freeport	No
241	0.126	1214	6	1.5	Freeport	No
318.2	0.115	1856	6	2	Freeport	Yes
281.5	0.115	1223	6	1.5	Freeport	No
211.8	0.080	961	5	1	Freeport	No
310.2	0.307	1679	8	1	Freeport	Yes
343.2	0.188	2316	10	3	Freeport	Yes
240.3	0.103	1422	6	1	Freeport	No
341.9	0.172	2399	8	2	Freeport	Yes
275.7	0.138	1091	7	1	Freeport	No
278.8	0.103	1225	6	1	Freeport	No
244.7	0.115	1353	5	1	Freeport	No
307.3	0.145	1680	6	1	Freeport	No
329.5	0.225	1960	8	1	Freeport	Yes
309.6	0.111	1916	9	2	Freeport	Yes
274.7	0.140	1340	5	1	Freeport	No
286.7	0.126	1394	6	1	Freeport	No
330.2	0.072	1681	8	2	Freeport	Yes
252.5	0.144	1468	6	1	Freeport	No
461.7	0.344	3692	9	2	Freeport	Yes
279	0.149	1456	5	1	Freeport	No
315.2	0.131	1430	6	1.5	Freeport	No