On the "Compiled Information" tab, a VLOOKUP formula has been pre-entered into cell E3. This formula was written correctly, and
1 answer:
You might be interested in
Answer:
<em>The probability that the spark plugs are supposed to have a gap between 3.9mm and 4.3mm.</em>
<em>P(3.9≤X≤4.3) = 0.9922</em>
Step-by-step explanation:
<u><em>Step(i):-</em></u>
<em>Given that the mean of the Normal distribution = 4.1mm</em>
<em>Given that the standard deviation of the Normal distribution = 0.0075mm</em>
<em>Let 'X' be the random variable in a normal distribution</em>
Given that X₁ = 3.9mm
Given that X₂ = 4.3mm
<u><em>Step(ii):-</em></u>
<em>The probability that the spark plugs are supposed to have a gap between 3.9mm and 4.3mm.</em>
<em>P(3.9≤X≤4.3) = P(-2.666≤Z≤2.666)</em>
<em> = P(Z≤2.666)-P(Z≤-2.666)</em>
<em> = 0.5 +A(2.666) - (0.5-A(2.666)</em>
<em> = 2 × A(2.666)</em>
<em> = 2×0.4961</em>
<em> = 0.9922</em>
<u><em>Final answer:-</em></u>
<em>The probability that the spark plugs are supposed to have a gap between 3.9mm and 4.3mm.</em>
<em>P(3.9≤X≤4.3) = 0.9922</em>
<em></em>