I need help in this I have never covered this material could you please help
U01A1 Pool Data.doc
1.
Calculate the mean, median, range, and standard
deviation of home price and size.
These are produced by Descriptive Statistics using Excel. The output has been edited to improve formatting.
Price 
Size 

Mean 
268.3 
3038.8 
Median 
256.9 
2806.5 
Standard Deviation 
72.77946 
1078.569 
Range 
90.3–343.4 
1603–3418 
The mean Price of a Florida pool home in Boca Raton is $268,300.00. The mean size of a Florida pool home in the Boca Raton area is 3038.8 square feet. The median price of the Florida pool home in the Boca Raton area is $256,900. The median size of that Boca Raton property is 2806.5 square feet. The standard deviation associated with the price of that Boca Raton home is $72.77946. The standard deviation of size is 1078.569 square feet.
2. Calculate the mode for the number of bathrooms.
This is most easily done via descriptive statistics in Excel, which shows that the mode is 2.5.
3. Produce a histogram that shows the number of houses by price range, in increments of $50,000 (for example, $0–$50,000, $50,001–$ 100,000, and so on).
Since the minimum is above 150,000 and the maximum below 350,000, the histogram only needs four bars to represent the groupings by 50,000 increments.
4. Produce a scatter plot showing the relationship between price and home size.
As an imaginary line drawn through the average of all the points would move from left to right and up, there is a relatively strong positive relationship.
Tutor Answer
5 Reviews
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