getanswer

Estimate a long term trend for the LEI and CEI using one of the following trend estimation methodologies:1) Hodrick-Prescott trendOR2) Phase Average Trend (or Hodrick-Prescott trend with Phase Average Trend approximation; Lambda parameter set at 108,000)Calculate the deviations from trend in each index by subtracting the calculated trend from the actual index.Compare by making a graph: Make one graph for the LEI and its trend, and one graph for the CEI and its trend. Describe any differences you see between the graphs. Briefly discuss the factors that cause the differences. (you will make two graphs, each graph will show the actual data for the variable and the estimated trend for the variable)Compare by making a graph Make one graph to compare the the deviations from trend of the LEI and CEI. Describe any differences you see between the graphs. Briefly discuss the factors that cause the differences. (you will make one graphs, the graph will show the deviation from trend for each variable)Indexes published by The Conference Board are online and in this file from last year: TheConferenceBoard_USLEI_Historical_Data-1.xlsx