43 Master 43 Essential Statistical Formulas in Excel 2016 with Easy Examples π
Learn how to create and apply 43 key statistical functions in Excel 2016 with clear examples. Perfect for boosting your data analysis skills! Watch Part 3 now.

Excel (A-Z)
6.3K views β’ Sep 20, 2017

About this video
This video is about how to create 43 Statistical Functions with Examples in MS Excel Office Spreadsheet 2016 - Part 3.
00:05 - Steyx formula with example
00:54 - Trend formula with example
02:20 - Trimmean formula with example
03:34 - Vara formula with example
04:54 - Varpa formula with example
06:16 - Slope formula with example
07:31 - Small formula with example
09:10 - Standardize formula with example
10:23 - Stdeva formula with example
11:37 - Stdevpa formula with example
12:53 - Skew.p formula with example
14:04 - Skew formula with example
15:18 - Rsq formula with example
16:30 - Prob formula with example
17:48 - Phi formula with example
18:47 - Permutationa formula with example
20:12 - Permut formula with example
21:30 - Pearson formula with example
22:31 - Mina formula with example
24:00 - Min formula with example
25:09 - Median formula with example
26:51 - Maxa formula with example
28:24 - Max formula with example
29:39 - Logest formula with example
30:33 - Linest formula with example
32:04 - Large formula with example
33:17 - Kurt formula with example
34:45 - Intercept formula with example
36:09 - Harmean formula with example
37:25 - Growth formula with example
38:45 - Geomean formula with example
40:07 - Gauss formula with example
40:54 - Gammaln.precise formula with example
41:50 - Gammaln formula with example
42:49 - Gamma formula with example
43:40 - Frequency formula with example
45:51 - Forecast.linear formula with example
47:39 - Forecast.ets.stat formula with example
49:07 - Forecast.ets.seasonality formula with example
50:24 - Forecast.ets.confint formula with example
51:41 - Forecast.ets formula with example
52:53 - fisherinv formula with example
53:48 - fisher formula with example
Thank you for watching this video !! .
Excel tips and tricks for interview: https://www.youtube.com/playlist?list=PLZnHzQfaP-kN2KBptEKFUducwRkQGyNLV
Advanced Excel tips and tricks for job: https://www.youtube.com/playlist?list=PLZnHzQfaP-kNMIbOOl3ypmty4qjEAWZYR
Intermediate Excel tips and tricks for job: https://www.youtube.com/playlist?list=PLZnHzQfaP-kM1-Vfhd_h19jTKbYEuGgD-
Basic Excel tips and tricks for job: https://www.youtube.com/playlist?list=PLZnHzQfaP-kMJblqLO2dALPxT5kljIxHK
Excel shortcuts and tricks: https://www.youtube.com/playlist?list=PLZnHzQfaP-kOj_fVUfAQ2ui1iXmsZJg_g
Data cleaning in excel data analytics: https://www.youtube.com/playlist?list=PLZnHzQfaP-kNz4N7gdDwbw1-xelRiqNs8
Data analysis in excel: https://www.youtube.com/playlist?list=PLZnHzQfaP-kOY6XVgxq5KX94m9dvCp4I5
Excel graphs and charts tutorial: https://www.youtube.com/playlist?list=PLZnHzQfaP-kPAMQruqKZ0IAUye7lWn90J
Creative excel charts tutorial: https://www.youtube.com/playlist?list=PLZnHzQfaP-kPnNtDAds8doks4QwYLGVVi
Data analysis excel formulas: https://www.youtube.com/playlist?list=PLZnHzQfaP-kPkfHH9emFeqfEFyRbLWGGb
Latest excel formulas: https://www.youtube.com/playlist?list=PLZnHzQfaP-kNI8BFIyHuY4gRZ63dCmkyL
Important excel formulas: https://www.youtube.com/playlist?list=PLZnHzQfaP-kOV5sfQqKEHg4gD_88FPcfL
Simple vba code for beginners: https://www.youtube.com/playlist?list=PLZnHzQfaP-kNYOHshq5hItieqFnZTV75C
Excel macro how to use: https://www.youtube.com/playlist?list=PLZnHzQfaP-kP5pB7IrO6DSg8-bNLFNY7_
Excel animation: https://www.youtube.com/playlist?list=PLZnHzQfaP-kO3sAStHqmuUKAgtdpilfv4
AI in Excel: https://www.youtube.com/playlist?list=PLZnHzQfaP-kNKCptTK8ECUxt-orsmACa_
Excel for auditors: https://www.youtube.com/playlist?list=PLZnHzQfaP-kNE4YgeR0HwsJUfhEL9FqR8
Latest excel features: https://www.youtube.com/playlist?list=PLZnHzQfaP-kP73WZ1j2r5eelCQv1nM8Fn
Python in excel: https://www.youtube.com/playlist?list=PLZnHzQfaP-kMKEPrHWg6aZHFB6VLc32tf
Power pivot dax function tutorial: https://www.youtube.com/playlist?list=PLZnHzQfaP-kPri8SUozzLqA6ZEF77-UVx .
#msexcel, #exceltutorial, #microsoftexceltutorial
00:05 - Steyx formula with example
00:54 - Trend formula with example
02:20 - Trimmean formula with example
03:34 - Vara formula with example
04:54 - Varpa formula with example
06:16 - Slope formula with example
07:31 - Small formula with example
09:10 - Standardize formula with example
10:23 - Stdeva formula with example
11:37 - Stdevpa formula with example
12:53 - Skew.p formula with example
14:04 - Skew formula with example
15:18 - Rsq formula with example
16:30 - Prob formula with example
17:48 - Phi formula with example
18:47 - Permutationa formula with example
20:12 - Permut formula with example
21:30 - Pearson formula with example
22:31 - Mina formula with example
24:00 - Min formula with example
25:09 - Median formula with example
26:51 - Maxa formula with example
28:24 - Max formula with example
29:39 - Logest formula with example
30:33 - Linest formula with example
32:04 - Large formula with example
33:17 - Kurt formula with example
34:45 - Intercept formula with example
36:09 - Harmean formula with example
37:25 - Growth formula with example
38:45 - Geomean formula with example
40:07 - Gauss formula with example
40:54 - Gammaln.precise formula with example
41:50 - Gammaln formula with example
42:49 - Gamma formula with example
43:40 - Frequency formula with example
45:51 - Forecast.linear formula with example
47:39 - Forecast.ets.stat formula with example
49:07 - Forecast.ets.seasonality formula with example
50:24 - Forecast.ets.confint formula with example
51:41 - Forecast.ets formula with example
52:53 - fisherinv formula with example
53:48 - fisher formula with example
Thank you for watching this video !! .
Excel tips and tricks for interview: https://www.youtube.com/playlist?list=PLZnHzQfaP-kN2KBptEKFUducwRkQGyNLV
Advanced Excel tips and tricks for job: https://www.youtube.com/playlist?list=PLZnHzQfaP-kNMIbOOl3ypmty4qjEAWZYR
Intermediate Excel tips and tricks for job: https://www.youtube.com/playlist?list=PLZnHzQfaP-kM1-Vfhd_h19jTKbYEuGgD-
Basic Excel tips and tricks for job: https://www.youtube.com/playlist?list=PLZnHzQfaP-kMJblqLO2dALPxT5kljIxHK
Excel shortcuts and tricks: https://www.youtube.com/playlist?list=PLZnHzQfaP-kOj_fVUfAQ2ui1iXmsZJg_g
Data cleaning in excel data analytics: https://www.youtube.com/playlist?list=PLZnHzQfaP-kNz4N7gdDwbw1-xelRiqNs8
Data analysis in excel: https://www.youtube.com/playlist?list=PLZnHzQfaP-kOY6XVgxq5KX94m9dvCp4I5
Excel graphs and charts tutorial: https://www.youtube.com/playlist?list=PLZnHzQfaP-kPAMQruqKZ0IAUye7lWn90J
Creative excel charts tutorial: https://www.youtube.com/playlist?list=PLZnHzQfaP-kPnNtDAds8doks4QwYLGVVi
Data analysis excel formulas: https://www.youtube.com/playlist?list=PLZnHzQfaP-kPkfHH9emFeqfEFyRbLWGGb
Latest excel formulas: https://www.youtube.com/playlist?list=PLZnHzQfaP-kNI8BFIyHuY4gRZ63dCmkyL
Important excel formulas: https://www.youtube.com/playlist?list=PLZnHzQfaP-kOV5sfQqKEHg4gD_88FPcfL
Simple vba code for beginners: https://www.youtube.com/playlist?list=PLZnHzQfaP-kNYOHshq5hItieqFnZTV75C
Excel macro how to use: https://www.youtube.com/playlist?list=PLZnHzQfaP-kP5pB7IrO6DSg8-bNLFNY7_
Excel animation: https://www.youtube.com/playlist?list=PLZnHzQfaP-kO3sAStHqmuUKAgtdpilfv4
AI in Excel: https://www.youtube.com/playlist?list=PLZnHzQfaP-kNKCptTK8ECUxt-orsmACa_
Excel for auditors: https://www.youtube.com/playlist?list=PLZnHzQfaP-kNE4YgeR0HwsJUfhEL9FqR8
Latest excel features: https://www.youtube.com/playlist?list=PLZnHzQfaP-kP73WZ1j2r5eelCQv1nM8Fn
Python in excel: https://www.youtube.com/playlist?list=PLZnHzQfaP-kMKEPrHWg6aZHFB6VLc32tf
Power pivot dax function tutorial: https://www.youtube.com/playlist?list=PLZnHzQfaP-kPri8SUozzLqA6ZEF77-UVx .
#msexcel, #exceltutorial, #microsoftexceltutorial
Tags and Topics
Browse our collection to discover more content in these categories.
Video Information
Views
6.3K
Duration
54:43
Published
Sep 20, 2017
User Reviews
3.8
(1) Related Trending Topics
LIVE TRENDSRelated trending topics. Click any trend to explore more videos.