Question
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.
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 LagStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started