2-3 hrs. just highlighted part In Hello.docx file in RED

Hello,

Here is a description of the assignment. I have highlighted my part IN

red and what I need to do.

I have attached the spreadsheet with all other data needed to complete.

Also need to add word doc with findings and comparison to actual data

and whether Chebyshev's or Empirical Rule is more accurate with each of

listing prices and square footages.

ASSIGNMENT:

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.

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.