A B F Times Late/ Final Exam 1 Absent Grade Answer Formula l-COUNT(A2:A23) 2 1 84.00 92.50 df =E2-2 Coefficient of Correlation, r 93.00 Coefficient of Determination, r Mean of Late/Absent 4 16 46.00 =CORREL(B2:B23,C2:C23) =RSQ(C2:C23,B2:B23) =AVERAGE(B2:B23) 4 6. 11 95.50 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) 8. 10 46.00 Std. Dev. Of Final Exam =STDEV.S(C2:C23) 10 9. 19 63.00 11 10 2 73.50 12 11 2 98.00 13 12 17 24.50 14 13 8 73.00 15 14 20 69.50 16 15 17 16 19 49.00 23 68.50 18 17 6 70.00 19 18 75.50 20 19 21 20 2 78.00 97.00 22 21 23 22 2 100.00 2 93.50 2.
A B F Times Late/ Final Exam 1 Absent Grade Answer Formula l-COUNT(A2:A23) 2 1 84.00 92.50 df =E2-2 Coefficient of Correlation, r 93.00 Coefficient of Determination, r Mean of Late/Absent 4 16 46.00 =CORREL(B2:B23,C2:C23) =RSQ(C2:C23,B2:B23) =AVERAGE(B2:B23) 4 6. 11 95.50 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) 8. 10 46.00 Std. Dev. Of Final Exam =STDEV.S(C2:C23) 10 9. 19 63.00 11 10 2 73.50 12 11 2 98.00 13 12 17 24.50 14 13 8 73.00 15 14 20 69.50 16 15 17 16 19 49.00 23 68.50 18 17 6 70.00 19 18 75.50 20 19 21 20 2 78.00 97.00 22 21 23 22 2 100.00 2 93.50 2.
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
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.
- Calculate the
correlation coefficient , r, using Excel’s CORRELfunction . Explain what itmeans.
- Calculate the coefficient of determination, r2, using Excel’s RSQ function. Explain what it means..
![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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fd74bb6b8-812e-455c-a7a9-3b0bb1900cd5%2Fef515024-e40b-497a-b66e-c1a049cb9af1%2F7yukytr_processed.png&w=3840&q=75)
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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fd74bb6b8-812e-455c-a7a9-3b0bb1900cd5%2Fef515024-e40b-497a-b66e-c1a049cb9af1%2Fpusft2p_processed.png&w=3840&q=75)
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
![](/static/compass_v2/shared-icons/check-mark.png)
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
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
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…](https://www.bartleby.com/isbn_cover_images/9781680331141/9781680331141_smallCoverImage.jpg)
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…](https://www.bartleby.com/isbn_cover_images/9781680331141/9781680331141_smallCoverImage.jpg)
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt