Groups | Search | Server Info | Login | Register

Groups > comp.os.ms-windows.apps.misc > #13

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

Cross-posted to 5 groups.

Show all headers | View raw

On 6/18/12 9:29 PM, in article
0c0f10cd-e98c-4a52-b58d-2e739b7dcd47@8g2000vbu.googlegroups.com, "Onion
Knight" <onionknightgot@gmail.com> wrote:

> On Jun 15, 9:16 pm, 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
>> methodhttp://tmp.gallopinginsanity.com/LinearTrendLineCreation.mov
>> 
>> A couple of other people in the group say that the video skips a
>> number of steps but when I look at the directions from Microsoft I do
>> not see any they could be referring to.
>> 
>> Does anyone see any missing steps for the creation of a linear trend
>> line? I admit this is a bit over my head so any input would be welcome.
> 
> Thank you to all who responded. The answer is now clear and Snit made
> his trend lines correctly. They showed an increase in Linux usage in
> 2011 and a decrease in 2012. CC has now admitted his process was so
> fucked up he could not even see the change in the trend and thought
> the data was at flaw when it was his own process.

Exactly correct: cc ending up claiming the data he asked us to use was wrong
and admitted he missed the trends I was able to show.  He incorrectly
thought that his ability to get a higher R^2 value somehow proved that some
of the data points were wrong... he could not accept that the trend changed,
even though it was easy to see it did:

Second half of 2011 - clearly trending up:
<http://tmp.gallopinginsanity.com/LinuxTrend2011-2ndhalf.png>

First half of 2012 - clearly trending down:
<http://tmp.gallopinginsanity.com/LinuxTrendLine2012.jpg>

cc screwed up his analysis and missed this... though he was also
inconsistent with his claims about this:

  cc #1:
    -----
    It will be 1%.  Same as it ever was.
    -----
  cc #2:
    -----
    Linux has been on a significant downward trend since then.
    -----
    And if you look at January and then look at now, then there
    is a downward trend.
    -----

It is not possible for both of his claims to be correct, of course.

-- 
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.ms-windows.apps.misc | Previous | Next — Previous 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 "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 Steve Carroll <fretwizzer@gmail.com> - 2012-06-15 18:39 -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 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