Homework Help is Here – Start Your Trial Now!
Math
Statistics
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)  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.

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)  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.

Big Ideas Math A Bridge To Success Algebra 1: Student Edition 2015
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
See similar textbooks
icon
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 correlation in the population. Use a 0.05 significance level. Use the Excel file Assignment10_R1.xlsx, Exercise1_Correlation NHST worksheet) 

  1. Write the Null & Alternate Hypotheses (Follow the examples shown in Clear-Sighted Statistics. Use the appropriate Greek letters and mathematical symbols). 

H0: 

H1: 

 

  1. Write the Decision Rule using the Critical Value(s), not p-values. 

 

 

  1. Calculate the value of the test statistic and the p-value. 
A В D E Alpha 0.05 given given =B2-2 |=T.INV.2T(B1,B3) ='Exercise1_Excel_Built-In f.'!E4 |='Exercise1_Excel_Built-In f.'!E5 Vn-2 t= 3 df 4 CV t 5 2 V1-r² 6. 7 =(B5*SQRT(B3))/SQRT(1-B6) =TDIST(ABS(B8), B3,2) 8. 9 p-value 10
Transcribed Image Text:A В D E Alpha 0.05 given given =B2-2 |=T.INV.2T(B1,B3) ='Exercise1_Excel_Built-In f.'!E4 |='Exercise1_Excel_Built-In f.'!E5 Vn-2 t= 3 df 4 CV t 5 2 V1-r² 6. 7 =(B5*SQRT(B3))/SQRT(1-B6) =TDIST(ABS(B8), B3,2) 8. 9 p-value 10
A B D F Times Late/ Final Exam 1 Absent Grade Answer Formula l-COUNT(A2:A23) 84.00 92.50 2 1 3 2 df =E2-2 4 3 16 46.00 Coefficient of Correlation, r =CORREL(B2:B23,C2:C23) 93.00 Coefficient of Determination, r? =RSQ(C2:C23,B2:B23) 5 4 2 6 5 11 95.50 Mean of Late/Absent =AVERAGE(B2:B23) 7 6 24 20.00 Std. Dev. Of Late Absent =STDEV.S(B2:B23) 8. 7 7 39.00 Mean of Final Exam =AVERAGE(C2:C23) 10 46.00 Std. Dev. Of Final Exam =STDEV.S(C2:C23) 10 9 19 63.00 73.50 98.00 11 10 2 12 11 2 13 12 17 24.50 14 13 73.00 69.50 8 15 14 20 16 15 19 49.00 17 16 23 68.50 18 17 70.00 19 18 4 75.50 20 19 2 78.00 21 20 7 97.00 22 21 2 100.00 23 22 2 93.50
Transcribed Image Text:A B D F Times Late/ Final Exam 1 Absent Grade Answer Formula l-COUNT(A2:A23) 84.00 92.50 2 1 3 2 df =E2-2 4 3 16 46.00 Coefficient of Correlation, r =CORREL(B2:B23,C2:C23) 93.00 Coefficient of Determination, r? =RSQ(C2:C23,B2:B23) 5 4 2 6 5 11 95.50 Mean of Late/Absent =AVERAGE(B2:B23) 7 6 24 20.00 Std. Dev. Of Late Absent =STDEV.S(B2:B23) 8. 7 7 39.00 Mean of Final Exam =AVERAGE(C2:C23) 10 46.00 Std. Dev. Of Final Exam =STDEV.S(C2:C23) 10 9 19 63.00 73.50 98.00 11 10 2 12 11 2 13 12 17 24.50 14 13 73.00 69.50 8 15 14 20 16 15 19 49.00 17 16 23 68.50 18 17 70.00 19 18 4 75.50 20 19 2 78.00 21 20 7 97.00 22 21 2 100.00 23 22 2 93.50
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 2 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Point Estimation, Limit Theorems, Approximations, and Bounds
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
SEE MORE TEXTBOOKS