Student Absences and Grades on the Final Exam Dr. V. noticed that the more frequently a student is late or absent from class the worse he or she performs on the final exam. He decided to investigate. Dr. V. collected a random sample of 22 students. This sample includes the number of times a student is absent and their grades on the final exam. The data can be found in the Excel file Assignment10_R1.xlsx on the Exercise1_Excel_Built-in f. worksheet. Do not use any software that I did not assign. Question 1: Which or the two variables (times absent or grades on the final exam) is the independent variable and which is the dependent variable? Question 2: Using Microsoft Excel: (Excel file Assignment10_R1.xlsx on the Exercise1_Excel_Built-in f.xlsx worksheet) Count the number of XY variables. Calculate the mean and sample standard deviation of both the independent and dependent variables. Calculate the correlation coefficient, r, using Excel’s CORREL function. Explain what it means. Calculate the coefficient of determination, r2, using Excel’s RSQ function. Explain what it means..
Student Absences and Grades on the Final Exam
Dr. V. noticed that the more frequently a student is late or absent from class the worse he or she performs on the final exam. He decided to investigate. Dr. V. collected a random sample of 22 students. This sample includes the number of times a student is absent and their grades on the final exam. The data can be found in the Excel file Assignment10_R1.xlsx on the Exercise1_Excel_Built-in f. worksheet. Do not use any software that I did not assign.
Question 1: Which or the two variables (times absent or grades on the final exam) is the independent variable and which is the dependent variable?
Question 2: Using Microsoft Excel: (Excel file Assignment10_R1.xlsx on the Exercise1_Excel_Built-in f.xlsx worksheet)
- Count the number of XY variables.
- Calculate the mean and sample standard deviation of both the independent and dependent variables.
- Calculate the
correlation coefficient , r, using Excel’s CORRELfunction . Explain what it means.
- Calculate the coefficient of determination, r2, using Excel’s RSQ function. Explain what it means..
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 7 images