Groups | Search | Server Info | Login | Register

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

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

Show all headers | View raw

On 6/21/12 7:42 AM, in article
7fb8feb1-76b0-494c-b529-62e302564041@googlegroups.com, "cc"
<scatnubbs@hotmail.com> wrote:

>> You are so smart about statistics! Please teach me how to tell if a
>> depiction of a standard deviation is right or wrong and how far the
>> lines should be from the mean. You are such an expert you must know
>> these things!
> 
> I'd love to, but you seem to lack a basic reading comprehension necessary to
> learn. 

So you have no answer.  You are just going to run.  Got it.  Bottom line:
you do not know.

> I will move on to the other areas of Snit's dumbness as soon as you two
> understand the basics of what was wrong with his original argument.

And now you start spewing insults and accusations - even though, above, you
make it clear you are clueless on the stats topics we are discussing.

> You both seem to think that comparing the R^2 value for a trendline on one
> dataset to another R^2 value for a trendline on a *different* dataset is
> somehow a valid operation.

Not I!  So while I will not speak for others, I will note that what "seems"
to the case for you is *not* the case.

I did note how you were worshiping the God of R^2 values... bragging so
heavily about how high you could get yours... by weighting data in a way
that will *always* give you a higher R^2 value.  As I noted, if you take
this to an extreme you can get an R^2 value that is 1.0 or very close on
*any* data set.

And below, again, you go on about what "seems" to be the case to you - but
it has already been established that what "seems" to be the case to you is
not based on reality.  You also put down my video - showing you did not even
get the point of it!  It was not about outliers and anomalies but about a
straightforward process in Excel!  And you claimed - incorrectly - that I
missed steps.  Again, you were wrong.  But, still, you pretend to be
knowledgeable on these things so at the bottom of this post I will ask you
some questions.  

> Neither of you seem to understand why anomalies are important, how they may
> legitmately occur, and why not dealing with them will result in incorrect
> analysis (see Snit's video). Oddly enough, you both want to try to put words
> in my mouth and fabricate arguments out of things I've never said. So until we
> clear up your guys' learning disabilities and you both understand why Snit was
> and is terribly wrong about the trend of Linux usage, then we can't move on.
> 
> Also, I'm flattered you think I'm an expert on this. But in reality, this is
> simple stuff. Perhaps they didn't teach it to you and Snit in high school?
> That's a real shame because then idiots like you two come around and say
> stupid things that anyone with some common sense knows is false, and anyone
> with slightly more common sense can prove false mathematically.

Oh, you keep presenting yourself as being some sort of expert on these
things - finding flaws in the process MS and Apple and others say is the
correct one, etc.  But when asked questions you just run... or make up
stories about people.

But the questions for you remain:

1) For a normal distribution, how can you visually tell if the sigma lines
are drawn correctly?

2) For question 1, can this placement be based on the distance from the mean
to any other element on the curve - and if so, what element?

3) Given this data: <http://goo.gl/NhFuK>, does this show a steady rate, an
increase, or a decrease for the second half of 2011?

Of course, there are more questions for you, noted in my .sig, but let's
just start with those 3.  I really would love to learn from you!  Oh, you
are so very knowledgeable!

-- 
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.os.linux.advocacy | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

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 TomB <tommy.bongaerts@gmail.com> - 2012-06-19 19:07 +0000
    Re: Correct process for creating a linear trend line in Excel Snit <usenet@gallopinginsanity.com> - 2012-06-19 12:17 -0700
      Re: Correct process for creating a linear trend line in Excel Steve Carroll <fretwizzer@gmail.com> - 2012-06-19 13:33 -0700
        Re: Correct process for creating a linear trend line in Excel Tattoo Vampire <sitting@this.computer> - 2012-06-19 18:23 -0400
          Re: Correct process for creating a linear trend line in Excel Steve Carroll <fretwizzer@gmail.com> - 2012-06-19 16:13 -0700
          Re: Correct process for creating a linear trend line in Excel Snit <usenet@gallopinginsanity.com> - 2012-06-19 16:33 -0700
            Re: Correct process for creating a linear trend line in Excel Onion Knight <onionknightgot@gmail.com> - 2012-06-19 18:32 -0700
              Re: Correct process for creating a linear trend line in Excel Tattoo Vampire <sitting@this.computer> - 2012-06-19 21:44 -0400
                Re: Correct process for creating a linear trend line in Excel Onion Knight <onionknightgot@gmail.com> - 2012-06-19 20:31 -0700
                Re: Correct process for creating a linear trend line in Excel Captain Napalm <fake@email.address> - 2012-06-20 07:20 -0400
                Re: Correct process for creating a linear trend line in Excel chrisv <chrisv@nospam.invalid> - 2012-06-20 06:34 -0500
                Re: Correct process for creating a linear trend line in Excel Onion Knight <onionknightgot@gmail.com> - 2012-06-20 18:28 -0700
            Re: Correct process for creating a linear trend line in Excel cc <scatnubbs@hotmail.com> - 2012-06-20 05:31 -0700
              Re: Correct process for creating a linear trend line in Excel Snit <usenet@gallopinginsanity.com> - 2012-06-20 08:46 -0700
                Re: Correct process for creating a linear trend line in Excel cc <scatnubbs@hotmail.com> - 2012-06-20 08:56 -0700
                Re: Correct process for creating a linear trend line in Excel Snit <usenet@gallopinginsanity.com> - 2012-06-20 09:32 -0700
                Re: Correct process for creating a linear trend line in Excel cc <scatnubbs@hotmail.com> - 2012-06-20 09:50 -0700
                Re: Correct process for creating a linear trend line in Excel Snit <usenet@gallopinginsanity.com> - 2012-06-20 09:57 -0700
                Re: Correct process for creating a linear trend line in Excel cc <scatnubbs@hotmail.com> - 2012-06-20 10:27 -0700
                Re: Correct process for creating a linear trend line in Excel Snit <usenet@gallopinginsanity.com> - 2012-06-20 10:32 -0700
                Re: Correct process for creating a linear trend line in Excel Onion Knight <onionknightgot@gmail.com> - 2012-06-20 18:32 -0700
                Re: Correct process for creating a linear trend line in Excel Snit <usenet@gallopinginsanity.com> - 2012-06-20 19:48 -0700
                Re: Correct process for creating a linear trend line in Excel cc <scatnubbs@hotmail.com> - 2012-06-21 07:42 -0700
                Re: Correct process for creating a linear trend line in Excel Snit <usenet@gallopinginsanity.com> - 2012-06-21 09:12 -0700
                Re: Correct process for creating a linear trend line in Excel cc <scatnubbs@hotmail.com> - 2012-06-21 10:16 -0700
                Re: Correct process for creating a linear trend line in Excel Snit <usenet@gallopinginsanity.com> - 2012-06-21 10:55 -0700
                Re: Correct process for creating a linear trend line in Excel cc <scatnubbs@hotmail.com> - 2012-06-21 11:08 -0700
                Re: Correct process for creating a linear trend line in Excel Snit <usenet@gallopinginsanity.com> - 2012-06-21 11:27 -0700
                Re: Correct process for creating a linear trend line in Excel cc <scatnubbs@hotmail.com> - 2012-06-21 11:58 -0700
                Re: Correct process for creating a linear trend line in Excel Snit <usenet@gallopinginsanity.com> - 2012-06-21 13:20 -0700
                cc cannot help but run like a coward. Snit <usenet@gallopinginsanity.com> - 2012-06-21 13:21 -0700
              Re: Correct process for creating a linear trend line in Excel Onion Knight <onionknightgot@gmail.com> - 2012-06-20 18:30 -0700
                Re: Correct process for creating a linear trend line in Excel Snit <usenet@gallopinginsanity.com> - 2012-06-20 19:52 -0700
                Re: Correct process for creating a linear trend line in Excel cc <scatnubbs@hotmail.com> - 2012-06-21 06:28 -0700
                Three questions for cc Snit <usenet@gallopinginsanity.com> - 2012-06-21 09:21 -0700
                Re: Correct process for creating a linear trend line in Excel cc <scatnubbs@hotmail.com> - 2012-06-21 06:29 -0700
        Re: Correct process for creating a linear trend line in Excel Onion Knight <onionknightgot@gmail.com> - 2012-06-19 18:31 -0700
    Re: Correct process for creating a linear trend line in Excel Onion Knight <onionknightgot@gmail.com> - 2012-06-19 18:29 -0700

csiph-web