48,753 views
2 votes
2 votes
Year, xThe table lists the average monthly cost to workers for family health insurance for various years.a) Use a graphing calculator to fit a regression line to the data,b) Predict the average monthly cost to workers for family health insurance in 2020, and compare thevalue with $487.7, which is obtained using the points (1,331) and (4,378).c) Find the correlation coefficient for the regression line, and determine whether the line fits the dataclosely.2009, 02010, 12011, 22012,32013, 42014,5Average Monthly Cost toWorkers for Family HoalthInsurance$291331346357378399a) The linear equation of the regression line that best models the data is y=x+(Round to the nearest hundredth as needed.)

Year, xThe table lists the average monthly cost to workers for family health insurance-example-1
User Narayan Yerrabachu
by
3.1k points

1 Answer

13 votes
13 votes

A) Check the graph, below

B) $518.38 (y=19.771x+300.9)

C) r=0.965

A) Let's plot a scatter plot with a trendline for that table:

b) We need to find out the equation by making use of 2 formulas. The first one to find out the slope, and the second to find out the linear coefficient.


\begin{gathered} m=\frac{n\sum^{}_{}xy-\sum^{}_{}x\sum^{}_{}y}{n\sum^{}_{}x^2-(\sum^{}_{}x)^2} \\ b=\frac{\sum^{}_{}y-m\sum^{}_{}x}{n} \end{gathered}

But before that, we need to place in here a table, with the given data:

Considering the last line the summation of each category, we can plug into that formula, and plugging into them the formula we have:


\hat{y}=19.771x+300.9

Considering that 2020 would be the 11th year on that table and that we can plug into that equation, for the first one 2009 is the 0th year.


\begin{gathered} \hat{y}=19.771x+300.9 \\ \hat{y}=19.771(11)+300.9 \\ \hat{y}=518.38 \end{gathered}

So in 2020, the cost for a family would be $518.38 note that above the prediction base on only two points.

C) Let's find the correlation coefficient using the following formula:


\begin{gathered} r=\frac{n\sum^{}_{}xy-(\sum^{}_{}x)(\sum^{}_{}y)}{\sqrt[]{\lbrack n(\sum^{}_{}x^2)-(\sum^{}_{}x)^2\rbrack\lbrack n\sum^{}_{}y^2-(\sum^{}_{}y)^2\rbrack}}= \\ \\ r=\frac{5\cdot5601-15\cdot2102}{\sqrt[]{\lbrack5\cdot55-(15)^2\rbrack\cdot\lbrack5\cdot743492-(2102)^2\rbrack}} \\ r=0.965 \end{gathered}

Note that n=5, ∑x=15, ∑xy=5601, ∑y=2102, ∑x²=55, and we've plugged into that and find a positive correlation.

Year, xThe table lists the average monthly cost to workers for family health insurance-example-1
Year, xThe table lists the average monthly cost to workers for family health insurance-example-2
User Rare Pleasures
by
2.7k points