Estimate the regression coefficients

Reference no: EM13163069

The marketing manager of a large supermarket chain wants to determine how sales of the soft drinks are affected by shelf space and product placement. The soft drinks were placed either at the front or back of the aisle. Data collected from a random sample of 20 equal-sized stores is summarized in the attached Excel spreadsheet 1.xls (see the attached Excel spreadsheet).

a. Write out the multiple regression equation.

b. Estimate the regression coefficients using ordinary least squares and interpret them.

c. Predict the weekly sales for a store with 10 feet of shelf space situated at the back of the aisle.

d. At the 0.05 level of significance determine whether each independent variable makes a contribution to the regression model.

Attachment:- 1.xls

Reference no: EM13163069

Questions Cloud

State the value of the molar absorptivity : the value of the molar absorptivity is 4.84*10^3 M^-1 cm^-1 for K2CrO4 at that wavelength. what is the concentration of the solution

What is the new volume of the helium sample : The temperature of a 2.o-liter sample of helium gas at stp is increased to 27 degrees Celsius and the pressure is decreased to 80kpa what is the new volume of the helium sample?

Determine the molecular weight of the gas : .56 g of a specific gas are held at 101 degrees Celcius and 800 torr in a volume of 285 mL. Determine the molecular weight of the gas.

Performed to clarify the phage''s mode of replication : A single-stranded RNA phage replicates in E. coli with no DNA intermediates. The following experiments were performed to clarify the phage's mode of replication.

Estimate the regression coefficients : Estimate the regression coefficients using ordinary least squares and interpret them and predict the weekly sales for a store with 10 feet of shelf space situated at the back of the aisle

What is the balanced equation : Approximately how many grams of calcium nitrate were required to react totally with 40.0 g of sodium carbonate? How many grams of product were formed at that point? Do your answers appear to obey the Law of Conservation of Matter?

Calculate the concentration of each ion : If 1.0 l of 0.10 M sodium phosphate is mixed with 1.0 l of 0.10 M magnesium nitrate, magnesium phosphate is produced. Calculate the concentration of each ion when the reaction is finished and the mass of precipitate.

Calculate the rate at which sulfur dioxide is being produced : Calculate the rate at which sulfur dioxide is being produced. Give your answer in kilograms per second. Be sure your answer has the correct number of significant digits.

What would we expect to happen to quantity demanded : Estimate the own-price elasticity for good X, the cross-price elasticity for goods X and R, and the income elasticity for good X and what would we expect to happen to quantity demanded

User Account

All Pages