descriptive statistic assignment

Descriptive Statistics Assignment - Spring 2021 Assignment must be submitted as a pdf. Submit a Word and Excel pdf or combine into one pdf.

On Word document: give title to data, list data (set of 30-50), cite source, write a paragraph description of data

On Excel Worksheet:

a) List data

b) Sort data from smallest to largest.

c) Using Data Analysis, present Descriptive Statistics

d) Continue with quartiles (Q1, Q2, Q3) below COUNT, listing 5 number summary and interquartile range

e) Calculate Z scores

f) State minimum and maximum for +-1 standard deviation, +-2 sd and +-3 sd

g) Calculate percentage of data for 1, 2, 3 standard deviations from the mean for your data set

On Word document from #1 above, write a paragraph summarizing results