Get Instant Help From 5000+ Experts For
question

Writing: Get your essay and assignment written from scratch by PhD expert

Rewriting: Paraphrase or rewrite your friend's essay with similar meaning at reduced cost

Editing:Proofread your work by experts and improve grade at Lowest cost

And Improve Your Grades
myassignmenthelp.com
loader
Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

Attach file

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!
Free Quote
wave
Sales Forecast of BMW: Multiple Regression Analysis
Answered

Data Summary

This report has been prepared to evaluate the sales forecast of BMW. BMW is one of the biggest car manufacturing firms. The organization has been established in 1917. Following is the current financial data of the company:

Financial Data

Total assets

178.35

Total equity

15.07

Operating Income

8.68

Net Income

20.21

Revenues

136.26

Study of multiple regression models has been done over the sales trend of the company to evaluate the future changes.

Data summary:

Data of the company has been collected on annual basis of 5 years.

Here,

X1 = Average price of cars

X2 = Average advertising expenses

X3 = Annual GDP of company

X4 = average household income

X5 = Major competitor’s GM’s vehicles (Parvizi et al, 2015)

Following is the multiple regression analysis summary of the company:

Sales

Price

Advertising

GDP

Income

GM price

2017

      1,90,191

      1,62,108

      97,50,00,000

    1,43,73,80,00,00,000

      50,816

    1,67,416

2018

      2,05,895

      1,90,773

   1,00,00,00,000

    1,50,08,70,00,00,000

      50,816

    1,70,731

2019

      2,19,717

      1,58,495

      87,50,00,000

    1,58,12,50,00,00,000

      50,054

    1,82,845

2020

      1,70,978

      1,58,387

   2,98,70,00,000

    1,56,72,60,00,00,000

      50,054

    1,63,422

2021

      2,52,527

      1,54,936

   3,28,50,00,000

    1,58,12,50,00,00,000

      45,018

    1,59,958

2022

      2,89,475

      1,74,139

   4,52,30,00,000

    1,58,12,50,00,00,000

      45,018

    1,78,725

Y = 857503 – 0752X1 + 0.0000064X2 + 0.00000000083X3 – 18.44X4 + 1.861X5 (Fox, 2015)

Where,

Y = the quantity of cars which has been demanded annually

The constant value of Cars intercept = 857503

X1 = Average price of cars

X2 = Average advertising expenses

X3 = Annual GDP of company

X4 = average household income

X5 = Major competitor’s GM’s vehicles (Darlington and Hayes, 2016)


Coefficient of X variables directly makes an impact over the demand of the cars which are as follows:

Intercept

857503.0951

X Variable 1

0.523113473

X Variable 2

 -0.0000064855

X Variable 3

 -0.0000000083

X Variable 4

-18.44763935

X Variable 5

1.861337935

Regression Statistics

Multiple R

1

R Square

1

Adjusted R Square

65535

Standard Error

0

Observations

6

ANOVA

df

SS

MS

F

Significance F

Regression

5

9362688585

1872537717

#NUM!

#NUM!

Residual

0

0

65535

Total

5

9362688585

Coefficients

Standard Error

t Stat

P-value

Lower 95%

Upper 95%

Lower 95.0%

Upper 95.0%

Intercept

857503.0951

0

65535

857503.1

857503.1

857503.1

857503.1

X Variable 1

0.523113473

0

65535

0.523113

0.523113

0.523113

0.523113

X Variable 2

        -0.0000064855

0

65535

-6.5E-06

-6.5E-06

-6.5E-06

-6.5E-06

X Variable 3

        -0.0000000083

0

65535

-8.3E-09

-8.3E-09

-8.3E-09

-8.3E-09

X Variable 4

-18.44763935

0

65535

-18.4476

-18.4476

-18.4476

-18.4476

X Variable 5

1.861337935

0

65535

1.861338

1.861338

1.861338

1.861338

(López, Fabrizio and Plencovich, 2014)

Sensitivity analysis:

The regression analysis of the company explains that the sensitivity analysis of each independent intercept is different. It expresses that few changes into the price, advertising expenses; GM, GDP, income etc would impact over the sales of the company. The coefficient of the company explains that the changes into the entire variables would enhance the sales of the company positively except the variable advertising and GDP. Following is the residual value of the company:

Residual Output

Observation

Predicted Y

Residuals

1

190191

8.73115E-11

2

205895

2.91038E-11

3

219717

-8.73115E-11

4

170978

2.91038E-11

5

252527

-2.91038E-11

6

289475

5.82077E-11

It explains that few changes into the X variables impact over the X variable of the company (Chatterjee and Hadi, 2015).

Interpretation:

Further, the interpretation has been done over the all X variables and Y variables of the company and firstly, the following changes into the all 5 variables of the company have been evaluated:

In addition, through the calcualtion os regression analysis of the company, it has been found that the few changes into 0.52 changes into the price of the product would directly make an impcat over the 857503 units of the company. Further, the same analysis has been over other intercept of the company and various macro economical aspcet and it has been found that the -0.000000064855 changes into the advertsing expenses of the product would directly make an impcat over the 857503 units of the company. On the other hand, -0.00000000083 changes into the GDP of the product would directly make an impcat over the 857503 units of the company (Draper and Smith, 2014). At the same time, -18.44 and 1.86 changes into the Income and Gm respectively of the product would directly make an impcat over the 857503 units of the company.

Further, it expresses that the Standrd error of the product is 0. R square is 1. It explains that the company would enjoy a great number of saes of car in near future and at the same time, the performance of the company would also be better.

Conclusion:

To conclude, multiple regression method makes it easy for the company and the analyst to analyze that what are the factors which have impact over the sales of the company and how much would they impact over the performance of the company and the sales revenues of the company.

References:

Chatterjee, S. and Hadi, A.S., 2015. Regression analysis by example. John Wiley & Sons.

Darlington, R.B. and Hayes, A.F., 2016. Regression analysis and linear models: Concepts, applications, and implementation. Guilford Publications.

Draper, N.R. and Smith, H., 2014. Applied regression analysis. John Wiley & Sons.

Fox, J., 2015. Applied regression analysis and generalized linear models. Sage Publications.

López, M.V., Fabrizio, M.C. and Plencovich, M.C., 2014. Multiple Regression Analysis. Probability and Statistics: A Didactic Introduction, 416.

Parvizi, D., Friedl, H., Wurzer, P., Kamolz, L.P., Lebo, P., Tuca, A., Rappl, T., Wiedner, M., Kuess, K., Grohmann, M. and Koch, H., 2015. A multiple regression analysis of postoperative complications after body-contouring surgery: a retrospective analysis of 205 patients. Obesity surgery, 25(8), pp.1482-1490. 

support
close