# Assignment 2

Good Essays
1856 Words
Grammar
Plagiarism
Writing
Score
Assignment 2
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 five trained repair teams that it sends out on an on-call basis. Since the company advertises one-day service, it will not accept more than five requests for service per day. Two months ago, the vice president started considering expanding the workforce. At that time he asked the call desk to record the actual calls for each of the next 40 days. The data to respond to the questions below are provided in the Office worksheet. Define the random variable x as the number of service calls per day. Clearly x is a discrete random variable.
a. 3 points: Use built-in Excel functions to find the minimum and maximum values of x. That is, find the minimum number and maximum number of service calls per day over the 40 day period.
• Place the minimum in cell E2.
• Place the maximum in cell E3.
b. 3 points: Based on the minimum and maximum number of service calls per day in the sample of
40 days, specify the complete range of x. That is, make a list of all possible outcomes of x under the column labeled x starting in cell G2.
c. 5 points: Using the built-in Excel function named COUNTIF, calculate the count (frequency) of each outcome (x) in the sample. In general, your function with its arguments will appear as
“=COUNTIF(argument 1, argument 2),”

## You May Also Find These Documents Helpful

• Good Essays

And information or data which may be required by the solution will be entered in cells with borders to help identify them.…

• 1877 Words
• 8 Pages
Good Essays
• Good Essays

We also fix issues with non functional garage door opener to such as sensor, door opener gear, fried board, broken rails, loose chain rewire and more.…

• 578 Words
• 3 Pages
Good Essays
• Satisfactory Essays

discovered that their cost can now be modeled by the equation: C(n) = 25n2 + 150n +21500,…

• 250 Words
• 1 Page
Satisfactory Essays
• Satisfactory Essays

problems below and submit your work in an Excel document. Be sure to show all of your work and clearly label all…

• 263 Words
• 1 Page
Satisfactory Essays
• Good Essays

various types of repairs. A potential customer had just called to inquire about the cost to repair…

• 1305 Words
• 6 Pages
Good Essays
• Good Essays

A Project scope is a document that outlines the plans for the project and is used to record approval. The project scope is added to after initial approval…

• 1733 Words
• 6 Pages
Good Essays
• Good Essays

B. For each spring and the rubber band, plot the accumulated elongation (X-axis) versus the applied force (Y-axis) on a computer spreadsheet.…

• 550 Words
• 5 Pages
Good Essays
• Better Essays

Business Ethics Did Glenn act ethically in this case? Would Mary have acted unethically if she had actually orally guaranteed to repay her husband’s debts and then raised the Statute of Frauds to prevent enforcement of the oral promises?…

• 1012 Words
• 3 Pages
Better Essays
• Satisfactory Essays

1.) Input, via a question in the console, the report owner’s first name as a string and build the last name via input, one character at a time.…

• 338 Words
• 2 Pages
Satisfactory Essays
• Good Essays

 ‘Mean’ is the total of all the values in the set of data divided by the…

• 943 Words
• 16 Pages
Good Essays
• Good Essays

Question 1 : Explain how utilitarianism might provide a defense for Roche and how a rights-based ethic might instead condemn Roche’s drug trials in China. Which of these two approaches is stronger or more reasonable? Explain the reasons for your answer.…

• 1003 Words
• 3 Pages
Good Essays
• Satisfactory Essays

Decision Analysis Course Outline, Quarter I, 2006 Class Materials Topic Hardcopy in Packet Other* Introduction 1 Freemark Abbey Winery Structuring Decisions Framework for Analyzing Risk 2 The North Star Concert North Star.xls Best Guess, Worst Case, Best Case; and Continuous Uncertainties 3 Engine Services, Inc. Quick Start Guide to Crystal Ball…

• 469 Words
• 3 Pages
Satisfactory Essays
• Good Essays

The Data Set for Assignments in file DataSetForAss presents Weekly Income (WI), Weekly Expenditure on Food (WEF), Highest Level of Education (HLE)1 , Family Size (FS), and Gender of the Head of Household (GHH)2 for the a population of 500 households. Households are named by number from 1 to 500 as shown in Column A. Columns B to F record these households’ WI, WEF, HLE, FS and GHH, respectively. Column I presents 45 randomly selected households as your sample, where each number is the name of the household in your sample.…

• 785 Words
• 3 Pages
Good Essays
• Satisfactory Essays

This in-process parts cannot be easily use the service department to supply for their emergency repairs…

• 428 Words
• 3 Pages
Satisfactory Essays
• Satisfactory Essays

•To view your graded work, come back to the Dropbox or go to the Gradebook after your instructor has evaluated it. Click the Dropbox to access it.…

• 419 Words
• 2 Pages
Satisfactory Essays