Question

A diet low in salt and calories is generally considered better for your health. Consumer Reports, June 1986, pp. 366-367 reported on the sodium and calories contained in each of 54 major hot dog brands. A subset of this data is presented in the datafile “HM802HotDog”.Use the ANOVA procedure to compare the Calories in all three varieties (Beef, Meat, and Poultry) of hot dog. Hint; Use ANOVA to compare the variables Calories Beef, Calories Meat, and Calories Poultry in the attached “HM802HotDog” data set. From your analysis please report the Sum of Squares between groups and Sum of Squared within groups.

2nd column caolories

3rd column sodium

1

Beef

186

495

2

Beef

181

477

3

Beef

176

425

4

Beef

149

322

5

Beef

184

482

6

Beef

190

587

7

Beef

158

370

8

Beef

139

322

9

Beef

175

479

10

Beef

148

375

11

Meat

173

458

12

Meat

191

506

13

Meat

182

473

14

Meat

190

545

15

Meat

172

496

16

Meat

147

360

17

Meat

146

387

18

Meat

139

386

19

Meat

175

507

20

Meat

136

393

21

Poultry

129

430

22

Poultry

132

375

23

Poultry

102

396

24

Poultry

106

383

25

Poultry

94

387

26

Poultry

102

542

27

Poultry

87

359

28

Poultry

99

357

29

Poultry

107

528

30

Poultry

113

513

Answer 1

The ANOVA model for the mean value of calories is obtained in EXCEL by using following step;

Step 1: Write the data value in excel. The screenshot is shown below;

Step 2: Data>Data Analysis>ANOVA: Single Factor >OK. The screenshot is shown below:

Step 3: Select>Input Range>OK. Select Grouped by: Rows and tick Labels in first column and Alpha value = 0.05 at 5% significance level. The screenshot is shown below;

The ANOVA table is obtained. The screenshot is shown below;

ANOVA
Source of Variation	Sum of Square	df	MS	F	P-value	F crit
Between Groups	32739.87	29	1128.961	65535	#NUM!	#NUM!
Within Groups	0	0	65535
Total	32739.87	29