Linear Regression Analysis

S

ShaneDevenshire

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top