Excel Statistical Analysis 01: Data & Statistics |
|
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 |