Path: csiph.com!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!news.musoftware.de!wum.musoftware.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: Snit Newsgroups: comp.os.linux.advocacy,comp.os.ms-windows.apps.misc,microsoft.public.excel.programming,comp.apps.spreadsheets,microsoft.public.excel.misc Subject: Re: Correct process for creating a linear trend line in Excel Date: Mon, 18 Jun 2012 23:16:55 -0700 Lines: 58 Message-ID: References: <0c0f10cd-e98c-4a52-b58d-2e739b7dcd47@8g2000vbu.googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 8bit X-Trace: individual.net sNsi3fgOu1h3c9TdJNcxsAaIBHJdZQL6fSbOT9o2837MZTMmwJ9v95HEMDZhLPCfmL Cancel-Lock: sha1:Jai9jefGsU4OG0mCvwakPkMC7YE= User-Agent: Microsoft-Entourage/12.33.0.120411 Thread-Topic: Correct process for creating a linear trend line in Excel Thread-Index: Ac1N4x/MVmpmifVjokaBFJokH1mKFA== Xref: csiph.com comp.os.linux.advocacy:115174 comp.os.ms-windows.apps.misc:13 comp.apps.spreadsheets:40 On 6/18/12 9:29 PM, in article 0c0f10cd-e98c-4a52-b58d-2e739b7dcd47@8g2000vbu.googlegroups.com, "Onion Knight" wrote: > On Jun 15, 9:16 pm, Onion Knight 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: First half of 2012 - clearly trending down: 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: cc being proved wrong about his stats BS: 7 simple questions cc will *never* answer: cc again pretends to be knowledgeable about things he is clueless about.