Multiple least square regression equation

Reference no: EM1314084

The district manager of Jasons, a large discount electronics chain, is investigating why certain stores in her region are performing better than others. She believes that three factors are related to total sales: the number of competitors in the region, the population in the surrounding area, and the amount spent on advertising. From her district, consisting of several hundred stores, she selects a random sample of 30 stores. For each store she gathered the following information.

Y = total sales last year (in $ thousands).

X₁ = number of competitors in the region.

X₂ = population of the region (in millions).

X₃ = advertising expense (in $ thousands).

The sample data were run on MINITAB, with the following results.

Analysis of variance
SOURCE	DF	SS	MS
Regression	3	3050	1016.67
Error	26	2200	84.62
Total	29	5250.O0

Predictor	Coef	StDev	t-ratio
Constant	14	7	2
X₁	-1	o.fo	-1.43
X₂	30	5.2	5.77
X₃	0.2	0.08	2.5

a) What are the estimated sales for the Byrne store, which has four competitors, a regional population of 0.4 (400,000), and advertising expense of 30 ($30,000)?

b) Compute the R2 value.

c) Compute the multiple standard error of estimate.

d) Conduct a global test of hypothesis to determine whether any of the regression. Coefficients are not equal to zero. Use the .05 level of significance.

e) Conduct tests of hypotheses to determine which of the independent variables have significant regression coefficients. Which variables would you consider eliminating? Use the .05 significance level.

Reference no: EM1314084

Questions Cloud

Determining restaurants violation of health code : Based on these data, explain whether or not course attendance had any effect on determining of a restaurants violation of health code.

Micro and macro perspectives for quality : Describe the dimensions of quality from micro- and macro-perspectives. What are the different formats or models and applications of quality? Discuss the top three in your opinion.

Investment of cash by rickie james : Which of the following reflects the investment of cash by Rickie James in her sole proprietorship and Which of the following reflects payment of a utilities bill from the power company?

Joint probability density function : The joint probability density function.

Multiple least square regression equation : From her district, consisting of several hundred stores, she selects a random sample of 30 stores. For each store she gathered the following information.

Determining source of difference by comparison procedure : Carry out suitable multiple comparison procedure to determine the source of the difference.

Calculating steady state level of population : Compute the steady state levels of population. How might we transition between these two steady states and growth during the Malthusian regime?

What basis of accounting do enterprise : What basis of accounting do enterprise and internal service funds use and Which of the following is not a GASB-required statement for proprietary fun

Linear relation between degree of stenosis-reactive nuclei : Are you doubtful of any of these data points? if so why does there show to be a linear relation between degree of stenosis and nuber of reactive nuclei?

User Account

All Pages