Question

In: Math

The manager of a supermarket chain wants to determine if the location of the product -...

The manager of a supermarket chain wants to determine if the location of the product - where it is to be displayed - has any effect on the sale of a pet toys. Three different aisle locations are to be considered: the front of the aisle, the middle of the aisle, or the rear-aisle. Twenty-one stores are randomly selected, with 7 stores randomly assigned to sell the pet toy at the front-aisle, the middle-aisle, and the rear-aisle.

Front Middle Rear

8.6 3.2 4.6 7.2 2.4 6.0 5.4 2.0 4.0 6.2 1.4 2.8 5.0 1.8 2.2 4.0 1.6 2.8 4.5 1.8 2.5

A boxplot of the data is provided as well as MINITAB output:

  1. (a) Does this data indicate that the sales of the pet toy are the same at the three aisle locations? State the appropriate statistical hypotheses.

  2. (b) To test the H0 in part (a), an ANOVA table was obtained in MINITAB:

         Source  DF     SS     MS      F      P
         Factor   2  51.59
         Error
         Total   20  80.82
    

    The P-value of test was found to be 0.000106.
    (i) Provide the value of the test statistic from which this P -value was found.

⃝c Jim Stallard 2019: Reproduction, in whole or in part, requires written consent of the copyright holder.6

(ii) Using a level of significance of 5%, what can you conclude from this data? Write a brief sentence describing your finding. [2]

(c) The output below results from an application of Tukey’s HSD method.

   Front subtracted from:
            Lower  Center   Upper   --+---------+---------+---------+-------
   Middle  -5.553  -3.814  -2.076   (------*------)
   Rear    -4.024  -2.286  -0.547         (------*------)
                                    --+---------+---------+---------+-------
                                   -5.0      -2.5       0.0       2.5
   Middle subtracted from:
          Lower  Center  Upper   --+---------+---------+---------+-------
   Rear  -0.210   1.529  3.267                        (------*------)

Summarize these results.

Solutions

Expert Solution


(ii) Since p-value<0.05 so we reject H0 at 5% level of significance and conclude that there is sufficient evidence that this data indicate that the sales of the pet toy are not same at the three aisle locations.

(c) Since the Confidence intervals of Middle-Front and Rear-Front do not contain zero hence Front is significantly different from Middle and Rear. Whereas Confidence interval of Rear-Middle contains zero hence they are not significantly different. Moreover we have seen that Confidence intervals of Middle-Front and Rear-Front do not contain only negative values hence we can conclude that average sale from front of the aisle is larger than other locations.


Related Solutions

The retailing manager of a supermarket chain wants to determine whether product location has any effect...
The retailing manager of a supermarket chain wants to determine whether product location has any effect on the sale of pet toys. Three different aisle locations are considered: front, middle, and rear. A random sample of 18 stores is selected with 6 stores randomly assigned to each aisle location. The size of the display area and price of the product are constant for all stores. At the end of a 1-month trial period, the sales volumes (in thousands of dollars)...
A large, U.S. based supermarket chain wants to purchase a medium-sized European supermarket chain based in...
A large, U.S. based supermarket chain wants to purchase a medium-sized European supermarket chain based in London. The U.S. supermarket has reached a point of saturation in the United States and they are looking for ways to grow. The U.S. based supermarket chain pursues a cost-leadership strategy in the United States and offers customers value through low prices and a vast variety of products. The U.S. based supermarket currently has a global market share of 2% and earns approximately 1.78%...
A Manager wants to consider another variable in determining product location for paper products. In addition...
A Manager wants to consider another variable in determining product location for paper products. In addition to shelf space, the manager wants to consider whether placing the product at the front (= 1) or back (= 0) of the aisle influences weekly sales. Use the dataset below: a. Run a multiple regression using shelf space (X1) and location (X2) to predict sales (Y). Report your regression equation. b. Is the regression model you ran statistically significant? How can you tell?...
The same marketing manager from problem #1 wants to consider another variable in determining product location...
The same marketing manager from problem #1 wants to consider another variable in determining product location for paper products. In addition to shelf space, the manager wants to consider whether placing the product at the front (= 1) or back (= 0) of the aisle influences weekly sales. Use the data file PaperProducts(2). a. Run a multiple regression using shelf space (X1) and location (X2) to predict sales (Y). Report your regression equation b. Is the regression model you ran...
The marketing manager of a large supermarket chain faced the business problem of determining the effect...
The marketing manager of a large supermarket chain faced the business problem of determining the effect on the sales of pet food of shelf space and whether the product was placed at the front ​(equals​1) or back ​(equals ​0) of the aisle. Data are collected from a random sample of 12​ equal-sized stores and are given below. Complete parts​ (a) through​ (g). For parts​ (a) through​ (d), do not include an interaction term. Store Shelf_Space_(Feet) Location Weekly_Sales_($) 1 5 Back...
Exhibit 14 -3 A sample of data The marketing manager of a large supermarket chain believes...
Exhibit 14 -3 A sample of data The marketing manager of a large supermarket chain believes the sales volume, in dollars, of pet food depends on the amount of shelf space (measured in feet of shelf space) devoted to pet food. Shelf Space Sales 5 160 5 220 5 140 10 190 10 240 10 260 15 230 15 270 15 280 20 260 20 290 20 310 The proportion of the variation in sales that is explained by shelf...
The marketing manager of a large supermarket chain would like to use shelf space to predict...
The marketing manager of a large supermarket chain would like to use shelf space to predict the sales of pet food. For a random sample of 15 similar stores, she gathered the following information regarding the shelf space, in feet, devoted to pet food and the weekly sales in hundreds of dollars. . Store Shelf Space Weekly Sales 1 5 1.3 2 5 1.6 3 5 1.4 4 10 1.7 5 10 1.9 6 10 2.3 7 15 2.2 8...
The marketing manager of a large supermarket chain would like to use shelf space to predict...
The marketing manager of a large supermarket chain would like to use shelf space to predict the sales of pet food. A random sample of 12 equal-sized stores is selected, with the following results. Shelf Space Sales Aisle Location 5 160 0 5 220 1 5 140 0 10 190 0 10 240 0 10 260 1 15 230 0 15 270 0 15 280 1 20 260 0 20 290 0 20 310 1 A. Construct a scatter plot...
Problem Scenario You are the store manager for a regional supermarket chain. Your store employees are...
Problem Scenario You are the store manager for a regional supermarket chain. Your store employees are non-union and management intends to keep it that way. Recently, a local union has attempted to organize your employees to form a union. This incident was reported to top management at headquarters. You later received orders from headquarters to discharge or in the words of one senior manager “Get rid of all Union instigators immediately” from your store who have signed union authorization cards...
1. The marketing manager of a large supermarket chain would like to use shelf space to...
1. The marketing manager of a large supermarket chain would like to use shelf space to predict the sales of a specialty pet food. Data are collected from a random sample of 8 equal-sized stores, with the following results: Store Shelf Space (in square feet) Weekly Sales (in Dollars) 1 4 120 2 4 150 3 8 160 4 8 180 5 12 200 6 16 210 7 16 240 8 20 260 Use Excel to find the regression results...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT