# create a regression equation to make a forecast

My hypothesis for a paper I am writing is: There will be more people working past the age of 65 in 2012 than there were in 1997.

I have done some more research and need help plotting this out on a Linear Regression.

I believe this can be done by plotting out every 3 years average number of people working past 65 since 1997 until now and then making a predictability study as to number of people who will be working over the age of 65 in 2012.

I hope this helps with what I am trying to accomplish if anyone can assist.

© BrainMass Inc. brainmass.com June 3, 2020, 10:03 pm ad1c9bdddfhttps://brainmass.com/statistics/regression-analysis/create-a-regression-equation-to-make-a-forecast-212804

#### Solution Preview

I found some data that might help you. I went to http://www.bls.gov/spotlight/2008/older_workers/ which has an article/data/graphs that will be relevant to your hypothesis. Then I clicked on a link in that article which brought me to http://data.bls.gov/PDQ/servlet/SurveyOutputServlet?series_id=LNU02000097. This page has the number of U.S. workers over age 65 from 1998 to 2008 (monthly and annually).

I think it would be more accurate to use data from ...