وب سایت تخصصی شرکت فرین
دسته بندی دوره ها

Excel Statistics Essential Training: 2

سرفصل های دوره

Data isn’t valuable until you figure out what the data actually mean. Statistics transforms data into meaningful information, enabling organizations to make more informed decisions. That’s why statistics—collecting, analyzing, and presenting data—is a valuable skill for anyone in business or academia.

In this course, LinkedIn Learning statistics and business analysis instructor Eddie Davila takes you on a nuanced, step-by-step applied learning path to understanding statistics and statistical methods in Excel. Eddie first teaches the basic principles of statistical sampling, and then utilizes random samples to explore complex applications of statistical theory—all while using Excel statistics tools and functions. He covers topics like regression, hypothesis tests, analysis of variance (ANOVA), and Monte Carlo simulations, showing how Excel can help you tackle and interpret advanced statistical analyses.


01 - Introduction
  • 01 - Using Excel for statistics
  • 02 - What you need to know
  • 03 - Exercise files
  • 04 - Tool pack

  • 02 - 1. Sampling
  • 01 - Sample considerations
  • 02 - The central limit theorem
  • 03 - T-statistic vs. z-statistic

  • 03 - 2. Confidence Intervals
  • 01 - Introduction to confidence intervals
  • 02 - Creating confidence intervals in Excel (proportions)
  • 03 - Creating confidence intervals in Excel (means)

  • 04 - 3. Hypothesis Tests
  • 01 - How to test a hypothesis
  • 02 - Five steps of hypothesis testing
  • 03 - One-tailed vs. two-tailed tests
  • 04 - Hypothesis test exercise (means)
  • 05 - Hypothesis test exercise (proportions)

  • 05 - 4. Comparing Two Populations
  • 01 - Explanation of two population comparisons
  • 02 - Comparing two populations (proportions)
  • 03 - Comparing two populations (means)

  • 06 - 5. ANOVA Analysis of Variance
  • 01 - ANOVA What is analysis of variance
  • 02 - Hypothesis test and the F-statistic

  • 07 - 6. Regression
  • 01 - What is regression
  • 02 - Regression terminology
  • 03 - Linear regressions

  • 08 - 7. Simulation
  • 01 - What are simulations
  • 02 - Monte Carlo simulation example
  • 03 - Business simulation example

  • 09 - Conclusion
  • 01 - Continue learning Excel statistics
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

    در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 26715
    حجم: 512 مگابایت
    مدت زمان: 205 دقیقه
    تاریخ انتشار: ۲۶ آذر ۱۴۰۲
    دسته بندی محصول
    طراحی سایت و خدمات سئو

    139,000 تومان
    افزودن به سبد خرید