Statistics – Practice Problems For an Excel Chart
Real Estate Data: Statistical Analysis using EXCEL
July 9, 2019Descriptive statistics and probability problems
July 9, 2019Practice Problems For an Excel Chart
a. Determine the types of measurement scales for each variable (Nominal, Ordinal, Interval, Ratio):
1) Name
2) Gender
3) Absences
4) Physical Education(PE)
5) Math
6) Writing
7) Reading
b. Determine the number of boys and girls in the class and create a bar graph or pie chartto display the information.
c. Determine the correlations between pairs of all interval variables (i.e., Absences with PE, PE with math, math with writing, etc.)
d. 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?
A Complete, Neat and Step-by-step Solution is provided in the attached file.
