Excel For Statistical Data Analysis Treningskurs

Last updated

Kurskode

excelstatsda

Varighet

14 timer (vanligvis 2 dag inkludert pauser)

Krav

Participants should be familiar with the basics of Excel and Statistics.

Oversikt

Publikum

Analytikere, forskere, forskere, nyutdannede og studenter og alle som er interessert i å lære å forenkle statistisk analyse i Microsoft Excel .

Kursmål

Dette kurset vil bidra til å forbedre din kjennskap til Excel og statistikk, og som et resultat øke effektiviteten og effektiviteten til arbeidet ditt eller forskningen din.

Dette kurset beskriver hvordan du bruker Analyseverktøyet i Microsoft Excel , statistiske funksjoner og hvordan du utfører grunnleggende statistiske prosedyrer. Den vil forklare hva Excel begrensningen er og hvordan du kan overvinne dem.

Machine Translated

Kursplan

Aggregating Data in Excel

  • Statistical Functions
  • Outlines
  • Subtotals
  • Pivot Tables

Data Relation Analysis

  • Normal Distribution
  • Descriptive Statistics
  • Linear Correlation
  • Regression Analysis
  • Covariance

Analysing Data in Time

  • Trends/Regression line
  • Linear, Logarithmic, Polynomial, Power, Exponential, Moving Average Smoothing
  • Seasonal fluctuations analysis

Comparing Populations

  • Confidence Interval for the Mean
  • Test of Hypothesis Concerning the Population Mean
  • Difference Between Mean of Two Populations
  • ANOVA: Analysis of Variances
  • Goodness-of-Fit Test for Discrete Random Variables
  • Test of Independence: Contingency Tables
  • Test Hypothesis Concerning the Variance of Two Populations

Forecasting

  • Extrapolation

Testimonials

★★★★★
★★★★★

Related Categories

Relaterte kurs

Kursrabatter

Kursrabatter Nyhetsbrev

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients

is growing fast!

We are looking to expand our presence in Norway!

As a Business Development Manager you will:

  • expand business in Norway
  • recruit local talent (sales, agents, trainers, consultants)
  • recruit local trainers and consultants

We offer:

  • Artificial Intelligence and Big Data systems to support your local operation
  • high-tech automation
  • continuously upgraded course catalogue and content
  • good fun in international team

If you are interested in running a high-tech, high-quality training and consulting business.

Apply now!

This site in other countries/regions