ata is transforming the way decisions are made in business, marketing, politics, economics, sports, and international development. As professionals, it is crucial to be proficient in the basic concepts of statistics and to understand how data is collected, interpreted, and used in the world around us.
Determine factors that have the greatest impact on property prices utilizing the introductory statistics concepts by choosing and visually representing relevant data, make valid predictions based on the analysis, and use statistics to craft an informed response to the question “What drives property prices?” Use confidence intervals and hypothesis tests to determine the validity of the mean property prices stated by two opposing parties in a disagreement over the affordability of housing in a given area. Make a recommendation regarding the affordability of housing based on the findings.
The dataset used for this assignment contains data from properties listed on “domain.com.au” in the Melbourne metropolitan area between January 2016 and September 2017. This data includes key geographic information (e.g., suburb, distance from Melbourne CBD), property information (e.g., property type, number of rooms, land area), and selling information (e.g., sale date, price).
Instructions Part 1.1 | Part 1.2 | Part 1.3 | Part 1.4 | Part 1.5 | Part 2 |
Create a copy of the Google Sheet, Property Prices – Part 1 Data Template (opens in new window). Information from 2,355 total properties have been included for you and you will use the pre-labeled tabs to perform pertinent computations for each part of the assignment.
Rename your copy of the Google Sheet using your username, and share your copy of the spreadsheet with your professor.
To fairly easily generate a random sample, use the Power Tools Add on >> Select Shuffle >> then select “Rows”.
There may be a short wait time while the add-on randomly shuffles the rows. Once the rows are shuffled, use the first 300 rows as your random sample (A2:A301). You must delete cells A301:A2356.
Copy the Google Slides – Part 1 Template (opens in new window) to use as a template for presenting your work for Part 1 of the assignment.
Rename your copy of the Google Slides file using your username.
Submit your copy of the Property Prices and Google Slides for grading.
Resources
Add Apps And Extensions (opens in a new window)
Share Files From Google Drive (opens in a new window)
Generating A Random Sample And Sorting Tutorial [DOWNLOAD]