I need help on 4 and 8 Instructions Complete this assignment using Excel for any
ID: 3041722 • Letter: I
Question
I need help on 4 and 8
Instructions
Complete this assignment using Excel for any calculations. Type all answers with work in the spaces below. Show your answers in BOTH fractional form and decimal form rounded to 3 decimal places. Use complete sentences when necessary. Each problem is worth 10 points.
Problems
The two-way table below summarizes how students performed in three past sections of MAT 152 on the Unit 1 Test. The row labels are letter grades. The column labels describe whether or not a student completed both chapter quizzes for the unit (first column), or missed at least one quiz for the unit (second column).
Completed both quizzes
Missed at least one quiz
Total
A
28
1
29
B
11
3
14
C
13
1
14
D/F
3
11
14
Total
55
16
71
What is the probability that a randomly selected student earned an A on the test?
What is the probability that a randomly selected student completed both quizzes?
What is the probability that a randomly selected student earned a C or better on the test?
Suppose the patterns in these scores continue. A student in MAT 152 misses the first two quizzes (did NOT complete both). Knowing this, what is the probability he/she will earn an A on the test?
Suppose the patterns in these scores continue. A student in MAT 152 completed both quizzes. Given this information, what is the probability that he/she will earn a D or F on the test?
What is the probability that a randomly selected student earned a D/F AND completed both quizzes?
If two students are randomly selected without replacement, what is the probability that both earned a C?
Are the events “Earned a C or better on the test” and “Completed both quizzes” independent or dependent? You must justify your answer mathematically.
Are the events “Earned an A on the test” and “Missed at least one quiz” mutually exclusive? Justify your answer.
What is the probability that a randomly selected student earned a D/F OR missed at least one quiz?
Completed both quizzes
Missed at least one quiz
Total
A
28
1
29
B
11
3
14
C
13
1
14
D/F
3
11
14
Total
55
16
71
Explanation / Answer
a) 29 out of 71 students earned an A on the test
P(student earned an A on the test) = 29 / 71 = 0.408
b) 55 out of 71 students completed both quizzes
P(student completed both quizzes) = 55 / 71 = 0.774
c) 57 out of 71 students earned a C or better on the test
P(student earned a C or better on the test) = 55 / 71 = 0.803
d) 16 students Missed at least one quiz, out of them 1 student earned an A on the test
P(Missed two quiz|student earned an A on the test) = 1 / 16 = 0.0625
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.