[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Excel help (again)



PureBytes Links

Trading Reference Links

I have a file of values and dates with different numbers of days between
dates. In Excel, what's a reasonable way to measure the distance of each
value from a line of best fit so that I can categorize outliers. I'd
like to be able to say that certain outliers are more or less
(in)significant. 

I played with the LINEST function in Excel but I can't get the hang of
it, and I couldn't see how I could plot a regression line. 

Appreciate any ideas or help

Thanks in advance
Colin West