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)?
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)?
Big Ideas Math A Bridge To Success Algebra 1: Student Edition 2015
1st Edition
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:HOUGHTON MIFFLIN HARCOURT
Chapter4: Writing Linear Equations
Section: Chapter Questions
Problem 14CR
Related questions
Question
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.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Recommended textbooks for you
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt