2011-09-24 08:05:22 | Excel help | |

Anne-Marie Blackburn Anne-Marie Blackburn bioluminescence@hotmail.co... 80.42.220.68 |
Ok, this is probably a very stupid question but us bioscientists are not renowned for our statistical prowess: how do you calculate a trend in Excel? I'm reading through Dana's AR4 blog and I've no idea how to calculate the trend in temperatures. I'd be very grateful if someone could point me in the right direction. | |

2011-09-24 08:17:32 | ||

MartinS mstolpe@student.ethz... 93.200.121.71 |
Do you know how do draw a graph with Excel? You can click with your left mouse button on the graph and with your right click on "add trend" (something like that, I am using the german version). Now you can choose what kind of trend (linear or something else) and you can also add the formula of your trend line. Hopefully this helps! | |

2011-09-24 08:38:43 | comment | |

Robert Way robert_way19@hotmail... 134.153.162.53 |
Another way is to use the following function: | |

2011-09-24 09:00:30 | ||

Anne-Marie Blackburn Anne-Marie Blackburn bioluminescence@hotmail.co... 80.42.220.68 |
Thanks Martin - I'd managed to get as far as the trend line but couldn't calculate the trend. I guess I should take the time to learn how to use Excel/Calc/R... Thanks Robert - that did the trick: I got the same results as Dana :) I'll look into the data analysis toolbar - seems like a good thing to add. I'm actually using Calc right now but figured the function would be the same - and it was. Maybe I need to have a proper look at Excel. | |

2011-09-24 10:19:44 | ||

muoncounter Dan Friedman dfriedman3@comcast... 76.30.158.238 |
On the chart's trendline options, you should see checkboxes for show equation and show r^2. You can also force a line to go through (0,0). | |

2011-09-24 13:19:01 | ||

Alex C coultera@umich... 67.194.16.244 |
If you're using the newest version of Excel you want to double click on the trendline, and that should open up an options menu. In the older versions, when you tell it you want a trendline it opened up the menu first, and then you got to select your preferences and make the line based on that. I'm not a big fan of the new setup. | |

2011-09-28 23:08:51 | ||

MarkR Mark Richardson m.t.richardson2@gmail... 192.171.166.133 |
Also look up the LINEST() feature in a how to somewhere. It's my first look port of call normally. :) |