1. The Excel file MBA Student Survey provides data on a sample of students’ social and study habits. Use PivotTables to find the average age, number of nights out per week, and study hours per week by gender, whether the student is international or not, and undergraduate concentration.

2. A mental health agency measured the self‐esteem score for randomly selected individuals with disabilities who were involved in some work activity within the past year. The Excel file Self‐Esteem provides the data including the individuals’ marital status, length of work, type of support received (direct support includes job‐related services such as job coaching and counseling), education, and age. Use PivotTables to find the average length of work and self‐esteem score for individuals in each classification of marital status and support level. What conclusions might you reach from this information?