Log on to this course’s canvas site, click on Modules under course navigation menu.
Read carefully before starting your exam
Log on to this course’s canvas site, click on Modules under course navigation menu. Then, scroll down to Exam 2, click on Exam 2. Before you start working on any part of this exam, save the Exam-2.xlsx file as Exam-2_your full name. At the end of the exam, submit only one Excel file. To submit your file, log on to this course’s canvas site, click on Modules tab. Then, click on Exam 2 and upload your file. Keep in mind – you can submit your file only once.
- The file name Exam-2.xlsx, sheet named Part 1 is kept blank. Use Part 1 sheet to answer this question. Put a box around your answers. For (a) and (b), round your answers to 4 decimal places.
The Wall Street Journal reported some interesting statistics on the job market. One statistic is that 40% of all workers say they would change jobs for “slightly higher pay.” Suppose 20 workers are randomly selected and asked if they would change jobs for “slightly higher pay.”
Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines
Order Paper Now- a)What is the probability that nine or more say yes?
- b)What is the probability that exactly six say yes?
- c)What is the expected [mean] number of workers that would say they would change jobs for slightly higher pay?
[Hint: Use binomial distribution to answer question 1]
[7.5 + 5 + 2.5 = 15 points]
- The file name Exam-2.xlsx, sheet named Part 2 is kept blank. Use Part 2 sheet to answer this question. Put a box around your answers. For (a), (b), and (c), round your answers to 4 decimal places. Put a box around your answers.
Suppose that the number of ounces of soda put into a soft-drink can is normally distributed with mean = 12.05 ounces and standard deviation = 0.03 ounce.
| (a) | What fraction of cans will contain at least 12 ounces of soda? |
| (b) | What fraction of cans will contain less than 11.9 ounces of soda? |
| (c) | What fraction of cans will contain between 12 and 12.08 ounces of soda? |
| (d) | One percent of all cans will weigh more than what value?
|
[5 +2. 5 + 10 + 12.5 = 30 points]
- The fileExam-2.xlsx, sheet named Flaws, lists the discrete distributionof the number of flaws found in a porcelain cup produced by a manufacturing firm. Use these data and the associated probabilities to compute the expected (mean) number of flaws and the standard deviation of flaws.
[Note: Use Excel to calculate the expected value and the standard deviation of flaws. Show your work on Flaws sheet. Do not create a new sheet or a new workbook.]
[5 + 10 = 15 points]
- Use Part 4 sheet to answer this question. Put a box around your answers.
A bicycle company makes two mountain bike models that each come in three colors. The following table shows the production volumes for last week:
Looking for a similar assignment? Our writers will offer you original work free from plagiarism. We follow the assignment instructions to the letter and always deliver on time. Be assured of a quality paper that will raise your grade. Order now and Get a 15% Discount! Use Coupon Code "Newclient"
