Statistical Analysis with Excel View a tutorial on this topic

Platform: PC

Description

Microsoft® Excel, the powerful spreadsheet application, boasts a robust set of statistical functions. This tutorial series will guide you through each of those basic functions and demonstrate how you can perform more complex analysis by activating the Data Analysis ToolPak.
Click here to learn about subscribing to this collection!
Click any of the highlighted titles to view free sample tutorial movies. Atomic Training subscribers to this collection have access to all of the following movies, plus thousands of tutorials on other applications.
Key # Length
1. preview Finding the arithmetic mean 76169 1:15
2. preview Using the AVERAGEA function 76170 0:52
3. locked Using the AVERAGEIF function 76171 1:34
4. locked Using the AVERAGEIFS function 76172 1:19
5. locked Finding the geometric mean 76173 0:31
6. locked Finding the median 76174 0:39
7. locked Finding the mode 76175 1:10
8. locked Finding the standard deviation 76176 0:50
9. locked Using the STDEVA functions 76177 1:06
10. locked Finding the variance 76178 0:55
11. locked Using the VARA functions 76179 1:04
12. locked Finding the kurtosis of a distribution 76180 0:53
13. locked Finding the skewness of a distribution 76181 0:32
14. locked Finding the confidence interval 76182 0:53
15. locked Using the FREQUENCY function 76183 0:58
16. locked Finding the five number summary 76184 1:03
17. locked Ranking values without ties 76185 1:11
18. locked Ranking values with ties present 76186 0:56
19. locked Finding a value’s standard score 76187 0:37
Key # Length
1. locked Finding the bivariate correlation coefficient 76188 0:43
2. locked Finding the values associated with a linear regression 76189 1:20
3. locked Finding linear slope 76190 0:43
4. locked Finding the y-intercept of a linear regression 76191 0:41
5. locked Predicting a future value using an existing value 76192 0:46
6. locked Using the TREND function 76193 1:18
7. locked Finding the values associated with an exponential regression 76194 1:16
8. locked Predicting values along an exponential curve using existing values 76195 1:17
Key # Length
1. locked Finding the probability of a one-tailed z-test 76196 0:48
2. locked Finding the probability associated with a Student's t-test for paired samples 76197 0:59
3. locked Finding the critical value of the Student's t-test for paired samples 76198 0:38
4. locked Examining data for homogeneity of variance using the FTEST function 76199 1:09
5. locked Finding the critical value of the FTEST 76200 0:56
6. locked Finding the probability associated with a Student's t-test for independent samples 76201 1:14
7. locked Finding the critical value of the Student's t-test for independent samples 76202 0:36
8. locked Finding the probability associated with a chi-squared test for independence 76203 0:38
9. locked Finding the critical value of the chi-squared test for independence 76204 0:42
Key # Length
1. locked Activating the Data Analysis ToolPak 76205 0:55
2. locked Finding descriptive statistics 76206 0:59
3. locked Creating a histogram 76207 1:10
4. locked Performing a t-test for paired, or related samples 76208 1:10
5. locked Examining data for homogeneity of variance 76209 1:09
6. locked Performing a t-test for independent, or unrelated, samples 76210 1:08
7. locked Performing a one-way analysis of variance (ANOVA) 76211 0:56
8. locked Performing a factorial analysis of variance (ANOVA) 76212 0:52
9. locked Performing a repeated measures analysis of variance (ANOVA) 76213 0:46
10. locked Finding the correlation coefficient of two or more variables 76214 0:48
11. locked Performing a linear regression 76215 0:56
Tutorial series by Greg Corder, Kate Corder
Box shot reprinted by permission from Microsoft Corporation. Microsoft is either a registered trademark or trademark of Microsoft Corporation in the United States and/or other countries.