Statistics in MS Excel | | Business Trainings, Communications

Statistics in MS Excel
Our training is geared towards teaching participants how to use MS Excel in data analysis, hypothesis testing and time-series analysis.
12 hours
Online
English
OFFICE-003
Statistics in MS Excel
Sign Up
Duration
12 hours
Location
Online
Language
English
Code
OFFICE-003
Schedule and prices
€ 250 *
Training for 7-8 or more people? Customize trainings for your specific needs
Statistics in MS Excel
Sign Up
Duration
12 hours
Location
Online
Language
English
Code
OFFICE-003
Schedule and prices
€ 250 *
Training for 7-8 or more people? Customize trainings for your specific needs

Description

Most of us know how to use simple statistical tools such as taking a list of numbers, ordering them and finding the mean. Some of us may even be good at building charts or analyzing the structure of data and current trends. All these usually provide a better understanding of the companies situation. However, it is not enough for making proper management decisions or forecasting future financial results.

For example, regression analysis is the estimation of the ratio between two or more variables. The two primary uses for regression in business are forecasting and optimization. Regression helps managers and business owners forecast future conditions, lend quantitative support to managers' judgement, point out flaws in management thinking and provide new insights that can help company decision makers move their businesses toward a more profitable future.

Hypothesis testing helps to analyze the effect of one factor on another, by exploring the relationship's statistical significance. In a business world, a hypothesis test may be used to explain how much an increase in labor affects productivity or whether the current marketing campaign really boosted sales of the company products. It allows managers to examine causes and effects before making a crucial management decision.

So, when properly used, statistical methods make the decision-making process much easier. This training focuses on providing individuals with an understanding of the main statistic methods as well as their step-by-step implementation and interpretation of results.
After completing the course, a certificate
is issued on the Luxoft Training form

Objectives

  • How to use MS Excel for data processing, analysis, hypothesis testing and time-series analysis.

Target Audience

  • Managers
  • Analysts

Prerequisites

  • Basic Knowledge of MS Excel

Roadmap

  • Descriptive Statistics
  • Common Probability Distributions
  • Sampling and Estimation
  • Hypothesis Testing
  • Correlation and Regression
  • Time-Series Analysis
Schedule and prices
View:
Register for the next course
Registering in advance ensures you have priority. We will notify you when we schedule the next course on this topic
+
Courses you may be interested in
Key Aspects of Project Management
This training is an introduction into software project management, for prospective and current project managers.
Basics of Agile Methodology for Software Development
The training is built on practical exercises, Scrum simulations, discussions and case studies illustrating the basic principles and practices of Agile development.
View Catalog
Your benefits
Expertise
Our trainers are industry experts, involved in software development project
Live training
Facilitated online so that you can interact with the trainer and other participants
Practice
A focus on helping you practice your new skills
Still have questions?
Connect with us
Thank you!
The form has been submitted successfully.