The Consumer Confidence Index (CCI) attempts to measure peoples feelings about general business conditions, employment opportunities, and

Question:

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 S02_20.xlsx.
a. Create 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?