What is the equation of the line of best fit for the following data? Round the slope and y intercept of the line to three decima
l places
2 answers:
Answer:
Choice B
Step-by-step explanation:
We can perform a least squares regression model in Ms. Excel to determine the equation of the line of best fit for the data given;
The first step is to enter the data into any two adjacent columns of an excel workbook. Next, click on the Data ribbon followed by the Data Analysis tool pack. We then proceed to select regression from the pop-up window. The final step is to select the y range and the x range of values from our data.
Once we click ok, Excel returns our least squares regression model as shown in the attachment below.
The coefficient of X variable 1 is our slope.
You might be interested in