Microsoft Office Tutorials and References
In Depth Information
You will find these examples in the Excel Chapter 26 file.
On the Review sheet I sampled the Executive MBA database for 2009 students.
1. Use Excel
nd the average age of our sample as well as the average
age by gender.
2. Count the number of students in each undergraduate discipline.
3. What is the average age by undergraduate discipline and gender?
2. Drag the undergraduate
eld to the left where the Raw Data
elds are. Drag the
eld again to the center of the PivotTable where the Data Fields are supposed to be.