The medical community unanimously agrees on the health benefitsof regular exercise, but are adults listening? During each of thepast 15 years, a polling organization has surveyed americans abouttheir exercise habits. In the most recent of these polls, slightlyover half of all American adults reported that they exercise for 30or more minutes at least three times per week. The following datashow the percentages of adults who reported that they exercise for30 or more minutes at least three times per week during each of the15 years of this study.
Year | Percentage of Adults Who Exercise 30 or more minutes atleast three times per week |
1 | 41.5 |
2 | 45.2 |
3 | 47.1 |
4 | 45.6 |
5 | 46.7 |
6 | 44.7 |
7 | 47.9 |
8 | 50 |
9 | 48.2 |
10 | 49.4 |
11 | 50 |
12 | 52.4 |
13 | 51.1 |
14 | 54.9 |
15 | 52.5 |
- Does a linear trend appear to be present?
- use simple linear regression to find the parameters for theline that minimizes MSE for this time series. Do not round yourinterim computations and round your final answers to four decimalplaces. For subtractive or negative numbers use a minus sign.(Example: -300)
y-intercept, b0 =
Slope, b1 =
MSE = - Use the trend equation from part (b) to forecast the percentageof adults next year (year 16 of the study) who will report thatthey exercise for 30 or more minutes at least three times per week.Do not round your interim computations and round your final answersto four decimal places. For subtractive or negative numbers use aminus sign. (Example: -300)
% - Use the trend equation from part (b) to forecast the percentageof adults three years from now (year 18 of the study) who willreport that they exercise for 30 or more minutes at least threetimes per week. Do not round your interim computations and roundyour final answers to four decimal places. For subtractive ornegative numbers use a minus sign. (Example: -300)