4.38
27 reviews
Statistical Analysis and Research using Excel
Learn various Statistical Formulas and Data Analysis functions in Excel with practical exposure using different dataset.
- Description
- Curriculum
- FAQ
- Reviews
Statistical Analysis and Research using Excel is a blended learning program of theoretical knowledge with its application in Microsoft Excel software. This course is a base to all the analytical studies and research studies. It is focused on more industry relevant examples and situations, where in you learn how you actually need to apply your research and analytical skills at workplace. This can also be considered as a foundation course if you are looking out for higher education in research and analytics.
From the work perspective, this course is more suitable to jobs for data engineering, data analyst and marketing research jobs.
Introduction to Statistics
Measures of Central Tendency
Measures of Dispersion
-
8Components of Central TendencyVideo lesson
-
9Concept - Arithmetic MeanVideo lesson
-
10Lab - Arithmetic MeanVideo lesson
-
11Concept - Geometric MeanVideo lesson
-
12Lab - Geometric MeanVideo lesson
-
13Concept - Harmonic MeanVideo lesson
-
14Lab - Harmonic MeanVideo lesson
-
15Concept - MedianVideo lesson
-
16Lab - MedianVideo lesson
-
17Concept - QuartileVideo lesson
-
18Lab - QuartileVideo lesson
-
19Concept - PercentileVideo lesson
-
20Lab - PercentileVideo lesson
-
21Concept - DecileVideo lesson
-
22Lab - DecileVideo lesson
-
23Concept - ModeVideo lesson
-
24Lab - ModeVideo lesson
-
25Knowledge Check 2Quiz
Correlation
-
26Components of DispersionVideo lesson
-
27Concept - RangeVideo lesson
-
28Lab - RangeVideo lesson
-
29Concept - Mean DeviationVideo lesson
-
30Lab - Mean DeviationVideo lesson
-
31Concept - Quartile DeviationVideo lesson
-
32Lab - Quartile DeviationsVideo lesson
-
33Concept - Standard DeviationsVideo lesson
-
34Lab - Standard DeviationsVideo lesson
-
35Concept - VarianceVideo lesson
-
36Lab - VarianceVideo lesson
-
37Knowledge Check 3Quiz
Regression
-
38Types of CorrelationVideo lesson
-
39Concept - Correlation Scatter DiagramsVideo lesson
-
40Lab - Correlation Scatter DiagramsVideo lesson
-
41Concept - Pearson CorrelationVideo lesson
-
42Lab - Pearson CorrelationVideo lesson
-
43Concept - Rank CorrelationVideo lesson
-
44Lab - Rank CorrelationVideo lesson
-
45Knowledge Check 4Quiz
Assignment - Statistical Analysis
-
46Introduction to Regression AnalysisVideo lesson
-
47Concept - Regression AnalysisVideo lesson
-
48Lab - Regression AnalysisVideo lesson
-
49Concept - Residuals AnalysisVideo lesson
-
50Lab - Residuals AnalysisVideo lesson
-
51Concept - Multiple RegressionVideo lesson
-
52Lab - Multiple RegressionVideo lesson
-
53Knowledge Check 5Quiz
Introduction to Research
Managing Research Data
Descriptive Statistics
T Test and Z Test
Chi Square Analysis
-
71Concept - T TestVideo lesson
-
72Lab - T TestVideo lesson
-
73Interpretation - T TestVideo lesson
-
74Concept - Z TestVideo lesson
-
75Lab - Z TestVideo lesson
-
76Interpretation - Z TestVideo lesson
-
77Concept - Paired T TestVideo lesson
-
78Lab - Paired T TestVideo lesson
-
79Interpretation - Paired T TestVideo lesson
-
80Knowledge Check 9Quiz
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
Course details
Lectures
8
Quizzes
2
Video
13 hours
Certificate of Completion
Full lifetime access
Access on mobile and TV
Popular courses
External Links May Contain Affiliate Links read more