Home |
Search |
Today's Posts |
#1
Posted to comp.os.linux.advocacy,comp.os.ms-windows.apps.misc,microsoft.public.excel.programming,comp.apps.spreadsheets,microsoft.public.excel.misc
|
|||
|
|||
Correct process for creating a linear trend line in Excel
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/Lin...neCreation.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. |
#2
Posted to comp.os.linux.advocacy,comp.os.ms-windows.apps.misc,microsoft.public.excel.programming,comp.apps.spreadsheets,microsoft.public.excel.misc
|
|||
|
|||
Correct process for creating a linear trend line in Excel
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/Lin...neCreation.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. Give it up, Snit Glasser. Nobody here believes that "Onion Knight" is anything but a sock |
#3
Posted to comp.os.ms-windows.apps.misc,microsoft.public.excel.programming,comp.apps.spreadsheets,microsoft.public.excel.misc,microsoft.public.excel
|
|||
|
|||
Correct process for creating a linear trend line in Excel
On Jun 15, 5:22*pm, "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/Lin...neCreation.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", which refers to yet-another "a debate in COLA". No matter; I'm not interested. *I think we can answer your Excel questions without getting into anything so esoteric. I see no missing steps in creating the linear trendline per se using Excel. Given your reply it's pretty evident you realize that the process you undertake depends on what your goal for creating the trend line is and why you'd want to do the steps you mentioned in your reply. Earlier, in another forum, Snit was talking about this and a poster cut right to the chase by asking Snit (based on common sense and what Snit had previously written) the two most obvious questions: "I gather there are two questions he 1) Is the trendline approriately fitted to that data? 2) Is the trendline useful in some way?" Snit's reply: "Not quite: the question was merely if the process of creating the trend line was correct - did it follow the process of creating a linear trend line that is supported by the build in "linear trend line" properties of the program." As you can see, Snit himself explains that his goal was not to see if the "trendline approriately fitted to that data" nor to have the trendline be "useful in some way". Personally I find this rather strange... but Snit's goal was revealed in the same post the above quotes came from... and it's actually even more strange. Notably, Snit wrote about a correlation between Linux UI improvements and an increase in market share (a thing he has been arguing in another newsgroup): "The point, however, was not to predict the future past where I first created the line. I had noted that the desktop Linux distros were clearly focusing on improving their usability - and I predicted that an increase in usability would lead to an increase in users." And this, from the same post: "But the graph was initially made to show that the then-current data fit with my past predictions - not to make any specific prediction about the future (such as that the same level of upward trend would be seen)." Anyone familiar with this topic knows that, regardless of the method he used to create his "past predictions" (or any, for that matter) the data Snit used would not aid in supporting a correlation between UI improvements in Linux and a rise in marketshare because it's the wrong kind of data. We know Snit didn't care if the line fit his data or was useful in any way... if he's going to argue that he didn't produce the line to show evidence of his alleged correlation (a thing he is saying up above... but possibly without realizing it) then one would have to logically ask: What the hell was the purpose of his trend line? |
#4
Posted to comp.os.linux.advocacy,microsoft.public.excel.programming,comp.apps.spreadsheets,microsoft.public.excel.misc,microsoft.public.excel
|
|||
|
|||
Correct process for creating a linear trend line in Excel
On Jun 15, 11:22*pm, "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/Lin...neCreation.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", which refers to yet-another "a debate in COLA". No matter; I'm not interested. *I think we can answer your Excel questions without getting into anything so esoteric. I see no missing steps in creating the linear trendline per se using Excel. 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. |
#5
Posted to comp.os.linux.advocacy,microsoft.public.excel.programming,comp.apps.spreadsheets,microsoft.public.excel.misc,microsoft.public.excel
|
|||
|
|||
Correct process for creating a linear trend line in Excel
On Jun 16, 1:41*am, Steve Carroll wrote:
On Jun 15, 6:11*pm, Foster wrote: On Fri, 15 Jun 2012 16:47:40 -0700, Snit wrote: On 6/15/12 3:44 PM, in article , "Foster" wrote: On Sat, 16 Jun 2012 00:29:39 +0200, Peter K hlmann 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/Lin...neCreation.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. Give it up, Snit Glasser. Nobody here believes that "Onion Knight" is anything but a sock I agree. Too many coincidences. I think the other person who came out of the blue is a sock as well. P.S. I fixed your reply to alt.test back to COLA as well. First: I do not use socks. *I I really don't want to get involved but all I will say is it looks bad from my perspective. End of it. I'm out of the thread. OK, but you'll be missing the best part. Here's an absolutely hilarious exchange that shows how watered down Snit's trend line argument has gotten (to the point where it is now literally non- existent). In some newsgroups he cross-trolled to earlier (in the hopes of getting an appeal to authority so he could claim a win over cc), a poster who knows the topic cut right to the chase: -- "I gather there are two questions he 1) Is the trendline approriately fitted to that data? 2) Is the trendline useful in some way? " -- Snit's outrageous reply is the funniest thing I've seen on usenet in a long time: -- "Not quite: the question was merely if the process of creating the trend line was correct - did it follow the process of creating a linear trend line that is supported by the build in "linear trend line" properties of the program." -- In other words, Snit knew he couldn't bullsh*t this guy so he had to say "Not quite" to the two main reasons for even creating a trend line in the first place! *And the reason he gave is equally as funny... he wanted to "merely" know if his "process" in Excel was "correct" for creating the trend line. Naturally, when you create a trend line you have *some* goals in mind... the goals the poster stated. You can't even talk about the process used to create the trend line until you know what the goals for creating it are. This is just common sense of which Snit obviously has none of... as he tossed those goals aside in an effort to prove he was "right". Too funny ;) This pathetically cross-posted thread only got created because Snit dumped the idea of using people who are good at math because they exposed him. Now he's appealing to people who have used the trend line function in Excel and is, like the post I just showed you, completely dumping the reason for creating it altogether in the hopes of *saving face. You'll notice that he is not pointing out how his goal for creating the trend line is *not* to see if it will be "approriately fitted to that data" or be "useful in some way" (a thing any sane person would assume). Gee, do you think he would have received a different answer had he made that clear? LOL! Snit made the claim that he created a linear trendline and did so correctly. I would love to see where you think Snit said the 2011 trend would continue into 2012, unchanged. His 2011 trendline fit his claims well. His 2012 tendline did not. You say that others "exposed him" on this but he never claimed otherwise. You are just throwing a toddler tantrum because Snit was proved right by people who know a lot more than you. For the last decade or so you have been following him around lying about him because your girlfriend dumped your lying ass and you blamed him. Poor Steve dumped by an insane bitch and unable to get over it. Yes Steve the woman who dumped your lying ass was insane and evil. If you had half a brain you would be celebrating that she left you and not crying about it into the next decade. |
#6
Posted to comp.os.linux.advocacy,microsoft.public.excel.programming,comp.apps.spreadsheets,microsoft.public.excel.misc,microsoft.public.excel
|
|||
|
|||
Correct process for creating a linear trend line in Excel
On Jun 16, 12:45*am, Snit wrote:
On 6/15/12 4:22 PM, in article , "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/Lin...neCreation.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", which refers to yet-another "a debate in COLA". No matter; I'm not interested. *I think we can answer your Excel questions without getting into anything so esoteric. Really the video is all you need to see (I am the one who created it and the other related images with trend lines)... it shows the steps and they match what MS suggests exactly (with the exception that I use the right-click method to get to some tools where the MS page suggests using the Ribbon). I see no missing steps in creating the linear trendline per se using Excel. Thank you. *I think anyone who knows Excel well... or even not so well.... or even poorly but can read the steps provided by MS... can see this. *But someone in COLA kept saying I was missing steps: * cc: * * ------ * * I will gladly educate your ignorant ass, and give you step by * * step instructions on how to correctly do it so you can see * * all your missing steps, but first you have to stop lying. * * ------ * * So you are missing some key steps before doing the trendline. * * I have said that many times now. * * ------ He later said he was in reference to doing more than just creating the trend line, which is all I said I was doing - he claimed I was missing steps to do part of a process I never claimed to do. *Yes: his claims were idiotic. This is the nature of the "advocacy" groups. Bottom line: my steps for creating a linear trend line were flawless, which is not to say creating such a line was the only form of analysis that could be done on such data or that the creation of a linear trend line on data that is clearly not linear is the best way to do an analysis. Using the same steps, though, I was able to show a trend line with a very good fit for the second half of 2011: <http://tmp.gallopinginsanity.com/LinuxTrend2011-2ndhalf.png And also able to show how the trend changed for the first half of 2012: <http://tmp.gallopinginsanity.com/LinuxTrendLine2012.jpg The fact is, a linear trend line is not going to show a very good fit with non-linear data... or data where the trend changes. I would also select the trendline options to display the trendline equation and the R-squared of the trendline. You can see where I did that in the above links... and in others that I made... a whole bunch of them combined: <http://tmp.gallopinginsanity.com/LinuxMultLinearTrendLines.png Even then my labeling is not done well... but my only claim was that I made the linear trend line correctly, not that the graph had good labeling, etc. I openly acknowledge it did not. And after displaying the trendline equation, I might select the option to Format Trendline Label in order to alter the display precision of the coefficients. *I would select Scientific with 14 decimal places if I want to see the trendline coefficients "exactly"; that is, the most precision that Excel will display. Seems a bit excessive for the needs here - but I did know about those options. But none of those "steps" affects how the linear trendline is created. Correct. *Nor do they remove the fact there are other forms of analysis that can be done. FYI, we can also use the Excel function LINEST to determine the regression line coefficients. If the dates are in A1:A24 and the percentages are in B1:B24, select two horizontal cells and array-enter the following formula (press ctrl+shift+Enter instead just Enter): *=LINEST(B1:B24,A1:A24). I have used this function a couple of times... but never for any real work. :) To compare with the "exact" trendline coefficients, I would also format the LINEST results as Scientific with 14 decimal places. You might notice infinitesimal differences between the trendline coefficients and the LINEST results. *But in this case, they are same up 10 or 11 decimal places in this case; "close enough for government work". *As a guess, the difference might be attributed to physically different internal algorithms and/or to differences in internal floating-point arithmetic anomalies. For some insight into how the Excel LINEST and linear trendline coefficients might be derived, seehttp://en.wikipedia.org/wiki/Simple_linear_regression. Note that =COVAR(A1:A24,B1:B24)/VARP(A1:A24) in E3 and =AVERAGE(B1:B24)-E3*AVERAGE(A1:A24) are about the same as the LINEST results. *The difference is in the 3 least-significant binary bits of the floating-point representations in this case. 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 ****ing 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 he <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. :) -- 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. 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. |
#7
Posted to comp.os.linux.advocacy,microsoft.public.excel.programming,comp.apps.spreadsheets,microsoft.public.excel.misc,microsoft.public.excel
|
|||
|
|||
Correct process for creating a linear trend line in Excel
On Jun 16, 12:18*am, Snit wrote:
On 6/15/12 5:11 PM, in article , "Foster" wrote: On Fri, 15 Jun 2012 16:47:40 -0700, Snit wrote: On 6/15/12 3:44 PM, in article , "Foster" wrote: On Sat, 16 Jun 2012 00:29:39 +0200, Peter Köhlmann 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/Lin...neCreation.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. Give it up, Snit Glasser. Nobody here believes that "Onion Knight" is anything but a sock I agree. Too many coincidences. I think the other person who came out of the blue is a sock as well. P.S. I fixed your reply to alt.test back to COLA as well. First: I do not use socks. *I I really don't want to get involved but all I will say is it looks bad from my perspective. End of it. I'm out of the thread. Again: Carroll is lying when he claims Onion Knight is my sock. *There is a reason there is *no* support for his accusation... and a reason he is making the accusation is clear: in addition to his paranoia, he is wanting to change the topic from the fact I was right and he and cc were wrong. But this is the last I will say on the subject unless there is something new added to the subject... you know, like reason or logic or evidence or something of value that would deserve a refutation. *Until then it is just Carroll screaming how Onion Knight and Kaba are both my socks for no reason other than the fact they are, at least mostly, right. -- 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. Steve knows he has been proved wrong so he is now in major attack mode. You and I and anyone else who notes what a lying ass he is will all be seen as the same person. This has been his MO for a decade or more. He is ****ing insane. |
#8
Posted to comp.os.linux.advocacy,microsoft.public.excel.programming,comp.apps.spreadsheets,microsoft.public.excel.misc,microsoft.public.excel
|
|||
|
|||
Correct process for creating a linear trend line in Excel
|
#10
Posted to comp.os.linux.advocacy,microsoft.public.excel.programming,comp.apps.spreadsheets,microsoft.public.excel.misc,microsoft.public.excel
|
|||
|
|||
Correct process for creating a linear trend line in Excel
|
#11
Posted to comp.os.linux.advocacy,microsoft.public.excel.programming,comp.apps.spreadsheets,microsoft.public.excel.misc,microsoft.public.excel
|
|||
|
|||
Correct process for creating a linear trend line in Excel
|
#12
Posted to comp.os.linux.advocacy,comp.apps.spreadsheets,microsoft.public.excel.misc,microsoft.public.excel
|
|||
|
|||
Correct process for creating a linear trend line in Excel
On Jun 17, 1:57*am, Martin Brown
wrote: On 16/06/2012 00:22, 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/Lin...neCreation.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", which refers to yet-another "a debate in COLA". No matter; I'm not interested. I think we can answer your Excel questions without getting into anything so esoteric. I see no missing steps in creating the linear trendline per se using Excel. I would also select the trendline options to display the trendline equation and the R-squared of the trendline. And after displaying the trendline equation, I might select the option to Format Trendline Label in order to alter the display precision of the coefficients. I would select Scientific with 14 decimal places if I want to see the trendline coefficients "exactly"; that is, the most precision that Excel will display. But none of those "steps" affects how the linear trendline is created. FYI, we can also use the Excel function LINEST to determine the regression line coefficients. If the dates are in A1:A24 and the percentages are in B1:B24, select two horizontal cells and array-enter the following formula (press ctrl+shift+Enter instead just Enter): =LINEST(B1:B24,A1:A24). To compare with the "exact" trendline coefficients, I would also format the LINEST results as Scientific with 14 decimal places. You might notice infinitesimal differences between the trendline coefficients and the LINEST results. But in this case, they are same up 10 or 11 decimal places in this case; "close enough for government work". As a guess, the difference might be attributed to physically different internal algorithms and/or to differences in internal floating-point arithmetic anomalies. The difference is that (apart from in some very early versions of XL2007 where the graph regression function was wrecked to make it agree with another well known products answers) the linear regression on XL charts uses a well designed algorithm that gives a very good approximation to the true least squares parameter fit to data. LINEST is demonstrably numerically unstable although it requires at least a 3rd order polynomial fit and moderately hostile data to break it. Examples have been posted here or in another m.p.e group previously. (some years back) For linear fits the two are more or less interchangable but for higher orders of polynomial the chart function fit is more accurate. For some insight into how the Excel LINEST and linear trendline coefficients might be derived, see http://en.wikipedia.org/wiki/Simple_linear_regression. Note that =COVAR(A1:A24,B1:B24)/VARP(A1:A24) in E3 and =AVERAGE(B1:B24)-E3*AVERAGE(A1:A24) are about the same as the LINEST results. The difference is in the 3 least-significant binary bits of the floating-point representations in this case. You might also take note of the wiki page section titled "Normality assumption". That may or may not be relevant to the COLA debates. What is COLA? The newsgroup where the troll Snit and his sock puppet Onion Knight are lying and trolling with this topic. |
#13
Posted to comp.os.linux.advocacy,comp.apps.spreadsheets,microsoft.public.excel.misc,microsoft.public.excel
|
|||
|
|||
Correct process for creating a linear trend line in Excel
On Jun 17, 4:18*pm, Steve Carroll wrote:
On Jun 17, 1:57*am, Martin Brown wrote: On 16/06/2012 00:22, 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/Lin...neCreation.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", which refers to yet-another "a debate in COLA". No matter; I'm not interested. I think we can answer your Excel questions without getting into anything so esoteric. I see no missing steps in creating the linear trendline per se using Excel. I would also select the trendline options to display the trendline equation and the R-squared of the trendline. And after displaying the trendline equation, I might select the option to Format Trendline Label in order to alter the display precision of the coefficients. I would select Scientific with 14 decimal places if I want to see the trendline coefficients "exactly"; that is, the most precision that Excel will display. But none of those "steps" affects how the linear trendline is created.. FYI, we can also use the Excel function LINEST to determine the regression line coefficients. If the dates are in A1:A24 and the percentages are in B1:B24, select two horizontal cells and array-enter the following formula (press ctrl+shift+Enter instead just Enter): =LINEST(B1:B24,A1:A24). To compare with the "exact" trendline coefficients, I would also format the LINEST results as Scientific with 14 decimal places. You might notice infinitesimal differences between the trendline coefficients and the LINEST results. But in this case, they are same up 10 or 11 decimal places in this case; "close enough for government work". As a guess, the difference might be attributed to physically different internal algorithms and/or to differences in internal floating-point arithmetic anomalies. The difference is that (apart from in some very early versions of XL2007 where the graph regression function was wrecked to make it agree with another well known products answers) the linear regression on XL charts uses a well designed algorithm that gives a very good approximation to the true least squares parameter fit to data. LINEST is demonstrably numerically unstable although it requires at least a 3rd order polynomial fit and moderately hostile data to break it. Examples have been posted here or in another m.p.e group previously. (some years back) For linear fits the two are more or less interchangable but for higher orders of polynomial the chart function fit is more accurate. For some insight into how the Excel LINEST and linear trendline coefficients might be derived, see http://en.wikipedia.org/wiki/Simple_linear_regression. Note that =COVAR(A1:A24,B1:B24)/VARP(A1:A24) in E3 and =AVERAGE(B1:B24)-E3*AVERAGE(A1:A24) are about the same as the LINEST results. The difference is in the 3 least-significant binary bits of the floating-point representations in this case. You might also take note of the wiki page section titled "Normality assumption". That may or may not be relevant to the COLA debates. What is COLA? The newsgroup where the troll Snit and his sock puppet Onion Knight are lying and trolling with this topic. What names have you used on Usenet, Steve? How many? Can you even list them all? No. You can't. You think everyone is like you and is using socks. As far as trolling that is you. Snit noted he created a linear trendline correctly using a process exactly as Microsoft describes. He proved this with a video where he showed his process and it was exactly correct. Your sock puppet CC claimed Snit missed steps and you agreed wit your sock puppet. What a surprise. While I have not been on usenet for a long time I used to post to the mac advocacy group years ago under a different name. Even then you were using several sock puppets to troll Snit because you blamed him for your girlfriend dumping you. That was about 10 years ago and you have never stopped attacking him and lying about him. When I came in to say Snit was right about his method of making a linear trendline in Excel you attacked me both in usenet and by emailing me repeatedly until I forwarded your emails to your ISP and then you stopped. On the original debate you can see the answer above by joeu2004, 'I see no missing steps in creating the linear trendline per se using Excel.' You and your sock puppet were wrong. Snit did not skip steps as you claimed. That was all this thread was about and you turned it into another of your avenues of attack and trolling because you could not handle the fact you were proved wrong in both your Steve name and your sock CC name. In short: go **** yourself you trolling asshole. |
#14
Posted to comp.os.linux.advocacy,comp.apps.spreadsheets,microsoft.public.excel.misc,microsoft.public.excel
|
|||
|
|||
Correct process for creating a linear trend line in Excel
On Jun 17, 11:23*am, Onion Knight wrote:
On Jun 17, 4:18*pm, Steve Carroll wrote: On Jun 17, 1:57*am, Martin Brown wrote: On 16/06/2012 00:22, 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/Lin...neCreation.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", which refers to yet-another "a debate in COLA". No matter; I'm not interested. I think we can answer your Excel questions without getting into anything so esoteric. I see no missing steps in creating the linear trendline per se using Excel. I would also select the trendline options to display the trendline equation and the R-squared of the trendline. And after displaying the trendline equation, I might select the option to Format Trendline Label in order to alter the display precision of the coefficients. I would select Scientific with 14 decimal places if I want to see the trendline coefficients "exactly"; that is, the most precision that Excel will display. But none of those "steps" affects how the linear trendline is created. FYI, we can also use the Excel function LINEST to determine the regression line coefficients. If the dates are in A1:A24 and the percentages are in B1:B24, select two horizontal cells and array-enter the following formula (press ctrl+shift+Enter instead just Enter): =LINEST(B1:B24,A1:A24). To compare with the "exact" trendline coefficients, I would also format the LINEST results as Scientific with 14 decimal places. You might notice infinitesimal differences between the trendline coefficients and the LINEST results. But in this case, they are same up 10 or 11 decimal places in this case; "close enough for government work". As a guess, the difference might be attributed to physically different internal algorithms and/or to differences in internal floating-point arithmetic anomalies. The difference is that (apart from in some very early versions of XL2007 where the graph regression function was wrecked to make it agree with another well known products answers) the linear regression on XL charts uses a well designed algorithm that gives a very good approximation to the true least squares parameter fit to data. LINEST is demonstrably numerically unstable although it requires at least a 3rd order polynomial fit and moderately hostile data to break it. Examples have been posted here or in another m.p.e group previously. (some years back) For linear fits the two are more or less interchangable but for higher orders of polynomial the chart function fit is more accurate. For some insight into how the Excel LINEST and linear trendline coefficients might be derived, see http://en.wikipedia.org/wiki/Simple_linear_regression. Note that =COVAR(A1:A24,B1:B24)/VARP(A1:A24) in E3 and =AVERAGE(B1:B24)-E3*AVERAGE(A1:A24) are about the same as the LINEST results. The difference is in the 3 least-significant binary bits of the floating-point representations in this case. You might also take note of the wiki page section titled "Normality assumption". That may or may not be relevant to the COLA debates. What is COLA? The newsgroup where the troll Snit and his sock puppet Onion Knight are lying and trolling with this topic. What names have you used on Usenet, Steve? See what I mean about your trolling? Hint: People just aren't as stupid as you need them to be. https://groups.google.com/group/comp...8fd0b61d327d78 (snip more lies/trolling) |
#15
Posted to comp.os.linux.advocacy,comp.apps.spreadsheets,microsoft.public.excel.misc,microsoft.public.excel
|
|||
|
|||
Correct process for creating a linear trend line in Excel
|
#16
Posted to comp.os.linux.advocacy,microsoft.public.excel.programming,comp.apps.spreadsheets,microsoft.public.excel.misc,microsoft.public.excel
|
|||
|
|||
Correct process for creating a linear trend line in Excel
On Jun 15, 9:03*pm, Onion Knight wrote:
On Jun 16, 12:45*am, Snit wrote: On 6/15/12 4:22 PM, in article , "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/Lin...neCreation.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", which refers to yet-another "a debate in COLA". No matter; I'm not interested. *I think we can answer your Excel questions without getting into anything so esoteric. Really the video is all you need to see (I am the one who created it and the other related images with trend lines)... it shows the steps and they match what MS suggests exactly (with the exception that I use the right-click method to get to some tools where the MS page suggests using the Ribbon). I see no missing steps in creating the linear trendline per se using Excel. Thank you. *I think anyone who knows Excel well... or even not so well... or even poorly but can read the steps provided by MS... can see this. *But someone in COLA kept saying I was missing steps: * cc: * * ------ * * I will gladly educate your ignorant ass, and give you step by * * step instructions on how to correctly do it so you can see * * all your missing steps, but first you have to stop lying. * * ------ * * So you are missing some key steps before doing the trendline. * * I have said that many times now. * * ------ He later said he was in reference to doing more than just creating the trend line, which is all I said I was doing - he claimed I was missing steps to do part of a process I never claimed to do. *Yes: his claims were idiotic. This is the nature of the "advocacy" groups. Bottom line: my steps for creating a linear trend line were flawless, which is not to say creating such a line was the only form of analysis that could be done on such data or that the creation of a linear trend line on data that is clearly not linear is the best way to do an analysis. Using the same steps, though, I was able to show a trend line with a very good fit for the second half of 2011: <http://tmp.gallopinginsanity.com/LinuxTrend2011-2ndhalf.png And also able to show how the trend changed for the first half of 2012: <http://tmp.gallopinginsanity.com/LinuxTrendLine2012.jpg The fact is, a linear trend line is not going to show a very good fit with non-linear data... or data where the trend changes. I would also select the trendline options to display the trendline equation and the R-squared of the trendline. You can see where I did that in the above links... and in others that I made... a whole bunch of them combined: <http://tmp.gallopinginsanity.com/LinuxMultLinearTrendLines.png Even then my labeling is not done well... but my only claim was that I made the linear trend line correctly, not that the graph had good labeling, etc. I openly acknowledge it did not. And after displaying the trendline equation, I might select the option to Format Trendline Label in order to alter the display precision of the coefficients. *I would select Scientific with 14 decimal places if I want to see the trendline coefficients "exactly"; that is, the most precision that Excel will display. Seems a bit excessive for the needs here - but I did know about those options. But none of those "steps" affects how the linear trendline is created.. Correct. *Nor do they remove the fact there are other forms of analysis that can be done. FYI, we can also use the Excel function LINEST to determine the regression line coefficients. If the dates are in A1:A24 and the percentages are in B1:B24, select two horizontal cells and array-enter the following formula (press ctrl+shift+Enter instead just Enter): *=LINEST(B1:B24,A1:A24). I have used this function a couple of times... but never for any real work. :) To compare with the "exact" trendline coefficients, I would also format the LINEST results as Scientific with 14 decimal places. You might notice infinitesimal differences between the trendline coefficients and the LINEST results. *But in this case, they are same up 10 or 11 decimal places in this case; "close enough for government work".. *As a guess, the difference might be attributed to physically different internal algorithms and/or to differences in internal floating-point arithmetic anomalies. For some insight into how the Excel LINEST and linear trendline coefficients might be derived, seehttp://en.wikipedia.org/wiki/Simple_linear_regression. Note that =COVAR(A1:A24,B1:B24)/VARP(A1:A24) in E3 and =AVERAGE(B1:B24)-E3*AVERAGE(A1:A24) are about the same as the LINEST results. *The difference is in the 3 least-significant binary bits of the floating-point representations in this case. 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 ****ing 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 he <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. :) -- 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.. Funny how while Steve is throwing a toddler tantrum The tantrum is all Snit's... here is what he was originally arguing before he realized his stepped on his d*ck: https://groups.google.com/group/comp...d65e9dcec15bd2 |
#17
Posted to comp.os.linux.advocacy,microsoft.public.excel.programming,comp.apps.spreadsheets,microsoft.public.excel.misc,microsoft.public.excel
|
|||
|
|||
Correct process for creating a linear trend line in Excel
On Jun 18, 7:09*pm, Steve Carroll wrote:
On Jun 15, 9:03*pm, Onion Knight wrote: On Jun 16, wrote: On 6/15/12 4:22 PM, in article , "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/Lin...neCreation.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", which refers to yet-another "a debate in COLA". No matter; I'm not interested. *I think we can answer your Excel questions without getting into anything so esoteric. Really the video is all you need to see (I am the one who created it and the other related images with trend lines)... it shows the steps and they match what MS suggests exactly (with the exception that I use the right-click method to get to some tools where the MS page suggests using the Ribbon). I see no missing steps in creating the linear trendline per se using Excel. Thank you. *I think anyone who knows Excel well... or even not so well... or even poorly but can read the steps provided by MS... can see this. *But someone in COLA kept saying I was missing steps: * cc: * * ------ * * I will gladly educate your ignorant ass, and give you step by * * step instructions on how to correctly do it so you can see * * all your missing steps, but first you have to stop lying. * * ------ * * So you are missing some key steps before doing the trendline. * * I have said that many times now. * * ------ He later said he was in reference to doing more than just creating the trend line, which is all I said I was doing - he claimed I was missing steps to do part of a process I never claimed to do. *Yes: his claims were idiotic. This is the nature of the "advocacy" groups. Bottom line: my steps for creating a linear trend line were flawless, which is not to say creating such a line was the only form of analysis that could be done on such data or that the creation of a linear trend line on data that is clearly not linear is the best way to do an analysis. Using the same steps, though, I was able to show a trend line with a very good fit for the second half of 2011: <http://tmp.gallopinginsanity.com/LinuxTrend2011-2ndhalf.png And also able to show how the trend changed for the first half of 2012: <http://tmp.gallopinginsanity.com/LinuxTrendLine2012.jpg The fact is, a linear trend line is not going to show a very good fit with non-linear data... or data where the trend changes. I would also select the trendline options to display the trendline equation and the R-squared of the trendline. You can see where I did that in the above links... and in others that I made... a whole bunch of them combined: <http://tmp.gallopinginsanity.com/LinuxMultLinearTrendLines.png Even then my labeling is not done well... but my only claim was that I made the linear trend line correctly, not that the graph had good labeling, etc. I openly acknowledge it did not. And after displaying the trendline equation, I might select the option to Format Trendline Label in order to alter the display precision of the coefficients. *I would select Scientific with 14 decimal places if I want to see the trendline coefficients "exactly"; that is, the most precision that Excel will display. Seems a bit excessive for the needs here - but I did know about those options. But none of those "steps" affects how the linear trendline is created. Correct. *Nor do they remove the fact there are other forms of analysis that can be done. FYI, we can also use the Excel function LINEST to determine the regression line coefficients. If the dates are in A1:A24 and the percentages are in B1:B24, select two horizontal cells and array-enter the following formula (press ctrl+shift+Enter instead just Enter): *=LINEST(B1:B24,A1:A24). I have used this function a couple of times... but never for any real work. :) To compare with the "exact" trendline coefficients, I would also format the LINEST results as Scientific with 14 decimal places. You might notice infinitesimal differences between the trendline coefficients and the LINEST results. *But in this case, they are same up 10 or 11 decimal places in this case; "close enough for government work". *As a guess, the difference might be attributed to physically different internal algorithms and/or to differences in internal floating-point arithmetic anomalies. For some insight into how the Excel LINEST and linear trendline coefficients might be derived, seehttp://en.wikipedia.org/wiki/Simple_linear_regression. Note that =COVAR(A1:A24,B1:B24)/VARP(A1:A24) in E3 and =AVERAGE(B1:B24)-E3*AVERAGE(A1:A24) are about the same as the LINEST results. *The difference is in the 3 least-significant binary bits of the floating-point representations in this case. 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'sso ****ing 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 he <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. :) -- 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. Funny how while Steve is throwing a toddler tantrum The tantrum is allSnit's... here is what he was originally arguing before he realized his stepped on his d*ck: https://groups.google.com/group/comp...msg/edd65e9dce... Funny how you keep trolling Snit but can't show where he was wrong in any place he did not point out. |
#18
Posted to comp.os.linux.advocacy,comp.os.ms-windows.apps.misc,microsoft.public.excel.programming,comp.apps.spreadsheets,microsoft.public.excel.misc
|
|||
|
|||
Correct process for creating a linear trend line in Excel
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 ****ed up he could not even see the change in the trend and thought the data was at flaw when it was his own process. |
#19
Posted to comp.os.linux.advocacy,microsoft.public.excel.programming,comp.apps.spreadsheets,microsoft.public.excel.misc,microsoft.public.excel
|
|||
|
|||
Correct process for creating a linear trend line in Excel
On Jun 15, 11:22*pm, "joeu2004" wrote:
I see no missing steps in creating the linear trendline per se using Excel. Thank you for your assistance. CC has since admitted that he ****ed up his process and thought the data that showed the change in trends from 2011 to 2012 was bad data. He has now admitted he can't show this and that Snit was right. Your input was helpful in leading CC to this obvious conclusion. Meanwhile Steve is using a so many socks he has admitted he can't list them all. Turns out both pretty much knew they were talking out their asses and that Snit was right all along. |
#20
Posted to comp.os.linux.advocacy,microsoft.public.excel.programming,comp.apps.spreadsheets,microsoft.public.excel.misc,microsoft.public.excel
|
|||
|
|||
Correct process for creating a linear trend line in Excel
On 6/18/12 9:16 PM, in article
, "Onion Knight" wrote: The tantrum is allSnit's... here is what he was originally arguing before he realized his stepped on his d*ck: https://groups.google.com/group/comp...msg/edd65e9dce... Funny how you keep trolling Snit but can't show where he was wrong in any place he did not point out. I have repeatedly proved Carroll and his sock cc wrong: 1) cc was wrong to say I missed steps in the creation of a linear trend line in Excel. I did no such thing. 2) cc was wrong to claim the incorrect depictions I showed him of sigma lines were, in fact, incorrect. But they were. 3) cc was wrong to say I was pushing the correlations I noted as being proof of the causation I had spoken of earlier. I did no such thing. 4) cc was wrong to deny the fact that on a depiction of a normal distribution you can visually see where the sigma lines should be drawn based on the distance from the mean (specifically, the distance from the mean to the inflection points). 5) cc was wrong to deny I showed an upward trend in Linux usage, based on the data we were both using. The upward trend was in the latter half of 2011: <http://goo.gl/NhFuK. There is no reasoned debate about any of these facts... but Carroll and cc cannot just let it go and will never admit to their errors. -- 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. |
#21
Posted to comp.os.linux.advocacy,comp.os.ms-windows.apps.misc,microsoft.public.excel.programming,comp.apps.spreadsheets,microsoft.public.excel.misc
|
|||
|
|||
Correct process for creating a linear trend line in Excel
|
#22
Posted to comp.os.linux.advocacy,microsoft.public.excel.programming,comp.apps.spreadsheets,microsoft.public.excel.misc,microsoft.public.excel
|
|||
|
|||
Correct process for creating a linear trend line in Excel
|
#23
Posted to comp.os.linux.advocacy,microsoft.public.excel.programming,comp.apps.spreadsheets,microsoft.public.excel.misc,microsoft.public.excel
|
|||
|
|||
Correct process for creating a linear trend line in Excel
On Jun 19, 12:03*am, Snit wrote:
On 6/18/12 9:16 PM, in article , "Onion Knight" wrote: The tantrum is allSnit's... here is what he was originally arguing before he realized his stepped on his d*ck: https://groups.google.com/group/comp...msg/edd65e9dce.... Funny how you keep trolling Snit but can't show where he was wrong in any place he did not point out. I have repeatedly proved Nothing. Reality shows that Snit you sought outside help and a poster named kaba responded with: "I gather there are two questions he 1) Is the trendline approriately fitted to that data? 2) Is the trendline useful in some way? " - kaba Logical questions by kaba... and, of course, they highlight the 2 most important reasons for even bothering to create a trend line at all. Snit then dishonestly changed his claimed reason for creating his trend line to a ridiculous reason: "Not quite: the question was merely if the process of creating the trend line was correct - did it follow the process of creating a linear trend line that is supported by the build in "linear trend line" properties of the program." - Snit Anyone can see that when Snit abandoned the statistical goals for his trend line he effectively killed his statistical argument. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a linear trend line in Excel | Charts and Charting in Excel | |||
Excel trend line equation does not generate correct results | Excel Discussion (Misc queries) | |||
Problem creating a logarithmic trend line | Charts and Charting in Excel | |||
Extracting Constant from Non-linear Trend line | Charts and Charting in Excel | |||
How do I anchor one end of a linear trend line? | Charts and Charting in Excel |