Question

As the table shows, projections indicate that the percent of adults with diabetes could dramatically increase. Percent of Adults with Diabetes Year Percent Year Percent Year Percent 2010 15.9 2040 2025 23.4 31.5 2015 2020 27.8 18.3 20.5 2030 2035 Answer parts a. through c. 2045 33.2 34.8 29.0 2050 a. Find a linear model that fits the data in the table, with x- 0 for the year 2000 (Use integers or decimals for any numbers in the expression. Round to three decimal places as needed.)

Answer 1

In excel, first, we will make a table of the given data points as -

10	15.9
15	18.3
20	20.5
25	23.4
30	27.8
35	29
40	31.5
45	33.2
50	34.8

Then we will plot a X-y scatter plot, from Insert Menu, and add a trendline.

Chart Title 40 35 y 0.493x 11.254 30 20 15 10 5 0 0 10 20 30 40 50 60 25 LC

The equation of the trendline is the given model of the system.

Thus the model is given by the equation

y = 0.493x + 11.254