Basic Statistics with Excel

Statistics learned in school, was it too hard to understand? No matter how much you listened to the explanation, statistics were confusing, but we will help you understand them. If you implement them one by one by hand using Excel, you will understand statistical concepts that you didn't understand! A new experience that makes boring statistics fun! We will give you a gift. :)

(4.1) 수강평 10개

강의소개.상단개요.수강생.short

난이도 초급

수강기한 무제한

Excel
Excel
Statistics
Statistics
Excel
Excel
Statistics
Statistics

먼저 경험한 수강생들의 후기

먼저 경험한 수강생들의 후기

4.1

5.0

bu.yu

32% 수강 후 작성

Thank you for the quick lecture.

5.0

상명

90% 수강 후 작성

It was good

5.0

조연수

100% 수강 후 작성

It was very helpful. Thank you.

강의상세_배울수있는것_타이틀

  • A general understanding of basic statistics!

  • Statistical knowledge that you can learn by seeing it with your own eyes if you follow it step by step.

The logic behind basic statistical theory and statistical testing,
Understand while implementing it in Excel 🔦

Lecture Topics 📖

Statistics classes in school are so hard to understand, aren't they? Especially the ones about tests, no matter how many times you hear about them, they're still confusing! The truth is, statistics is difficult because we lack a basic understanding of the underlying theories behind them. Once you understand the background of statistical tests and study them, nothing is more fun than statistics! :)

In this course, you'll learn the properties of basic statistical indicators , the laws of large numbers and the central limit theorem, fundamental statistical concepts , and establish a solid understanding of confidence intervals, statistical significance levels, and p-values . This course is filled with my teaching expertise, accumulated while teaching basic statistics to undergraduates at American universities. Statistics can be difficult, but we make it fun.

Unique features of this course 🪄

  • We help you develop the ability to understand difficult statistical theories on your own using Excel.
    • If you look at the files that implement the statistical theories you created one by one, you will be able to clearly understand the statistical theories that you had only vaguely felt.
  • We help you understand the properties of statistical indicators and gain the power to predict the distribution of data .
  • A clear understanding of statistical testing will help you overcome your fear of advanced statistics .

I recommend this to these people 🙋‍♀️

Someone who feels better when they implement something themselves

People who learn by giving specific examples when studying

Those who don't understand basic statistics and just memorize and solve problems

For those who want to know why they learn statistical theory


What you'll learn 📚

1) Random variables and samples
We'll create random variables ourselves and learn about their properties. This will establish concepts about random variables and sampling. We'll use the RAND() function to create virtual coins and learn about Bernoulli random variables.

2) Data visualization tools
Learn how to visualize given data in Excel. Learn about pie charts, histograms, scatter plots, and more.

3) Statistical indicators that capture the center and spread of data
Learn statistical indicators that capture the characteristics of data distributions. You'll explore concepts such as mean, median, IQR, and variance. Understand the concepts of expected value and variance of random variables through visualization.

Learn about boxplots, which visualize the characteristics of a distribution using learned statistical indicators.

4) Digging into random variables
We will learn about the characteristics of random variables. We will deepen our understanding of random variables by understanding the concept of parameters and visualizing each concept. We will establish the concepts of random variables and samples and understand the laws of large numbers.

5) Building a foundation based on statistical inference
We will focus on understanding the central limit theorem, a fundamental principle of statistical inference. We will also study the properties of the normal distribution and learn how to calculate probability.

6) Understanding statistical inference
Gain a deeper understanding of confidence intervals and the statistical estimation process.

7) Understanding statistical tests
Learn statistical testing terminology and implement the entire process to understand the statistical testing process. Learn about statistical significance levels, rejection thresholds, p-values, and more.


Expected Questions Q&A 💬

Q. Is this a course that non-majors can also take?

You can think of this class as a foundational course that will enable non-statisticians to study like statistics majors.

Q. Do I need to be proficient in Excel before taking the course?

Since we teach using Excel, a basic understanding of the language is helpful, but this course is designed for those without it. We explain basic Excel functions and apply them to learn statistical knowledge, so prior knowledge of Excel is not required. :)

Q. What level of content is covered in the class?

This course will take you from a basic understanding of statistics to a level where you can understand statistical testing theory. After taking this course, you'll find it very helpful if you take a mathematical statistics course at school.


Introducing the Knowledge Sharer ✒️

I'd like to share what I've learned and realized while studying statistics with those of you who are following my path. I hope this lecture will be a helpful resource, answering some of your questions. I also hope that for those who are following my path, I hope my footsteps will offer some comfort.

History

  • Representative of Wise Statistics Life
  • (Current) Lecturer in Statistics at Korea University of Engineering and Technology
  • (Current) Samsung DS Division New Employee Job Training Basic Statistics Instructor
  • (Former) Lecturer in Applied Statistics and Actuarial Risk Management at the Graduate School of Actuarial Science, Sungkyunkwan University

Academic background

  • The University of Iowa, Statistics & Actuarial Science PhD Program (ABD)
  • Master's degree in Actuarial Science from Sungkyunkwan University
  • Bachelor of Science in Statistics and Industrial Engineering from Sungkyunkwan University

강의소개.콘텐츠.추천문구

학습 대상은 누구일까요?

  • For those who are studying basic statistics for the first time

  • For those who want to study statistics visually through Excel

선수 지식, 필요할까요?

  • Excel Basics (Recommended)

강의소개.지공자소개

7,231

수강생

181

수강평

42

답변

4.8

강의 평점

5

강의_other

Tôi xin chia sẻ những điều mình đã học được trong quá trình nghiên cứu.

 

Tôi muốn chia sẻ những gì mình đã học và nhận ra trong quá trình nghiên cứu thống kê với các bạn, những người đang đi trên con đường mà tôi đã từng đi qua. Hy vọng rằng đây sẽ là những bài giảng hữu ích giúp giải đáp thắc mắc cho một số người. Đồng thời, tôi cũng mong rằng dấu chân của mình, một người đi trước, sẽ phần nào trở thành niềm an ủi cho những ai đang bước đi trên con đường mà tôi đã từng đi.

 

Thân ái, Isaac.

Thống kê cuộc sống thông thái Đại diện

Nghiên cứu sinh Tiến sĩ (ABD), chuyên ngành Thống kê & Khoa học Định phí bảo hiểm, Đại học Iowa

Thạc sĩ Khoa học tính toán bảo hiểm, Đại học Sungkyunkwan

Bachelor's degree in Statistics and Industrial Engineering, Sungkyunkwan University

 YouTube Channel: Wise Statistics Life

더보기

커리큘럼

전체

41개 ∙ (강의상세_런타임_시간 강의상세_런타임_분)

해당 강의에서 제공: [object Object]
강의 게시일: 
마지막 업데이트일: 

수강평

전체

10개

4.1

10개의 수강평

  • buyu9309님의 프로필 이미지
    buyu9309

    수강평 5

    평균 평점 5.0

    5

    32% 수강 후 작성

    Thank you for the quick lecture.

    • wjkyori2847님의 프로필 이미지
      wjkyori2847

      수강평 19

      평균 평점 2.8

      4

      100% 수강 후 작성

      It seems like you've explained in an easy way how to apply the basic concepts of normal distribution, T-distribution, and statistics that I wanted to know about to Excel... The video quality is a bit disappointing though...

      • jychoi0942님의 프로필 이미지
        jychoi0942

        수강평 9

        평균 평점 5.0

        5

        61% 수강 후 작성

        • fotosarlang7182님의 프로필 이미지
          fotosarlang7182

          수강평 1

          평균 평점 5.0

          5

          100% 수강 후 작성

          • hwangyoungduk1995님의 프로필 이미지
            hwangyoungduk1995

            수강평 1

            평균 평점 5.0

            5

            100% 수강 후 작성

            비슷한 강의

            같은 분야의 다른 강의를 만나보세요!

            강의상세.할인문구

            $80.30

            29%

            $114.40