Using the data provided: Plot the data. What does the plot tell you about the appropriateness of using a trend and seasonally adjusted model for your data? Develop forecasts for the four periods beyond your data, based on a model that incorporates both a trend and seasonal adjustment Calculate a MAD and Bias based on the last 12 periods of data. What do the MAD and bias indicate about your model? Overall, are you satisfied with your model? If so, why? If not, suggest some things that could be done to improve your model. Quarterly Revenue for Exxon Mobil Corporation, 1999-2004 (millions of dollars) 2004 2003 2001 2002 Qtr 67,602 63,780 43,531 57,27854,081 26,884 Qtr2 70,693 57,165 50,909 56,184 55,95629.422 Qtr3 76,375 59,841 54,182 52,113 58,568 33,072 Qtr4 83,357 65,952 56,211 47,300 64,132 55,961 Year 298,035246,738204,506 212,900 232,737 185,527 2000 Year Quarter Revenue 26,880 Qtr2 29,422 33,072 Qtr4 55,961 54,081 55,956 58,568 64,132 2001Qtr 57,278 56,184 52,113 47,300 2002Qtr 43,531 50,909 54,182 Qtr4 56,211 63,780 57,165 59,841 65,952 67,602 70,693 76,375 83,350 Qtr1 Qtr3 Qtr1 Qtr3 6 1999 8 2000 Qtr4 Qtr3 Qtr4 2 Qtr3 2003 Qtr1 Qtr3 Qtr4 Qtr1 2004 Qtr3 Qtr4 https://d2vlcm61l7u1fs.cloudfront.net/media%2Fd84%2Fd84ebdfd-8808-43ce-bdf0-95db9489a0a7%2Fphpvz0Uw7.png

https://d2vlcm61l7u1fs.cloudfront.net/media%2F61c%2F61c9f4e1-a7fe-466e-87e4-a7b5873b69b4%2FphpHY77Q3.png
Formula:
Slope of trend line, G25 =SLOPE(E33:E56,D33:D56)
Intercept of trend line, G26 =INTERCEPT(E33:E56,D33:D56)
F33 =$G$26+D33*$G$25 copy to F33:F60
G33 =E33/F33 copy to G33:G56
H33 =AVERAGE(G33,G37,G41,G45,G49,G53) copy to H33:H36
H37 =H33 copy to H33:H60
I33 =H33*F33 copy to I33:I60
J33 =E33-I33 copy to J33:J56
K33 =ABS(J33) copy to K33:K56
 
“Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!”

What Students Are Saying About Us

.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐
"Honestly, I was afraid to send my paper to you, but splendidwritings.com proved they are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"

.......... Customer ID: 14***| Rating: ⭐⭐⭐⭐⭐
"The company has some nice prices and good content. I ordered a term paper here and got a very good one. I'll keep ordering from this website."

"Order a Custom Paper on Similar Assignment! No Plagiarism! Enjoy 20% Discount"