Directions for finance question | Business & Finance homework help


Directions: Answer the topic underneath by placing the misspend graph and/or answers in the denominated cells of the spreadsheet (see detached spreadsheet benevolence).

 

DO NOT CHANGE THE APPEARANCE OR FUNCTIONALITY OF THE SPREADSHEET UNLESS INSTRUCTED TO DO SO.

 

 

Question 4

 

Gateway 2000 Inc. receives extensive shipments of microprocessors from Intel Corp. It must try to determine that the symmetry of microprocessors that are wanting is insignificant. Deem Gateway patterns and tests 5 microprocessors out of a shipment of thousands of these microprocessors. Deem too that if at lowest 1 of the microprocessors is wanting, the shipment is returned. This sampling and superintendence purpose can be modeled as a Binomial way delay parameters n and p. Define x = the sum of wanting microprocessors out of 5 patternd and inspected. Use the spreadsheet named Gateway.

 

4a. Starting in cell A3, tender down, roll all likely values for the sum of wanting microprocessors (out of 5 patternd).

 

4b. Deem that Intel Corp.’s shipment contains 10% wanting microprocessors. Use Excel’s built-in part for the Binomial arrangement to investigate the chance for each outcome you rolled in support A. Start the chance calculations in cell B3 and change down.  Also, profession that you determined that the sum of the probabilities of all likely outcomes is 1.

 

4c.  Again, deem that Intel Corp.’s shipment contains 10% wanting microprocessors. In cell C11, furnish the mediocre sum of wantings we wait-for in a pattern of 5 microprocessors.

 

4d. Again, deem that Intel Corp.’s shipment contains 10% wanting microprocessors. In cell C13, procure the chance that the solid shipment conciliate be returned (lofty 10% flaw reprove and 5 microprocessors patternd).

 

4e. In cell C15, investigate the chance that the solid shipment conciliate be kept by Gateway flush though the shipment has 10% wanting microprocessors lofty 5 microprocessors are patternd.