QNT351 Week 2: Descriptive Statistics – Real Estate Data Part 1
Probability Concepts and Distributions
QNT351 Week 2: Search the Internet for a realty site.
Select a hometown of someone on your team in the search section on the website you have chosen. When all of the listings populate, make sure that the sort criteria reads “New Listings.” This ensures that you are searching a random cross-section of listings rather than favoring one price range.
Create an Excel® spreadsheet with 4 columns of the first 100 single family homes listed, not including condominiums or townhouses.
Include each of the following categories in the spreadsheet: Property address, listing price, square footage, and number of bedrooms.
Prepare a histogram of the listing price data using the Excel Data analysis capability.
Create a table that summarizes the frequency data in your histogram.
Summarize your findings from your frequency distribution and your histogram.
Create either a pie chart or a bar graph of the number of bedrooms in your 100 homes.
Calculate measures of central tendency for both listing prices and square footages. Those measures are mean, median, and mode.
Determine the quartiles for both listing prices and square footages.
Calculate measures of dispersion for both listing prices and square footages. Those measures are range, variance, and standard deviation.
Apply Chebyshev’s Theorem and the Empirical Rule to both the listing price and square footage data.
Based on your analyses are your data approximately normally distributed? Justify your answer.
Format your assignment consistent with APA guidelines.
This assignment contains a Microsoft Word document and an Excel spreadsheet.
Click HERE for more QNT351 weeks.
If you would like to order an original assignment, please contact info@prowriting.co or text (617) 299-6181. Kindly visit our original assignment website www.prowriting.co
________________________________________________________________________________________
QNT351 Week 2: Descriptive Statistics – Real Estate Data Part 1
Probability Concepts and Distributions
QNT351 Week 2: Search the Internet for a realty site.
Select a hometown of someone on your team in the search section on the website you have chosen. When all of the listings populate, make sure that the sort criteria reads “New Listings.” This ensures that you are searching a random cross-section of listings rather than favoring one price range.
Create an Excel® spreadsheet with 4 columns of the first 100 single family homes listed, not including condominiums or townhouses.
Include each of the following categories in the spreadsheet: Property address, listing price, square footage, and number of bedrooms.
Prepare a histogram of the listing price data using the Excel Data analysis capability.
Create a table that summarizes the frequency data in your histogram.
Summarize your findings from your frequency distribution and your histogram.
Create either a pie chart or a bar graph of the number of bedrooms in your 100 homes.
Calculate measures of central tendency for both listing prices and square footages. Those measures are mean, median, and mode.
Determine the quartiles for both listing prices and square footages.
Calculate measures of dispersion for both listing prices and square footages. Those measures are range, variance, and standard deviation.
Apply Chebyshev’s Theorem and the Empirical Rule to both the listing price and square footage data.
Based on your analyses are your data approximately normally distributed? Justify your answer.
Format your assignment consistent with APA guidelines.
This assignment contains a Microsoft Word document and an Excel spreadsheet.
Click HERE for more QNT351 weeks.
If you would like to order an original assignment, please contact info@prowriting.co or text (617) 299-6181. Kindly visit our original assignment website www.prowriting.co