The data given below show percentages of work completed for a construction project:

Graph the data in Excel and comment on the shapes of the distributions.
• Forecast the cumulative percentages of work completed for each of the next six months using linear regression and compute R2, r, and Syt.

• Is linear regression an appropriate forecasting method for this data? If not, can you suggest an alternative forecasting method with adequate rationale?
• Use your chosen method (other than linear regression) to forecast the percentages of work completed for months 16, 17, 18 and 19.
• Is this a better forecasting method for this data than linear regression?
Justify your answer.

Transcribed Image Text:

Month Cumulative percentage of work completed 12345678 5.8 2 3 7.9 9.9 12.8 5 17.2 22.5 29.7 36.4 9 43.9 10 51.9 11 62.2 12 69.1