♫musicjinni

Excel Statistical Analysis 01: Data & Statistics

video thumbnail
Download Excel File: https://excelisfun.net/files/Ch01-ESA.xlsm
Topics in video:
(00:00) Introduction
(00:54) Use File Explorer, Show File Extensions, Create Folder for class
(02:59) Use People Web Site to download files for this class
(05:58) How to open Excel files using File Explorer
(04:28) Define Data Analysis and synonyms such as Data Analytics, Statistical Analysis, Mathematical Analysis and more
(06:40) Define Raw Data, Proper Data Set, Table, Data, Element, Variable, Observation, Measurement
(12:33) Define Categorical and Quantitative Data. Define the terms for data types: Nominal, Ordinal, Interval and Ratio
(16:50) Define Discrete and Continuous Numerical Data
(17:42) Define Cross Sectional and Time Series Data
(18:09) Define Statistics, Descriptive Statistics and Inferential Statistics
(22:28) Conclusion
(22:43) Closing and Video Links

Excel Statistical Analysis 01: Data & Statistics

Excel Statistical Analysis for Business – Busn 210 - Spring 2023 Quarter Introductory Video

Excel Statistical Analysis for Business – Busn 210 - Winter 2022 Quarter Introductory Video

Excel Statistical Analysis for Business – Busn 210 - Fall 2022 Quarter Introductory Video

Excel Statistical Analysis for Business – Busn 210 - Summer 2022 Quarter Introductory Video

Excel Statistical Analysis for Business – Busn 210 - Spring 2022 Quarter Introductory Video

Excel Statistical Analysis for Business – Busn 210 – Winter 2023 Quarter Introductory Video

Excel Statistical Analysis 17: AND, OR, and NOT Logical Tests for COUNTIFS & FILTER Functions

Excel Statistical Analysis 09: Location, Mean, Median, Mode, Moving Average, Skew & More!

Excel Statistical Analysis 02: Structure of Excel files, Navigation, Keyboard and more

Excel Statistical Analysis 27: Binomial Probability Distributions. BINOM.DIST.RANGE Function & Chart

Excel Statistical Analysis 12: Percentile, Quartile, Percentile Rank and Rank Functions & Algorithms

Excel Statistical Analysis 03: Comprehensive Worksheet Formula & Model Building Video

Excel Statistical Analysis 16: Introduction to Probability. Power Query & Pivot Table Example too

Excel Statistical Analysis 04: PivotTable & Power Query to Build Frequency Distributions

Excel Statistical Analysis 29: HYPGEOM.DIST Function for Conditional Probabilities Across # Trials

Disclaimer DMCA