Please do Problem A and show and discribe how it was done on excell.
Problem Set #4 (Chapter 5, 23 points): a. Utilizing the worksheet Problem 4a, complete the following: 1) Referencing the table in B3:E7, calculate cell relative frequencies in the range C12:013. (Note: Row and column totals will calculate automatically.) 11) Enter the probabilities of events F, M, Y, N in cells C16:C19. 111) Compute the conditional probabilities P(Y/F) and P(Y/M) in cells H16 and H17. State your conclusion in H19. b. Utilizing the worksheet Problem 4b, which contains a database of random sample of 350 blade weights, complete the following: 1) Using the Histogram tool in the Data Analysis Tool Pack, create a histogram of the blade weights in a separate worksheet (you do not need to save it). Indicate the shape of the distribution in cell F4. 11) In cells E6 and E7, determine the mean and sample standard deviation of the blade weights using the appropriate Excel functions. 111) Assuming that blade weights in the manufacturing process are normally distributed with the mean and standard deviation values you calculated in ii) above, use the NORM.DISTO function compute the following probabilities and locate your solutions in H14:H17. a. P(X=5.10) b. P(4.88=5.10) d. What is the minimum weight of the top 10% of blade weights? B C D E F G H J 1 Problem 4a 2 3 4 Count of Age Gender College Grad N Y Grand Total 10 F 3 10 13 Table showing cell frequencies 17 27 5 6 7 8 M Grand Total 13 27 40 9 10 11 No (N) College Grad Yes(Y) 7.5% 12 13 14 Gender Female (F) Male(M) Grand Total 7.5% Grand Total Create table showing cell relative frequencies (Example provided in C12) 7.5% 0.0% 0.0% 7.5% Calculate Show calculations/solution here: P(YF) P(YM) 15 16 17 P(F) = P(M) = P(N) = P(Y) = 18 Conclusion: 19 20 21 22 23 24 25 26 27 28 29 20 Problem Set #4 (Chapter 5, 23 points): a. Utilizing the worksheet Problem 4a, complete the following: 1) Referencing the table in B3:E7, calculate cell relative frequencies in the range C12:013. (Note: Row and column totals will calculate automatically.) 11) Enter the probabilities of events F, M, Y, N in cells C16:C19. 111) Compute the conditional probabilities P(Y/F) and P(Y/M) in cells H16 and H17. State your conclusion in H19. b. Utilizing the worksheet Problem 4b, which contains a database of random sample of 350 blade weights, complete the following: 1) Using the Histogram tool in the Data Analysis Tool Pack, create a histogram of the blade weights in a separate worksheet (you do not need to save it). Indicate the shape of the distribution in cell F4. 11) In cells E6 and E7, determine the mean and sample standard deviation of the blade weights using the appropriate Excel functions. 111) Assuming that blade weights in the manufacturing process are normally distributed with the mean and standard deviation values you calculated in ii) above, use the NORM.DISTO function compute the following probabilities and locate your solutions in H14:H17. a. P(X=5.10) b. P(4.88=5.10) d. What is the minimum weight of the top 10% of blade weights? B C D E F G H J 1 Problem 4a 2 3 4 Count of Age Gender College Grad N Y Grand Total 10 F 3 10 13 Table showing cell frequencies 17 27 5 6 7 8 M Grand Total 13 27 40 9 10 11 No (N) College Grad Yes(Y) 7.5% 12 13 14 Gender Female (F) Male(M) Grand Total 7.5% Grand Total Create table showing cell relative frequencies (Example provided in C12) 7.5% 0.0% 0.0% 7.5% Calculate Show calculations/solution here: P(YF) P(YM) 15 16 17 P(F) = P(M) = P(N) = P(Y) = 18 Conclusion: 19 20 21 22 23 24 25 26 27 28 29 20
