# Excel Activity #2 — Chapter 4 5

Excel Activity #2 — Chapter 4 & 5

Instructions: Find Part I & II, below, utilizing Excel and the Excel skills you ascertained from

STAT 1102. Print your results in a well formatted professional manner. All formulas/equations

utilized within Excel need be pasted within a Word Document, printed, and submitted with

your Excel results (i.e. if you instructed a specific cell within Excel to make a specific

calculation, for example Cell C2 is set to “=AVERAGE(range…)”, then on a Word Doc list:

1.Cell C2 = “=AVERAGE(range…)”

2…..

3…..

The activity is due 7.19 at classes beginning.

Part 1—Binomial Probability in Excel:

The number of left-handed students follows a binomial distribution, and the probability that an

individual is left-handed is 0.14. In a class of 70 students, what is the probability that:

1. Exactly 10 of them are left-handed?

2. More than 15 of them are left handed?

3. At most 12 of them are left-handed?

Part 2—Normal Probability in Excel:

A study found that the average wait time in a McDonald’s drive-thru is 4 minutes and the standard

deviation is 1.2 minutes. It is also known that the distribution of these times is normal.

1. What is the probability that a person waits over 6 minutes?

2. What is the probability that a person waits between 2.5 and 3.5 minutes?

3. Someone claimed that only 10% of people waited longer than they did. If this is true, how many

minutes did they wait?

4. Suppose you sampled 40 people from the McDonald’s drive-thru. What is the probability

that you get an average wait time less than 4.2 minutes?