Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

As a manager, you are tasked with building a forecast of Microsoft stock price. MS Excel users: 1. Import historical Microsoft's stock price data into

As a manager, you are tasked with building a forecast of Microsoft stock price. MS Excel users: 1. Import historical Microsoft's stock price data into Excel and declare the dataset as time series 2. Build one moving average and one exponential smoothing forecast (choose any coefficients) 3. Calculate all three accuracy measures (MAE, MSE, and MAPE) to compare your models and suggest the best one 4. Build and appropriate chart that displays the actual data and both of your forecasts.

Date Close
1/1/1990 0.642361
2/1/1990 0.685764
3/1/1990 0.769097
4/1/1990 0.805556
5/1/1990 1.013889
6/1/1990 1.055556
7/1/1990 0.923611
8/1/1990 0.854167
9/1/1990 0.875
10/1/1990 0.885417
11/1/1990 1.003472
12/1/1990 1.045139
1/1/1991 1.362847
2/1/1991 1.440972
3/1/1991 1.473958
4/1/1991 1.375
5/1/1991 1.524306
6/1/1991 1.419271
7/1/1991 1.53125
8/1/1991 1.776042
9/1/1991 1.854167
10/1/1991 1.955729
11/1/1991 2.026042
12/1/1991 2.317708
1/1/1992 2.505208
2/1/1992 2.572917
3/1/1992 2.46875
4/1/1992 2.296875
5/1/1992 2.520833
6/1/1992 2.1875
7/1/1992 2.273438
8/1/1992 2.328125
9/1/1992 2.515625
10/1/1992 2.773438
11/1/1992 2.910156
12/1/1992 2.667969
1/1/1993 2.703125
2/1/1993 2.605469
3/1/1993 2.890625
4/1/1993 2.671875
5/1/1993 2.894531
6/1/1993 2.75
7/1/1993 2.3125
8/1/1993 2.347656
9/1/1993 2.578125
10/1/1993 2.503906
11/1/1993 2.5
12/1/1993 2.519531
1/1/1994 2.660156
2/1/1994 2.578125
3/1/1994 2.648438
4/1/1994 2.890625
5/1/1994 3.359375
6/1/1994 3.226563
7/1/1994 3.21875
8/1/1994 3.632813
9/1/1994 3.507813
10/1/1994 3.9375
11/1/1994 3.929688
12/1/1994 3.820313
1/1/1995 3.710938
2/1/1995 3.9375
3/1/1995 4.445313
4/1/1995 5.109375
5/1/1995 5.292969
6/1/1995 5.648438
7/1/1995 5.65625
8/1/1995 5.78125
9/1/1995 5.65625
10/1/1995 6.25
11/1/1995 5.445313
12/1/1995 5.484375
1/1/1996 5.78125
2/1/1996 6.167969
3/1/1996 6.445313
4/1/1996 7.078125
5/1/1996 7.421875
6/1/1996 7.507813
7/1/1996 7.367188
8/1/1996 7.65625
9/1/1996 8.242188
10/1/1996 8.578125
11/1/1996 9.804688
12/1/1996 10.328125
1/1/1997 12.75
2/1/1997 12.1875
3/1/1997 11.460938
4/1/1997 15.1875
5/1/1997 15.5
6/1/1997 15.796875
7/1/1997 17.671875
8/1/1997 16.523438
9/1/1997 16.539063
10/1/1997 16.25
11/1/1997 17.6875
12/1/1997 16.15625
1/1/1998 18.648438
2/1/1998 21.1875
3/1/1998 22.375
4/1/1998 22.53125
5/1/1998 21.203125
6/1/1998 27.09375
7/1/1998 27.484375
8/1/1998 23.984375
9/1/1998 27.515625
10/1/1998 26.46875
11/1/1998 30.5
12/1/1998 34.671875
1/1/1999 43.75
2/1/1999 37.53125
3/1/1999 44.8125
4/1/1999 40.65625
5/1/1999 40.34375
6/1/1999 45.09375
7/1/1999 42.90625
8/1/1999 46.28125
9/1/1999 45.28125
10/1/1999 46.28125
11/1/1999 45.523438
12/1/1999 58.375
1/1/2000 48.9375
2/1/2000 44.6875
3/1/2000 53.125
4/1/2000 34.875
5/1/2000 31.28125
6/1/2000 40
7/1/2000 34.90625
8/1/2000 34.90625
9/1/2000 30.15625
10/1/2000 34.4375
11/1/2000 28.6875
12/1/2000 21.6875
1/1/2001 30.53125
2/1/2001 29.5
3/1/2001 27.34375
4/1/2001 33.875
5/1/2001 34.59
6/1/2001 36.5
7/1/2001 33.095001
8/1/2001 28.525
9/1/2001 25.584999
10/1/2001 29.075001
11/1/2001 32.105
12/1/2001 33.125
1/1/2002 31.855
2/1/2002 29.17
3/1/2002 30.155001
4/1/2002 26.129999
5/1/2002 25.455
6/1/2002 27.35
7/1/2002 23.99
8/1/2002 24.540001
9/1/2002 21.870001
10/1/2002 26.735001
11/1/2002 28.84
12/1/2002 25.85
1/1/2003 23.73
2/1/2003 23.700001
3/1/2003 24.209999
4/1/2003 25.57
5/1/2003 24.610001
6/1/2003 25.639999
7/1/2003 26.41
8/1/2003 26.52
9/1/2003 27.799999
10/1/2003 26.139999
11/1/2003 25.709999
12/1/2003 27.370001
1/1/2004 27.65
2/1/2004 26.530001
3/1/2004 24.93
4/1/2004 26.129999
5/1/2004 26.23
6/1/2004 28.559999
7/1/2004 28.49
8/1/2004 27.299999
9/1/2004 27.65
10/1/2004 27.969999
11/1/2004 26.809999
12/1/2004 26.719999
1/1/2005 26.280001
2/1/2005 25.16
3/1/2005 24.17
4/1/2005 25.299999
5/1/2005 25.799999
6/1/2005 24.84
7/1/2005 25.610001
8/1/2005 27.379999
9/1/2005 25.73
10/1/2005 25.700001
11/1/2005 27.68
12/1/2005 26.15
1/1/2006 28.15
2/1/2006 26.870001
3/1/2006 27.209999
4/1/2006 24.15
5/1/2006 22.65
6/1/2006 23.299999
7/1/2006 24.059999
8/1/2006 25.700001
9/1/2006 27.35
10/1/2006 28.709999
11/1/2006 29.360001
12/1/2006 29.860001
1/1/2007 30.860001
2/1/2007 28.17
3/1/2007 27.870001
4/1/2007 29.940001
5/1/2007 30.690001
6/1/2007 29.469999
7/1/2007 28.99
8/1/2007 28.73
9/1/2007 29.459999
10/1/2007 36.810001
11/1/2007 33.599998
12/1/2007 35.599998
1/1/2008 32.599998
2/1/2008 27.200001
3/1/2008 28.379999
4/1/2008 28.52
5/1/2008 28.32
6/1/2008 27.51
7/1/2008 25.719999
8/1/2008 27.290001
9/1/2008 26.690001
10/1/2008 22.33
11/1/2008 20.219999
12/1/2008 19.440001
1/1/2009 17.1
2/1/2009 16.15
3/1/2009 18.370001
4/1/2009 20.26
5/1/2009 20.889999
6/1/2009 23.77
7/1/2009 23.52
8/1/2009 24.65
9/1/2009 25.719999
10/1/2009 27.73
11/1/2009 29.41
12/1/2009 30.48
1/1/2010 28.18
2/1/2010 28.67
3/1/2010 29.290001
4/1/2010 30.540001
5/1/2010 25.799999
6/1/2010 23.01
7/1/2010 25.809999
8/1/2010 23.469999
9/1/2010 24.49
10/1/2010 26.67
11/1/2010 25.26
12/1/2010 27.91
1/1/2011 27.73
2/1/2011 26.58
3/1/2011 25.389999
4/1/2011 25.92
5/1/2011 25.01
6/1/2011 26
7/1/2011 27.4
8/1/2011 26.6
9/1/2011 24.889999
10/1/2011 26.629999
11/1/2011 25.58
12/1/2011 25.959999
1/1/2012 29.530001
2/1/2012 31.74
3/1/2012 32.259998
4/1/2012 32.02
5/1/2012 29.190001
6/1/2012 30.59
7/1/2012 29.469999
8/1/2012 30.82
9/1/2012 29.76
10/1/2012 28.540001
11/1/2012 26.620001
12/1/2012 26.709999
1/1/2013 27.450001
2/1/2013 27.799999
3/1/2013 28.610001
4/1/2013 33.099998
5/1/2013 34.900002
6/1/2013 34.540001
7/1/2013 31.84
8/1/2013 33.400002
9/1/2013 33.279999
10/1/2013 35.41
11/1/2013 38.130001
12/1/2013 37.41
1/1/2014 37.84
2/1/2014 38.310001
3/1/2014 40.990002
4/1/2014 40.400002
5/1/2014 40.939999
6/1/2014 41.700001
7/1/2014 43.16
8/1/2014 45.43
9/1/2014 46.360001
10/1/2014 46.950001
11/1/2014 47.810001
12/1/2014 46.450001
1/1/2015 40.400002
2/1/2015 43.849998
3/1/2015 40.66
4/1/2015 48.639999
5/1/2015 46.860001
6/1/2015 44.150002
7/1/2015 46.700001
8/1/2015 43.52
9/1/2015 44.259998
10/1/2015 52.639999
11/1/2015 54.349998
12/1/2015 55.48
1/1/2016 55.09
2/1/2016 50.880001
3/1/2016 55.23
4/1/2016 49.869999
5/1/2016 53
6/1/2016 51.169998
7/1/2016 56.68
8/1/2016 57.459999
9/1/2016 57.599998
10/1/2016 59.919998
11/1/2016 60.259998
12/1/2016 62.139999
1/1/2017 64.650002
2/1/2017 63.98
3/1/2017 65.860001
4/1/2017 68.459999
5/1/2017 69.839996
6/1/2017 68.93
7/1/2017 72.699997
8/1/2017 74.769997
9/1/2017 74.489998
10/1/2017 83.18
11/1/2017 84.169998
12/1/2017 85.540001
1/1/2018 95.010002
2/1/2018 93.769997
3/1/2018 91.269997
4/1/2018 93.519997
5/1/2018 98.839996
6/1/2018 98.610001
7/1/2018 106.080002
8/1/2018 112.330002
9/1/2018 114.370003
10/1/2018 106.809998
11/1/2018 110.889999
12/1/2018 101.57
1/1/2019 104.43
2/1/2019 112.029999
3/1/2019 117.940002
4/1/2019 130.600006
5/1/2019 123.68
6/1/2019 133.960007
7/1/2019 136.270004
8/1/2019 137.860001
9/1/2019 139.029999
10/1/2019 143.369995
11/1/2019 151.380005
12/1/2019 157.699997
1/1/2020 170.229996
2/1/2020 162.009995
3/1/2020 157.710007
4/1/2020 179.210007
5/1/2020 183.25
6/1/2020 203.509995
7/1/2020 205.009995
8/1/2020 225.529999
9/1/2020 210.330002
10/1/2020 202.470001
11/1/2020 214.070007
12/1/2020 222.419998

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

Step: 3

blur-text-image

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

Advanced Engineering Mathematics

Authors: Erwin Kreyszig

3rd Edition

471507288, 978-0471507284

More Books

Students also viewed these Mathematics questions

Question

Why is it difficult to use project management software well? LO.1

Answered: 1 week ago