Groups | Search | Server Info | Login | Register


Groups > comp.os.linux.advocacy > #114431

Re: Correct process for creating a linear trend line in Excel

From Steve Carroll <fretwizzer@gmail.com>
Newsgroups comp.os.linux.advocacy
Subject Re: Correct process for creating a linear trend line in Excel
Date 2012-06-15 18:41 -0700
Organization http://groups.google.com
Message-ID <2ce0d449-da20-4f04-8372-2bacfcf20f86@j9g2000vbk.googlegroups.com> (permalink)
References <d0ca6d15-3a34-4b08-8379-84cf34f74ffe@v9g2000vbc.googlegroups.com> <jrgd1o$71s$1@dont-email.me> <1smpndcpf81js.tavjpchxlzrh$.dlg@40tude.net> <CC0117AC.35AE%usenet@gallopinginsanity.com> <1p6fptvt16m75$.1q5k0ny9zl6gb.dlg@40tude.net>

Show all headers | View raw


On Jun 15, 6:11 pm, Foster <frankfoste...@yahoo.com> wrote:
> On Fri, 15 Jun 2012 16:47:40 -0700, Snit wrote:
> > On 6/15/12 3:44 PM, in article 1smpndcpf81js.tavjpchxlzrh$....@40tude.net,
> > "Foster" <frankfoste...@yahoo.com> 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/LinearTrendLineCreation.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 here:

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!




Back to comp.os.linux.advocacy | Previous | NextPrevious in thread | Next in thread | Find similar


Thread

Correct process for creating a linear trend line in Excel Onion Knight <onionknightgot@gmail.com> - 2012-06-15 14:16 -0700
  Re: Correct process for creating a linear trend line in Excel Peter Köhlmann <peter-koehlmann@t-online.de> - 2012-06-16 00:29 +0200
    Re: Correct process for creating a linear trend line in Excel Foster <frankfoster50@yahoo.com> - 2012-06-15 18:44 -0400
      Re: Correct process for creating a linear trend line in Excel Snit <usenet@gallopinginsanity.com> - 2012-06-15 16:47 -0700
        Re: Correct process for creating a linear trend line in Excel Steve Carroll <fretwizzer@gmail.com> - 2012-06-15 16:54 -0700
        Re: Correct process for creating a linear trend line in Excel Foster <frankfoster50@yahoo.com> - 2012-06-15 20:11 -0400
          Re: Correct process for creating a linear trend line in Excel Snit <usenet@gallopinginsanity.com> - 2012-06-15 17:18 -0700
            Re: Correct process for creating a linear trend line in Excel Onion Knight <onionknightgot@gmail.com> - 2012-06-15 20:05 -0700
              Re: Correct process for creating a linear trend line in Excel Snit <usenet@gallopinginsanity.com> - 2012-06-15 21:12 -0700
          Re: Correct process for creating a linear trend line in Excel Steve Carroll <fretwizzer@gmail.com> - 2012-06-15 18:41 -0700
            Re: Correct process for creating a linear trend line in Excel Onion Knight <onionknightgot@gmail.com> - 2012-06-15 20:01 -0700
              Re: Correct process for creating a linear trend line in Excel Snit <usenet@gallopinginsanity.com> - 2012-06-15 20:21 -0700
          Re: Correct process for creating a linear trend line in Excel GreyCloud <mist@cumulus.com> - 2012-06-15 23:32 -0600
            Re: Correct process for creating a linear trend line in Excel Snit <usenet@gallopinginsanity.com> - 2012-06-15 23:14 -0700
    Re: Correct process for creating a linear trend line in Excel DFS <nospam@dfs.com> - 2012-06-15 19:17 -0400
      Re: Correct process for creating a linear trend line in Excel Peter Köhlmann <peter-koehlmann@t-online.de> - 2012-06-16 01:39 +0200
        Re: Correct process for creating a linear trend line in Excel DFS <nospam@dfs.com> - 2012-06-15 23:26 -0400
          Re: Correct process for creating a linear trend line in Excel Snit <usenet@gallopinginsanity.com> - 2012-06-15 21:15 -0700
          Re: Correct process for creating a linear trend line in Excel Foster <frankfoster50@yahoo.com> - 2012-06-16 12:36 -0400
            Re: Correct process for creating a linear trend line in Excel Snit <usenet@gallopinginsanity.com> - 2012-06-16 10:30 -0700
              Re: Correct process for creating a linear trend line in Excel Steve Carroll <fretwizzer@gmail.com> - 2012-06-16 11:20 -0700
      Re: Correct process for creating a linear trend line in Excel Snit <usenet@gallopinginsanity.com> - 2012-06-15 16:49 -0700
    Re: Correct process for creating a linear trend line in Excel Snit <usenet@gallopinginsanity.com> - 2012-06-15 16:48 -0700
  Re: Correct process for creating a linear trend line in Excel "joeu2004" <joeu2004@foo.bar> - 2012-06-15 16:22 -0700
    Re: Correct process for creating a linear trend line in Excel Snit <usenet@gallopinginsanity.com> - 2012-06-15 17:45 -0700
      Re: Correct process for creating a linear trend line in Excel Onion Knight <onionknightgot@gmail.com> - 2012-06-15 20:03 -0700
        Re: Correct process for creating a linear trend line in Excel Snit <usenet@gallopinginsanity.com> - 2012-06-15 21:11 -0700
    Re: Correct process for creating a linear trend line in Excel Onion Knight <onionknightgot@gmail.com> - 2012-06-15 19:54 -0700
      Re: Correct process for creating a linear trend line in Excel Snit <usenet@gallopinginsanity.com> - 2012-06-15 21:06 -0700
    Re: Correct process for creating a linear trend line in Excel Martin Brown <|||newspam|||@nezumi.demon.co.uk> - 2012-06-17 08:57 +0100
      Re: Correct process for creating a linear trend line in Excel Steve Carroll <fretwizzer@gmail.com> - 2012-06-17 09:18 -0700
        Re: Correct process for creating a linear trend line in Excel Onion Knight <onionknightgot@gmail.com> - 2012-06-17 10:23 -0700
          Re: Correct process for creating a linear trend line in Excel Steve Carroll <fretwizzer@gmail.com> - 2012-06-17 13:02 -0700
          Re: Correct process for creating a linear trend line in Excel Snit <usenet@gallopinginsanity.com> - 2012-06-17 15:09 -0700
    Re: Correct process for creating a linear trend line in Excel cc <scatnubbs@hotmail.com> - 2012-06-18 06:29 -0700
      Re: Correct process for creating a linear trend line in Excel Snit <usenet@gallopinginsanity.com> - 2012-06-18 09:29 -0700
        Re: Correct process for creating a linear trend line in Excel cc <scatnubbs@hotmail.com> - 2012-06-18 09:42 -0700
          Re: Correct process for creating a linear trend line in Excel Steve Carroll <fretwizzer@gmail.com> - 2012-06-18 09:45 -0700
          Re: Correct process for creating a linear trend line in Excel Snit <usenet@gallopinginsanity.com> - 2012-06-18 10:53 -0700
            Re: Correct process for creating a linear trend line in Excel cc <scatnubbs@hotmail.com> - 2012-06-18 11:02 -0700
              Re: Correct process for creating a linear trend line in Excel Snit <usenet@gallopinginsanity.com> - 2012-06-18 11:10 -0700

csiph-web