Excel 2016 - Statistical Analysis :opens video dialog

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

Try out the unlocked free sample tutorials below, or learn more about subscription options.

A. Describing Data

Tutorial Number	Availability Status	Tutorial Title	Key #	Length
1.	Unplayed movie	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	135783	01m:15s
This section does not have any training resources.

B. Comparing Variables

Tutorial Number	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	135788	01m:18s
This section does not have any training resources.

C. Tests of Significance

Tutorial Number	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	134779	00m:57s
This section does not have any training resources.

D. Data Analysis ToolPak

Tutorial Number	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	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@AtomicLearning.com) If you don’t currently have access to Atomic Learning, you can request more information online. End of dialog content	134790	01m:59s
This section does not have any training resources.

Excel 2016 - Statistical Analysis - Assessments

1.	Excel 2016 - Statistical Analysis Section A Assessment	5589A
2.	Excel 2016 - Statistical Analysis Section B Assessment	5589B
3.	Excel 2016 - Statistical Analysis Section C Assessment	5589C
4.	Excel 2016 - Statistical Analysis Section D Assessment	5589D

Tutorial series by Dan Fanella, PhD

Microsoft and Excel are trademarks of Microsoft, registered in the United States and other countries.

Preview Easy Links

Get Easy Links HTML

Create Easy Links

Excel 2016 - Statistical Analysis :opens video dialog

Preview Easy Links

Get Easy Links HTML

Create Easy Links

Share the Learning!

Excel 2016 - Statistical Analysis :opens video dialog

Share Your Expertise