Question

Does brand and location of the product increase sales? A market researcher designs an experiment to see if the brand and location of chewing gum in a grocery store has anything to do with the average volume of gum sales. Six brands of chewing gum are moved to four different locations within a store. The gum sale results can be found in the excel file ChewingGum. Run the appropriate tests and place the screen shot of your minitab or excel output below.

Run all tests at the 5% significance level. When running a chi square test for association, you MUST check off “each cell’s contribution to Chi-Square” in MiniTab (this is found by selecting “statistics” when in the test dialog box). If using Excel you must complete these by hand within excel.When running a one-way or two-way ANOVA test, also perform a Fisher’s LSD comparison test for any significant factors, at the 5% significance level.

Brand	Location	Sales
A	Front	150
B	Front	156
C	Front	203
D	Front	183
E	Front	147
F	Front	190
A	Back	58
B	Back	62
C	Back	89
D	Back	73
E	Back	46
F	Back	83
A	Left	111
B	Left	98
C	Left	117
D	Left	118
E	Left	101
F	Left	113
A	Right	130
B	Right	117
C	Right	105
D	Right	113
E	Right	114
F	Right	115

Answer 1

We conduct Anova: Two Way

Factor Information

Factor    Type   Levels Values
Brand     Fixed       6 A, B, C, D, E, F
Location Fixed       4 Back, Front, Left, Right

Analysis of Variance

Source      DF Adj SS   Adj MS F-Value P-Value
Brand      5    2177    435.5     2.53    0.075
Location   3   32258 10752.6    62.51    0.000
Error       15    2580    172.0
Total       23   37015

Model Summary

      S    R-sq R-sq(adj) R-sq(pred)
13.1157 93.03%     89.31%      82.15%

p-value of Brand = 0.075 > alpha

hence there is not significant difference in Brand

p-value of Location    = 0.000 < alpha

hence there is significant difference in Location