This is a two part project that must be done on the excel sheet. Part 1(should be done in the week 3 tab) Make a Frequency Distribution with 5 classes, also list the midpoints, relative frequency, and...

This is a two part project that must be done on the excel sheet.

Part 1(should be done in the week 3 tab)

Make a Frequency

Distribution with 5 classes, also list the midpoints, relative frequency, and

cumulative frequency

·

Make a relative

frequency ogive

·

Make a frequency polygon

·

Calculate the mean

·

Calculate the median

·

Calculate the standard

deviation

·

Calculate the Q1 and Q3

values

Part 2 (should be done in the week 5 tab)

·

For the average age,

form a 95% confidence interval:

• What distribution should be used?


• What is the critical value?


• What is the error bound?


• What is the lower bound?


• What is the upper bound?

·

For the proportion of

males, form a 95% confidence interval:

• What distribution should be used?


• What is the critical value?


• What is the error bound?


• What is the lower bound?


• What is the upper bound?