Trend Line – Average Annual Hours of Work, Married Couple with Children
October 5th, 2022
See the attached file.
Prepare answers to Exercise 14.4 (page 621) of the Doane and Seward e-text as modified below.e-text as modified below.
Modifications: In Exercise 14.4 do items (a) for years 1990 through 1995, (b), then change item (c.) to fit only a linear trend, and do the following changes: (d) plot the trendline with the equation added using the options button, (e) predict 1998 and 1999 using the trendline equation and compare to the actual hours for 1998 & 1999, and (f) discuss the comparison of predicted value to actual value.
Use Excel to show all work.