Question

Please help me find the correct answer for the one I got incorrect. Thank you!

Answer 1

Use the following steps to find the linear equation in time series. 1. Enter the data in the spread sheet. 2. Select 'Stat from main menu and then select 'Time series. Trend analysis'. 3. Specify the variable as percentage of adults. 4. Finally click ok. The output is shown below: Time Series Plot of percentage of adults percentage of adults 1 2 3 4 5 6 10 11 12 13 14 15 7 8 9 Index The time series graph indicates that the percentage of adults who reported that they exercise for 30 or more minutes at least three times per week data is random.

b. The linear regression for the time series is shown below: Time Series Plot of percentage of adults Time Series Plot of percentage of adults Trend Analysis for percentage of adults Method Model type Linear Trend Model Data percentage of adults Length 15 NMissing 0 Fitted Trend Equation Yt = 42.530 +0.7154xt Accuracy Measures MAPE 2.46925 MAD 1.17487 MSD 1.93275 Hence, from the output, the linear regression is Y = 42.530 +0.7154xt

From the trend equation from part [b], the forecast percentage of adults next year 16 is, Y = 42.530 +0.7154xt. Therefore, the forecast percentage for the year 16 is, Y = 42.530+0.7154x(16) = 42.530 +0.7154x(16) = 42.530+11.4464 = 53.9764 Hence, the forecasted value for the year 16 is 53.9764. d. From the trend equation from part [b], the forecast percentage of adults next year 18 is, Y = 42.530 +0.7154xt. Therefore, the forecast percentage for the year 18 is, Y = 42.530+0.7154x(18) = 42.530 +0.7154x(18) = 42.530+12.8772 = 55.4072 Hence, the forecasted value for the year 18 is 55.4072.