Question

A study was undertaken to see how accurate food labeling for calories on food that is considered reduced calorie.  The group measured the amount of calories for each item of food and then found the percent difference between measured and labeled food,(measured – labeled) divided by labeled multiplied by 100%.  The group also looked at food that was nationally advertised, regionally distributed, or locally prepared.  The data is in table #11.3.5 ("Calories datafile," 2013).  Do the data indicate that at least two of the mean percent differences between the three groups are different?  Test at the 10% level.

Table #11.3.5: Percent Differences Between Measured and Labeled Food

National Advertised	Regionally Distributed	Locally Prepared
2	41	15
-28	46	60
-6	2	250
8	25	145
6	39	6
-1	16.5	80
10	17	95
13	28	3
15	-3
-4	14
-4	34
-18	42
10
5
3
-7
3
-0.5
-10
6

Answer 1

Let us slove in excel,

enter data in excel as is mentioned above,

then follow the path,

Data> Data Analysis >

r Data Analysis ? ок Cancel TW NUT Analysis Tools Anova: Single Factor Anova: Two-Factor With Replication Anova: Two-Factor Without Replication Correlation Covariance Descriptive Statistics Exponential Smoothing F-Test Two-Sample for Variances Fourier Analysis Histogram Help аг. VS F P-vame Ecrir

Anova: Single Factor ? x Input Input Range: ок | $A$1:$C$21 Cancel Grouped By: O Columns O Rows Help NO ✓ Labels in First Row Alpha: 0.05 00 Output options O Output Range: O New Worksheet Ply: New Workbook ISTUTULT

The analysis Output results are as,

SUMMARY
Groups	Count	Sum	Average	Variance
National Advertised	20	2.5	0.125	110.6809
Regionally Distributed	12	301.5	25.125	258.3693
Locally Prepared	8	654	81.75	7050.786

Source of Variation	SS	df	MS	F	P-value	F crit
Between Groups	38095.9	2	19047.95	12.97915	5.36E-05	2.452014
Within Groups	54300.5	37	1467.581
Total	92396.4	39

Here P-value is significant(p-value<0.05), there is significant evedance that there is defference between the 3 groups .

Thanks