Access the University of Phoenix Material, "Data for Inferential Practice Problems." Use the Excel® Analysis ToolPak? when necessary for the following:
a. Determine the types of measurement scales for each variable (Nominal, Ordinal, Interval, Ratio):
name
gender
absences
physical education (PE)
Math
Writing
Reading
Determine the number of boys and girls in the class and create a bar graph or pie chart to display the information.
Determine the correlations between pairs of all interval variables (i.e., Absences with PE, PE with math, math with writing, etc.)
How much of the math grade can be explained by the PE grade? How much of the writing grade can be explained by the reading grade? Show work for correlation of these variables.