​Excel Activity #2 — Chapter 4 5 Instructions:

User Generated

pnbavzn

Business Finance

Description

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?

Unformatted Attachment Preview

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?
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

This question has not been answered.

Create a free account to get help with this and any other question!

Related Tags