Calculate the Equation from the Parameters. If this toolbar doesnt open click your graph and then click the Design tab in the green ribbon. One of the most interesting and useful forms of data analysis you can perform in Excel is regression analysis.
To provide this data you need to enter X values into one column or row and calculate the corresponding Y values in the next column or row.
Click the button on the right side of the chart and. Excel will draw a line as close as possible to all data points so that there are as many points above the line as below. Type x values in cell A1. The series will be a function of the parameters a and b.