Using Excel for Statistics Tips and Warnings
Monday, July 5th, 2010The availability of spreadsheets that include facilities for data management and
statistical analysis has changed the way people manage their information. Their
power and ease of use have given new opportunities for data analysis, but they have
also brought new problems and challenges for the user.
Excel is widely used for the entry and management of data. Some points are given in
this guide, but these topics are covered in more detail in a companion document,
entitled “The Disciplined Use of Spreadsheets for Data Entry”
In this guide we point out strengths, and weaknesses, when using Excel for statistical
tasks. We include data management, descriptive statistics, pivot tables, probability
distributions, hypothesis tests, analysis of variance and regression. We give the
salient points as tips and warnings. For those who need more than Excel we list some
of the ways that users can add to its facilities, or use Excel in combination with other
software. Finally we give our conclusions about the use of Excel for statistical work.
Tips for using Excel
Monday, July 5th, 2010Read this pdf file for more Tips for using Excel
Pdf Panda - We always provide latest fresh pdf ebook for you
