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
Видео Excel Statistical Analysis 01: Data & Statistics канала ExcelIsFun
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 канала ExcelIsFun
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Excel Data Analysis Class 01: PivotTables, Power Query, Formulas and ChartsExcel Statistical Analysis 03: Comprehensive Worksheet Formula & Model Building VideoExcel Data Analysis Class 02: Power Pivot, DAX Formulas, Relationships, Data Modeling & Much More!How I Would Learn to be a Data AnalystExcel Statistical Analysis 06: Frequency Distributions, Visualizations & Skew for Quantitative DataExcel Statistical Analysis 02: Structure of Excel files, Navigation, Keyboard and moreWhat do companies "really" want in a Data Analyst (I look at 3 job ads)Data cleaning in Excel - 10 tricks *PROs* use all the timeExcel Statistical Analysis 04: PivotTable & Power Query to Build Frequency DistributionsBeginner's Excel Tutorial - Data Science/Analysis and BeyondExcel Statistical Analysis 05: Frequency Distributions & Visualizations for Categorical DataData Analysis with ExcelDescriptive Statistics in Excel Using the Data Analysis ToolStatistical Data Analysis in ExcelBeginner to Pro FREE Excel Data Analysis CourseExcel Statistical Analysis 33: Chart Normal (Bell) Probability Distribution in Excel with Area Chart5 Concepts in Statistics You Should Know | Data Science InterviewExcel Statistical Analysis 08: X-Y Scatter Charts for Linear Data: Excel Chart? Analyze Data Button?