The equation of line of best fit is y = 2.3033 x + 160.71.
Step-by-step explanation:
The kine of best fit for the provided data can be computed in Excel.
Step 1:
Enter the data.
Step 2:
Select the entire data.
Go to Insert - Charts - Scatter
The scatter plot will be displayed.
Step 3:
Select the graph.
Go to Design - Quick Layout - Layout 9.
The line of best fit will be displayed on the graph.
The scatter plot and the line of best fit for Aiden’s data is shown below.
The equation of line of best fit is:
y = 2.3033 x + 160.71