
Microsoft Excel 2003 for Statistics
by Mark and Elizabeth Clarkson
Start the free chapterMicrosoft 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.
Course content
Introduction2 lessons
Data Validation4 lessons
Statistical Distributions5 lessons
Generating Random Data3 lessons
Probability13 lessons
- Probability Terms & Definitions pt. 16:551 credit or ad
- Probability Terms & Definitions pt. 20:431 credit or ad
- The Laws of Probability4:451 credit or ad
- Computing Independent Probabilities pt. 13:271 credit or ad
- Computing Independent Probabilities pt. 23:051 credit or ad
- Computing Dependent Probabilities5:361 credit or ad
- Selecting a Random Sample: Set Up4:231 credit or ad
- Selecting a Random Sample: Execution4:121 credit or ad
- Sampling from a List pt. 14:021 credit or ad
- Sampling from a List pt. 26:191 credit or ad
- Sampling an Existing Database pt. 13:231 credit or ad
- Sampling an Existing Database pt. 25:311 credit or ad
- Adding Data to an Existing Database3:261 credit or ad
Descriptive Statistics9 lessons
- The Default Histogram3:581 credit or ad
- Improving the Histogram with Custom Bins3:241 credit or ad
- Creating Descriptive Statistics6:351 credit or ad
- Using Inline Functions3:531 credit or ad
- A Histogram of 2006 Restaurant Bills3:271 credit or ad
- Unconfounding The Data pt. 16:181 credit or ad
- Unconfounding The Data pt. 22:201 credit or ad
- The Pareto Chart pt. 14:311 credit or ad
- The Pareto Chart pt. 23:511 credit or ad
Computing Probabilities w/ Distributions8 lessons
- Using the Binomial pt. 13:271 credit or ad
- Using the Binomial pt. 24:271 credit or ad
- Using Compliments3:371 credit or ad
- Using the Poisson4:011 credit or ad
- Building a Histogram5:001 credit or ad
- When to Use the Normal Distribution3:471 credit or ad
- Computing Probabilities with Normdist()3:571 credit or ad
- Norminv() / Normal vs. Poisson4:511 credit or ad
Relationships18 lessons
- Relationships in Anscombe's Data4:341 credit or ad
- The Types of Graphs in Excel3:261 credit or ad
- Pivot Tables & Pivot Charts7:161 credit or ad
- Scatter Diagrams6:001 credit or ad
- Pivot Tables with Multiple Variables6:581 credit or ad
- Pivot Tables & Pivot Charts pt. 12:511 credit or ad
- Pivot Tables & Pivot Charts pt. 25:061 credit or ad
- Chi-Squared: Getting Ready3:471 credit or ad
- Chi-Squared: How Chi-Squared Works5:311 credit or ad
- Chi-Squared: Expected Values6:541 credit or ad
- Chi-Squared: Computing Expected Values5:061 credit or ad
- Chi-Squared: Summarizing the Data7:321 credit or ad
- A 2nd Chi-Squared Test pt. 14:521 credit or ad
- A 2nd Chi-Squared Test pt. 27:011 credit or ad
- Finishing Our 2nd Chi-Squared Test7:271 credit or ad
- Intro to Correlation7:481 credit or ad
- Your First Correlation In Date & Bill5:211 credit or ad
- Computing More Correlations5:501 credit or ad
Graphical analysis8 lessons
- Improving Our Histogram6:161 credit or ad
- Reformatting Our Scatter Chart5:451 credit or ad
- Formatting Axes & Finishing Touches7:311 credit or ad
- Other Chart Options5:441 credit or ad
- Graphing Multiple Variables3:391 credit or ad
- Multiple Variables: The Plot Area4:481 credit or ad
- Multiple Variables: Lines & Ordering5:531 credit or ad
- Multiple Variables: Axes & Titles4:201 credit or ad
Inferential Statistics - Regression16 lessons
- The Trend Line6:391 credit or ad
- R-Squared & the Regression Equation6:391 credit or ad
- Regression: R-Squared & Significance4:281 credit or ad
- Coefficients & Residuals5:321 credit or ad
- Residual & Line Fit Plots4:331 credit or ad
- Making Predictions2:291 credit or ad
- Identifying Data Sets for Regression6:381 credit or ad
- The Pivot Table pt. 14:011 credit or ad
- The Pivot Table pt. 22:491 credit or ad
- Regression by Total Bill3:251 credit or ad
- Regression by Average Bill pt. 12:441 credit or ad
- Regression by Average Bill pt. 22:421 credit or ad
- Regression by Type7:061 credit or ad
- Banquet Estimates2:001 credit or ad
- Estimating Our Error5:051 credit or ad
- Buffet Estimates4:001 credit or ad
Inferential Statistics in ANOVA11 lessons
- t-Test: Setting Up the t-Test5:081 credit or ad
- t-Test: Consulting Our Pivot Table4:421 credit or ad
- t-Test: Running the t-Test6:081 credit or ad
- t-Test: Interpreting the Results3:561 credit or ad
- ANOVA: Introduction2:451 credit or ad
- ANOVA: Preparing the Data3:341 credit or ad
- ANOVA: Running ANOVA & Checking Variances4:111 credit or ad
- ANOVA: Interpreting the Results2:571 credit or ad
- ANOVA: Understanding the Statistics6:111 credit or ad
- Graphing the Confidence Intervals3:271 credit or ad
- Computing the Confidence Intervals5:541 credit or ad
Wrap-up & Review6 lessons
- Data Classes / Validation / Distributions4:161 credit or ad
- Generating Data & Probability Concepts3:381 credit or ad
- Histograms & Descriptive Statistics3:321 credit or ad
- Pivot Tables / Chi-Squared / Correlation3:481 credit or ad
- Improving Graphs & Linear Regression4:021 credit or ad
- t-Test & ANOVA2:281 credit or ad