文件名称:Statistics Using Excel Succinctly(SyncFusion,2015)
文件大小:2.59MB
文件格式:PDF
更新时间:2018-04-09 03:16:43
Statistics Excel
Why do Statistics in Excel? There are a number of commonly used, powerful tools for carrying out statistical analyses. The most popular of these are Statistical Package for the Social Sciences (SPSS), Statistical Analysis System (SAS), Stata, Minitab and R. Many people choose to use Excel as their principal analysis tool or as a complement to one of these tools for any of the following reasons: It is widely available and so many people already know how to use it It is not necessary to incur the cost of yet another tool (as some of the popular tools are quite expensive) It is not necessary to learn new methods of manipulating data and drawing graphs It provides numerous built-in statistical functions and data analysis tools It is much easier to see what is going on since, unlike the more commonly used statistical analysis tools, very little is hidden from the user It provides the user with a lot of control and flexibility This makes Excel an ideal tool for quick analyses and even some serious systematic analyses. However, it has two major shortcomings: Many people are not very familiar with the statistical capabilities that are built into Excel Excel was not designed to be a comprehensive statistical package and so many commonly used statistical tests are not provided 12 We will address the first of these shortcomings in this book. We will also give you some techniques for extending the built-in statistical capabilities included in Excel, which partially addresses its second shortcoming. Where Excel provides the statistical analysis capabilities that you need (and, fortunately, many of the most commonly used tests are included in Excel), it is a great tool to use for the reasons previously mentioned. Where it does not, there are a number of software packages which extend Excel’s built-in capabilities. Once such software package is one that I have developed called Real Statistics. You can download it for free here.