Statistical Analysis using Microsoft Excel Eğitimi

  • Eğitim Tipi: Classroom
  • Süre: 1 Gün
  • Seviye: Intermediate
Bu eğitimi kendi kurumunuzda planlayabilirsiniz. Bize Ulaşın!

Statistics involves collecting, analysing, interpreting, presenting, and organising data and provides methods for making inferences and conclusions about a population based on a sample of data.

Microsoft Excel offers various techniques and functions to calculate a single value or an array of values from the data in your Excel worksheets.

Whether you want to use the Excel Analysis ToolPak (an add-in that provides many statistical analysis tools) or formulas for statistical analysis, such as probability and distribution, this course will guide you through building and developing the various advanced statistical approaches needed.

We will use Microsoft Excel and various sample datasets to produce statistical results that can be used in reports and storytelling.

We will help you apply the topics covered in the course to your everyday activities through hands-on learning and structured workshops.

You will need a working knowledge of the following;

  • Understand how to write formulas using standard functions
  • Ideally, you should have attended:
    • Fundamentals of Statistics (QASTATFUND)
    • Microsoft Excel Intermediate (QAEXITMC)

At the end of the course, you’ll be able to:

  • Build probability formulas

  • Develop statistical distribution functionality

  • Apply inferential statistics to datasets

Module 1: Probability rules

  • Conditional Probability
  • Bayes’ Theorem
  • Random Variables

Module 2: Statistical Distributions

Normal

  • Bernoulli
  • Binomial
  • Poisson

Module 3: Inferential Statistics

  • Point Estimates
  • Hypothesis Testing
  • Confidence Levels

Module 4: Inference for Numerical Data

  • T-tests
  • ANOVA

Module 5: Inference for Categorical Data

  • Proportions
  • Chi-Square



Eğitimlerle ilgili bilgi almak ve diğer tüm sorularınız için bize ulaşın!

Yakın tarihte açılacak eğitimler

Sınıf eğitimlerimizi İstanbul, Ankara ve Londra ofislerimizde düzenlemekteyiz. Kurumunuza özel eğitimleri ise, dilediğiniz tarih ve lokasyonda organize edebiliriz.

09 Ocak 2025 (1 Gün)
İstanbul, Ankara, Londra
Classroom / Virtual Classroom
16 Ocak 2025 (1 Gün)
İstanbul, Ankara, Londra
Classroom / Virtual Classroom
09 Ocak 2025 (1 Gün)
İstanbul, Ankara, Londra
Classroom / Virtual Classroom
16 Ocak 2025 (1 Gün)
İstanbul, Ankara, Londra
Classroom / Virtual Classroom
24 Şubat 2025 (1 Gün)
İstanbul, Ankara, Londra
Classroom / Virtual Classroom
24 Şubat 2025 (1 Gün)
İstanbul, Ankara, Londra
Classroom / Virtual Classroom
24 Nisan 2025 (1 Gün)
İstanbul, Ankara, Londra
Classroom / Virtual Classroom
24 Nisan 2025 (1 Gün)
İstanbul, Ankara, Londra
Classroom / Virtual Classroom

İlgili Eğitimler

Sitemizi kullanarak çerezlere (cookie) izin vermektesiniz. Detaylı bilgi için Çerez Politika'mızı inceleyebilirsiniz.