On Jun 15, 11:22*pm, "joeu2004" wrote:
"Onion Knight" wrote:
There has been some debate in COLA as to the correct way
to create a linear trendline in Excel. Someone in the forum
kindly made a video to show what he thought was the correct
method
http://tmp.gallopinginsanity.com/Lin...neCreation.mov
[....]
Does anyone see any missing steps for the creation of a
linear trend line?

I cannot find the original debate in comp.os.linux.advocacy (COLA); just the
thread titled "Visualizing where to draw the standard deviation line", which
refers to yet-another "a debate in COLA".

No matter; I'm not interested. *I think we can answer your Excel questions
without getting into anything so esoteric.

I see no missing steps in creating the linear trendline per se using Excel.

Thank you for your posting of this educated opinion, even though it
broke Steve. He is now running around screaming about how I and
anyone else who agreed with Snit on this must be Snit's sock puppets.
Give it a little time and he will insist you must be Snit as well.

This matter is settled. Snit was right to say his process was fine
and cc and Carroll who argued against him were wrong. Snit's linear
trendline was created without flaw. This was obvious from the start
but it is good to get a more educated and impartial stating of it. Fun
to watch Steve crumble as he reads it too.