Question: Continue to work with the Real Estate data set from Assignment 2. Use the Data Analysis add-in to create a table that presents the descriptive




Continue to work with the Real Estate data set from Assignment 2. Use the Data Analysis add-in to create a table that presents the descriptive statistics for the following data: price, bedrooms, age, acreage, real estate taxes and assessed value. Demonstrate good table design as covered in the lecture notes and readings. The table should be in a separate worksheet (tab) which is labeled. Within this worksheet, please write a brief discussion which highlights E{itrinlportant elements and demonstrates your understanding of standard deviation. Real Estate data set ? BEDROOM PRICE ASSESS VALUE RETAXES AGE ACRE Mean 3.912547529 $ 555,820.95 $ 254,795.66 $ 6,012.23 30.62357414 1.6 .... Standard Error 0.053738504 $ 18,994.40 $ 9.473.49 $ 282.26 2.37887345 0.3 Median 41 $ 495,000.00 $ 234,510.00 $ 5,225.00 20 0.9 ..... Mode $ 675,000.00 $ $ 1.0 Standard Deviation | 0.871492081 $ 308,037.42 $ 153,634.18 $ 4,577.50 38.57884431 5.4 Sample Variance 0.759498447| $ 94,887,052,085.00 $ 23,603,462,480.09 $ 20,953,512.09 1488.327228 29.5 Kurtosis 3.979830698 $ 18.81 $ 2.58 $ 22.72 11.23749979 89.5 .... Skewness 0.86800452 $ 3.16 $ 1. 14 $ 3.33 3.09313252 9.0 Range 7 $ 2,940,000.00 $ 953,490.00 $ 45,828.00 240 61.6 Minimum 2 $ 125,000.00 $ $ ....SSSSSS O 0.0 .................... Maximum g $ 3,065,000.00 $ 953,490.00 $ 45.828.00 240 61.6 ..... Sum 1029 $ 146, 180,909.00 $ 67,011,258.00 $ 1,581,217.00 8054 433.6 Count 263 $ 263.00 $ 263.00 $ 263.00 263 263.0
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
