3. Individual Assignment: Inferential Problems
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):
? Determine the number of boys and girls in the class and create a bar graph or pie chartto 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 correlationof these variables.
Step by step solutions to all the problems are provided.