(2-3 pages) Case Study Business Report

Anonymous

Question 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

Tutor Answer

mickeygabz
School: Duke University

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 ...

flag Report DMCA
Review

Anonymous
Top quality work from this tutor! I’ll be back!

Anonymous
It’s my second time using SP and the work has been great back to back :) The one and only resource on the Interwebs for the work that needs to be done!

Anonymous
Thanks, good work

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
Similar Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors