Groups | Search | Server Info | Login | Register

Groups > comp.apps.spreadsheets > #27

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

Cross-posted to 5 groups.

Show all headers | View raw

On 6/15/12 7:54 PM, in article
b7bd335e-2fe4-4ab2-97a4-6baef75435a0@5g2000vbf.googlegroups.com, "Onion
Knight" <onionknightgot@gmail.com> wrote:

> On Jun 15, 11:22 pm, "joeu2004" <joeu2...@foo.bar> wrote:
>> "Onion Knight" <onionknight...@gmail.com> 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
>> [....]
>>> 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.

I wonder what his max has been?  I am sure it has been at least three people
at once he was claiming were me.  He is obsessed with me.  It is whacky.

> 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.

Agreed.  Now let's let it drop - at least from the non-COLA groups.  And,
really, even from the COLA groups.

Carroll and cc will run around making up stories about how people from all
groups on Usenet are me and will insist that these folks who know more than
they do are just wrong or missing the point or will hunt for some point to
nit pick.  Meanwhile the facts will remain the same:

* My process for creating trend lines in Excel was correct.
* My prediction of an increase in usage of Linux was correct for 2011
* My prediction of Linux usage staying at that level or increasing
  in 2012 has turned out to *not* be correct.

And with all the other stuff about sigma lines and incorrect depictions and
yada yada yada I was right and they were simply trolling me.

And it is easy to predict their trolling will only increase now that others
have commented on these matters.  Their frenzy will be a sight to behold.

-- 
The indisputable facts about that absurd debate: <http://goo.gl/2337P>
cc being proved wrong about his stats BS: <http://goo.gl/1aYrP>
7 simple questions cc will *never* answer: <http://goo.gl/cNBzu>
cc again pretends to be knowledgeable about things he is clueless about.

Back to comp.apps.spreadsheets | Previous | Next — Previous 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 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 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 "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 Steve Carroll <fretwizzer@gmail.com> - 2012-06-18 12:09 -0700
          Re: Correct process for creating a linear trend line in Excel Onion Knight <onionknightgot@gmail.com> - 2012-06-18 21:16 -0700
            Re: Correct process for creating a linear trend line in Excel Snit <usenet@gallopinginsanity.com> - 2012-06-18 23:03 -0700
              Re: Correct process for creating a linear trend line in Excel Steve Carroll <fretwizzer@gmail.com> - 2012-06-19 09:17 -0700
            Re: Correct process for creating a linear trend line in Excel Steve Carroll <fretwizzer@gmail.com> - 2012-06-19 11:09 -0700
    Re: Correct process for creating a linear trend line in Excel Steve Carroll <fretwizzer@gmail.com> - 2012-06-15 18:39 -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 Onion Knight <onionknightgot@gmail.com> - 2012-06-18 21:33 -0700
      Re: Correct process for creating a linear trend line in Excel Snit <usenet@gallopinginsanity.com> - 2012-06-18 23:19 -0700
  Re: Correct process for creating a linear trend line in Excel Onion Knight <onionknightgot@gmail.com> - 2012-06-18 21:29 -0700
    Re: Correct process for creating a linear trend line in Excel Snit <usenet@gallopinginsanity.com> - 2012-06-18 23:16 -0700

csiph-web