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. : Using Excel, conduct a NHST to determine whether there is a correlation in the population. Use a 0.05 significance level. Use the Excel file Assignment10_R1.xlsx, Exercise1_Correlation NHST worksheet) Test Set-Up: What type of Null Hypothesis Test should you use? It this a left-tailed, two-tailed, or right-tailed test. Significance Level: Use a 5% significance level. What is/are the Critical Value(s)? Write the Null & Alternate Hypotheses (Follow the examples shown in Clear-Sighted Statistics. Use the appropriate Greek letters and mathematical symbols). H0: H1: Write the Decision Rule using the Critical Value(s), not p-values. Calculate the value of the test statistic and the p-value.
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.
: Using Excel, conduct a NHST to determine whether there is a
- Test Set-Up: What type of Null Hypothesis Test should you use? It this a left-tailed, two-tailed, or right-tailed test.
- Significance Level: Use a 5% significance level. What is/are the Critical Value(s)?
- Write the Null & Alternate Hypotheses (Follow the examples shown in Clear-Sighted Statistics. Use the appropriate Greek letters and mathematical symbols).
H0:
H1:
- Write the Decision Rule using the Critical Value(s), not p-values.
- Calculate the value of the test statistic and the p-value.
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 2 images