Video Training / Learning Office Tutorials →Introduction To Research Data Analysis Excel Application

What you'll learn
Identify and discuss the various statistical methods
Choose the right statistics for analysis collected data
Implement data analysis on Microsoft Excel
Interpret results of analsys and draw inferences
Requirements
No programming skills or knowledge of statistics required
Description
While Excel is a powerful tool for data analysis, it's worth noting that for more complex and specialized tasks, you may eventually need to explore other data analysis tools and programming languages. However, Excel is an excellent starting point and can often meet the needs of many data analysis projects. It is for this reason that this course presents the fundamentals in data analysis, and a guide on how to use of Microsoft Excel for this purpose. It offers lessons that covers areas in Measures of Central Tendency, Measures of Dispersion, Correlation, Regression and Inferential statistics.Excel is known for its user-friendly interface. It doesn't require extensive programming or technical skills, making it accessible to a broad audience. It provides a wide range of built-in functions and formulas for performing basic calculations and mathematical operations.Excel is a versatile tool that can handle a wide range of data analysis tasks, from simple data entry and calculations to more complex statistical analysis and data visualization. Learning Excel for data analysis provides you with transferable skills that can be valuable in various roles and industries. It can also serve as a foundation for learning more advanced data analysis tools like Microsoft Power BI, R, or Python.
Overview
Section 1: Introduction
Lecture 1 Introduction
Section 2: Measures of Central Tendency
Lecture 2 MEASURES OF CENTRAL TENDENCY I
Lecture 3 MEASURES OF CENTRAL TENDENCY II: USING EXCEL
Section 3: Measures of Dispersion
Lecture 4 MESAURES OF DISPERSION I
Lecture 5 MEASURE OF DISPERSION II: USING EXCEL
Section 4: Correlation and Regression
Lecture 6 CORRELATION AND REGRESSION I
Lecture 7 CORRELATION AND REGRESSION II: USING EXCEL
Section 5: Hypothesis Testing and Inferential Statistics
Lecture 8 HYPOTHESIS TESTING AND INFERENTIAL STATISTICS I
Lecture 9 HYPOTHESIS TESTING AND INFERENTIAL STATISTICS II: USING EXCEL
Academic researchers,High school, undergraduate and postgraduate students


Homepage

https://www.udemy.com/course/irda-excel/