Click in the equation area labeled C figure 5 Type an equal sign and then a parentheses. Start Your Free Excel Course. Use the MMULT function to return the product of matrix A -1 and B.
The FORECASTLINEAR function will calculate a new y-value using the simple straight-line equation.
First select the X-Value column cells. On an Excel chart theres a trendline you can see which illustrates the regression line the rate of change. As you can see the equation shows how y is related to x. The first step in fitting an equation to data is to determine what form the equation should have.