tag:blogger.com,1999:blog-32079676.post7346531817534486871..comments2024-08-18T07:49:23.117-07:00Comments on RRResearch: Praise those who post Excel Tips!Rosie Redfieldhttp://www.blogger.com/profile/06807912674127645263noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-32079676.post-23775626096973439962009-01-21T16:41:00.000-08:002009-01-21T16:41:00.000-08:00Hey Rosie,For what its worth, I posted how to use ...Hey Rosie,<BR/><BR/>For what its worth, I posted how to use linest on the M&I twiki (not accessible outside UBC) http://twiki.microbiology.ubc.ca/twiki/bin/view/Labs/Eltis/CalcLinestExcel<BR/><BR/>"Excel will calculate full statistics for linear regression including slope (m(sub)n - usually n=1), intercept (b), errors of these estimates, coefficient of determination (R^2), degrees of freedom, F stat etc. Doing linear regression using a chart will only show slope, intercept and R^2.<BR/><BR/>In a spreadsheet, type formula =linest([y's],[x's],,true). You need true (or 1) to show all the stats. Hit {enter} (you also need the correct number of comma's). Then, select the cell where you typed the formula, 5 cells down and 2 or more across. Click up on the formula in the formula bar. Hit {F2}, then hit {control}-{shift}-{enter}. This will calculate the formula as an array formula and not just a single cell formula.<BR/><BR/>Go to Excel help for linest for full details of statistics available. "<BR/><BR/>Linest is an array formula, meaning you don't just get one piece of info from this formula, you get all the associated stats as well. Following the info above you will see all then numbers calculated. Search for it in excel help (or on the twiki) to see a picture of what the array calculates.<BR/><BR/>I like showing my array so I can double check things. However, if you know that the SE you are looking for would be in row 2, column 1 of the array, index(linest) will allow you to retrieve just that one piece of data from the array of numbers that are calculated.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-32079676.post-89624405452800281772009-01-09T05:24:00.000-08:002009-01-09T05:24:00.000-08:00Whoo-hoo! Thanks for the tip! I'm just like you wi...Whoo-hoo! Thanks for the tip! I'm just like you with respect to the statistical competence and for a smallish question like this, you've indicated a great resource (and process for getting there, of course).Heatherhttps://www.blogger.com/profile/10816228341555194198noreply@blogger.comtag:blogger.com,1999:blog-32079676.post-17333878352704771352008-12-23T01:13:00.000-08:002008-12-23T01:13:00.000-08:00With an interest in Open Science, I was adding you...With an interest in Open Science, I was adding your blog to my RSS feeds and noticed your excel post here. I'm more of a LabVIEW guy myself, but since I teach a Junior Lab (Physics) course, I've learned a bit about Excel, particularly LINEST (the built in linear regression function). So, thought I'd leave a comment in case you have more questions about LINEST and use of INDEX function. :) <BR/><BR/>PS: You can find our course help page for linear fitting here: http://openwetware.org/wiki/Physics307L:Help/Fitting_a_lineSteve Kochhttps://www.blogger.com/profile/09076719001132389463noreply@blogger.com