Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS AWS Certified Developer - Associate CompTIA Security+
Photoshop Graphic Design Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
2020-12-16 11:42:56
30-Day Money-Back Guarantee

This course includes:

  • 12.5 hours on-demand video
  • 28 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Assignments
Business Business Analytics & Intelligence Excel

Statistical Analysis and Research using Excel

Learn various Statistical Formulas and Data Analysis functions in Excel with practical exposure using different dataset.
Rating: 4.2 out of 54.2 (55 ratings)
12,311 students
Created by EdSolver Learning
Last updated 1/2021
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Statistical Analysis
  • Research Methodology
  • Excel
  • Non Parametric Tests
  • Parametric Tests

Requirements

  • No, however having basic idea about statistics is a plus.

Description

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.

Who this course is for:

  • Students curious about Statistics and Excel
  • Statictical Analysts
  • Researchers
  • Graduate Students
  • Data Analyst
  • Beginner Data Analysts
  • Business Management Students

Course content

15 sections • 79 lectures • 12h 32m total length

  • Preview03:23

  • Preview08:32
  • Excel Environment Setup
    02:32
  • Preview07:02
  • Lab - Basic Aggregations
    07:19
  • Statistical Analysis Using Charts
    08:51
  • Knowledge Check 1
    3 questions

  • Components of Central Tendency
    05:01
  • Preview07:03
  • Lab - Arithmetic Mean
    12:08
  • Concept - Geometric Mean
    10:09
  • Lab - Geometric Mean
    12:34
  • Concept - Harmonic Mean
    09:10
  • Lab - Harmonic Mean
    11:41
  • Concept - Median
    07:57
  • Lab - Median
    12:55
  • Concept - Quartile
    10:00
  • Lab - Quartile
    12:47
  • Concept - Percentile
    07:29
  • Lab - Percentile
    11:13
  • Concept - Decile
    06:56
  • Lab - Decile
    06:25
  • Concept - Mode
    07:12
  • Lab - Mode
    05:25
  • Knowledge Check 2
    5 questions

  • Components of Dispersion
    06:49
  • Concept - Range
    05:50
  • Lab - Range
    17:37
  • Concept - Mean Deviation
    09:56
  • Lab - Mean Deviation
    13:53
  • Concept - Quartile Deviation
    06:31
  • Lab - Quartile Deviations
    18:01
  • Concept - Standard Deviations
    12:15
  • Preview15:11
  • Concept - Variance
    05:44
  • Lab - Variance
    07:25
  • Knowledge Check 3
    6 questions

  • Types of Correlation
    11:26
  • Concept - Correlation Scatter Diagrams
    07:08
  • Lab - Correlation Scatter Diagrams
    10:31
  • Concept - Pearson Correlation
    11:07
  • Lab - Pearson Correlation
    22:42
  • Concept - Rank Correlation
    11:07
  • Lab - Rank Correlation
    16:33
  • Knowledge Check 4
    3 questions

  • Preview06:48
  • Concept - Regression Analysis
    10:55
  • Lab - Regression Analysis
    14:18
  • Concept - Residuals Analysis
    14:50
  • Lab - Residuals Analysis
    11:41
  • Concept - Multiple Regression
    04:04
  • Lab - Multiple Regression
    10:55
  • Knowledge Check 5
    4 questions

  • Assignment - SA 1
    2 questions
  • Assignment - SA 2
    3 questions

  • Introduction to Research Analysis
    06:46
  • Methods and Process of Research
    10:51
  • Data Sources
    07:25
  • Hypothesis
    07:50
  • Knowledge Check 6
    3 questions

  • Data Collection
    05:36
  • Questionnaire Design
    06:45
  • Measurement Scales
    10:36
  • Sampling
    15:44
  • Data Preparation
    09:43
  • Knowledge Check 7
    5 questions

  • Introduction to Descriptive Statistics
    03:36
  • Concept - Components of Descriptive Statistics
    09:24
  • Lab - Components of Descriptive Statistics
    08:29
  • Knowledge Check 8
    2 questions

Instructor

EdSolver Learning
Lead with Learning
EdSolver Learning
  • 4.3 Instructor Rating
  • 104 Reviews
  • 17,454 Students
  • 3 Courses

EdSolver Learning is just right platform for YOU, for your professional career development. We emphasis on bridging the academic-industry gap with our courses to make YOU ready for a good career. With us, YOU can improve your knowledge, enhance your skill and become more creative.

We provide training courses in to graduates, post-graduates and working professionals. We have a team of experts to provide YOU industry-demand skills in following areas.

Data Analytics

Computer Software and Systems

Financial Management

Business Management

Enterprise Solutions

Digital Marketing

Creative Designs

And much more......


Give yourself a wonderful experience of learning with the best education community. EdSolver Learning.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.