Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using Excel, perform exponential smoothing to the Standard and Poor's/Toronto Stock Exchange Composite Index time series using an exponential smoothing constant w = 0.8 and

Using Excel, perform exponential smoothing to the Standard and Poor's/Toronto Stock Exchange Composite Index time series using an exponential smoothing constant w = 0.8 and w = 0.2. What do you observe? Comment on the results.

Toronto Stock Exchange Statistics Standard and Poor's/Toronto Stock Exchange Composite Index Standard and Poor's/Toronto Stock Exchange 60 Index
Reference period
Index
Jan-98 6,700.20 381.23
Feb-98 7,092.49 406.82
Mar-98 7,558.50 435.32
Apr-98 7,664.99 440.34
May-98 7,589.78 441.02
Jun-98 7,366.89 427.01
Jul-98 6,931.43 400.51
Aug-98 5,530.71 318.75
Sep-98 5,614.12 321.55
Oct-98 6,208.28 359.99
Nov-98 6,343.87 369.21
Dec-98 6,485.94 375.98
Jan-99 6,729.56 396.87
Feb-99 6,312.69 368.25
Mar-99 6,597.79 384.98
Apr-99 7,014.70 410.85
May-99 6,841.80 400.07
Jun-99 7,010.07 411.04
Jul-99 7,081.03 415.1
Aug-99 6,970.81 407.32
Sep-99 6,957.72 408.54
Oct-99 7,256.22 433.85
Nov-99 7,523.23 447.29
Dec-99 8,413.75 495.86
Jan-00 8,481.11 498.59
Feb-00 9,128.99 519.93
Mar-00 9,462.39 568.89
Apr-00 9,347.61 559.86
May-00 9,251.99 556.35
Jun-00 10,195.45 617.91
Jul-00 10,406.31 638.35
Aug-00 11,247.91 687.08
Sep-00 10,377.92 618.28
Oct-00 9,639.57 569.28
Nov-00 8,819.92 525.33
Dec-00 8,933.68 528.72
Jan/2001 9,321.87 554.84
Feb/2001 8,078.72 472.6
Mar/2001 7,608.00 443.04
Apr/2001 7,946.63 459
May/2001 8,161.87 471.09
Jun/2001 7,736.35 444.84
Jul/2001 7,689.69 445.15
Aug/2001 7,399.22 430.33
Sep/2001 6,838.56 398.2
Oct/2001 6,885.70 397.55
Nov/2001 7,425.65 431.78
Dec/2001 7,688.41 442.55
Jan/2002 7,648.49 438.92
Feb/2002 7,637.50 436.48
Mar/2002 7,851.47 446.74
Apr/2002 7,663.39 434.04
May/2002 7,656.13 429.17
Jun/2002 7,145.61 401.2
Jul/2002 6,605.42 371.06
Aug/2002 6,611.95 371.8
Sep/2002 6,180.42 345.06
Oct/2002 6,248.79 351.36
Nov/2002 6,570.42 372.63
Dec/2002 6,614.54 373.15
Jan/2003 6,569.49 370.48
Feb/2003 6,555.12 371.97
Mar/2003 6,343.29 361.23
Apr/2003 6,586.07 373.94
May/2003 6,859.80 388.11
Jun/2003 6,983.14 394.63
Jul/2003 7,257.92 409.03
Aug/2003 7,510.32 423.28
Sep/2003 7,421.13 416.58
Oct/2003 7,772.70 436.2
Nov/2003 7,859.39 438.25
Dec/2003 8,220.89 458.72
Jan/2004 8,521.39 476.64
Feb/2004 8,788.49 490.59
Mar/2004 8,585.93 475.59
Apr/2004 8,243.97 455.87
May/2004 8,417.32 463.61
Jun/2004 8,545.58 472.78
Jul/2004 8,458.07 469.34
Aug/2004 8,377.03 465.48
Sep/2004 8,668.29 482.19
Oct/2004 8,870.97 496.37
Nov/2004 9,030.05 501.18
Dec/2004 9,246.65 511.91
Jan/2005 9,204.05 506.75
Feb/2005 9,668.32 532.08
Mar/2005 9,612.38 533.87
Apr/2005 9,369.30 522.02
May/2005 9,607.30 536.89
Jun/2005 9,902.77 555.06
Jul/2005 10,422.93 585.02
Aug/2005 10,668.94 600.4
Sep/2005 11,011.83 620.04
Oct/2005 10,383.32 585.55
Nov/2005 10,824.14 611.09
Dec/2005 11,272.26 634.72
Jan/2006 11,945.64 672.69
Feb/2006 11,688.34 659.27
Mar/2006 12,110.61 682.54
Apr/2006 12,204.17 685.33
May/2006 11,744.52 657.38
Jun/2006 11,612.87 653.46
Jul/2006 11,830.96 667.43
Aug/2006 12,073.75 682.21
Sep/2006 11,761.27 673.16
Oct/2006 12,344.59 703.41
Nov/2006 12,752.38 732.35
Dec/2006 12,908.39 742.77
Jan/2007 13,034.12 747.47
Feb/2007 13,045.02 743.77
Mar/2007 13,165.50 752.45
Apr/2007 13,416.68 765.35
May/2007 14,056.78 804.47
Jun/2007 13,906.57 799.7
Jul/2007 13,868.63 799.42
Aug/2007 13,660.48 793.37
Sep/2007 14,098.89 817.39
Oct/2007 14,625.00 848.82
Nov/2007 13,689.12 798.5
Dec/2007 13,833.06 808.53
Jan/2008 13,155.10 772.56
Feb/2008 13,582.69 795.23
Mar/2008 13,350.13 783.44
Apr/2008 13,937.04 825.91
May/2008 14,714.73 878.42
Jun/2008 14,467.03 863.19
Jul/2008 13,592.91 811.73
Aug/2008 13,771.25 821.69
Sep/2008 11,752.90 707.34
Oct/2008 9,762.76 591.28
Nov/2008 9,270.62 563.09
Dec/2008 8,987.70 541.82
Jan/2009 8,694.90 523.28
Feb/2009 8,123.02 489.56
Mar/2009 8,720.39 528.68
Apr/2009 9,324.83 565.38
May/2009 10,370.07 632.47
Jun/2009 10,374.91 630.06
Jul/2009 10,787.15 654.56
Aug/2009 10,868.21 652.78
Sep/2009 11,394.96 680.75
Oct/2009 10,910.75 647.72
Nov/2009 11,447.20 680.26
Dec/2009 11,746.11 693.23
Jan/2010 11,094.31 648.53
Feb/2010 11,629.63 680.76
Mar/2010 12,037.73 706.81
Apr/2010 12,210.70 716.05
May/2010 11,762.99 691.63
Jun/2010 11,294.42 662.05
Jul/2010 11,713.43 685.03
Aug/2010 11,913.86 694.05
Sep/2010 12,368.65 715.07
Oct/2010 12,676.24 728.09
Nov/2010 12,952.88 741.34
Dec/2010 13,443.22 768.65
Jan/2011 13,551.99 778.65
Feb/2011 14,136.50 813.29
Mar/2011 14,116.10 810.86
Apr/2011 13,944.79 797.9
May/2011 13,802.88 789.12
Jun/2011 13,300.87 763.9
Jul/2011 12,945.63 733.3
Aug/2011 12,768.70 728.2
Sep/2011 11,623.84 667.08
Oct/2011 12,252.06 698.04
Nov/2011 12,204.11 695.49
Dec/2011 11,955.09 680.87
Jan/2012 12,452.15 709.18
Feb/2012 12,644.01 718.86
Mar/2012 12,392.18 706.96
Apr/2012 12,292.69 699.79
May/2012 11,513.21 656.5
Jun/2012 11,596.56 663.62
Jul/2012 11,664.71 665.46
Aug/2012 11,949.26 683.47
Sep/2012 12,317.46 702.87
Oct/2012 12,422.91 711.58
Nov/2012 12,239.36 702.59
Dec/2012 12,433.53 713.72
Jan/2013 12,685.24 727.76
Feb/2013 12,821.83 738.55
Mar/2013 12,749.90 731.34
Apr/2013 12,456.50 710.71
May/2013 12,650.42 726.27
Jun/2013 12,129.11 695.52
Jul/2013 12,486.64 714.68
Aug/2013 12,653.90 727.13
Sep/2013 12,787.20 732.89
Oct/2013 13,361.26 767.47
Nov/2013 13,395.40 771.86
Dec/2013 13,621.55 783.75
Jan/2014 13,694.94 785.53
Feb/2014 14,209.59 813.25
Mar/2014 14,335.31 820.51
Apr/2014 14,651.87 837.58
May/2014 14,604.16 836.6
Jun/2014 15,146.01 866.04
Jul/2014 15,330.74 884.33
Aug/2014 15,625.73 898.26
Sep/2014 14,960.51 864.24
Oct/2014 14,613.32 849.5
Nov/2014 14,744.70 863.04
Dec/2014 14,632.44 854.85
Jan/2015 14,673.48 857.34
Feb/2015 15,234.34 890.4
Mar/2015 14,902.44 869.28
Apr/2015 15,224.52 886.56
May/2015 15,014.09 875.04
Jun/2015 14,553.33 847.78
Jul/2015 14,468.44 853.4
Aug/2015 13,859.12 815.45
Sep/2015 13,306.96 784.51
Oct/2015 13,529.17 794.49
Nov/2015 13,469.83 791.8
Dec/2015 13,009.95 764.54
Jan/2016 12,822.13 754.85
Feb/2016 12,860.35 755.27
Mar/2016 13,494.36 790.93
Apr/2016 13,951.45 815.46
May/2016 14,065.78 821.06
Jun/2016 14,064.54 817.65
Jul/2016 14,582.74 847.4
Aug/2016 14,597.95 851.38
Sep/2016 14,725.86 858.47
Oct/2016 14,787.27 868.38
Nov/2016 15,082.85 888.3
Dec/2016 15,287.59 900.05
Jan/2017 15,385.96 909.19
Feb/2017 15,399.24 907.57
Mar/2017 15,547.75 915.58
Apr/2017 15,586.13 918.9
May/2017 15,349.91 906.38
Jun/2017 15,182.19 892.65
Jul/2017 15,143.87 891.19
Aug/2017 15,211.87 892.56
Sep/2017 15,634.94 921.79
Oct/2017 16,025.59 947.17
Nov/2017 16,067.48 952.04
Dec/2017 16,209.13 959.69
Jan/2018 15,951.67 944.41
Feb/2018 15,442.68 913.9
Mar/2018 15,367.29 908.99
Apr/2018 15,607.88 921.43
May/2018 16,061.50 950.45
Jun/2018 16,277.73 965.32
Jul/2018 16,434.01 979.38
Aug/2018 16,262.88 965.73
Sep/2018 16,073.14 952.28
Oct/2018 15,027.28 895.08
Nov/2018 15,197.82 913.29
Dec/2018 14,322.86 859.32
Jan/2019 15,540.60 929.25
Feb/2019 15,999.01 953.91
Mar/2019 16,102.09 959.5
Apr/2019 16,580.73 994.53
May/2019 16,037.49 961.89
Jun/2019 16,382.20 979.6
Jul/2019 16,406.56 979.73
Aug/2019 16,442.07 982.45
Sep/2019 16,658.63 997.93
Oct/2019 16,483.16 986.33
Nov/2019 17,040.20 1,018.62
Dec/2019 17,063.43 1,014.92
Jan/2020 17,318.49 1,032.97
Feb/2020 16,263.05 972.15
Mar/2020 13,378.75 819.89
Apr/2020 14,780.74 891.63
May/2020 15,192.83 917.17
Jun/2020 15,515.22 934.21
Jul/2020 16,169.20 968.67
Aug/2020 16,514.44 990.52
Sep/2020 16,121.38 967.27
Oct/2020 15,580.64 928.9
Nov/2020 17,190.25 1,023.52
Dec/2020 17,433.36 1,034.76
Jan/2021 17,337.02 1,026.60
Feb/2021 18,060.26 1,073.42
Mar/2021 18,700.67 1,117.15
Apr/2021 19,108.33 1,138.85
May/2021 19,730.99 1,180.14
Jun/2021 20,165.58 1,209.15
Jul/2021 20,287.80 1,216.15
Aug/2021 20,582.94 1,231.33
Sep/2021 20,070.25 1,203.34
Oct/2021 21,037.07 1,265.19
Nov/2021 20,659.99 1,248.56
Dec/2021 21,222.84 1,286.86
Jan/2022 21,098.29 1,281.96
Feb/2022 21,126.36 1,278.42
Mar/2022 21,890.16 1,322.67
Apr/2022 20,762.00 1,255.54
May/2022 20,729.34 1,254.79
Jun/2022 18,861.36 1,146.43
Jul/2022 19,692.92 1,187.97

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

A Survey Of Mathematics With Applications

Authors: Allen R. Angel, Christine D. Abbott, Dennis Runde

11th Edition

0135740460, 978-0135740460

More Books

Students also viewed these Mathematics questions

Question

=+2 Identify the treatment and response.

Answered: 1 week ago

Question

Using Gauss-Jordan elimination, invert this matrix ONLY 0 0 0 0 1

Answered: 1 week ago