make sure you have loaded the analysis toolpak for excel 2013 2010 or 2007 for more information see load the analysis toolpak in excel

  1. alculate the frequency and percentage for gender and ethnicity.
  2. Calculate the mean, standard deviation, median, and 50th percentile for age.
  3. Create a bar chart for participants’ gender and a bar chart for ethnicity (based on percentages, not counts).
  4. Create a histogram for participants’ age.
  5. 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.

“Get 15% discount on your first 3 orders with us”
Use the following coupon
FIRST15

Order Now