Assignment 2 Essay examples

Words: 1866
Pages: 8

M2 Group Assignment Instructions
Complete the Assignment, name it as GroupXX_Assign2.xls (where XX is your Group Name), and upload and submit to the instructor through Dropbox. Do not enter anything in the spreadsheet cells that are black, labeled “Grader”.
You must complete this assignment without the assistance of persons other than the members of your Group. You may use any other resources you deem necessary. Answer the questions below by placing the appropriate graph and/or answers in the designated cells of the spreadsheet.
DO NOT CHANGE THE APPEARANCE OR FUNCTIONALITY OF THE
SPREADSHEET UNLESS INSTRUCTED TO DO SO.
Question 1 (35 points)
Office Support, Inc. provides on-site repair for most large photocopy machines. It currently has
…show more content…
If the gasket production machine is working properly, the population of gasket OD measures can be reasonably modeled by a Normal distribution with mean OD = 400 mm and standard deviation OD = 2 mm. Use the spreadsheet named Asterex.
a. 5 points: Find the values for the sample statistics indicated in column D. Use a built-in Excel function or formula when appropriate. Place the appropriate function or formula for each statistics in the indicated cell in column E.

2

b. 5 points: The engineering specifications provide that a gasket should be between 395 mm and
405 mm, otherwise a gasket is defective. Assuming the process is working correctly; find the probability that a randomly selected gasket is not defective. Use Excel’s built-in function for the
Normal distribution to answer the question, and place the value in cell J2.
c. 5 points: The engineering specifications provide that a gasket should be between 395 mm and
405 mm, otherwise a gasket is defective. Assuming the process is working correctly; find the probability that a randomly selected gasket is defective. Use Excel’s built-in function for the
Normal distribution to answer the question, and place the value in cell J4.

Question 3 (35 points)
For the coming season, Savannah Bee Company plans to introduce a new product called Orange Blossom
Honey. Savannah Bee faces the decision of how many units of Orange Blossom Honey to produce for the coming holiday season.
Members