### PreJunior Quiz 04 Name: __________________

- 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

- What is the average sum for AUB (UB in advanced class KHS)?
- What is the average sum for UB?
- What is the average sum for TSP?

- Perform a pivot table analysis of high school versus gender.
- Which high school had the highest performing females?
- What was the average sum for those females?
- Which high school had the highest performing males?
- What was the average sum for that high school?

UB