QNT/351 Descriptive Statistics – Real Estate Data Part 1

Descriptive Statistics – Real Estate Data Part 1

QNT/351 Version 5

Learning Team Assignment: Descriptive Statistics – Real Estate Data Part 1

Purpose of Assignment

Using descriptive statistics to organize raw data into a table and to produce graphs based on the organized data. An additional purpose is finding measures of central tendency and dispersion for the data and relating the computed standard deviation to its mean of the data.

Resources Required

Chapters 2, 3, and 4

Grading Guide

Content	Met	Partially Met	Not Met	Comments:
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 frequency distribution for listing prices, including relative frequencies.
Create your frequency distribution as identified in chapters 2, 3, and 4.
Generate a histogram from your frequency distribution, again making sure you are consistent with the rules discussed in Chapter 2.
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 sets of data.
Compare your findings with your actual data.
Conclude whether Chebyshev’s or Empirical Rule is more accurate with each of listing prices and square footages.
		Total Available	Total Earned
			#/X
Writing Guidelines	Met	Partially Met	Not Met	Comments:
The paper—including tables and graphs, headings, title page, and reference page—is consistent with APA formatting guidelines and meets course-level requirements.
Intellectual property is recognized with in-text citations and a reference page.
Paragraph and sentence transitions are present, logical, and maintain the flow throughout the paper.
Sentences are complete, clear, and concise.
Rules of grammar and usage are followed including spelling and punctuation.
		Total Available	Total Earned
			#/X
Assignment Total	#	10	#/X
Additional comments: