Question: Can anybody help through EXCEL for bellow problem step by step tutorial. The Consumer Confidence Index (CCI) attempts to measure people's feelings about general business

Can anybody help through EXCEL for bellow problem step by step tutorial.

The Consumer Confidence Index (CCI) attempts to measure people's feelings about general business conditions, employment opportunities, and their own income prospects. Monthly average values of the CCI are listed in the file P02_20.xlsx. a. Make a time series graph of the CCI values. b. Have U.S. consumers become more or less confident through time? c. How would you explain recent variations in the overall trend of the CCI?

Month CCI
Jun-1997 129.9
Jul-1997 126.3
Aug-1997 127.6
Sep-1997 130.2
Oct-1997 123.4
Nov-1997 128.1
Dec-1997 136.2
Jan-1998 128.3
Feb-1998 137.4
Mar-1998 133.8
Apr-1998 137.2
May-1998 136.3
Jun-1998 138.2
Jul-1998 137.2
Aug-1998 133.1
Sep-1998 126.4
Oct-1998 119.3
Nov-1998 126.4
Dec-1998 126.7
Jan-1999 128.9
Feb-1999 133.1
Mar-1999 134.0
Apr-1999 135.5
May-1999 137.7
Jun-1999 139.0
Jul-1999 136.2
Aug-1999 136.0
Sep-1999 134.2
Oct-1999 130.5
Nov-1999 137.0
Dec-1999 141.7
Jan-2000 144.7
Feb-2000 140.8
Mar-2000 137.1
Apr-2000 137.7
May-2000 144.7
Jun-2000 139.2
Jul-2000 143.0
Aug-2000 140.8
Sep-2000 142.5
Oct-2000 135.8
Nov-2000 132.6
Dec-2000 128.6
Jan-2001 115.7
Feb-2001 109.2
Mar-2001 116.9
Apr-2001 109.9
May-2001 116.1
Jun-2001 118.9
Jul-2001 116.3
Aug-2001 114.0
Sep-2001 97.0
Oct-2001 85.3
Nov-2001 84.9
Dec-2001 94.6
Jan-2002 97.8
Feb-2002 95.0
Mar-2002 110.7
Apr-2002 108.5
May-2002 110.3
Jun-2002 106.3
Jul-2002 97.4
Aug-2002 94.5
Sep-2002 93.7
Oct-2002 79.6
Nov-2002 84.9
Dec-2002 80.7
Jan-2003 78.8
Feb-2003 64.8
Mar-2003 61.4
Apr-2003 81.0
May-2003 83.6
Jun-2003 83.5
Jul-2003 77.0
Aug-2003 81.7
Sep-2003 77.0
Oct-2003 81.7
Nov-2003 92.5
Dec-2003 94.8
Jan-2004 97.7
Feb-2004 88.5
Mar-2004 88.5
Apr-2004 93.0
May-2004 93.1
Jun-2004 102.8
Jul-2004 105.7
Aug-2004 98.7
Sep-2004 96.7
Oct-2004 92.9
Nov-2004 92.6
Dec-2004 102.7
Jan-2005 105.1
Feb-2005 104.4
Mar-2005 103.0
Apr-2005 97.5
May-2005 103.1
Jun-2005 106.2
Jul-2005 103.6
Aug-2005 105.5
Sep-2005 87.5
Oct-2005 85.2
Nov-2005 98.3
Dec-2005 103.8
Jan-2006 106.8
Feb-2006 102.7
Mar-2006 107.5
Apr-2006 109.8
May-2006 104.7
Jun-2006 105.4
Jul-2006 107.0
Aug-2006 100.2
Sep-2006 105.9
Oct-2006 105.1
Nov-2006 105.3
Dec-2006 110.0
Jan-2007 110.2
Feb-2007 111.2
Mar-2007 108.2
Apr-2007 106.3
May-2007 108.5
Jun-2007 105.3
Jul-2007 111.9
Aug-2007 105.6
Sep-2007 99.5
Oct-2007 95.2
Nov-2007 87.8
Dec-2007 90.6
Jan-2008 87.3
Feb-2008 76.4
Mar-2008 65.9
Apr-2008 62.8
May-2008 58.1
Jun-2008 51.0
Jul-2008 51.9
Aug-2008 58.5
Sep-2008 61.4
Oct-2008 38.8
Nov-2008 44.7
Dec-2008 38.6
Jan-2009 37.4
Feb-2009 25.3
Mar-2009 26.9
Apr-2009 40.8
May-2009 54.8
Jun-2009 49.3
Jul-2009 47.4
Aug-2009 54.5
Sep-2009 53.4
Oct-2009 48.7
Nov-2009 50.6
Dec-2009 52.9

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!