Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
linear regression
Can anyone point me in the right direction of how to use Excel to do simple
regression? Thanks. Jason. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
linear regression
Jason --
One easy way is inside the chart function. 1) Create the XY chart showing the data points. 2) Right-click on one of the data points in the chart. 3) Click 'Add Trendline'. 4) On the 'Type' tab, make sure that the 'linear' trendline is selected. 5) On the 'Options' tab, make sure that the 'Display equation' is selected, and the 'Display R-squared' is selected. 6) Click 'OK'. Or do you need to have the formulas in the spreadsheet itself? "Jason - MR" wrote: Can anyone point me in the right direction of how to use Excel to do simple regression? Thanks. Jason. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
regression | Excel Worksheet Functions | |||
Perpendicular distance of a point from linear regression line? | Charts and Charting in Excel | |||
How do I conduct linear regression in Excel with more than 16 x's | Excel Worksheet Functions | |||
formula for linear regression | Excel Worksheet Functions | |||
trendline - request power --> get linear | Excel Worksheet Functions |