PreJunior Quiz 04 Name: __________________

  1. Use the quiz four spreadsheet at http://www.comfsm.fm/~dleeling/ca/entrance51trio.xls to perform the following subtotal by program type:

      At each change in: Prog
      Use function: Average
      Add subtotal to: Sum

    1. What is the average sum for AUB (UB in advanced class KHS)?
    2. What is the average sum for UB?
    3. What is the average sum for TSP?
  2. Perform a pivot table analysis of high school versus gender.
    1. Which high school had the highest performing females?
    2. What was the average sum for those females?
    3. Which high school had the highest performing males?
    4. What was the average sum for that high school?

UB