Become a member

Online Access to 1000+ Courses!

This Course can only be played using a subscription. You can play only first 3 chapters for free. Click Here to avail a subscription

Microsoft Excel is the world's best-selling mathematical application, one that is installed on nearly every business computer out there. Although not a statistical application, Excel can perform many basic statistical tasks, from computing simple descriptive statistics such as mean and standard deviation, to complex regression analyses, chi-squared and t tests, and Analysis of Variance (ANOVAs). Join Mark and Beth Clarkson as they introduce you to the basics of statistics, statistical analysis, and statistical graphing with Microsoft Excel. Each step along the way is illustrated with real-world situations. You can start learning right now by clicking one of the movie topics below.

Transcription not available

**Course:**Microsoft Excel 2003 for Statistics**Author:**Mark and Elizabeth Clarkson**SKU:**33751**ISBN:**1-933736-73-9**Work Files:**Yes**Captions:**No**Subject:**Business Applications- The first 3 chapters of courses are available to play for FREE (first chapter only for QuickStart! and MasterClass! courses). Just click on the movie link to play a lesson.

US$ 39.00

US$ 79.95

Starting at $30/month

Course outline

Instructors & Overview of Course
(04:50)

Preparing to Enter Data
(03:51)

Validating List Data
(05:11)

Using Custom Warnings
(03:22)

Terms & Concepts
(03:39)

The Normal Distribution
(06:21)

The Binomial Distribution pt. 1
(03:47)

The Binomial Distribution pt. 2
(03:30)

The Poisson Distribution
(02:55)

Poisson & Custom Distributions (05:46)

The Laws of Probability (04:45)

Sampling from a List pt. 1 (04:02)

Sampling from a List pt. 2 (06:19)

The Default Histogram (03:58)

Creating Descriptive Statistics (06:35)

Using Inline Functions (03:53)

Unconfounding The Data pt. 1 (06:18)

Unconfounding The Data pt. 2 (02:20)

The Pareto Chart pt. 1 (04:31)

The Pareto Chart pt. 2 (03:51)

Using the Binomial pt. 1 (03:27)

Using the Binomial pt. 2 (04:27)

Using Compliments (03:37)

Using the Poisson (04:01)

Building a Histogram (05:00)

Norminv() / Normal vs. Poisson (04:51)

Relationships in Anscombe's Data (04:34)

The Types of Graphs in Excel (03:26)

Pivot Tables & Pivot Charts (07:16)

Scatter Diagrams (06:00)

Chi-Squared: Getting Ready (03:47)

Chi-Squared: Expected Values (06:54)

A 2nd Chi-Squared Test pt. 1 (04:52)

A 2nd Chi-Squared Test pt. 2 (07:01)

Intro to Correlation (07:48)

Computing More Correlations (05:50)

Improving Our Histogram (06:16)

Reformatting Our Scatter Chart (05:45)

Other Chart Options (05:44)

Graphing Multiple Variables (03:39)

The Trend Line (06:39)

Coefficients & Residuals (05:32)

Residual & Line Fit Plots (04:33)

Making Predictions (02:29)

The Pivot Table pt. 1 (04:01)

The Pivot Table pt. 2 (02:49)

Regression by Total Bill (03:25)

Regression by Average Bill pt. 1 (02:44)

Regression by Average Bill pt. 2 (02:42)

Regression by Type (07:06)

Banquet Estimates (02:00)

Estimating Our Error (05:05)

Buffet Estimates (04:00)

t-Test: Setting Up the t-Test (05:08)

t-Test: Running the t-Test (06:08)

t-Test: Interpreting the Results (03:56)

ANOVA: Introduction (02:45)

ANOVA: Preparing the Data (03:34)

ANOVA: Interpreting the Results (02:57)

t-Test & ANOVA (02:28)

About the Authors (00:57)