View Single Post
  #5   Report Post  
Posted to comp.os.linux.advocacy,microsoft.public.excel.programming,comp.apps.spreadsheets,microsoft.public.excel.misc,microsoft.public.excel
Onion Knight Onion Knight is offline
external usenet poster
 
Posts: 18
Default Correct process for creating a linear trend line in Excel

On Jun 16, 1:41*am, Steve Carroll wrote:
On Jun 15, 6:11*pm, Foster wrote:









On Fri, 15 Jun 2012 16:47:40 -0700, Snit wrote:
On 6/15/12 3:44 PM, in article ,
"Foster" wrote:


On Sat, 16 Jun 2012 00:29:39 +0200, Peter K hlmann 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


A couple of other people in the group say that the video skips a
number of steps but when I look at the directions from Microsoft I do
not see any they could be referring to.


Does anyone see any missing steps for the creation of a linear trend
line? I admit this is a bit over my head so any input would be welcome.


Give it up, Snit Glasser.


Nobody here believes that "Onion Knight" is anything but a sock


I agree.
Too many coincidences.


I think the other person who came out of the blue is a sock as well.


P.S. I fixed your reply to alt.test back to COLA as well.


First: I do not use socks. *I


I really don't want to get involved but all I will say is it looks
bad from my perspective.
End of it.
I'm out of the thread.


OK, but you'll be missing the best part. Here's an absolutely
hilarious exchange that shows how watered down Snit's trend line
argument has gotten (to the point where it is now literally non-
existent). In some newsgroups he cross-trolled to earlier (in the
hopes of getting an appeal to authority so he could claim a win over
cc), a poster who knows the topic cut right to the chase:

--
"I gather there are two questions he

1) Is the trendline approriately fitted to that data?

2) Is the trendline useful in some way? "
--

Snit's outrageous reply is the funniest thing I've seen on usenet in a
long time:

--
"Not quite: the question was merely if the process of creating the
trend line was correct - did it follow the process of creating a
linear trend line that is supported by the build in "linear trend
line" properties of the program."
--

In other words, Snit knew he couldn't bullsh*t this guy so he had to
say "Not quite" to the two main reasons for even creating a trend line
in the first place! *And the reason he gave is equally as funny... he
wanted to "merely" know if his "process" in Excel was "correct" for
creating the trend line. Naturally, when you create a trend line you
have *some* goals in mind... the goals the poster stated. You can't
even talk about the process used to create the trend line until you
know what the goals for creating it are. This is just common sense of
which Snit obviously has none of... as he tossed those goals aside in
an effort to prove he was "right". Too funny ;)

This pathetically cross-posted thread only got created because Snit
dumped the idea of using people who are good at math because they
exposed him. Now he's appealing to people who have used the trend line
function in Excel and is, like the post I just showed you, completely
dumping the reason for creating it altogether in the hopes of *saving
face. You'll notice that he is not pointing out how his goal for
creating the trend line is *not* to see if it will be "approriately
fitted to that data" or be "useful in some way" (a thing any sane
person would assume). Gee, do you think he would have received a
different answer had he made that clear? LOL!


Snit made the claim that he created a linear trendline and did so
correctly. I would love to see where you think Snit said the 2011
trend would continue into 2012, unchanged.

His 2011 trendline fit his claims well. His 2012 tendline did not. You
say that others "exposed him" on this but he never claimed otherwise.
You are just throwing a toddler tantrum because Snit was proved right
by people who know a lot more than you.

For the last decade or so you have been following him around lying
about him because your girlfriend dumped your lying ass and you blamed
him. Poor Steve dumped by an insane bitch and unable to get over it.
Yes Steve the woman who dumped your lying ass was insane and evil. If
you had half a brain you would be celebrating that she left you and
not crying about it into the next decade.