Cover image for Doing statistics with Excel for Windows, version 5.0 : an introductory course supplement for explorations in data analysis
Title:
Doing statistics with Excel for Windows, version 5.0 : an introductory course supplement for explorations in data analysis
Personal Author:
Publication Information:
New York : John Wiley & Sons, 1996
Physical Description:
1v + 1 compact disc
ISBN:
9780471148999

Available:*

Library
Item Barcode
Call Number
Material Type
Item Category 1
Status
Searching...
30000005016583 HF1017 P44 1996 Open Access Book Advance Management
Searching...

On Order

Summary

Summary

This user-friendly workbook enables students to see the valuable information in data and provides them with detailed command instructions for using Microsoft Excel to accomplish the desired statistical analysis. Every chapter is designed to allow students to explore a single statistical concept by investigating a data set and consists of a summary of the statistical objective, a problem statement, characteristics of the data set, tutorials and investigative exercises.


Table of Contents

An Introduction to the Workbook
The Basics of Windows
The Basics in Excel for Windows, Version 5.0
Displaying Qualitative Data
Displaying Quantitative Data
Numerical Descriptors
A Study of the Binomial Distribution
A Study of the Normal Distribution
A Study of the Central Limit Theorem
Hypothesis Tests - One Population
Hypothesis Tests - Two Populations
Testing Proportions
Chi-Square Test for Independence
Linear Regression and Correlation
Pulling It All Together