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 CompTIA Security+ Microsoft AZ-900
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Personal Transformation Life Purpose Meditation CBT Emotional Intelligence
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Vue JS
Google Flutter Android Development iOS Development React Native Swift 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
Microsoft Power BI SQL Tableau Business Analysis Data Modeling Business Intelligence MySQL Data Analysis Blockchain
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Business Plan Startup Online Business Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Teaching & Academics Social Science Excel

MS Excel: Statistics and Data Analysis

Perform Statistical analysis beginning from descriptives to hypothesis testing using MS-Excel Analysis Toolpak
Rating: 4.1 out of 54.1 (21 ratings)
136 students
Created by Rama Krishna Yelamanchili
Last updated 12/2020
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Design, Develop and administer questionnaires, Collect data from different sources, Enhance ability to analyze data, and Derive inferences to take successful decisions. Data Analysis speed and accuracy will enhance 10x.
  • Statistical Analysis with Pivot Table
  • Data Science with Excel Analysis Toolpak
  • Parametric and Non Parametric Tests

Requirements

  • Quest to analyze legions of Data
  • An understanding of Excel

Description

Present day organizations are data driven. Starting from Start-ups to Conglomerates every organization is relying on data for decision making. Organizations are flooded with data from multiple facets (websites, social network sites, third party data sources, daily operational data etc). Skimming this data to get meaningful information has become daunting task for organizations. They are looking for skilled manpower who can convert this gigantic data into sleek information for decision making. This course is for the beginners who wish to test the water in Data Analytics.

This course fuses Statistical Analysis with MS Excel because of which you would be able to churn legions of data into meaningful information within no time. Excel has hundreds of built-in functions and Data Analysis Toolpak (Excel Add-in) with which you can run descriptive statistics to predictive analysis with ease. In this course I created videos that help you understand statistical concepts and solve complex equations using Excel. Excel Workbooks are provided to you for practice and master the concepts.


Who this course is for:

  • Students who want to pursue career as Data Analyst, Data Scientist, Research Associates
  • Social Science students who want to do empirical research report/ Project Assignment / Thesis
  • Business Management Students (all streams)
  • Research Scholars / Research Students of Social Sciences and Business Management
  • All professionals who want to turn data into information
  • Entrepreneurs who wants to leverage of Data

Course content

12 sections • 30 lectures • 1h 35m total length

  • Preview02:18

  • Introduction to Statistics- What is in it for me
    01:46
  • The DCOVA framework
    02:22
  • Descriptive Statistics and Inferential Statistics
    01:55
  • Variable types (Categorical Variables, Numerical Variables)
    01:38
  • Number of Variables - Types of Analysis
    01:40
  • Measurement Scales for Variables
    02:06
  • Data Sources (Primary Data sources, Secondary Data sources)
    01:51

  • Sorting Data using Excel
    03:27
  • Sort Options and Advanced Filter
    01:47
  • Preview03:56
  • Drawing Stratified Random Sample using Excel
    04:12

  • Creating Chart to get Bird's Eye View with Excel
    03:25

  • How to Load the Analysis Toolpak in Excel
    01:42
  • Preview02:10
  • Calculating Frequency Distribution and Histogram with Data Analysis Command
    04:51
  • The Empirical Rule - Tests of Normality
    03:19

  • Preview03:08
  • Calculating Bivariate and Multivariate Correlation with Analysis Toolpak
    05:25

  • Importance and assumptions of Simple Linear Regression
    03:12
  • Running Simple Linear Regression Analysis in Excel
    05:00

  • Relevance and Assumptions of Multiple Regression Analysis
    02:05
  • Running Multiple Linear Regression Analysis in Excel
    03:29

  • Preview03:45
  • Exponential Smoothing using Excel Data Analysis Toolpak
    03:03

  • Preview03:45
  • Calculating Independent Sample t-test in Excel Data Analysis Toolpak
    03:50

Instructor

Rama Krishna Yelamanchili
Professor of Finance, AACSB accredited Business School, Hyd
Rama Krishna Yelamanchili
  • 3.9 Instructor Rating
  • 48 Reviews
  • 242 Students
  • 11 Courses

Currently I am working as Professor of Finance in one of the India's leading business school accredited by AACSB, a constituent of NAAC A+ Grade Private University located in Hyderabad, Telangana, India. I teach courses like Security Analysis and Portfolio Management, Investments, Financial Management, Corporate Finance, Accounting, and Financial Statement Analysis.

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