19 F G A PA You are trying to sell organic bread and are trying to influence demand using price, advertisement spend and sales promotions Sales promotion strategies include "buy 1 get one free", "bundling with another product", "mail in rebates". To handle different sales promotions you decided to use the value of the sales promotion. For example, "buy 1 get one free would " be the cost of an extra load of bread. a) Copy this worksheet Prl, name it Pr1.1.A. create a scatter plot between Price Price Prom Demand and Demand. Use Data Analysis toolpak to run a simple regression equation and Ad Spend per per Value per units explain the results. Do the same for Ad Spend and Demand and Promotion Value unit unit unit $ and Demand in worksheets Pri.1.B and Pri.1.C $4.04 $2.46 $3.04 46, 108.63 b) Copy the worksheet Prl, name it Pr1.2. Use Multiple Regression Additive Method $9.70 $2.17 $3.05 40, 703.64 an 43.545.36 and the Data Analysis Tool Pak to build your multiple regression equation adding $6.72 $2.30 $3.13 the independent variables one by one. Explain why you chose the order of the $6.09 $2.36 $1.26 44,051.67 th 42,502 12 variable based on what you know from the simple regressions you created. Show $7.88 $2.29 $2.36 each step in different worksheets. Name them Pr1.2.A, Pr1.2.B and so on. $8.64 $2.24 $1.24 41,510.44 $5.83 $2.35 $1.80 44,556.93 "c) Copy worksheet Prl, name it Pr1.3. Use Multiple Regression Subtractive Method $9.69 $2.18 $1.26 40,652.34 C) 47.502 39 and the Data Analysis Tookpak to build your multiple regression equation. Show $2.77 $2.53 $1.16 each step in different worksheets. Name them Pr1.3.A, Pri.3B etc. $9.09 $2.21 $3.84 41,054.32 $7.38 $2.29 $2.07 42, 774.24 $8.94 $2.20 $1.05 41,532.52 $7.03 $2.29 $2.20 43, 139.87 $6.95 $2.31 $1.07 43,480.77 $7.02 $2.31 $2.60 43,417.34 $9.23 $2.26 $3.92 41,238.48 $9.02 $2.20 $3.68 41,096.60 $2.45 $2.57 $3.07 47,810.99 $5.80 $2.35 $2.08 44,343.99 $4.71 $2.42 $2.57 45, 707.74 $4.52 $2.45 $2.84 45,659.50 $3.02 $2.46 $2.53 47,144.01 $5.34 $2.42 $1.07 45, 156.28 $6.43 $2.34 $2.50 43,906.35 $3.60 $2.51 $3.13 46,832.20 $3.39 $2.53 $2.77 46,957.39 $7.80 $2.31 $3.74 42,425.68 $8.12 $2.25 $2.09 42,324.01 $6.07 $2.35 $1.81 44,287.55 $8.86 $2.26 $2.67 41,359.97 $3.56 $2.52 $2.56 46, 728.76 $6.01 $2.37 $2.58 44, 150.04 $9.95 $2.12 $2.36 40,291.10 $9.37 $2.23 $1.76 40,752.22 $3.66 $2.45 $2.05 46,457.50 $3.89 $2.45 $3.36 46,349.32 $9.68 $2.21 $3.91 40,686.40 $8.94 $2.18 $3.19 41,542.63 $9.02 $2.25 $1.50 41,456.72 $9.88 $2.20 $2.31 40,279.86 $5.80 $2.41 $1.27 14,560.95 + $5.19 $2.44 $1.12 45,163.03 $2.53 $2.57 $2.62 47,659.05 $2.51 $2.50 $1.91 47,644.88 $5.20 $2.39 $1.48 45, 165.38 $5.35 $2.44 $2.74 44,896.54 $4.63 $2.42 $1.37 45,791.25 $5.69 $2.40 $2.57 44,443.89 $7.00 $2.27 $1.18 43,172.32 $6.94 $2.36 $1.21 43,270.38 $5.98 $2.41 $2.57 44,393.62