Excel 2016 - Statistical Analysis
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.
You'll learn about:
- Describing data
- Comparing variables
- Tests of significance
- Data Analysis ToolPak
| Tutorial Number | Availability Status | Tutorial Title | Key # | Length | ||
|---|---|---|---|---|---|---|
| 1. | What you'll learn in this training : opens video player dialog | 134744 | 01m:13s | |||
|
|
||||||
| 2. |  |
Finding the arithmetic mean
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online. 
|
134745 | 01m:16s | ||
| 3. | |
AVERAGEA function
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
134746 | 01m:20s | ||
| 4. | |
AVERAGEIF function
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
134747 | 01m:34s | ||
| 5. | |
AVERAGEIFS function
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
134748 | 02m:00s | ||
| 6. | |
Find the geometric mean
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
134749 | 01m:32s | ||
| 7. | |
Find the median
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
134750 | 01m:11s | ||
| 8. | |
Find the mode
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
134751 | 02m:47s | ||
| 9. | |
Find the standard deviation
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
134752 | 02m:33s | ||
| 10. | |
Use the STDEVA functions
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
134753 | 01m:57s | ||
| 11. | |
Find the variance
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
134754 | 01m:42s | ||
| 12. | |
Use the VARA functions
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
134755 | 01m:53s | ||
| 13. | |
Find the kurtosis of a distribution
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
134756 | 02m:01s | ||
| 14. | |
Find the skewness of a distribution
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
134757 | 02m:33s | ||
| 15. | |
Find the confidence interval
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
134758 | 02m:43s | ||
| 16. | |
Use the FREQUENCY function
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
134759 | 01m:12s | ||
| 17. | |
Find the quartile of a data set
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
134760 | 03m:00s | ||
| 18. | |
Ranking values
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
134761 | 03m:02s | ||
| 19. | |
Finding a value's standard score
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
134762 | 01m:24s | ||
| 20. | |
Treating values as text
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
135782 | 02m:18s | ||
| 21. | |
Finding the range of a set of values
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
135783 | 01m:15s | ||
| This section does not have any training resources. | ||||||
| Tutorial Number | Availability Status | Tutorial Title | Key # | Length | |
|---|---|---|---|---|---|
| 1. | |
Find the bivariate correlation coefficient
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
134763 | 01m:49s | |
| 2. | |
Find the values associated with a linear regression
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
134764 | 01m:25s | |
| 3. | |
Find linear slope
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
134765 | 01m:08s | |
| 4. | |
Find the y-intercept of a linear regression
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
134766 | 00m:56s | |
| 5. | |
Predict a future value using an existing value
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
134767 | 01m:31s | |
| 6. | |
TREND function
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
134768 | 01m:51s | |
| 7. | |
Find the values associated with an exponential regression
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
134769 | 01m:58s | |
| 8. | |
Predicting values along an exponential curve using existing values
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
134770 | 01m:39s | |
| 9. | |
Unimodal (MODE.SNGL) vs. multimodal (MODE.MULT)
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
135784 | 03m:21s | |
| 10. | |
Creating a stem and leaf plot
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
135785 | 08m:20s | |
| 11. | |
Creating a frequency distribution for one variable
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
135786 | 02m:26s | |
| 12. | |
Creating a crosstabulation pivot table for one variable
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
135787 | 01m:53s | |
| 13. | |
Creating a pivot chart with a single variable
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
135788 | 01m:18s | |
| This section does not have any training resources. | |||||
| Tutorial Number | Availability Status | Tutorial Title | Key # | Length | |
|---|---|---|---|---|---|
| 1. | |
Finding the probability of a one-tailed Z-Test
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
134771 | 01m:16s | |
| 2. | |
Finding the probability associated with a Student's T-Test for paired samples
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
134772 | 01m:49s | |
| 3. | |
Finding the critical value of the Student's T-Test for paired samples
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
134773 | 01m:00s | |
| 4. | |
Examining data for homogeneity of variance using F-TEST function
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
134774 | 01m:55s | |
| 5. | |
Finding the critical value of the F-test
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
134775 | 01m:40s | |
| 6. | |
Finding the probability associated with a student's T-Test for independent samples
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
134776 | 01m:50s | |
| 7. | |
Finding the critical value of the student's T-Test for independent samples
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
134777 | 01m:03s | |
| 8. | |
Finding the probability associated with a chi-squared test for independence
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
134778 | 01m:17s | |
| 9. | |
Finding the critical value of the chi-squared test for independence
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
134779 | 00m:57s | |
| This section does not have any training resources. | |||||
| Tutorial Number | Availability Status | Tutorial Title | Key # | Length | |
|---|---|---|---|---|---|
| 1. | |
Activating the data analysis ToolPak
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
134780 | 01m:16s | |
| 2. | |
Finding descriptive statistics
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
134781 | 01m:43s | |
| 3. | |
Create a histogram
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
134782 | 01m:37s | |
| 4. | |
Performing a T-test for paired or related samples
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
134783 | 01m:08s | |
| 5. | |
Examining data for homogeneity of variance
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
134784 | 02m:11s | |
| 6. | |
Performing a T-test for independent or unrelated samples
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
134785 | 01m:39s | |
| 7. | |
Performing a one-way analysis of variance (ANOVA)
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
134786 | 01m:51s | |
| 8. | |
Performing a factorial analysis of variance (ANOVA)
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
134787 | 01m:27s | |
| 9. | |
Performing a repeated measures analysis of variance (ANOVA)
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
134788 | 01m:11s | |
| 10. | |
Finding the correlation of two or more variables
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
134789 | 01m:35s | |
| 11. | |
Performing a linear regression
: opens dialog
Beginning of dialog content
Hmmmm. This video seems to be locked.If you believe you should have access, try logging in with your institution’s method of access before launching the video. (Still no luck? Give our support team a shout at 866.259.6890, ext. 8 or cs@hoonuit.com) If you don’t currently have access to Atomic Learning, you can request more information online.
|
134790 | 01m:59s | |
| This section does not have any training resources. | |||||
Share Your Expertise
Have a passion for ed tech? Share it by becoming an eLearning Contributor!
