Student Absences and Grades on the Final ExamDr. 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. ABDFTimesLate/Final Exam1AbsentGradeAnswerFormulal-COUNT(A2:A23)84.0092.502132df=E2-2431646.00Coefficient of Correlation, r=CORREL(B2:B23,C2:C23)93.00 Coefficient of Determination, r?=RSQ(C2:C23,B2:B23)542651195.50Mean of Late/Absent=AVERAGE(B2:B23)762420.00Std. Dev. Of Late Absent=STDEV.S(B2:B23)8.7739.00Mean of Final Exam=AVERAGE(C2:C23)1046.00Std. Dev. Of Final Exam=STDEV.S(C2:C23)1091963.0073.5098.001110212 11213121724.5014 1373.0069.50815 142016 151949.0017 162368.5018 1770.0019 18475.5020 19278.0021 20797.0022 212100.0023 22293.50 AВDEAlpha0.05 givengiven=B2-2|=T.INV.2T(B1,B3)='Exercise1_Excel_Built-In f.'!E4|='Exercise1_Excel_Built-In f.'!E5Vn-2t=3df4CV t52V1-r²6.7=(B5*SQRT(B3))/SQRT(1-B6)=TDIST(ABS(B8), B3,2)8.9p-value10

1) State the Null and Alternate Hypothesis. The Null Hypothesis can be stated that there is no correlation in the population.The Alternate Hypothesis can be stated as there is a correlation in the population. It is a two-tailed test.2) Calculate the values in Excel. The calculated values are as follows:3) The critical value at 0.05 significance level and df = 20 is t critical value = 2.0859 4) The null and alternative hypothesis in statistical terms are: 5) The decision rule using the critical values are: Reject the null hypothesis if the absolute value of the t-calculated is greater than the t-critical value. Otherwise do not reject the null hypothesis. 6) The test statistic is:t = -3.9273 The P-value is:P-value : 0.0008

Answered: Student Absences and Grades on the…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Question

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

H₀:

H₁:

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

Calculate the value of the test statistic and the p-value.

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

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

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 4 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

$Non-parametric Tests$

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