### Online College Courses for Credit

• > QNT 351 WEEK 2 Descriptive Statistics – Real Estate Data Part 1
+

# QNT 351 WEEK 2 Descriptive Statistics – Real Estate Data Part 1

##### Rating:
(0)
Author: Yanis Gherasim
(more)

### Developing Effective Teams

*No strings attached. This college course is 100% free and is worth 1 semester credit.

37 Sophia partners guarantee credit transfer.

299 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 32 of Sophia’s online courses. Many different colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.

Tutorial

QNT 351 WEEK 2 Descriptive Statistics – Real Estate Data Part 1

QNT 351 WEEK 2 Descriptive Statistics – Real Estate Data Part 1

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.

Review the new listings that populate.

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.

Evaluate your visual aid.

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.

Format your assignment consistent with APA guidelines.

Click the Assignment Files tab to submit your assignment.

QNT 351 WEEK 2 Descriptive Statistics – Real Estate Data Part 1

QNT 351 WEEK 2 Descriptive Statistics – Real Estate Data Part 1

QNT 351 WEEK 2 Descriptive Statistics – Real Estate Data Part 1

QNT 351 WEEK 2 Descriptive Statistics – Real Estate Data Part 1

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.

Review the new listings that populate.

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.

Evaluate your visual aid.

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.

Format your assignment consistent with APA guidelines.

Click the Assignment Files tab to submit your assignment.

QNT 351 WEEK 2 Descriptive Statistics – Real Estate Data Part 1

QNT 351 WEEK 2 Descriptive Statistics – Real Estate Data Part 1

Rating