X AutoSave Off Prob Assignment Instructions (1) v Search (Alt+Q) Shauna Hagan SH O X File Home Insert Page Layout Formulas Data Review View Help Comments Share Calibri 11 ~ A A = General Conditional Formatting Insert 9 Format as Table Ex Delete Paste BIUVV E E Analyze Sensitivity .00 0 Cell Styles v Format D Data Undo Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity A6 vi XVfx 22111581 B C D G H M N 0 P Q R S V INSTRUCTIONS Enter your Student Number in the yellow box PART (!) below. Your assignment will appear in the boxes on the right A sales team have demonstrated their software system to four potential clients (A,B,C,D). Based on feedback and past data they have worked out the probability of making a sale for each client STUDENT NUMBER Prob [Selling to Client A] 0.25 22111581 Prob (Selling to Client B] D.25 There are three parts to the assignment. Prob (Selling to Client C) 0.45 In a new MS EXCEL file answer these questions Client D is linked to Client A and they believe that if they sell to Client A the probability they sell 0.35 9 using EXCEL formulae and functions. But conversely if they don't sell to Client A the probability they sell to client D will reduce to 0. 15 10 You can add comments using Text Boxes or Calcuate the following Probabilities 11 any other suitable tool A. Not Selling to Client A 12 Preseantation is Important 13 Do not answer these questions by hand. B. Sellling to Clients A and E C. Sellling to Clients A or B 14 Once completed D. Selling to Clients A and B and C 15 E. Selling to Clients A or D 16 a) upload this file in slot provided on LOOP. 17 b) upload the answers to the 13 questions A to F. Selling to Exactly 3 Clients M in the LOOP Quiz provided. G. Selling to Clients A or B or C or D 18 19 PART (I1) A company has a fleet of 10 VANS and 5 TRUCKS. The probability that an individual VAN needs maintenance in a week is equal to 0.02 The probability that an individual TRUCK needs maintenance in a week is equal to 0.04 Assuming that a van or truck needing maintenace is independent of other vehicles needing maintenance, calcula H. What is the probability that 1 VAN needs maintenance in a week? 1. What is the probability that less than 3 TRUCKS need maintenance in a week? J. What is the probability that more than 2 of the companys' VEHICLES (Truck or Van) need maintenance in a week? Briefly comment on the assumption that a vehicle needing maintenance is independent of other vehicles needing PART (III) A Transportation Company have a fleet of lorries, which occasionally have breakdowns They believe that the number of breakdowns per day follows a Poisson Distribution, with a mean 2.5 Calcuate the following Probabilities K. Probability of 1 breakdown in a single day 1898828898 L. Probability of more than 5 breakdowns in a single day M. Probability of more than 9 breakdowns in 3 days Comment on the accuracy of your results and any assumptions made and test these assumptions where possible Zoom Assignment Details (+ Ready X Accessibility: Investigate + 50% 12.C LO 200m cup loop W P ENG 16:28 D Cloudy GA 11/10/2022