' Format all the probability values [including the sum of probabilities) in column I using 3 decimal places. Format the sum cell (box, color, etc.) to highlight that it contains the sum of the values above it. e. 5 points :In cell K9, calculate the expected value ,that is, nd the average number of service calls E(x)=EX -P{x) per day. The formula for Expected Value is: ' To calculate the expected value you should first write a formula in cell K2 and drag it to KB. The formula in cell K2 should make relative reference to the values in cell G2 and cell 12. f. 14 points: In cell N9, calculate the variance _ that is, find the variance for the random variable Var{x) ZEix- 13ml? -P(x] number of service calls per day. The formula for Variance is To calculate the variance you will rst be required to follow these steps . " Provide formulas in cells L2 through 1.5 that find the difference in each value of it and the _ .x E{x)l expected value, that is, a formula for . The formulas should make absolute reference to the expected value in cell KS, and relative reference to the values in cells (32 through GB. ' Provide formulas in cells M2 through MB that square the differences found in cells L2 lx em]? through L8,that is, formulas for . ' Provide formulas in cells N2 through NB that multiply the squared differences found in cells M2 through M3 by the probability values calculated in column I, that is, formulas for lx- EUCJl2 '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 Sro'Dev Wort!)- g. 2 points: In cell L13, calculate the probability that Office Support will have two or more service 2 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 4: calls per day. That is, nd PL]: _l) . Question 2 WOOD Inc. receives large shipments of microprocessors from Intel Corp. It must try to ensure that the proportion of microprocessors that are defective is small. Suppose Gateway samples and tests 5 microprocessors out of a shipment of thousands of these microprocessors. Suppose also that if at least 1 of the microprocessors is defective, the shipment is returned. This sampling and inspection scheme can be modeled as a Binomial process with parameters n and p. Define x = the number of defective microprocessors out of 5 sampled and inspected . Use the spreadsheet named Gateway a. 3 points: Starting in cell A3. moving down. list all possible values for the number of defective microprocessors (out of 5 sampled ). b. '5' points: Suppose that Intel Corp.'s shipment contains 10% defective microprocessors. Use Excel's builtin function for the Binomial distribution to calculate the probability for each outcome you listed in column A. Start the probability calculations in cell B3 and move down