ELEMENTARY STATISTICS USING EXCEL
SIXTH EDITION EXAM SCRIPT FINAL PAPER
2026 COMPLETE SOLVED QUESTIONS
EXCEL DATA INSIGHT TOOLKIT
◉ Solve the problem.
A card is drawn from a standard deck of 52 playing cards. Find the
probability that the card is an ace or a king.
4/13
2/13
8/13
1/13
Answer: 2/13
◉ Solve the problem.
The access code to a house's security system consists of five digits.
How many different codes are available if each digit can be
repeated?
,3125
5
100,000
32
Answer: 100,000
◉ Solve the problem.
Seven guests are invited for dinner. How many ways can they be
seated at a dinner table if the table is straight with seats only on one
side?
40,320
720
4
5040
Answer: 5040
◉ Solve the problem.
,If one card is drawn from a standard deck of 52 playing cards, what
is the probability of drawing a red card?
1/2
1/13
1/52
1/4
Answer: 1/2
◉ Solve the problem.
The distribution of Master's degrees conferred by a university is
listed in the table.
Major Frequency
Mathematics 216
English 207
Engineering 86
Business 176
Education 204
, What is the probability that a randomly selected student graduating
with a Master's degree has a major of Education? Round your
answer to three decimal places.
0.298
0.771
0.005
0.229
Answer: 0.229
◉ Solve the problem.
A group of students were asked if they carry a credit card. The
responses are listed in the table.
class cc carrier no cc
Freshman 19 41
Sophomore 40 0
If a student is selected at random, find the probability that he or she
is a freshman given that the student owns a credit card. Round your
answers to three decimal places.
SIXTH EDITION EXAM SCRIPT FINAL PAPER
2026 COMPLETE SOLVED QUESTIONS
EXCEL DATA INSIGHT TOOLKIT
◉ Solve the problem.
A card is drawn from a standard deck of 52 playing cards. Find the
probability that the card is an ace or a king.
4/13
2/13
8/13
1/13
Answer: 2/13
◉ Solve the problem.
The access code to a house's security system consists of five digits.
How many different codes are available if each digit can be
repeated?
,3125
5
100,000
32
Answer: 100,000
◉ Solve the problem.
Seven guests are invited for dinner. How many ways can they be
seated at a dinner table if the table is straight with seats only on one
side?
40,320
720
4
5040
Answer: 5040
◉ Solve the problem.
,If one card is drawn from a standard deck of 52 playing cards, what
is the probability of drawing a red card?
1/2
1/13
1/52
1/4
Answer: 1/2
◉ Solve the problem.
The distribution of Master's degrees conferred by a university is
listed in the table.
Major Frequency
Mathematics 216
English 207
Engineering 86
Business 176
Education 204
, What is the probability that a randomly selected student graduating
with a Master's degree has a major of Education? Round your
answer to three decimal places.
0.298
0.771
0.005
0.229
Answer: 0.229
◉ Solve the problem.
A group of students were asked if they carry a credit card. The
responses are listed in the table.
class cc carrier no cc
Freshman 19 41
Sophomore 40 0
If a student is selected at random, find the probability that he or she
is a freshman given that the student owns a credit card. Round your
answers to three decimal places.
