Groups | Search | Server Info | Login | Register
Groups > comp.os.linux.advocacy > #115589
| From | Snit <usenet@gallopinginsanity.com> |
|---|---|
| Newsgroups | comp.os.linux.advocacy |
| Subject | Re: Correct process for creating a linear trend line in Excel |
| Date | 2012-06-21 11:27 -0700 |
| Message-ID | <CC08B5BD.3C67%usenet@gallopinginsanity.com> (permalink) |
| References | (12 earlier) <7fb8feb1-76b0-494c-b529-62e302564041@googlegroups.com> <CC0895F1.3C37%usenet@gallopinginsanity.com> <0c35fa7e-3c93-42d5-9f4d-9e5212e54a70@googlegroups.com> <CC08AE14.3C5B%usenet@gallopinginsanity.com> <251fb93f-df14-4ec5-b6fd-1053bb059943@googlegroups.com> |
On 6/21/12 11:08 AM, in article 251fb93f-df14-4ec5-b6fd-1053bb059943@googlegroups.com, "cc" <scatnubbs@hotmail.com> wrote: > On Thursday, June 21, 2012 1:55:16 PM UTC-4, Snit wrote: >> On 6/21/12 10:16 AM, in article >> 0c35fa7e-3c93-42d5-9f4d-9e5212e54a70@googlegroups.com, "cc" >> <scatnubbs@hotmail.com> wrote: >> >>> 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. >> >> Nope. >> >>> For example, in your original dataset it is impossible to plot a trendline >>> against it and get a 1.0. >> >> You can, at the very least, get very close. Of course, to do this you have >> to "weight" the data in rather absurd ways. >> >>> I used all the original data points. So the R^2 value is generated from >>> those >>> points. >> >> But you admitted you weighted them differently - in a way that will *always* >> lead to a higher R^2 value. >> >>> 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. >> >> You already admitted you based your trend line on averages and standard >> deviations based on the data. >> >>> 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. >> >> Well, I used the actual data - you used averages and standard deviations >> based on that data. >> > > Incorrect. Everything above is entirely incorrect. You're talking about > weighting data and using that weighted data to get an R^2 value. I said I used > your ORIGINAL DATA SET. No weighted values, to calculate the R^2 value. So > however I achieved my trend line, the R^2 values were calculated using it > against the ORIGINAL DATA SET. This is an important fact, and is the reason > why you were so incredibly wrong before, and are so incredibly wrong now. > > Do you not understand how R^2 values are calculated? Even though I've > explained it a dozen times now? However you did it. LOL! At this point you have no clue. I love it! -- 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
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