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),”
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),”