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.
Code: OFFICE-003
Duration: 12 hours

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.

Roadmap

  • Descriptive Statistics
  • Common Probability Distributions
  • Sampling and Estimation
  • Hypothesis Testing
  • Correlation and Regression
  • Time-Series Analysis

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


Trainer in Krakow
Zbigniew Baran Senior Project Management Officer
Zbigniew is a Senior Project Management Officer and Financial Analyst in one of Luxoft’s key projects. In this position he is responsible for, among others, coordinating finance planning, forecasting and actuals as well as supporting the business' financial decision-making process by providing analysis and reporting.

He has extensive expertise in working with Excel for budgeting, forecasting, reporting and preparing financial/statistical/analytical models. For Luxoft Training Zbigniew facilitates our Excel courses such as MS Excel 2010 and Statistics in MS Excel. He also holds an ITIL Foundation certification.
Course is scheduled in: Krakow
6.06.2019 - 7.06.2019
Time: 09:00-15:00
City: Krakow
Duration: 12 hours
Language: English
Trainer
Zbigniew Baran
Senior Project Management Officer
€180
28.08.2019 - 29.08.2019
Time: 09:00-15:00
City: Krakow
Duration: 12 hours
Language: English
Trainer
Zbigniew Baran
Senior Project Management Officer
€180
Register for the next course
+
Registering in advance ensures you have priority. We’ll notify you when we schedule the next course on this topic
Register for the next course
+
Registering in advance ensures you have priority. We’ll notify you when we schedule the next course on this topic
Bucharest €180
Krakow €180
Wroclaw €180

Invoices for the course will be issued in local currency. All fees above can change according to training location and delivery mode and are subject to change while scheduling. For individual participants the price is as displayed. For legal entities VAT is added to the displayed price.

Courses you may be interested in:

Sign up

Choose dates
First Name*
Last Name*
Company
Email*
Phone
Your Comment
Luxoft Warsaw - Warsaw Spire, plac Europejski 1, 00-844 Warszawa
Dimitrie Pompeiu nr 5-7 , building C, Et. 5, sect 2, Bucharest, 014459

Contact phone:

021 371 4858
Luxoft Poland Wroclaw - Silver Tower pl. Konstytucji 3-go Maja 3 50-048 Wroclaw
Aleja Generała Tadeusza Bora-Komorowskiego 25, Quattro Business Park Five, 31-476 Kraków, Poland

Contact phone:

+48 122110650
Success
Thank you.
Your request has been received.