Question

The medical community unanimously agrees on the health benefits of regular exercise, but are adults listening? During each of the past 15 years, a polling organization has surveyed americans about their exercise habits. In the most recent of these polls, slightly over half of all American adults reported that they exercise for 30 or more minutes at least three times per week. The following data show the percentages of adults who reported that they exercise for 30 or more minutes at least three times per week during each of the 15 years of this study.

Year	Percentage of Adults Who Exercise 30 or more minutes at least three times per week
1	41.3
2	45.2
3	47.4
4	45.4
5	46.7
6	44.6
7	47.9
8	50.1
9	48.2
10	49.2
11	50
12	52.2
13	50.9
14	54.7
15	53.5

1. use simple linear regression to find the parameters for the line that minimizes MSE for this time series. Do not round your interim computations and round your final answers to four decimal places. For subtractive or negative numbers use a minus sign. (Example: -300)
   
   y-intercept, b₀ =
   
   Slope, b₁ =
   
   MSE =
   
2. Use the trend equation from part (b) to forecast the percentage of adults next year (year 16 of the study) who will report that they exercise for 30 or more minutes at least three times per week. Do not round your interim computations and round your final answers to four decimal places. For subtractive or negative numbers use a minus sign. (Example: -300)
   
   %
   
3. Use the trend equation from part (b) to forecast the percentage of adults three years from now (year 18 of the study) who will report that they exercise for 30 or more minutes at least three times per week. Do not round your interim computations and round your final answers to four decimal places. For subtractive or negative numbers use a minus sign. (Example: -300)
   
   %
4. Use the trend equation from part (b) to forecast the percentage of adults three years from now (year 18 of the study) who will report that they exercise for 30 or more minutes at least three times per week. Do not round your interim computations and round your final answers to four decimal places. For subtractive or negative numbers use a minus sign. (Example: -300)
   
   %

Answer 1

Using Excel

data -> data analysis -> regression

a)

MSE = 2.1803

b) y^ = 42.5867 + 0.7375 * t

d) is same as c) part