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

  • Thread starter Thread starter Lorna
  • Start date Start date
  • Tags Tags
    Excel Slope
AI Thread Summary
To use fit data with a fixed slope in Excel, the LINEST function is not suitable for this purpose. Instead, the slope (m) can be set manually, and the y-intercept (b) can be calculated using the formula b = avg(y) - m*avg(x). This approach allows for the adjustment of the slope while determining the intercept based on the data. A question arose regarding the calculation of the error in the y-intercept, which remains unanswered in the discussion.
Lorna
Messages
44
Reaction score
0
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
 
Physics news on Phys.org
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)
 
Oh yes! Thank you a lot!

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

Thank you!
 

Similar threads

Excel - linest function with blanks help
Replies
2
Views
2K
I Experimental Data - Error in slope
Replies
4
Views
2K
I What Are the Advantages of Linearizing Cubic Data for Analysis?
Replies
11
Views
2K
Error in Y-intercept, Least-square+Excel=True?
Replies
2
Views
2K
Graphical Analysis removing y-intercept
Replies
1
Views
2K
Data analysis by guessing, checking and fixing
Replies
5
Views
3K
I Error bars in Excel (standard deviation, standard error, percentage)
Replies
4
Views
3K
I Linear Regression, Population, Sample
Replies
4
Views
2K
Engineering Deflection and Slope of a Simply Supported Beam
Replies
8
Views
2K
Obtaining standard deviation of a linear regression intercep
Replies
3
Views
2K

Hot Threads

Recent Insights

Back
Top