Groups | Search | Server Info | Login | Register

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

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 8:03 PM, in article
f5f6f483-8e73-47d1-af08-0484186d81a3@s9g2000vbg.googlegroups.com, "Onion
Knight" <onionknightgot@gmail.com> wrote:

>>> You might also take note of the wiki page section titled "Normality
>>> assumption".  That may or may not be relevant to the COLA debates.
>> 
>> Not really... though the idea of a normal distribution was also debated.  A
>> bit of info you might or might not know: you can easily visualize where the
>> standard deviation (sigma) lines should be drawn on a normal distribution...
> 
>> the lines are *always* at the distance from the mean to the inflection point
>> on the curve (where the concavity changes).  I was repeatedly told by the
>> same person the distance was irrelevant:
>> 
>>   cc:
>>     -----
>>     There'se nothing wrong with the image, other than some weird
>>     axis labeling.
>>     -----
>>     Snit's so fucking stupid he thinks the sigma lines are drawn
>>     based on distance from the mean, not area under the curve.
>>     -----
>>     | The sigma lines are drawn based on the area of the curve -
>>     | which is easy to see when the images screw it up, esp. when
>>     | they do so really badly, like in some of the ones I showed
>>     | you.
>>     They are not wrong.
>>     ------
>>     LOL!!!! All of those links are fine. The first sigma lines
>>     cover 68% of the area UNDER THE CURVE.
>>     -----
>>     If you would like to prove, on any single one of the links
>>     you call incorrect, that the first sigma lines do not bound
>>     an area that is 68.2% of the area UNDER THE CURVE, then I
>>     would like to see it.
>>     -----
>>     Hahahaha your "approximate inflection points" are hilarious.
>>     Please, post more on this subject.
>>     ------
>> 
>> I explained to him why he was wrong here: <http://youtu.be/MoW3hMq-eIc>
>> 
>> There are many examples of people who should know better getting this wrong.
>> Here are some
>> 
>> <http://www.udel.edu/htr/Statistics/Images/Class12/normal2.gif> From:
>> <http://www.udel.edu/htr/Statistics/Notes/class12.html>
>> 
>> Which is the example I used for showing how him can make a decent
>> approximation visually: <http://tmp.gallopinginsanity.com/sd.png>.
>> 
>> I also pointed to some other examples which at least appear incorrect to me
>> (though they are not as far off as the above example):
>> 
>> <http://www.footballguys.com/shickstandard_1_files/image009.gif> From:
>> <http://www.footballguys.com/shickstandard_1.htm>
>> Sigma lines clearly not at a far enough distance from the mean, esp. on the
>> graph to the right.
>> 
>> <http://www.gsseser.com/images/StandardDeviation2s.gif> From:
>> <http://www.gsseser.com/Deviation.htm>
>> Sigma lines clearly not at a far enough distance from the mean.
>> 
>> You would think that such sites would be made by people who knew better.  I
>> openly admit I am not a math wiz but it is rather silly when sites claiming
>> to be teaching such things get their depictions wrong (of course, one of the
>> sites above is from "Footballguys"... and you might not expect them, by
>> stereotype, to be the most knowledgeable in such areas anyway).  :)
>> 
>> Anyway, sorry to have the idiotic debate spread to other forums... though it
>> is sorta fun to see people who clearly know what they are talking about rip
>> apart those who were calling me names and insisting they "knew" I was wrong.
>> :)
> 
> Funny how while Steve is throwing a toddler tantrum we have not as of
> yet heard from cc. I wonder how big of a fit he will throw. All I know
> is it is almost sure to be a good show. Goin' off to grab me a beer
> and a big ass bag of popcorn.

Prediction: cc will *never* admit the depictions I linked to above are
clearly wrong.  Never.  He will throw fits and change topics, he will call
me names, he will forge quotes and falsely attribute them to me and to
others, he will insist he is right, he will dodge and dance and play games
to the end of time.

But he will never, ever, under any circumstance admit what has been clear
for a long time but now has even more backing - the above depictions of
sigma lines are *wrong*.  And he will never admit he was ignorant of the
sigma lines being correctly depicted at the inflection points.  Never.  Poor
cc... he is completely predictable in his inability to admit to his own
mistakes.

And Carroll will be right their backing cc's every lie.

I think I will share some of that popcorn with you and watch their show.

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

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