Groups | Search | Server Info | Login | Register

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

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

Show all headers | View raw

On Thursday, June 21, 2012 12:12:17 PM UTC-4, Snit wrote:
> 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.
> 

Again, you are completely wrong. For example, in your original dataset it is impossible to plot a trendline against it and get a 1.0. I used all the original data points. So the R^2 value is generated from those points. Unless they happen to be in a straight line, you won't get a 1.0. You still think that these data points are manipulated or removed and then this updated data is used to get the R^2 value. That is just not true. I used all the same data points you did, no manipulation, no removal, in calculating the R^2 value.

Also, you seriously misunderstood what I was saying about my R^2 value. It was not all that high on it's own. It was just incredibly better than yours. Once again, we both calculated (okay Excel actually did it for us) the R^2 value against the same data points.

I've explained all this before, yet you still repeat the same blatantly incorrect bullshit.

-- 
<http://tmp.gallopinginsanity.com/LinearTrendLineCreation.mov> - Snit's ignorance of Excel and his hilarious attempt at statistical analysis 

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