Calculating Error in Y-Intercept for Fixed Slope Linest in Excel

[Lorna]

Hello,

Does anyone have an idea about how to use fit data with a line while fixing the slope in MS. Excel? Does linest by anyway capable of doing that?

Thank you

Lorna

 

[hotvette]

I doubt that linest has the ability to fix the slope, but you don't need it anyway. If you look at the equations for least squares line fit (i.e. y = mx + b), the intercept is calculated by:

b = avg(y) - m*avg(x)

 

[Lorna]

Oh yes! Thank you a lot!

How would we calculate the error in the y-intercept? would it be zero?

Thank you!