Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I am working on Microsoft revenue data. The first Graph is the Microsoft TS plot. I had to create the Time Series Plot using date

I am working on Microsoft revenue data. The first Graph is the Microsoft TS plot. I had to create the Time Series Plot using date and revenue for Microsoft the date starts from 1990 to 2018 ( Old date first). The first graph is Time Series Plot (TS Plot) " The second one is the Descriptive stats for Microsoft revenue data and the third and fourth pictures are the Autocorrelation function for Microsoft revenue data.

A- For the ACF (third and fourth picture) discuss T, C, and S components. Are your conclusions consistent with the Time Series Plot?

B- think about at least 3 different macroeconomic variables that you think will impact the revenue of your company (My company is Microsoft) Explain how the variables relate to your company revenue. What kind of relation do you expect? For example, if your company is Target, and you may want to pick income which should be directly (positively) related to target revenue because higher consumer income will increase consumption on goods and services, increasing Target revenue.

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

Time Series Plot of Revenue 35000 30000 25000 20000 Revenue 15000 10000 wany telny Japonia 5000 0 1 12 24 36 48 60 72 84 96 108 Index Statistics SE Variable NN* Mean Mean StDev Minimum Q1 Median Q3 Maximum Revenue 116 011091 796 8573 311 3150 9456 17898 32479 Autocorrelations Lag ACF T LBQ 1 0.942535 10.15 105.74 2 0.919508 5.94 207.26 3 0.878655 4.48 300.78 4 0.868196 3.81 392.90 5 0.816736 3.21 475.16 6 0.799464 2.89 554.69 7 0.770126 2.61 629.17 8 0.767863 2.46 703.90 9 0.727765 2.22 771.65 10 0.719862 2.11 838.57 11 0.698538 1.97 902.18 12 0.698725 1.91 966.43 | Autocorrelation Function for Revenue (with 5% significance limits for the autocorrelations) 1.0 0.8 0.6 0.4 0.2 Autocorrelation 0.0 -0.2 -0.4 -0.6 -0.8 -1.0 1 2 3 4 5 6 7 8 9 10 11 12 Lag

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Development Of The American Public Accounting Profession

Authors: T.A. Lee

1st Edition

0415403944, 9780415403948

More Books

Students also viewed these Accounting questions