Question
I am stuck on Problem D #6-9. 6. Using the population's mean and standard deviation for productivity at the Norcross plant (from #1), compute the
I am stuck on Problem D #6-9.
6. Using the population's mean and standard deviation for productivity at the Norcross plant (from #1), compute the probability that worker productivity is less than 100.
7. Using the population's mean and standard deviation for productivity at the Norcross plant (from #1), compute the probability that worker productivity is greater than 110.
8. Using the population's mean and standard deviation for productivity at the Dallas plant (from #2), what is the probability that a worker's productivity is less than 100 or greater than 110?
9. Compare and contrast the probabilities of productivity at each plant being less than 100 or greater than 110 (from #7 and #8). Discuss your findings and interpret results
This immediate table was the findings I calculated for questions 1-5
Mean Norcross | 102.35 | Std Dev | 3.68 |
Mean Dallas | 100.21 | Std Dev | 4.01 |
99.7, 98.3, 97.2, 98.8, 98.6, 97.3, 97.3, 93.5, 95.5, 95.2 | |||
Mean Sample Norcross | 97.14 | Std Dev | 1.9 |
Normal Probabilities | |||||
Common Data | |||||
Mean | 7 | ||||
Standard Deviation | 2 | ||||
Probability for a Range | |||||
Probability for X <= | From X Value | 7 | |||
X Value | 7 | To X Value | 9 | ||
Z Value | =STANDARDIZE(B8,B4,B5) | ="Z Value for " &E7 | =STANDARDIZE(E7,B4,B5) | ||
="P(X<="&B8&")" | =NORMDIST(B8,B4,B5,TRUE) | ="Z Value for " & E8 | =STANDARDIZE(E8,B4,B5) | ||
="P(X<="&E7&")" | =NORMDIST(E7,B4,B5,TRUE) | ||||
Probability for X > | ="P(X<="&E8&")" | =NORMDIST(E8,B4,B5,TRUE) | |||
X Value | 9 | ="P("&E7&"<=X<="&E8&")" | =ABS(E12-E11) | ||
Z Value | =STANDARDIZE(B13,B4,B5) | ||||
="P(X>"&B13&")" | =1-NORMDIST(B13,B4,B5,TRUE) | Find X and Z Given Cum. Pctage. | |||
Cumulative Percentage | 0.1 | ||||
="Probability for X<"&B8&" or X >"&B13 | Z Value | =NORMSINV(E16) | |||
="P(X<"&B8&" or X >"&B13 & ")" | =B10+B15 | X Value | =NORMINV(E16,B4,B5) | ||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started