USE EXCEL SHOW ALL STEPS Healthy Snacks decides to change its pretzels supplier.

ID: 2945816 • Letter: U

Question

USE EXCEL SHOW ALL STEPS

Healthy Snacks decides to change its pretzels supplier. In the review process, they limit their options to four suppliers. Except Sodium level, every other specification of pretzels produced by the four suppliers is the same. Table below lists the sodium level in pretzels obtained by sampling the products of each supplier.

No. Supplier 1 Supplier 2 Supplier 3 Supplier 4 1 2.93 3.09 3.38 3.36 2 3.18 2.73 3.03 3.34 3 3.05 2.70 2.53 3.68 4 3.34 2.91 2.58 3.70 5 2.68 2.82 2.67 3.33 6 2.92 2.68 2.54 3.42 7 2.91 3.03 2.71 3.45 8 2.63 2.96 2.79 3.25 9 2.90 2.84 2.51 3.42 10 3.28 2.37 3.26 3.75 11 2.55 2.44 2.58 2.98 12 3.15 2.78 3.11 3.12 13 3.09 2.86 2.53 3.35 14 2.94 2.28 2.44 3.72 15 2.84 2.72 2.79 2.93 ? 0.05

Explanation / Answer

Result:

Excel. Data, Data Analysis and Anova single factor option is selected.

Anova: Single Factor

SUMMARY

Groups

Count

Sum

Average

Variance

Supplier 1

44.39

2.959333

0.052507

Supplier 2

41.21

2.747333

0.054264

Supplier 3

41.45

2.763333

0.087567

Supplier 4

50.8

3.386667

0.064624

ANOVA

Source of Variation

P-value

F crit

Between Groups

3.988205

1.329402

20.5344

0.0000

2.769431

Within Groups

3.625453

0.06474

Total

7.613658

Is there any significant difference between the sodium level of pretzels produced by each supplier considering ?=0.05? If yes, which supplier(s) would you pick in order to minimize the cost of one bag of snack? Make sure you include all related information such p-value and test statistic in your answer.

H_0: mu_1 = mu_2= mu_3 = mu_4

H1: At least one pair of population means are different

Calculated F=20.5344, P=0.0000 which is < 0.05 level of significance.

Ho is rejected.

We conclude that there is significant difference between the sodium level of pretzels produced by the four suppliers.

By comparing the average values, the supplier 2 have low average sodium level of pretzels than others.