On a chart its the point where the trendline crosses the y axis. In the Equations column Column E write down the equations. Y a bX.
Highlight a spreadsheet cell to hold x the result of the final equation cell C12 labeled B in Figure 5.
The values of x and y are the sample means the averages of the known x- and the known y-values. In the Equations column Column E write down the equations. Excel functions formula charts formatting creating excel dashboard others. Y dependent variable b the slope of the regression line.