Finance assignment – producing and interpreting descriptive statistics

For this practical application assignment, assume that you are a real estate agent living and working in southern Florida. The senior real estate partner of your firm e-mails you the Florida Pool Home Data document (provided in the Resources) and asks you to find ways to describe the most important aspects of the home sale data (which is why they call this technique descriptive statistics). The file contains data for 80 properties, including home price, home size, number of bathrooms, niceness rating, and pool (and is used as an example on pages 144–145 of yourMBA6018 – Data Analysis for Business Decisions custom textbook). Be sure that you have read Appendix 2.1, pages 80–87, in your textbook, which provides instruction on how to construct a frequency distribution, histogram, and scatterplot in Excel. Compute the following data parameters:

  1. Calculate the mean, median, range, and standard deviation of home price and size. You can cut and paste the answers from the Analysis Toolpack, or you can place your results in the same Excel sheet as the data, below the existing table. Be sure to label each of your data calculations. (For example: Row 84 Column B should contain the Mean of Home Selling Prices, Column C the Mean of Home Size in Square Feet, Row 85 Column B should contain the Home Median price, and so on. Highlight all your results in yellow.)
  2. Calculate the mode for the number of bathrooms. (You can cut and paste the answers from the Analysis Toolpack, or you can use Row 88 Column D for this parameter. Do not forget to title Column A Row 88–Mode.Highlight your results in yellow.)
  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). Use a separate Excel sheet to do this and label that sheet “Home Price Range Histogram.”
  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. Use a separate Excel sheet to do this and label the sheet “Scatterplot.”
Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more