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 | ||
This section does not have any training resources. |
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 | ||
This section does not have any training resources. |