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