Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by GrahamSRowe

  1. GrahamSRowe

    Exponential trendline fit in Excel using LINEST - fixing a variable

    I know that you can use the following formulae in Excel to fit a curve using LINEST for the named ranges x and y: Exponential Trendline Equation: y = c *e ^(b * x) c: =EXP(INDEX(LINEST(LN(y),x),1,2)) b: =INDEX(LINEST(LN(y),x),1) My question is, if I want to fix c=1 can I simply use b...

Part and Inventory Search