Statistical Guides: Using Excel for Statistics - Tips and Warnings
Available Languages:
Available Languages:
Dated: November 2000
Author: Statistical Services Centre
A booklet aimed at staff working withing research projects, providing information about using Excel for statistical work. Although Excel can be very helpful for data manipulation, summary, tabulation and its graphical capabilities, and has the benefit of being more familiar to the average user, it can result in poor practice if not used optimally, and it is not ideal for more advanced statistical methods such as ANOVA. This guide helps the user understand how and when to make use of Excel within a research project context and contains tips and warnings for avoiding problems.
Taken from the introduction:
"The 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.
[...]
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."
The individual components of the trove are listed below. Click on one to download the file or go to the external url. You can download the full trove below as a .zip file.
Using_Excel_for_Statistics.pdf
353 KB
Guide
Statistical Guides: Approaches to the Analysis of Survey Data
A booklet giving guidance on how to approach the analysis of survey data. "This guide is concerned with some f...
Guide
Statistical Guides: Concepts Underlying the Design of Experiments
A booklet giving guidance on the key concepts of experimental design. "This guide describes the main concepts...
Guide
Statistical Guides: Data Management Guidelines for Experimental Projects
A booklet giving guidance on managing data for research projects. Planning the data management aspects of a pr...
Guide
Statistical Guides: Guidelines for Planning Effective Surveys
A booklet on planning surveys for research. The guide covers planning, when a survey is appr...
Guide
Statistical Guides: Confidence and Significance - Key Concepts of Inferential Statistics
A booklet giving an overview of inferential statistics. This includes concepts such as estimation, hypothesis...
Guide
Statistical Guides: Mixed Models and Multilevel Data Structures in Agriculture
A booklet aiming to help the reader understand what heirarchical data structures are and how they may be analy...
Guide
Statistical Guides: Modern Approaches to the Analysis of Experimental Data
A booklet giving guidance on analysis of data. It discusses the three main parts of the process: relating the...
Guide
Statistical Guides: Modern Methods of Analysis
A booklet which follows on from the guides 'Approaches to the Analysis of Survey Data' and 'Modern Approaches...
