Statistics Assignment ( Statistics for decision making)

 

Note from Teacher for this particular assignment. If you know how to do this anyway, I am assuming it is not relevant for you. Posted this so you can know what was expected, I highlighted the part which was my purpose for posting the message.

I'd recommend watching the Descriptive Statistics video in this week's learning materials before you work on the assignment.

 

The video walks you through how to use the descriptive statistics function in Excel to calculate statistical measures including central tendency and variance - which are required for this assignment.

With the Excel worksheet that I attached to the "Data Set" post and this video, you should be in great shape for the Data Set assignment.

Activity Data Set

Resource: Data Set (on 2nd attachment)

Download the data set.

Review the age and gender data in the data set.

Display gender information in a chart and plot age data in a box plot.

Calculate the appropriate measure of central tendency and variability for the age and gender. What conclusion can you draw from the data?