Data Exercise #1 Instructions

Please submit your findings in a WORD document.

Please use the following websites to complete this task: www.bea.gov and www.bls.gov

 www.bea.gov is the primary website for this task.

Acquire the Real GDP figures for each quarter of the last ten years.

Acquire Private Consumption (or personal income data) for the same period.

Enter those figures in EXCEL and complete a Simple Regression.

Report your findings in a written document that includes your results in tabular form.

*You may have to *add* Data Analysis to your Excel program.

*You may use another program to run your regression analysis if you are more comfortable doing so.

FORMAT

Title Page

Content & Analysis

Reference List

Appendix of Data (EXCEL sheets)

Lessons:

Video:  http://www.youtube.com/watch?v=k_OB1tWX9PM

Brief Written Explanation: https://www.moresteam.com/toolbox/regression-analysis.cfm

Regression in EXCEL: http://www.wikihow.com/Run-Regression-Analysis-in-Microsoft-Excel