In cell B$4,$ enter your full name. In cell B$4,$ enter your full name.

Problem:

Jamal Smith, the owner of Lobster Tail BnB in Portland, ME$,$ is trying to improve quality in his kitchen. He is sampling the weight of lobsters from large cases delivered

from his supplier. Jamal is wanting to use SPC to check that the size of the lobsters are within specs. Data from samples taken is provided below. He has set the Z$-$score

for this problem as $3($seen in cell $N38)$ and found the standard deviation for the population of all lobsters $($seen in cell N$40).$

In cell $N28,$ use a formula to figure the standard deviation of the sampling distribution.

$-$Note: This must be a formula using only cell references. No hardcoding.

In cells B$33$:K$33,$ use a formula to calculate the average of each sample taken $($or $x-$bar$).$

$-$Note: These cells must use formulas.

In cell N$31,$ use a formula to figure the average of the sample averages $($or $x-$bar bar$).$

$-$Note: These cells must use formulas.

In cells N$33$:N$34,$ use a formula to solve for UCLx and LCLx$.$

$-$Note: the $z=3$ is in cell $N25$

$-$Note: Only functions and cell references can be used. NO HARDCODING.

Note:

Chart will fill

in as

formulas are

filled in$.$

X$-$Bar Chart

Problem:

Jamal Smith, the owner of Lobster Tail BnB in Portland, ME$,$ is trying to improve quality in his kitchen. He is sampling the weight of lobsters from large cases delivered

from his supplier. Jamal is wanting to use SPC to check that the size of the lobsters are within specs. Data from samples taken is provided below. He has set the Z$-$score

for this problem as $3($seen in cell $N38)$ and found the standard deviation for the population of all lobsters $($seen in cell N$40).$

In cell $N28,$ use a formula to figure the standard deviation of the sampling distribution.

$-$Note: This must be a formula using only cell references. No hardcoding.

In cells B$33$:K$33,$ use a formula to calculate the average of each sample taken $($or $x-$bar$).$

$-$Note: These cells must use formulas.

In cell N$31,$ use a formula to figure the average of the sample averages $($or $x-$bar bar$).$

$-$Note: These cells must use formulas.

In cells N$33$:N$34,$ use a formula to solve for UCLx and LCLx$.$

$-$Note: the $z=3$ is in cell $N25$

$-$Note: Only functions and cell references can be used. NO HARDCODING.

Note:

Chart will fill

in as

formulas are

filled in$.$

X$-$Bar Chart