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. QUESTIONS - a. Write the Decision Rule using the Critical Value(s), not p-values. b. Calculate the value of the test statistic and the p-value.d. What is your decision regarding the Null Hypothesis? Frame your report in the context of this problem. ADEAlpha0.05 givenVn-2t=22 given20 =B2-23dfCV t2.0860 =T.INv.2T(B1,B3)4-0.6599 ='Exercise1_Excel_Built-In f.'!E40.43545|='Exercise1_Excel_Built-In f.'!E52V1-r²6.7-3.92729 =(B5*SQRT(B3))/SQRT(1-B6)p-value 0.000834 =TDIST(ABs(B8),B3,2)8.910 ABDFTimesLate/Final Exam1AbsentGradeFormulaAnswer22l-COUNT(A2:A23)84.0092.5021n32df21=E2-2431646.00Coefficient of Correlation, r -0.6599 =CORREL(B2:B23,C2:C23)93.00 Coefficient of Determination, r? 0.4354=RSQ(C2:C23,B2:B23)542=AVERAGE(B2:B23)Mean of Late/Absent 9.6818Std. Dev. Of Late Absent 7.6244651195.50762420.00=STDEV.S(B2:B23)8.7739.00Mean of Final Exam 70.4091=AVERAGE(C2:C23)1046.00Std. Dev. Of Final Exam24.0380=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

Name: Dr. V. noticed that the more frequently a student is late or absent fr
Uploaded: 2024-03-20T07:07:37.000Z
Channel: Bartleby
Description: 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 stud

Part(c) is missing, there are only 3 subparts to solve

Answered: r. V. noticed that the more frequently…

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

Topic Video

Question

100%

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.

QUESTIONS -

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

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

d. What is your decision regarding the Null Hypothesis? Frame your report in the context of this problem.

A
D
E
Alpha
0.05 given
Vn-2
t=
22 given
20 =B2-2
3
df
CV t
2.0860 =T.INv.2T(B1,B3)
4
-0.6599 ='Exercise1_Excel_Built-In f.'!E4
0.4354
5
|='Exercise1_Excel_Built-In f.'!E5
2
V1-r²
6.
7
-3.92729 =(B5*SQRT(B3))/SQRT(1-B6)
p-value 0.000834 =TDIST(ABs(B8),B3,2)
8.
9
10

A
B
D
F
Times
Late/
Final Exam
1
Absent
Grade
Formula
Answer
22
l-COUNT(A2:A23)
84.00
92.50
2
1
n
3
2
df
21
=E2-2
4
3
16
46.00
Coefficient of Correlation, r -0.6599 =CORREL(B2:B23,C2:C23)
93.00 Coefficient of Determination, r? 0.4354
=RSQ(C2:C23,B2:B23)
5
4
2
=AVERAGE(B2:B23)
Mean of Late/Absent 9.6818
Std. Dev. Of Late Absent 7.6244
6
5
11
95.50
7
6
24
20.00
=STDEV.S(B2:B23)
8.
7
7
39.00
Mean of Final Exam 70.4091
=AVERAGE(C2:C23)
10
46.00
Std. Dev. Of Final Exam
24.0380
=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

This is a popular solution!

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

$Research Design Formulation$

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