In Florida, real estate agents refer to homes having a swimming pool as pool homes. In...

80.2K

Verified Solution

Question

General Management

In Florida, real estate agents refer to homes having a swimmingpool as pool homes. In this case, Sunshine Pools Inc.markets and installs pools throughout the state of Florida. Thecompany wishes to estimate the percentage of a pool's cost that canbe recouped by a buyer when he or she sells the home. For instance,if a homeowner buys a pool for which the current purchase price is$30,000 and then sells the home in the current real estate marketfor $20,000 more than the homeowner would get if the home did nothave a pool, the homeowner has recouped (20,000/30,000) × 100% =66.67% of the pool's cost.

To make this estimate, the company randomly selects 80 homesfrom all of the homes sold in a Florida city (over the last sixmonths) having a size between 2,000 and 3,500 square feet. For eachsampled home, the following data are collected:Price - selling price (in thousands ofdollars); Size - square footage;Bathrooms - the number of bathrooms;Rating - a niceness rating (expressed asan integer from 1 to 7 and assigned by a real estate agent); andPool - whether or not the home has a pool(1 = yes, 0 = no). The data are given in the fileFloridaPoolHome-Spring2018.

4.         Compute themean selling prices of the homes having a pool and the homes thatdo not have a pool. Assuming that the average current purchaseprice of the pools in the sample is $32,500, estimate thepercentage of a pool's cost that can be recouped when the home issold. What concerns do you have about the reliability of theestimate?

Data Set:

HomePriceSizeBathroomsRatingPool
1260.926662.570
2337.334183.561
3268.429452.051
4242.229422.531
5255.227983.031
6205.722102.520
7249.522092.070
8193.624652.510
9242.729552.041
10244.527222.550
11184.225902.510
12325.731383.571
13266.127132.070
14166.022842.520
15330.731403.561
16289.132052.531
17268.827212.561
18276.732452.521
19222.424643.031
20241.529932.510
21307.926473.561
22223.526702.540
23231.128952.530
24216.526432.530
25205.529152.010
26258.328003.521
27227.625572.531
28255.428052.031
29235.728782.540
30285.127953.071
31284.827482.571
32193.722562.520
33247.526592.521
34274.832413.541
35264.431663.031
36204.124662.040
37273.929452.551
38238.527273.011
39274.431414.041
40259.625522.071
41285.627613.061
42216.128802.520
43261.334263.011
44236.428952.521
45267.527263.070
46220.229302.520
47300.130132.561
48260.026752.060
49277.528743.561
50274.927652.541
51259.830203.521
52235.028872.511
53191.420322.030
54228.526982.540
55266.628473.021
56233.026393.030
57343.434314.051
58334.034853.551
59289.729912.561
60228.424822.520
61233.427122.511
62275.731032.521
63290.831242.531
64230.829062.520
65310.133984.041
66247.930283.040
67249.927612.050
68220.528423.030
69226.226662.560
70313.727442.571
71210.125082.540
72244.924802.550
73235.829862.540
74263.227532.570
75280.225222.561
76290.828082.571
77235.426162.530
78190.326032.520
79234.428042.540
80238.728512.550

Answer & Explanation Solved by verified expert
4.5 Ratings (827 Votes)
We calculate the average selling price of homes with pools andwithout pools separatelySUMIF and COUNTIF functions have been used to find Summationprice of homes with pools and number of homes with poolscountSame method for homes without poolsAverage    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students