Platform: PC

Microsoft^{®} Excel^{®} boasts a robust collection of statistical functions. This online training series will demonstrate some of these functions from the simple to the complex, as well as how to perform more complex analysis by activating Excel's Data Analysis ToolPak.

Tutorial Number | Availability Status | Tutorial Title | Key # | Length |
---|---|---|---|---|

1. | Finding the bivariate correlation coefficient : opens dialog | 91484 | 00m:59s | |

2. | Finding the values associated with a linear regression : opens dialog | 91485 | 01m:38s | |

3. | Finding linear slope : opens dialog | 91486 | 00m:57s | |

4. | Finding the y-intercept of a linear regression : opens dialog | 91487 | 00m:51s | |

5. | Predicting a future value using an existing value : opens dialog | 91488 | 01m:13s | |

6. | Using the TREND function : opens dialog | 91489 | 01m:32s | |

7. | Finding the values associated with an exponential regression : opens dialog | 91490 | 01m:30s | |

8. | Predicting values along an exponential curve using existing values : opens dialog | 91491 | 01m:29s |

Tutorial Number | Availability Status | Tutorial Title | Key # | Length |
---|---|---|---|---|

1. | Finding the probability of a one-tailed Z-Test : opens dialog | 91492 | 01m:32s | |

2. | Finding the probability associated with a Student's T-Test for paired samples : opens dialog | 91493 | 01m:45s | |

3. | Finding the critical value of the Student's T-Test for paired samples : opens dialog | 91494 | 01m:14s | |

4. | Examining data for homogeneity of variance using the F.TEST function : opens dialog | 91495 | 01m:42s | |

5. | Finding the critical value of the F-Test : opens dialog | 91496 | 01m:34s | |

6. | Finding the probability associated with a Student's T-Test for independent samples : opens dialog | 91497 | 02m:02s | |

7. | Finding the critical value of the Student's T-Test for independent samples : opens dialog | 91498 | 01m:19s | |

8. | Finding the probability associated with a chi-squared test for independence : opens dialog | 91499 | 01m:17s | |

9. | Finding the critical value of the chi-squared test for independence : opens dialog | 91511 | 01m:27s |

Tutorial Number | Availability Status | Tutorial Title | Key # | Length |
---|---|---|---|---|

1. | Activating the Data Analysis ToolPak : opens dialog | 91500 | 00m:55s | |

2. | Finding descriptive statistics : opens dialog | 91501 | 01m:18s | |

3. | Creating a histogram : opens dialog | 91502 | 01m:17s | |

4. | Performing a t-test for paired, or related samples : opens dialog | 91503 | 01m:23s | |

5. | Examining data for homogeneity of variance : opens dialog | 91504 | 01m:19s | |

6. | Performing a t-test for independent, or unrelated, samples : opens dialog | 91505 | 01m:28s | |

7. | Performing a one-way analysis of variance (ANOVA) : opens dialog | 91506 | 01m:15s | |

8. | Performing a factorial analysis of variance (ANOVA) : opens dialog | 91507 | 01m:11s | |

9. | Performing a repeated measures analysis of variance (ANOVA) : opens dialog | 91508 | 01m:09s | |

10. | Finding the correlation coefficient of two or more variables : opens dialog | 91509 | 01m:07s | |

11. | Performing a linear regression : opens dialog | 91510 | 01m:10s |