College of Eastern Utah Wyckoff Home Prices Worksheet

Data:

Home selling prices in Wyckoff.

Use the attached Excel file: Housing Prices

(You do not need to type the data.)

Assignments:

1. Draw a histogram by Excel:

Title: Wyckoff Home Prices

1. Compute mean, variance, mode, variance, and standard deviation by Excel: DATA >> Data Analysis >> Descriptive Statistics.

Data name: Wyckoff Home Prices

1. Draw a box plot by Excel

Title: Wyckoff Home Prices

Analysis:

1. Is it symmetric, skewed right or skewed left? Do the shapes of histogram, box lot, and the skewness of descriptive statistics agree with your conclusion?
2. Write your finding on the Box plot page.

Submission Format:

1. Write your name at the end of each assignments
2. Make a file with 3 sheets for each assignments.