Purchase Solution

Regression Analysis and Time Series Forecasting

Not what you're looking for?

Ask Custom Question

I am a little confused about this. I have used the regression analysis in excel, but not sure if I did it right and if the scatter plot is correct. My biggest problem is that I need help with writing out the process. I have attached the excel file with the work that I have tried to complete.

The following data on the number of iron workers in the United States for the years 1978 through 2008 are provided by the U.S. Bureau of Labor Statistics. Using regression techniques discussed in this section, analyze the data for trend. Develop a scatter plot of the data and fit the trend line through the data. Discuss the strength of the model.

Year Union Members
(1000'S)
1978 17,340
1979 16,996
1980 16,975
1981 16,913
1982 17,002
1983 16,960
1984 16,740
1985 16,568
1986 16,390
1987 16,598
1988 16,748
1989 16,360
1990 16,269
1991 16,110
1992 16,211
1993 16,477
1994 16,334
1995 16,305
1996 16,145
1997 15,776
1998 15,472
1999 16,685
2000 15,359
2001 16,670
2002 16,098
2003 16,212
2004 16,316
2005 16,718
2006 16,707
2007 16,113
2008 15,128

Remember to show all work.

Purchase this Solution

Solution Summary

The solution provides step by step method for the calculation of regression analysis. Formula for the calculation and Interpretations of the results are also included.

Purchase this Solution


Free BrainMass Quizzes
Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.