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