Brugha Research Associates (BRA) just completed a controlled store test of a proposed new packaging for the Aussie brand of cookies. BRA collected eight weeks of pretest period sales data for Aussie cookies from 20 selected grocery stores in the Salt Lake City area, randomly divided these stores into two panel stores of 10 grocery stores, and designated one panel as the test panel and the other panel as the control panel. SLB then replaced the Aussie products in the test panel stores with Aussie products in the new packaging and collected eight weeks of posttest period sales data from stores in both panels.

BRA’s data processing department has produced the file brughastacked of the data for this study in a stacked arrangement as shown in the following figure. Marta Davis, Director of BRA’s Analytics Division, needs these data to be converted from stacked to unstacked with separate fields for pretest period sales and test period sales for each store and period. Convert these data for Marta Davis so they are unstacked and save the file under the name broughaunstacked.xlsx.

Transcribed Image Text:

Stacked Brugha Data B D 1 Store Number Panel Period Sales 2 96 Control Pretest $879.63 3 70 Control Pretest $689.72 4 63 Control Pretest $638.51 5 19 Control Pretest $325.00 6 24 Control Pretest $819.76 7 4 Control Pretest $942.93 8 81 Control Pretest $345.59 9 92 Control Pretest $694.70 10 93 Control Pretest $299.33 11 50 Control Pretest $440.54 12 96 Control Posttest $405.26 13 70 Control Posttest $270.20 14 86 Control Posttest $692.00 15 19 Control Posttest $752.90 16 24 Control Posttest $662.66 17 4 Control Posttest $707.52 18 81 Control Posttest $415.85 19 92 Control Posttest $894.70 20 93 Control Posttest $467.88 21 50 Control Posttest $851.67 22 10 Test Pretest $635.43 23 36 Test Pretest $549.08 24 3 Test Pretest $681.12 25 72 Test Pretest $389.34 26 52 Test Pretest $297.96 27 83 Test Pretest $419.57 28 54 Test Pretest $619.31 29 94 Test Pretest $623.12