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. 4 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. 4 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. 9 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),” where argument 1 is the data range and argument 2 is a cell reference containing a specific outcome value. Start by finding the count for x = 0, then finding the count for all other outcomes. The values will be under the column labeled “Count.” • In the first unused cell following the last count value (from above), use Excel’s built-in SUM function to calculate the total count (frequency). For example, if the count cells went from H2:H7, enter the sum in cell H8. Format the sum cell (box, color, etc.) to highlight that it contains the sum of the values above it. d. 10 points: Beginning in cell I2, write a formula to calculate the probability of each outcome, based on the concept of relative frequency. Reference the cell containing the sum of counts (from above) as an absolute reference in your formula, but reference the cell containing the count as a relative reference. • In the first unused cell following the last probability value (from above), use Excel’s built-in SUM function to calculate the total probability. For example, if the probability cells went from I2:I7, enter the sum in cell I8.

Attachments:

GroupXX-Assig….xlsx

Assign5-Instr….docx