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…
The formulas should make absolute
2
•
reference to the expected value in cell K9, and relative reference to the values in cells G2 through G8.
Provide formulas in cells M2 through M8 that square the differences found in cells L2
through L8, that is, formulas for [ x − E ( x) ] .
2
•
Provide formulas in cells N2 through N8 that multiply the squared differences found in cells
M2 through M8 by the probability values calculated in column I, that is, formulas for
[ x − E ( x)]
•
•
2
⋅ P( x) .
Calculate the Variance and place the value in cell N9.
In cell N10, calculate the standard deviation. Recall that the formula for the standard deviation is StdDev = Var ( x) .
g. 2 points: In cell L13, calculate the probability that Office Support will have two or more service calls per day. That is, find P ( X ≥ 2) .
h. 2 points: In cell L14, calculate the probability that Office Support will have less than two service calls per day. That is, find P ( X ≤ 1) .
Question 2 (15 points)
Asterex Inc. produces silicon gaskets that are used to connect piping materials for the petroleum industry. The gaskets are ring shaped, and look like a thin donut with a big hole in the center. It is important that the gaskets have the proper inside diameter (ID), outside diameter (OD), and wall thickness. The quality control department samples and tests gaskets every 15 minutes to ensure conformance to quality characteristics and engineering specifications for the three quality
Name: Amber Smith CAUTION: See "round" rules in Excel Instructions before calculating OT for slaried employees. Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear to the right of an incorrect answer. For a breakdown of the solution by chapter, see the worksheet tabs labeled CPP 2 through 6 representing the solutions for chapters 2-6. Continuing Payroll Problem-B
To fix the error: The cell DI7 should be left blank or it must contain a number. What should we with those cells?
Scenario: Richman Investments provides high-end smartphones to several employees. The value of each smartphone is $500, and approximately 1,000 employees have these company-owned devices. In the past year, employees have lost or damaged 75 smartphones .
a) Graph the following data on semi-log OR regular graph paper. Determine the D-value using the graph. Show your work.
A computer used by a 24-hour banking service is supposed to randomly assign each transaction to one of 5 memory locations. A check at the end of a day's transactions gave the counts shown in the table to each of the 5 memory locations, along with the number of reported errors.
2.56 0.60 48.86 3.64 73.43 40.16 63.63 102.47 4.06 1.37 0.63 0.56 4.63 1.25 34.33% 11.19% 5.70% 9.98% 21.17%
What is the thesis of Johnson’s essay? If it is stated directly, locate the relevant sentence or sentences. If it is implied, state the thesis in
Read the following short essay, and then write a 3-5 page response (12-point font, double-spaced, normal margins, no cover page, no binders). Your response should do the following three things: (1) state what the main conclusion of the essay is; (2) state what the most important premises (including sub-conclusions) are—i.e., state which premises are most important if the argument is to rationally convince its audience; (3) evaluate the quality of the argument, giving detailed reasons to justify your evaluation. For purposes of evaluation, assume that the speaker is a contemporary Canadian philosopher and the audience is a group of students in Introduction to Philosophy.
2 3 175 0.080 951 0.43 195 245 658 335 170 3.4 0.9 57.0 9.2 0.21 61.4 1,718 530 1.1 2,520 92,000 583 14 22 6 19 15 927 765 12,280 22
5. If the company continues to use one technician when the customer base expands to 20 customers, the average time in the waiting line will increase to 6.9454 hours. With an average travel time of 1 hour, the average total waiting time will be 6.9454 + 1 = 7.9454 hours. The total cost will be $397.78 per hour. This average total waiting time is too long and a second technician is definitely necessary. Using output from The Management Scientist, two service technicians provide the following:
A computer used by a 24-hour banking service is supposed to randomly assign each transaction to one of 5 memory locations. A check at the end of a day’s transactions gave the counts shown in the table to each of the 5 memory locations, along with the number of reported errors.
In regard to the first part of the Case Problem (The average number of days needed to repair the copier), I worked on the Excel to find the number of the days required to repair the copier (Repair Time (days). In Excel, I wrote down the table information given from the case study to make it easier to find it and copy, if necessary. I used the RAND() function in to create random values for column F4:F16. After created the RAND()values, I copied and pasted the values in the column F4:F16 because I needed to freeze the number, otherwise it would keep changing. Using the random
The assembly 's board department is in a death curve. The department 's operations are at 70 percent of estimated capacity level and given that the fixed costs are 80 percent of its , then it is likely that phone assembly departments are moving a lot of their board assembly job outside
Within the data set, there are 126 vendors; most vendors only have one duplicate, while there are thirty-four instances where vendors have anywhere from sixteen to thirty-eight duplicates. Of the 126 vendors, seventy-eight of them have more than one duplicate, anywhere from three to seventy-six transactions. This is a
1. In Excel, use a suitable method for generating the number of days needed to repair the copier, when it is out of service, according to the discrete distribution shown.