The following table consists of house data. Copy and paste this data into Excel in order to import it to the appropriate software(s). After completing your work, input the requested results here in addition to the formal report submitted in Canvas.

House ID	Stories	Bedrooms	Bathrooms	Square Footage
1	1	3	2.5	2920
2	2	3	2	3230
3	1	2	1.5	2050
4	2	4	3.5	2357
5	1	5	4	3011
6	2	4	3.5	3091
7	1	2	1	1972
8	2	3	2.5	2367
9	1	3	2.5	2635
10	2	4	3	3154
11	2	4	3	3252
12	2	5	4	5203
13	2	4	3.5	2798
14	2	3	2.5	1784
15	2	5	4.5	3952
16	1	2	1	2296
17	2	4	3.5	2274
18	1	3	2	2330
19	1	3	2	2458
20	1	4	3.5	1772
21	1	4	3.5	3175
22	1	4	3	2198
23	1	3	2	1246
24	1	3	2	2995

Mean of "Total Rooms" (Round answer to 2 decimal places) = Median of "Total Rooms" (Round answer to 2 decimal places) = Standard deviation of "Total Rooms" (Round answer to 2 decimal places) = Mean of "Total Rooms" for two story houses (Round answer to 2 decimal places) = Median of "Total Rooms" for two story houses (Round answer to 2 decimal places) = Standard deviation of "Total Rooms" for two story houses (Round answer to 2 decimal places) = Number of houses at least 4k square feet = Number of houses at least 3k square feet but less than 4k square feet = Number of houses at least 2k square feet but less than 3k square feet = Number of houses less than 2k square feet Submit QuestionQuestion 2=