Because of high tuition costs at state and private universities, enrollments at community colleges have increased dramatically in recent years. The following data show the enrolment (in thousands) for Jefferson Community College from 2001-2009: 11eb9aeb_0223_455b_9490_298f38f347a7_SM2005_00 a. Construct a time series plot. What type of pattern exists in the data? b. Use Excel Solver or LINGO to find the parameters for the line that minimizes MSE this time series. c. What is the forecasts for 2010?

An Introduction to Management Science 13th Edition by David Anderson,Dennis Sweeney ,Thomas Williams ,Jeffrey Camm, Kipp Martin

النسخة 13الرقم المعياري الدولي: 978-1439043271

An Introduction to Management Science 13th Edition by David Anderson,Dennis Sweeney ,Thomas Williams ,Jeffrey Camm, Kipp Martin

النسخة 13الرقم المعياري الدولي: 978-1439043271

تمرين 8

Because of high tuition costs at state and private universities, enrollments at community colleges have increased dramatically in recent years. The following data show the enrolment (in thousands) for Jefferson Community College from 2001-2009:

a. Construct a time series plot. What type of pattern exists in the data?
b. Use Excel Solver or LINGO to find the parameters for the line that minimizes MSE this time series.
c. What is the forecasts for 2010?

التوضيح

موثّق

a)Construct a time series plot using exc...