A regional retailer would like to determine if the variation in average monthly

Question

A regional retailer would like to determine if the variation in average monthly store sales can, in part, be plained by the size of the store measured in square feet. A random sample of 21 stores was selected and the store size and average monthly sales were computed. A partially completed simple regression table is shown below: Note: additional calculations provided Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations Ex- 347,520 40.5139 21 ANOVA Regression Residual Total 1,641.3765 113,416.4457 t Stat Coefficients 171.2069 0.0253 Standard Error 59.8460 Intercept a. State the sample regression model? Use any method to test to determine if square feet is a significant variable. Use a level of significance of 0.05 b.

Explanation / Answer

Part a

The sample regression model is given as below:

Y = 0 + 1X

Where, 0 = y-intercept of regression line and 1 = slope for regression line.

We are given

0 = 171.2069

1 = 0.0253

Y = 171.2069 + 0.0253*X

Monthly store sale = 171.2069 + 0.0253*Store size in sq.ft.

Part b

Here, we have to use the t test for coefficient of store size (sq.ft.). The null and alternative hypothesis for this test is given as below:

H0: 1 = 0

Versus

Ha: 1 0

This is a two tailed test.

We are given a level of significance = = 0.05

n = 21

df = n – 1 = 21 – 1 = 20

Test statistic is given as below:

t = 1 / SE(1)

We are given

1 = 0.0253

SE(1) = 0.0036

t = 0.0253/0.0036 = 7.027778

P-value = 0.00

(By using t-table or excel)

P-value < = 0.05

So, we reject the null hypothesis that the variable square feet is not a statistically significant.

There is a sufficient evidence to conclude that square feet is a statistically significant variable.

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.