The table shows the number of fiber-optic cable connections to homes in the U.S. from 2000-2004 ( represents 2000). Use technology to obtain the linear regression line, with regression coefficients rounded to two decimal places.

Question

The table shows the number of fiber-optic cable connections to homes in the U.S. from 2000-2004 (  represents 2000). Use technology to obtain the linear regression line, with regression coefficients rounded to two decimal places.

Quizplus · Accepted Answer

The linear regression line can be obtained using technology such as Excel or a graphing calculator. Using Excel, we input the x-values (years 2000-2004) in one column and the y-values (number of fiber-optic cable connections) in another column. We then insert a scatterplot and add a linear trendline. The regression equation and coefficients are then displayed, which are rounded to two decimal places. The regression line for this data set is y = 4046.20x - 8,063,240. Therefore, the best choice is B.

The Table Shows the Number of Fiber-Optic Cable Connections to Homes