10 pages

scheduals.docx

Home >Business & Finance homework help >Management homework help >10 pages

Table 1

Independent Variable Skewness Values – Pre-Transformation

Descriptive Statistics

	Skewness	Std. Error
Listing price ($)	.567	.309
Interior floor size (sqft)	.141	.309
Land size (sqft)	2.412	.309
# bedrooms	-.257	.309
# bathrooms	-.107	.309
Year Built	-.343	.309
Walkscore	-.293	.309
Walkability 70>=1 , 70<=0	2.213	.309
Building age (years)	.343	.309
Fireplace	.511	.309
Valid N (listwise)

Table 2

Independent Variable Skewness Values – Post Transformation

Descriptive Statistics
	N	Skewness
	Statistic	Statistic	Std. Error
Price Log 10	60	-.125	.309
interior floor size sqft Log 10	60	-.286	.309
Land size sqft Log 10	60	1.058	.309
Bedrooms Log 10	60	-.788	.309
Bathrooms Log 10	60	-.741	.309
Year Built Log 10	60	-.356	.309
Walk score Log 10	60	-1.620	.309
Walkability Log 10	8	.	.
Building age years Log 10	60	-.393	.309
Fireplace Log 10	58	.109	.314
Valid N (list wise)	8

Statistics
	LandsizesqftLog10	bedroomsLog10	bathroomsLog10	YearBuiltLog10	nteriorfloorsizesqftLog10
N	60	60	60	60	60
	24	24	24	24	24
25 Q1 50 Q2 75 Q3	3.7793	.6021	.4771	3.2919	3.3907
	3.8622	.6990	.6505	3.2993	3.5359
	3.9651	.7782	.7782	3.3045	3.6663

Table 3

Independent Variable Skewness Values

Variable	Q1	Q3	Lower Boundary	Upper Boundary
Land size sqft Log 10	3.7793	3.9651	3.37054	4.37386
Bedrooms Log 10	.6021	.7782	0.21468	1.16562
Bathrooms Log 10	.4771	.7782	-0.18532	1.44062
Year Built Log 10	3.2919	3.3045	3.26418	3.33222
Interior floor size sqft Log 10	3.3907	3.6663	2.78438	4.27262

Note: Q1 represents the 25th percentile and Q3 represents the 75th percentile. Lower Boundary = Q1 – ((Q3-Q1) X 2.2), and Upper Boundary = Q3 + ((Q3-Q1) X 2.2) (Hoaglin & Iglewicz, 1987)

Sample ID	Listing price	Interior floor size (sqft)	Land size (sqft)	beds	baths	Yr Built	Walkscore	Walkability 70>=1 , 70<=0	Building age	Fireplace
1	$1,119,000	1,720	4,000	5	3	1983	66	0	34	0
2	$1,359,000	2,648	4,420	7	3	1983	85	1	34	1
3	$1,388,000	1,678	4,092	3	2	1957	70	1	60	1
4	$1,498,800	2,425	7,200	3	3	1973	33	0	44	2
5	$1,499,000	2,448	9,240	4	3	1973	35	0	44	2
6	$1,499,000	2,134	6,600	3	2	1958	50	0	59	1
7	$1,589,999	2,206	4,360	3	3	1980	68	0	37	2
8	$1,598,000	1,913	12,735	3	1	1952	58	0	65	1
9	$1,650,000	2,464	6,231	4	2	1959	61	0	58	1
10	$1,660,000	2,996	7,000	4	3	1958	44	0	59	1
11	$1,668,000	2,550	8,777	6	2	1958	42	0	59	2
12	$1,680,000	2,450	4,455	5	5	1995	74	1	22	4
13	$1,799,000	3,114	7,200	6	4	1976	47	0	41	1
14	$1,978,000	2,457	7,540	5	3	1954	12	0	63	1
15	$1,980,000	3,463	7,276	5	4	2008	66	0	9	1
16	$1,980,000	1,724	9,450	2	2	1970	15	0	47	1
17	$2,088,800	2,213	7,197	4	4	1977	59	0	40	2
18	$2,089,000	3,005	4,200	5	6	2016	56	0	1	1
19	$2,098,000	3,252	4,620	7	6	2006	63	0	11	3
20	$2,098,000	3,332	4,554	6	5	2016	73	1	1	3
21	$2,188,000	3,476	6,004	7	6	2013	72	1	4	1
22	$2,188,000	3,188	6,050	5	5	1989	37	0	28	3
23	$2,188,000	3,410	27,500	6	4	1969	57	0	48	2
24	$2,248,000	3,315	4,356	7	4	2016	23	0	1	1
25	$2,248,000	3,271	8,830	5	3	1978	54	0	39	2
26	$2,298,000	2,188	8,645	3	2	1957	65	0	60	1
27	$2,298,800	3,460	4,920	6	5	2016	72	1	1	1
28	$2,298,800	3,460	4,920	6	5	2016	72	1	1	1
29	$2,298,000	2,188	8,645	3	2	1957	56	0	60	1
30	$2,338,000	2,244	10,235	3	2	1957	28	0	60	1
31	$2,388,000	4,246	5,907	7	5	2016	62	0	1	2
32	$2,480,000	5,759	18,428	5	5	1997	18	0	20	2
33	$2,488,000	4,776	7,000	8	7	2012	59	0	5	2
34	$2,538,000	4,272	6,480	6	6	2015	37	0	2	1
35	$2,588,000	4,764	7,357	6	6	2016	54	0	1	4
36	$2,598,000	4,716	7,773	6	6	2016	46	0	1	2
37	$2,688,000	2,734	12,547	4	2	1955	8	0	62	2
38	$2,698,000	2,541	7,070	5	3	1976	68	0	41	0
39	$2,738,000	5,066	7,000	7	7	2016	69	0	1	2
40	$2,788,000	3,163	9,193	3	3	2011	6	0	6	3
41	$2,798,888	4,897	6,975	8	6	2016	68	0	1	2
42	$2,799,900	4,124	6,000	6	5	1921	87	1	96	1
43	$2,880,000	4,100	7,287	6	5	1999	21	0	18	4
44	$2,889,000	5,031	8,050	7	6	2014	29	0	3	2
45	$2,900,000	4,396	7,000	6	6	2016	51	0	1	2
46	$2,988,000	5,165	8,712	7	7	2004	22	0	13	3
47	$2,998,000	2,246	13,480	4	2	1964	5	0	53	1
48	$3,088,000	5,251	7,200	6	6	2014	30	0	3	1
49	$3,380,000	4,003	23,220	3	3	1955	24	0	62	2
50	$3,388,000	5,010	8,052	6	6	2016	29	0	1	2
51	$3,398,888	3,565	20,472	5	3	1951	7	0	66	2
52	$3,480,000	4,660	13,200	6	6	2014	31	0	3	2
53	$3,495,000	4,259	6,000	6	5	2015	44	0	2	1
54	$3,648,000	4,923	7,540	7	6	2016	26	0	1	2
55	$3,688,000	5,399	8,050	6	6	2016	47	0	1	3
56	$3,788,000	4,484	7,920	5	6	2016	54	0	1	2
57	$3,960,000	4,572	34,123	5	5	1958	9	0	59	3
58	$3,988,000	3,850	22,600	7	4	1956	3	0	61	3
59	$4,388,000	4,751	15,284	4	4	1966	2	0	51	3
60	$4,588,000	5,560	10,675	5	7	2016	63	0	1	3