Is there a relationship between a state’s number of classroom teachers and the average salary of classroom teachers in the state? Generate one or more pivot tables using Excel to answer this question for the data from 1996 in the file P2_44.XLS. In addition to exploring the relationship between a state’s total number of classroom teachers and their average annual salary, consider the same relationships for both elementary and secondary teachers.