This weekâ€™s assignment will teach you how to conduct some of the basic statistical analyses that you will need for your signature assignment. Each week builds upon concepts you will need to know.
Make sure you have loaded the Analysis ToolPak. For Excel 2013, 2010, or 2007: for more information, see Load the Analysis ToolPak in Excel.
Open the small Excel database that you created last week and do the following:
- Calculate the frequency and percentage for gender and ethnicity.
- Calculate the mean, standard deviation, median, and 50th percentile for age.
- Create a bar chart for participantsâ€™ gender and a bar chart for ethnicity (based on percentages, not counts).
- Create a histogram for participantsâ€™ age.
- On a Word document or a scanned sheet of paper, calculate question 2 above (mean, standard deviation, median, and 50th percentile for age) by hand to test your calculation abilities.
Need Excel help? Click on Excel Function Help Workbook under Course Materials.
Due: Sunday, 11:59 p.m. (Pacific time)