1. Calculate the mean, median, range, and standard deviation of home price and size. For the assignment document, copy and paste the output (graph) from the Excel Analysis ToolPak or SAS Enterprise Guide into a Word document. Then cut and paste that spreadsheet into a Word document. Be sure to verbally summarize your data findings in four or five sentences that will help a home buyer make a purchasing decision in the Florida real estate market.
2. Calculate the mode for the number of bathrooms. You can cut and paste the answers from the Excel Analysis ToolPak or SAS Enterprise Guide. Then verbally summarize this data to help a buyer make a purchasing decision in the Florida real estate market.
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). Then verbally summarize how this histogram will help a buyer make a purchasing decision in the Florida real estate market.
4. Produce a scatter plot showing the relationship between price and home size. In a cell under your scatterplot, indicate whether the relationship is positive or negative and whether the results are what you expect. Then verbally summarize how this scatter plot output will help a buyer make a purchasing decision in the Florida real estate market.