Question

In: Statistics and Probability

A regression model between sales (y in $1000), unit price (x1 in dollars), and television advertisement...

A regression model between sales (y in $1000), unit price (x1 in dollars), and television advertisement (x2 in dollars) resulted in the following function: ​ = 7 - 3x1 + 5x2​ ​ For this model, SSR = 3500, SSE = 1500, and the sample size is 18. At the 5% level,

options: there is no evidence that the model is significant. the conclusion is that the slope of x1 is significant. it can be concluded that the model is significant. there is evidence that the slope of x2 is significant.

Solutions

Expert Solution

Solution:

Given: A regression model between sales (y in $1000), unit price (x1 in dollars), and television advertisement (x2 in dollars) resulted in the following function: ​ = 7 - 3x1 + 5x2​ ​

SSR = 3500

SSE = 1500

n = 18

Level of significance= 0.05

Step 1) State H0 and H H1:

H0: the regression model is not significant.

Vs

H1: the regression model is significant.

Step 2) Test statistic:

F = MSR / MSE

where

MSR = SSR / dfregression

where

dfregression=k = Number of independent variables.

dfregression=2

thus

MSR = SSR / dfregression

MSR = 3500 / 2

MSR = 1750

and

MSE = SSE / dferror

where

dferror= n - k - 1

dferror= 18 - 2 - 1

dferror= 15

thus

MSE = SSE / dferror

MSE = 1500 / 15

MSE = 100

thus test statistic is:

F = MSR / MSE

F = 1750 / 100

F = 17.5

Step 3) Find F critical value:

df_numerator = dfregression=2

df_denominator = dferror= 15

Level of significance= 0.05

F critical value = 3.68

Step 4) Decision Rule:

Reject null hypothesis H0, if F test statistic value  > F  critical value =3.68 , otherwise we fail to reject H0.

Since F test statistic value = F = 17.5 > F  critical value =3.68 , we reject null hypothesis H0 in favor of H1.

Step 5) Conclusion:

At 0.05 level of significance, we have sufficient evidence to conclude that:  the regression model is significant.

Thus correct answer is:
it can be concluded that the model is significant


Related Solutions

The following table contains results from the regression of sales price (y) on lot size (x1),...
The following table contains results from the regression of sales price (y) on lot size (x1), number of bedrooms (x2), number of bathrooms(x3) and number of storeys (x4). Sales price is the dependent variable and x1,x2,x3,x4 are independent variables. R2 = 0.54 F= stat = 48.3235 p value and F - stat of 1.18E - 88 n > 30. a. Write down the least square prediction equation b.use R2 to check the validity of the model. c use " t-stat"...
A regression model of the form y = beta0 + beta1 x1 + beta2 x2 +...
A regression model of the form y = beta0 + beta1 x1 + beta2 x2 + beta3 x3 + E was built using 20 observations. Partially completed regression output tables are provided below. What are the values of A, B, and C? Table 1 Statistic Value R-Square A Adjusted R-Square B Standard Error (RMSE) C n 20 Table 2 Source DF SS MS F P-Value Regression D 175 H J K Error E G I Total F 250 A regression...
Using Excel generate a simple regression model with Y as the dependent variable and X1 and...
Using Excel generate a simple regression model with Y as the dependent variable and X1 and X2 as the independent variables in the attached spreadsheet. Write the following from the output: Intercept: Coefficients of Independent variable: R-square: Significance F: Based on the model generated, forecast profits for a firm with X1= Based on the model generated, forecast profits for a firm with x1=250 and X2=100. Evaluate the predictability of the model using explanatory language that someone who does not have...
Fit a multiple linear regression model of the form y=β0 + β1 x1 + β2 x2...
Fit a multiple linear regression model of the form y=β0 + β1 x1 + β2 x2 + β3 x3 + ε. Here, ε is the random error term that is assumed to be normally distributed with 0 mean and constant variance. State the estimated regression function. How are the estimates of the three regression coefficients interpreted here? Provide your output, and interpretations in a worksheet titled “Regression Output.” Obtain the residuals and prepare a box-plot of the residuals. What information...
(a) Fit a simple linear regression model relating gasoline mileage (y) to engine displacement (x1) and carburetor (x2).
Here is the data Stat7_prob4.R : y=c(18.90, 17, 20, 18.25, 20.07, 11.2, 22.12, 21.47, 34.70, 30.40, 16.50, 36.50, 21.50, 19.70, 20.30, 17.80, 14.39, 14.89, 17.80, 16.41, 23.54, 21.47, 16.59, 31.90, 29.40, 13.27, 23.90, 19.73, 13.90, 13.27, 13.77, 16.50) x1=c(350, 350, 250, 351, 225, 440, 231, 262, 89.7, 96.9, 350, 85.3, 171, 258, 140, 302, 500, 440, 350, 318, 231, 360, 400, 96.9, 140, 460, 133.6, 318, 351, 351, 360, 350) x2=c(4, 4, 1, 2, 1, 4, 2, 2, 2, 2,...
1. Anqi pays 45 dollars per unit of x and 30 dollars per unit of y....
1. Anqi pays 45 dollars per unit of x and 30 dollars per unit of y. Her preferences are u(x, y) = x1/2y1/2. Anqi's income is 1800 dollars. How many units of good x should she purchase? 2 .A consumer has preferences u(x, y) = x1/2 + y1/2. She usually consumes 4 units of x and 4 units of y but the store has sold out of good y. How many units of good x must she consume to keep...
nqi pays 45 dollars per unit of x and 30 dollars per unit of y. Her...
nqi pays 45 dollars per unit of x and 30 dollars per unit of y. Her preferences are u(x, y) = x1/2y1/2. Anqi's income is 1800 dollars. If she joins a price club she can purchase good x for only 20 dollars per unit. What is the maximum fee that Anqi should pay for a membership at this price club?
A multiple regression analysis between yearly income (y in thousands of dollars), college grade point average...
A multiple regression analysis between yearly income (y in thousands of dollars), college grade point average (X1), age of the individuals (X2 in years), and the gender of the individual (X3: 0 representing female and 1 representing male) was performed on a sample of 10 people, and the following results were obtained. Coefficients Standard of Error Intercept 4.0928 1.4400 x1 10.0230 1.6512 x2 0.1020 0.1225 x3 -4.4811 1.4400 ANOVA Source of Variation DF Sum of Squares Mean Square F Regression...
The following is part of regression output produced by Excel ( for Y vs X1 and...
The following is part of regression output produced by Excel ( for Y vs X1 and X2): Y 12.9 6.1 1.1 39.7 3.4 5.9 8.9 15 7.3 X1 0.9 0.8 1.0 0.3 0.4 0.7 0.71 0.5 0.9 X2 4.2 3.1 1.2 15.7 2.5 0.7 5.0 6.4 3.0 A) write out the estimated regression equation showing that depends on X1 and X2. b)if. X1=0.58 and X2=7.0, what is the value predicted for y c)write the number which is the standard error...
A computer manufacturer has developed a regression model relating his sales (Y in $10,000s) with three...
A computer manufacturer has developed a regression model relating his sales (Y in $10,000s) with three independent variables. The three independent variables are price per unit (Price in $100s), advertising (ADV in $1,000s) and the number of product lines (Lines). Part of the regression results is shown below. Coefficient Standard Error Intercept 1.0211 22.8752 Price -0.1524 0.1411 ADV 0.8849 0.2886 Lines -0.1463 1.5340 Analysis of Variance Source of Variation Degrees of Freedom Sum of Squares Regression 2708.61 Error (Residuals) Required:...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT