Question: Please do it in excel For the mower test data, what distribution might be appropriate to model the failure of an individual mower? What fraction

Please do it in excel

  1. For the mower test data, what distribution might be appropriate to model the failure of an individual mower?
  2. What fraction of mowers fails the functional performance test using all the mower test data?
  3. What is the probability of havingxfailures in the next 100 mowers tested, forxfrom 0 to 20?
  4. What is the average blade weight and how much variability is occurring in the measurements of blade weights?
  5. Assuming that the data are normal, what is the probability that blade weights from this process will exceed 5.20?
  6. What is the probability that blade weights will be less than 4.80?
  7. What is the actual percent of blade weights that exceed 5.20 or are less than 4.80 from the data in the worksheet?
  8. Is the process that makes the blades stable over time? That is, are there any apparent changes in the pattern of the blade weights?
  9. Could any of the blade weights be considered outliers, which might indicate a problem with the manufacturing process or materials?
  10. Is the assumption that blade weights are normally distributed justified?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!