Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Linest: problems using broken reference data
I have as extensive data set and some data is missing in places, I want to
use linest and reference my X and Y variables to multiple non-connecting cells. Ive tried the standard form for referencing multiple cells (A4:D4, F4) but linest wont recognize the reference. Does any one have any suggestions? Example of data set X Y1 Y2 Y3 Y4 Y5 €¦€¦€¦. 1 2 2 3 6 3 2 1 N/A 2 3 1 3 1 2 4 1 2 4 N/A 1 5 3 1 5 N/A 3 5 2 N/A 6 2 3 6 1 4 .. .. I want slope of each data set. |
#2
|
|||
|
|||
How does this differ from your post of the previous evening, that was
addressed in that thread? Jerry Alex wrote: I have as extensive data set and some data is missing in places, I want to use linest and reference my X and Y variables to multiple non-connecting cells. Ive tried the standard form for referencing multiple cells (A4:D4, F4) but linest wont recognize the reference. Does any one have any suggestions? Example of data set X Y1 Y2 Y3 Y4 Y5 €¦€¦€¦. 1 2 2 3 6 3 2 1 N/A 2 3 1 3 1 2 4 1 2 4 N/A 1 5 3 1 5 N/A 3 5 2 N/A 6 2 3 6 1 4 . . I want slope of each data set. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why is the order of my data table opposite from graph? | Charts and Charting in Excel | |||
Pull Current Month's Data Out of List - Repost | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
"Broken" chart axis for data of different scales | Charts and Charting in Excel | |||
Adding more source data to existing scatter plot | Charts and Charting in Excel |