(2-3 pages) Case Study Business Report

User Generated

Nmvm456

Mathematics

Description

Questions must be answered in the form of a report. (Example attached)

Refer to the Real Estate data, which reports information on homes sold in the Goodyear, Arizona, area during the last year. Prepare a report on the selling prices of the homes. Be sure to answer the following questions in your report.

a. Around what values do the data tend to cluster? What is the mean selling price? What is the median selling price? Is one measure more representative of the typical selling prices than the others?

b. What is the range of selling prices? What is the standard deviation? About 95 percent of the selling prices are between what two values?

Unformatted Attachment Preview

Price Bedrooms Size Pool Distance Twnship Garage 263,1 4 2300 0 17 5 1 182,4 4 2100 1 19 4 0 242,1 3 2300 1 12 3 0 213,6 2 2200 1 16 2 0 139,9 2 2100 1 28 1 0 245,4 2 2100 0 12 1 1 327,2 6 2500 1 15 3 1 271,8 2 2100 1 9 2 1 221,1 3 2300 0 18 1 0 266,6 4 2400 1 13 4 1 292,4 4 2100 1 14 3 1 209 2 1700 1 8 4 1 270,8 6 2500 1 7 4 1 246,1 4 2100 1 18 3 1 194,4 2 2300 1 11 3 0 281,3 3 2100 1 16 2 1 172,7 4 2200 0 16 3 0 207,5 5 2300 0 21 4 0 198,9 3 2200 0 10 4 1 209,3 6 1900 0 15 4 1 252,3 4 2600 1 8 4 1 192,9 4 1900 0 14 2 1 209,3 5 2100 1 20 5 0 345,3 8 2600 1 9 4 1 326,3 6 2100 1 11 5 1 173,1 2 2200 0 21 5 1 187 2 1900 1 26 4 0 257,2 2 2100 1 9 4 1 233 3 2200 1 14 3 1 180,4 2 2000 1 11 5 0 234 2 1700 1 19 3 1 207,1 2 2000 1 11 5 1 247,7 5 2400 1 16 2 1 166,2 3 2000 0 16 2 1 177,1 2 1900 1 10 5 1 182,7 4 2000 0 14 4 0 216 4 2300 1 19 2 0 312,1 6 2600 1 7 5 1 199,8 3 2100 1 19 3 1 273,2 5 2200 1 16 2 1 206 3 2100 0 9 3 0 232,2 3 1900 0 16 1 1 198,3 4 2100 0 19 1 1 205,1 3 2000 0 20 4 0 175,6 4 2300 0 24 4 1 307,8 3 2400 0 21 2 1 269,2 5 2200 1 8 5 1 224,8 3 2200 1 17 1 1 171,6 3 2000 0 16 4 0 216,8 3 2200 1 15 1 1 192,6 6 2200 0 14 1 0 236,4 5 2200 1 20 3 1 172,4 3 2200 1 23 3 0 251,4 3 1900 1 12 2 1 246 6 2300 1 7 3 1 147,4 6 1700 0 12 1 0 176 4 2200 1 15 1 1 228,4 3 2300 1 17 5 1 166,5 3 1600 0 19 3 0 189,4 4 2200 1 24 1 1 312,1 7 2400 1 13 3 1 289,8 6 2000 1 21 3 1 269,9 5 2200 0 11 4 1 154,3 2 2000 1 13 2 0 222,1 2 2100 1 9 5 1 209,7 5 2200 0 13 2 1 190,9 3 2200 0 18 3 1 254,3 4 2500 0 15 3 1 207,5 3 2100 0 10 2 0 209,7 4 2200 0 19 2 1 294 2 2100 1 13 2 1 176,3 2 2000 0 17 3 0 294,3 7 2400 1 8 4 1 224 3 1900 0 6 1 1 125 2 1900 1 18 4 0 236,8 4 2600 0 17 5 1 164,1 4 2300 1 19 4 0 217,8 3 2500 1 12 3 0 192,2 2 2400 1 16 2 0 125,9 2 2400 1 28 1 0 220,9 2 2300 0 12 1 1 294,5 6 2700 1 15 3 1 244,6 2 2300 1 9 2 1 199 3 2500 0 18 1 0 240 4 2600 1 13 4 1 263,2 4 2300 1 14 3 1 188,1 2 1900 1 8 4 1 243,7 6 2700 1 7 4 1 221,5 4 2300 1 18 3 1 175 2 2500 1 11 3 0 253,2 3 2300 1 16 2 1 155,4 4 2400 0 16 3 0 186,7 5 2500 0 21 4 0 179 3 2400 0 10 4 1 188,3 6 2100 0 15 4 1 227,1 4 2900 1 8 4 1 173,6 4 2100 0 14 2 1 188,3 5 2300 1 20 5 0 310,8 8 2900 1 9 4 1 293,7 6 2400 1 11 5 1 179 3 2400 1 8 4 1 188,3 6 2100 0 14 2 1 227,1 4 2900 1 20 5 0 173,6 4 2100 1 9 4 1 188,3 5 2300 1 11 5 1 Baths 2 2 2 2,5 1,5 2 2 2,5 1,5 2 2 1,5 2 2 2 2 2 2,5 2 2 2 2,5 1,5 2 3 1,5 2 2 1,5 2 2 2 2 2 2 2,5 2 2,5 2 3 1,5 1,5 1,5 2 2 3 3 2,5 2 2 2 2 2 2 3 2 2 1,5 2,5 2 3 3 2,5 2 2 2 2 2 2 2 2,5 2 2 2 1,5 2 2 2 2,5 1,5 2 2 2,5 1,5 2 2 1,5 2 2 2 2 2 2,5 2 2 2 2,5 1,5 2 3 2 2,5 1,5 2 3 An Example of a Report Date: To: From: RE: Analysis of Buena School District Bus Data Per your request, I have prepared an analysis of the Buena School District Bus Data with respect to the maintenance cost for last month. The following questions will be answered throughout the report: • • • • • • • Around what values do the data tend to cluster? What was the mean maintenance cost last month? What was the median cost? Is one measure more representative of the typical cost than the other? What is the range of the maintenance costs? What is the standard deviation (i.e., the variation or spread in the data)? About 95 percent of the maintenance costs are between what two values? Please contact me if there is any additional information needed. Analysis Last month, the Buena School District provided maintenance on 80 vehicles, which totaled $36,023.00. The maintenance was for passenger vehicles that ranged from 6 passengers to 55 passengers in size and had been in use from 1 to 14 years. The miles traveled by the vehicles ranged from 700 to 1,000 miles and each vehicle used either gasoline or diesel fuel. The purpose of this report is to analyze the maintenance cost for the last month. The results of the analysis follow: • • The data tend to cluster around the $400 range. The mean of the data is $450 and the median of the data is $456. The median of the data appears to be more representative of the typical cost than the mean due to the fact that the data are not symmetrical when plotted. The range of maintenance costs is $241, since the smallest cost is $329 and the largest cost is $570. The variation or spread in the data is $53.68. About 95% of the maintenance costs are between $438 and $462. The output on which this report is based is found in the Appendix. If additional information or clarification is needed, please feel free to contact me. APPENDIX: Analysis of School Bus Maintenance Cost (Excel Documentation): Maintenance Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count Confidence Level (95.0%) 450.2875 6.002273 456 329 53.68596 2882.182 -0.15416 -0.16106 241 329 570 36023 80 11.94722
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

See attached

Analysis of House selling Prices
For this paper, analysis was carried out with regards to the selling price of houses in the
Goodyear, Arizona area during the last year. The analysis was carried out based on real estate
data for a sample of 105 houses.
Based on the analysis carried out, the average selling price ...


Anonymous
Super useful! Studypool never disappoints.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags