![]() ![]() Some errors remained in Excel 2007 for Windows and Excel 2008 for Mac. Microsoft responded to these criticisms and improved statistical calculations beginning with Excel 2003. This was a real problem i.n the past Excel used some poor algorithms for computing statistics which lead to incorrect results ( McCullough, 2005 Knusel, 2005). Use of Excel for statistics is somewhat controversial, and some recommend that Excel not be used for statistics because it is not accurate. While you can do nonlinear regression using Excel's solver, it isn't so easy to set up and the results are not as complete as a program designed to do nonlinear regression (like GraphPad Prism).Īre statistical results from Excel accurate? Another problem is that Excel reports statistical results without all the supporting details other programs provide. It lacks nonparametric tests, post tests following ANOVA, and many others tests. You are not going to get an unbiased answer from a statistical software company! But I would not recommend using Excel for statistics. One problem is that Excel is far from a complete statistics program. ![]() Is Excel complete and easy to use for statistics? The excellent book by Pace (2008) gives many more details (it can be purchased as a printed book, or as a pdf download). Excel has some statistical capabilities, and many also use it to do some statistical calculations. Microsoft Excel is widely used, and is a great program for managing and wrangling data sets. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |