Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
slope of data with the same y values
I want excel to calculate the slope of a set of data which has the same x
values. For each column I should enter the syntax. Is there any way that I can write once for all columns which have the same x or y values? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
slope of data with the same y values
Hi Rosa,
Not too sure I follow, however: If your X's are in column A (From Row 2 down to Row 101) and you want the SLOPE with Y's in columns B,C,D etc I think you would use SLOPE(B$2:B$101,$A$2:$A$101) then fill across to apply the same formula to the other columns of Y values with the same X values in column A. Or, apply a Name to the data column you want to repeatedly use then use that name in the Slope formula. Ken Johnson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
slope of data with the same y values
If you are saying that you y does not change with x, then the slope is
zero. If you are saying that y=x in all cases, then the slope is one. Otherwise, please clarify your question. Jerry Rosa wrote: I want excel to calculate the slope of a set of data which has the same x values. For each column I should enter the syntax. Is there any way that I can write once for all columns which have the same x or y value? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing Data | Excel Worksheet Functions | |||
How do I have a data table display cell names rather than values? | Excel Worksheet Functions | |||
How do I clear data values wthout losing the formulas? | Excel Worksheet Functions | |||
How do I show both data labels and values? | Charts and Charting in Excel | |||
how can i get the slope function to ignore missing data? | Excel Discussion (Misc queries) |