Question

In: Statistics and Probability

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:

14

2840.51

a.

Use the above results and write the regression equation that can be used to predict sales.

b.

If the manufacturer has 10 product lines, advertising of $40,000, and the price per unit is $3,000, what is your estimate of their sales?

c.

Compute the coefficient of determination and fully interpret its meaning.

d.

At a = 0.05, test to see if there is a significant relationship between sales and unit price.

e.

At a = 0.05, test to see if there is a significant relationship between sales and the number of product lines.

f.

Is the regression model significant?

g.

Fully interpret the meaning of the regression (coefficient of price) per unit that is, the slope for the price per unit.

.

Note: Please write in computer typing please

Solutions

Expert Solution

The fitted regression model is

a )

Sales_hat = 1.0211 - 0.1524* price + 0.8849 * ADV - 0.1463 * Lines

b )

Here product lines = 10

Advertising = $ 40000 and price per unit = $ 3000

the estimate of sale is

Substitute this values in fitted regression equation,we get

Sales_ hat = 1.0211 - 0.1524 * 3000 + 0.8849 * 40000 - 0.1463 * 10

= 1.0211 - 457.2 + 35396 - 1.463

Sales _ hat = 34938.36

c )

We want to find

Here given that

SSR = 2708.61

SSRes =2840.51

SST = SSR + SSRes

SST = 2708.61 + 2840.51

SST = 5549.12

= 0.49

Meaning 49% variability explain due to the regressor price , advertising and product lines

In short 49% model is good fit.

d)

To test

Ho : vs Ha:

Or

Ho There is no linear relationship between sales and price

Vs

Ha There is linear relationship between sales and price

Test statistic

​​​​

Where  

And

t = - 1.08008

Here

=2.22814

= 2.22814. By using t table

|t| <

That is 1.08008 < 2.22814

Price does not contribute significantly to the model

e)

To test

Ho There is no linear relationship between sales and number of products lines

Vs

Ha There is no linear relationship between sales and number of products lines

Test statistic

Standard error beta3 hat = 1.5340

t= - 0.095371

|t |< talpha/2,10

That is  

0.095371 < 2.22814

Product of lines does contribute significantly to the model

g)

When one unit change in price the average change in sales all other regressor variable kept constant


Related Solutions

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:...
Shown below is a portion of the computer output for a regression analysis relating sales (Y...
Shown below is a portion of the computer output for a regression analysis relating sales (Y in millions of dollars) and advertising expenditure (X in thousands of dollars). Predictor Coefficient Standard Error Constant 4.00 0.800 X -0.12 0.045          Analysis of Variance SOURCE DF SS Regression 1 1,400 Error 18 3,600 Please answer the following questions with showing all the steps needed.      a.  (8’) What has been the sample size for the above? Please explain how you obtain the answer using the...
A regression model was developed relating the 5-year average return (Y in %) of mutual funds...
A regression model was developed relating the 5-year average return (Y in %) of mutual funds with two independent variables: Net Asset Value and Expense Ratio (in %) of the funds. Part of the regression results are shown below. df SS MS Regression 2 1197.092 598.546 Residual 34 1784.290 52.479 Total 36 2981.382 Coefficients Standard Error Intercept 0.280 3.221 Net Asset Value 0.171 0.085 Expense Ratio (%) 11.135 3.659 1.    What is the value of the F test statistic for testing...
The following regression model has been proposed to predict sales at a computer store.                            Y=60-2X1+3
The following regression model has been proposed to predict sales at a computer store.                            Y=60-2X1+30X2+10X3                            Where                            X1= competitor’s previous day’s sales (in $1,000s)                            X2=population within 1 mile (in 1,000s)                            X3= 1 if radio advertising was used; 0 if otherwise What is the estimated regression equation if no radio advertising was used? What is the estimated regression equation if radio advertising was used? What is the expected amount of sales attributable to radio advertising?                            Y=...
Shown below is a portion of a computer output for a regression analysis relating Y (demand)...
Shown below is a portion of a computer output for a regression analysis relating Y (demand) and X (unit price). ANOVA df SS Regression 1 Error 3132.661 Total 47 8181.479 Coefficients Standard Error Intercept 80.390 3.102 X -2.137 0.248 (a) Compute the coefficient of determination and fully interpret its meaning. Be very specific. (b) Find the standard error for b1 (Sb1). (c) Perform a t test and determine whether or not demand and unit price are related. Let  =...
The following Regression function has been developed to check the relationship between Y- ‘Sales’ and the...
The following Regression function has been developed to check the relationship between Y- ‘Sales’ and the following independent variables; X1- Time (Length of time employed in months) X2 –Poten (Market potential) X3 – AdvExp (Advertising expenditure in the sales territory) X4 – Accounts (Number of accounts assigned to sales rep) 3 Consider the following Minitab output and answer the questions. Regression Analysis: Sales versus Time, Poten, AdvExp, Accounts Regression Equation Sales = -391 - 0.58 Time + 0.02227 Poten +...
The following estimated regression equation was developed relating yearly income (y in $1000s) of 30 individuals...
The following estimated regression equation was developed relating yearly income (y in $1000s) of 30 individuals with their age (x1) and their gender (x2) (0 if male and 1 if female). Ŷ = 30 + .7x1 + 3x2 Also provided are SST = 1200 and SSE = 384. The test statistic for testing the significance of the model is
The following estimated regression equation was developed relating yearly income (y in $1000s) of 30 individuals...
The following estimated regression equation was developed relating yearly income (y in $1000s) of 30 individuals with their age (x1) and their gender (x2) (0 if male and 1 if female). Ŷ = 30 + .7x1 + 3x2 Also provided are SST = 1200 and SSE = 384. If we want to test for the significance of the model, the critical value of F at α = .05 is a. 3.33. b. 3.35. c. 3.34. d. 2.96.
(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,...
A hospital administrator developed a regression line, y = 30 + 2x, to predict y =...
A hospital administrator developed a regression line, y = 30 + 2x, to predict y = the number of full-time employees (FTE) needed using x = the number of beds. The slope of this regression line suggests this: __________. for a unit increase in the number of beds, the number of FTEs is predicted to increase by 32 for a unit increase in the number of beds, the number of FTEs is predicted to decrease by 32 for a unit...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT