Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Software Development Tools No-Code Development
Business
Entrepreneurship Communication 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 Certifications Network & Security Hardware Operating Systems & Servers 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 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 Paid 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 & Gardening 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 & Diet Yoga Mental Health Martial Arts & 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 Learning Teacher Training Test Prep Other Teaching & Academics
Web Development JavaScript React Angular CSS Node.Js PHP HTML5 Vue JS
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Amazon AWS Cisco CCNA Microsoft AZ-900 AWS Certified Developer - Associate
Microsoft Power BI SQL Tableau Data Modeling Business Analysis Business Intelligence MySQL Qlik Sense Blockchain
Unity Unreal Engine Game Development Fundamentals C# 3D Game Development C++ Unreal Engine Blueprints 2D Game Development Virtual Reality
Google Flutter Android Development iOS Development React Native Swift Dart (programming language) Mobile App Development Kotlin SwiftUI
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting Canva InDesign Character Design Procreate Digital Illustration App
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Life Purpose Mindfulness Meditation Sound Therapy CBT Cognitive Behavioral Therapy
Entrepreneurship Fundamentals Business Fundamentals Freelancing Business Strategy Startup Business Plan Online Business Blogging Home Business
Digital Marketing Social Media Marketing Marketing Strategy Internet Marketing Google Analytics Copywriting Email Marketing YouTube Marketing Podcasting

BusinessBusiness Analytics & IntelligenceStatistics

Business Statistics with Excel

Learn business statistics from basic to expert level through a practical course with Excel.
Rating: 4.0 out of 54.0 (4 ratings)
26 students
Created by Diego Fernandez
Last updated 6/2020
English
English [Auto]

What you'll learn

  • Chart absolute frequency, relative frequency, cumulative absolute frequency and cumulative relative frequency histograms.
  • Approximate sample mean, sample median central tendency measures and sample standard deviation, sample variance, sample mean absolute deviation dispersion measures.
  • Estimate sample skewness, sample kurtosis frequency distribution shape measures and samples correlation, samples covariance association measures.
  • Define normal probability distribution, standard normal probability distribution and Student’s t probability distribution for several degrees of freedom alternatives.
  • Evaluate probability distribution goodness of fit through quantile-quantile plots and Jarque-Bera normality test.
  • Approximate population mean and population proportion point estimations.
  • Estimate population mean and population proportion confidence intervals assuming known or unknown population variance.
  • Calculate population mean and population proportion sample sizes assuming known population variance for specific margin of error.
  • Approximate population mean two tails, right tail and population proportion left tail statistical inference tests probability values.
  • Estimate paired populations means two tails statistical inference test probability value.
  • Assess population mean two tails statistical inference test power for several levels of statistical significance or confidence alternatives.

Requirements

  • Spreadsheet software such as Microsoft Excel® is required.
  • Practical example spreadsheet provided with the course.
  • Prior basic spreadsheet software knowledge is useful but not required.

Description

Learn business statistics through a practical course with Microsoft Excel® using S&P 500® Index ETF prices historical data. It explores main concepts from basic to expert level which can help you achieve better grades, develop your academic career, apply your knowledge at work or do your business statistics research. All of this while exploring the wisdom of best academics and practitioners in the field.

Become a Business Statistics Expert in this Practical Course with Excel

  • Chart absolute frequency, relative frequency, cumulative absolute frequency and cumulative relative frequency histograms.

  • Approximate sample mean, sample median central tendency measures and sample standard deviation, sample variance, sample mean absolute deviation dispersion measures.

  • Estimate sample skewness, sample kurtosis frequency distribution shape measures and samples correlation, samples covariance association measures.

  • Define normal probability distribution, standard normal probability distribution and Student’s t probability distribution for several degrees of freedom alternatives.

  • Evaluate probability distribution goodness of fit through quantile-quantile plots and Jarque-Bera normality test.

  • Approximate population mean and population proportion point estimations.

  • Estimate population mean and population proportion confidence intervals assuming known or unknown population variance.

  • Calculate population mean and population proportion sample sizes assuming known population variance for specific margin of error.

  • Approximate population mean two tails, right tail and population proportion left tail statistical inference tests probability values.

  • Estimate paired populations means two tails statistical inference test probability value.

  • Assess population mean two tails statistical inference test power for several levels of statistical significance or confidence alternatives.

Become a Business Statistics Expert and Put Your Knowledge in Practice

Learning business statistics is indispensable for data science applications in areas such as consumer analytics, finance, banking, health care, e-commerce or social media. It is also essential for academic careers in applied statistics or quantitative finance. And it is necessary for business statistics research.

But as learning curve can become steep as complexity grows, this course helps by leading you step by step using S&P 500® Index ETF prices historical data for business statistics analysis to achieve greater effectiveness.

Content and Overview

This practical course contains 34 lectures and 4.5 hours of content. It’s designed for all business statistics knowledge levels and a basic understanding of Microsoft Excel® is useful but not required.

At first, you’ll learn how to perform business statistics operations using built-in functions and array calculations. Next, you’ll learn how to do histogram calculation using Microsoft Excel® Add-in.

Then, you’ll define descriptive statistics. Next, you’ll define quantitative data, data population and data sample. After that, you’ll define absolute frequency distribution and relative frequency distribution or empirical probability. For frequency distributions, you’ll do frequency, density, cumulative frequency and cumulative density histograms. Later, you’ll define central tendency measures. For central tendency measures, you’ll estimate sample mean and sample median. Then, you’ll define dispersion measures. For dispersion measures, you’ll estimate sample standard deviation, sample variance and sample mean absolute deviation or sample average deviation. Next, you’ll define frequency distribution shape measures. For frequency distribution shape measures, you’ll estimate sample skewness and sample kurtosis. Then, you’ll define association measures. For association measures, you’ll estimate samples correlation and samples covariance.

Next, you’ll define probability distributions. Then, you’ll define theoretical and empirical probability distributions. After that, you’ll define continuous random variable and continuous probability distribution. Later, you’ll define normal probability distribution, standard normal probability distribution and Student’s t probability distribution for several degrees of freedom alternatives. Then, you’ll define probability distribution goodness of fit testing. For probability distribution goodness of fit testing, you’ll do quantile-quantile plots and Jarque-Bera normality test evaluations.

After that, you’ll define parameters estimation statistical inference. Then, you’ll define point estimation. For point estimation, you’ll do population mean and population proportion point estimations. After that, you’ll define confidence interval estimation. For confidence interval estimation, you’ll do population mean and population proportion confidence intervals estimation assuming known and unknown population variance. Later, you’ll define sample size estimation. For sample size estimation, you’ll do population mean and population proportion sample sizes estimation assuming known population variance for specific margin of error.

Later, you’ll define parameters hypothesis testing statistical inference. Next, you’ll define probability value. For probability value, you’ll do population mean two tails and right tail tests. Also, for probability value, you’ll do population proportion left tail test. Additionally, for probability value, you’ll do paired populations means two tails test. Finally, you’ll define statistical power, type I error, type II error, type I error probability and type II error probability. For statistical power, you’ll do population mean two tails tests for several statistical significance or confidence levels.

Who this course is for:

  • Undergraduates or postgraduates who want to learn about business statistics using Microsoft Excel®.
  • Academic researchers who wish to deepen their knowledge in applied statistics or quantitative finance.
  • Business data scientists who desire to apply this knowledge in areas such as consumer analytics, finance, banking, health care, e-commerce or social media.

Instructor

Diego Fernandez
Exfinsis
Diego Fernandez
  • 3.7 Instructor Rating
  • 2,499 Reviews
  • 12,888 Students
  • 36 Courses

Diego Fernandez is author of high-quality online courses and ebooks at Exfinsis for anyone who wants to become an expert in financial data analysis.

His main areas of expertise are financial analysis and data science. Within financial analysis he has focused on computational finance, quantitative finance and trading strategies analysis. Within data science he has concentrated on machine learning, applied statistics and econometrics. For all of this he has become proficient in Microsoft Excel®, R statistical software® and Python programming language® analysis tools. 

He has important online business development experience at fast-growing startups and blue-chip companies in several European countries. He has always exceeded expected professional objectives by starting with a comprehensive analysis of business environment and then efficiently executing formulated strategy.

He also achieved outstanding performance in his undergraduate and postgraduate degrees at world-class academic institutions. This outperformance allowed him to become teacher assistant for specialized subjects and constant student leader within study groups. 

His motivation is a lifelong passion for financial data analysis which he intends to transmit in all of the courses.

Top companies choose Udemy Business to build in-demand career skills.
NasdaqVolkswagenBoxNetAppEventbrite
  • Udemy Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Investors
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Accessibility statement
Udemy
© 2022 Udemy, Inc.