Question

HOUSE	PRICE	YRSOLD	HSQFT	LOTSFT	YRBUILT	PRICE_PER_SQFT	NEB
1	$536,000	2009.00	1,500	4,000	1930	$357	WESTERLEIGH
2	$498,000	2009.00	1,563	6,100	1950	$318	WESTERLEIGH
3	$506,500	2009.00	1,536	4,000	1950	$329	WESTERLEIGH
4	$630,000	2009.00	1,152	4,000	1949	$546	WESTERLEIGH
5	$455,000	2009.00	1,214	2,775	1925	$374	WESTERLEIGH
6	$265,000	2009.00	1,627	1,800	1985	$190	WESTERLEIGH
7	$347,500	2009.00	1,100	4,500	1950	$315	WESTERLEIGH
8	$320,000	2009.00	1,104	3,000	1925	$289	WESTERLEIGH
9	$535,000	2009.00	2,400	3,879	2000	$222	WESTERLEIGH
10	$456,300	2009.00	1,650	2,552	2007	$277	WESTERLEIGH
11	$440,000	2009.00	1,124	2,405	1930	$391	WESTERLEIGH
12	$413,000	2009.00	1,410	3,600	1955	$292	WESTERLEIGH
13	$320,000	2009.00	1,740	7,230	1950	$183	WESTERLEIGH
14	$270,000	2009.00	1,080	1,590	1925	$250	WESTERLEIGH
15	$375,000	2009.00	1,158	4,500	1920	$323	WESTERLEIGH
16	$485,000	2009.00	1,685	5,000	1925	$287	WESTERLEIGH
17	$448,000	2009.00	1,776	3,000	1915	$252	WESTERLEIGH
18	$425,000	2009.00	1,148	6,100	1955	$370	WESTERLEIGH
19	$376,500	2009.00	1,237	3,000	1920	$304	WESTERLEIGH
20	$350,000	2009.00	890	3,600	1920	$393	WESTERLEIGH
21	$470,000	2009.00	1,205	5,900	1955	$390	WESTERLEIGH
22	$420,000	2009.00	1,207	3,828	1945	$347	WESTERLEIGH
23	$410,000	2009.00	1,256	3,600	1930	$342	WESTERLEIGH
24	$440,000	2009.00	900	3,600	1960	$488	WESTERLEIGH
25	$395,000	2009.00	1,176	3,920	1930	$335	WESTERLEIGH
26	$355,000	2009.00	1,296	3,000	1940	$304	WESTERLEIGH
27	$415,000	2009.00	1,092	4,000	1960	$380	WESTERLEIGH
28	$495,000	2009.00	1,950	3,600	1920	$253	WESTERLEIGH
29	$355,425	2009.00	1,600	1,744	1993	$222	WESTERLEIGH
30	$410,000	2009.00	1,440	3,742	1965	$284	WESTERLEIGH
31	$447,500	2009.00	1,450	3,000	1970	$308	WESTERLEIGH
32	$420,000	2009.00	1,420	3,758	2006	$296	WESTERLEIGH
33	$455,000	2009.00	1,427	3,800	1920	$318	WESTERLEIGH
34	$380,000	2009.00	1,480	2,100	1970	$256	WESTERLEIGH
35	$400,000	2009.00	1,512	4,000	1960	$264	WESTERLEIGH
36	$310,000	2009.00	1,240	960	1993	$250	WESTERLEIGH
37	$365,000	2009.00	840	5,000	1955	$434	WESTERLEIGH
38	$370,000	2009.00	1,280	3,456	1965	$289	WESTERLEIGH
39	$415,000	2009.00	1,820	4,200	1960	$228	WESTERLEIGH
40	$419,796	2009.00	1,592	7,575	1930	$263	WESTERLEIGH
41	$380,000	2009.00	1,280	3,408	1965	$296	WESTERLEIGH
42	$410,000	2009.00	1,332	2,800	1970	$307	WESTERLEIGH
43	$435,000	2009.00	1,660	2,373	1995	$262	WESTERLEIGH
44	$515,000	2009.00	1,712	5,880	1930	$300	WESTERLEIGH
45	$370,000	2009.00	1,450	4,000	1955	$255	WESTERLEIGH
46	$429,000	2009.00	4,040	4,040	1950	$106	WESTERLEIGH
47	$295,000	2009.00	1,320	2,000	1940	$223	WESTERLEIGH
48	$520,000	2009.00	1,500	5,000	1960	$346	WESTERLEIGH
49	$410,000	2009.00	1,500	3,000	1925	$273	WESTERLEIGH
50	$379,000	2009.00	926	4,000	1955	$409	WESTERLEIGH
51	$487,500	2009.00	2,472	3,420	1970	$197	MARINER
52	$425,000	2009.00	2,400	3,800	1975	$177	MARINER
53	$370,000	2009.00	2,100	5,500	1935	$176	MARINER
54	$300,000	2009.00	1,870	2,500	1920	$160	MARINER
55	$385,000	2009.00	1,340	2,500	1925	$287	MARINER
56	$265,000	2009.00	1,992	3,591	1975	$133	MARINER
57	$300,000	2009.00	2,416	3,325	1980	$124	MARINER
58	$339,000	2009.00	1,820	2,850	1920	$186	MARINER
59	$350,000	2009.00	1,650	2,500	1903	$212	MARINER
60	$460,000	2009.00	1,744	4,419	2008	$263	MARINER
61	$214,200	2009.00	1,270	5,721	1925	$168	MARINER
62	$270,000	2009.00	2,200	1,512	1931	$122	MARINER
63	$220,000	2009.00	1,408	2,560	1901	$156	MARINER
64	$290,000	2009.00	1,540	4,950	1901	$188	MARINER
65	$335,000	2009.00	2,800	2,880	1920	$119	MARINER
66	$400,000	2009.00	2,052	5,900	1920	$194	MARINER
67	$485,000	2009.00	1,884	2,886	1975	$257	MARINER
68	$500,000	2009.00	2,080	4,326	1970	$240	MARINER
69	$414,726	2009.00	2100	3,594	2005	$197	MARINER
70	$415,740	2009.00	1,400	3,594	2005	$296	MARINER
71	$560,000	2009.00	2,568	4,000	1970	$218	MARINER
72	$390,100	2009.00	1,896	3,630	1970	$205	MARINER

You have downloaded the MS_Excel file with data on the prices of homes in two neighborhoods around the City of New York. The data is taken from Staten Island.

Using the MS_Excel, calculate:

c. The Average and the Standard Deviation for Age of houses in the two neighborhoods. Please note that you must calculate the Age of each house sold. Take note also that all houses were sold in 2009.

And please post the actual excel chart you come up with.

Answer 1

To find mean=Average (number1:number 50)

instead of writing number 1 and number 50, you have to select the cell range of house price from house 1 to house 50

It will result in $414,850 (Mean of Westerleigh)

==>STDEV.S(number 1: number 50)

instead of writing number 1 and number 50, you have to select the cell range of house price from house 1 to house 50

It will result in 71,711.405 (Standard Deviation of Westerleigh)

Similarly Mean and Standard deviation of Mariner could be found.

=>

Mean of Mariner = $371,648

Standard Deviation of Mariner = 93427.5069

-------------------------------

-------------------------------