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

Answered: Dr. 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

Concept explainers

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)

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.

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

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 5 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

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