What is the formula for linear regression where Y = B(X) + C?
--
Dana

Take a look "SLOPE" function in Help menu



"Dana" wrote:

What is the formula for linear regression where Y = B(X) + C?
--
Dana

hi,

That is the formula, usually Y = ax +b where a is the slope and b is the y
intercept.

In Excel you can use the =LINEST function to calculate various regression
parameters, you can use the TREND function to esimate a new y value based on
a given X. You can use the SLOPE function to find the slope of the linear
regression line for a series of point pairs, you can use the INTERCEPT
function to find the intercept of the same series. You can plot the data in
a chart and then ask Excel to plot a Linear trendline and display the formula
on the chart. Or you can use the Data Analysis command's Regression tool to
present a myrid of regression statisticsl.


--
Thanks,
Shane Devenshire


"Dana" wrote:

What is the formula for linear regression where Y = B(X) + C?
--
Dana