Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!postnews.google.com!5g2000vbf.googlegroups.com!not-for-mail From: Onion Knight Newsgroups: comp.os.linux.advocacy,microsoft.public.excel.programming,comp.apps.spreadsheets,microsoft.public.excel.misc,microsoft.public.excel Subject: Re: Correct process for creating a linear trend line in Excel Date: Fri, 15 Jun 2012 19:54:27 -0700 (PDT) Organization: http://groups.google.com Lines: 34 Message-ID: References: NNTP-Posting-Host: 109.163.233.201 Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Trace: posting.google.com 1339815267 32666 127.0.0.1 (16 Jun 2012 02:54:27 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Sat, 16 Jun 2012 02:54:27 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: 5g2000vbf.googlegroups.com; posting-host=109.163.233.201; posting-account=_0vpWgoAAABd8MtSaoNV-NkL_YvC-Yc_ User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/5.0 (Windows NT 6.1; rv:10.0) Gecko/20100101 Firefox/10.0,gzip(gfe) Xref: csiph.com comp.os.linux.advocacy:114440 comp.apps.spreadsheets:22 On Jun 15, 11:22=A0pm, "joeu2004" wrote: > "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 > > method > >http://tmp.gallopinginsanity.com/LinearTrendLineCreation.mov > [....] > > Does anyone see any missing steps for the creation of a > > linear trend line? > > I cannot find the original debate in comp.os.linux.advocacy (COLA); just = the > thread titled "Visualizing where to draw the standard deviation line", wh= ich > refers to yet-another "a debate in COLA". > > No matter; I'm not interested. =A0I think we can answer your Excel questi= ons > without getting into anything so esoteric. > > I see no missing steps in creating the linear trendline per se using Exce= l. Thank you for your posting of this educated opinion, even though it broke Steve. He is now running around screaming about how I and anyone else who agreed with Snit on this must be Snit's sock puppets. Give it a little time and he will insist you must be Snit as well. This matter is settled. Snit was right to say his process was fine and cc and Carroll who argued against him were wrong. Snit's linear trendline was created without flaw. This was obvious from the start but it is good to get a more educated and impartial stating of it. Fun to watch Steve crumble as he reads it too.