Introduction to Data Analytics (techniques you can apply today)

Simpliv

Course

Online

£ 10 + VAT

The best Other Education courses

See all

See all

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

In this course we use a real data-set to practice what is taught in each of the lecture videos. By using real data you will get "hands on" practice so that you are able to apply what you have learnt to your work or life needs.Although gender wage trends may not be a relevant topic for you, we use wage data to demonstrate how to execute and apply data analysis techniques. By the end of this course you will be able to explain why some females earn less than males and be able to identify (and measure) where gender wage discrimination is taking place and where not. This ability can be applied to any industry or research topic.The techniques taught in this course are all executable in Microsoft Excel and will help you improve your current analysis skills. The topics cover:Using averages and means
Using counts and medians
Data visualizations (graphs and plots)
Correlations and scatter-plots
Histograms to describe the shape of data
How to easily understand and use variance and standard deviation
How to construct and use "confidence intervals"
Hypothesis testing
Using t-tests to prove or disprove an assumptionFor all of the above we replicate the technique in Excel and practice drawing insights about what we are seeing.The course begins by introducing you to some basic theory about data and variables. You will then be introduced to some Excel tips and tricks (if you want) and the data-set that will be used. The data is a sample of over 500 survey responses that includes information about income, employment, education, gender, race, age and industry.We then dive into the different techniques until we can statistically prove, with a high level of confidence, where wage discrimination is taking place (or not).I hope you find this course rewarding, interesting and challenging!Jef Jacobs

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

Apply the right techniques for the type of data
Compare data by using averages, medians and modes
Further analyse data by its shape using histograms and other data visualizations
Measure and describe the spread of data around the average
Measure the strength of a relationship between two variables
Construct confidence intervals to describe how trustworthy and an average really is
Complete a t-test to compare how similar or different two sets of data are
Learn how to analyse wage data and identify gender discrimination

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Emagister S.L. (data controller) will process your data to carry out promotional activities (via email and/or phone), publish reviews, or manage incidents. You can learn about your rights and manage your preferences in the privacy policy.

Reviews

This centre's achievements

2021

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 6 years

Subjects

  • MS Excel
  • Microsoft excel training
  • Confidence Training
  • Industry
  • Microsoft Excel
  • Discrimination
  • Excel

Course programme

Beginner: Introduction to data and variables 2 lectures 18:04 Types of variables Types of data Beginner: Introduction to data and variables 2 lectures 18:04 Types of variables Types of data Types of variables Types of variables Types of variables Types of variables Types of data Types of data Types of data Types of data Introduction: The practice data we will use throughout this course 1 lecture 07:57 An overview of the data, variables and sample (including the downloadable file) In this lecture we learn about the practice data we will be analyzing throughout this course. You can also download the attached file and extract the sample data. If you cannot extract the sample data then please send me a message and I will make sure you receive the data. Introduction: The practice data we will use throughout this course 1 lecture 07:57 An overview of the data, variables and sample (including the downloadable file) In this lecture we learn about the practice data we will be analyzing throughout this course. You can also download the attached file and extract the sample data. If you cannot extract the sample data then please send me a message and I will make sure you receive the data. An overview of the data, variables and sample (including the downloadable file) In this lecture we learn about the practice data we will be analyzing throughout this course. You can also download the attached file and extract the sample data. If you cannot extract the sample data then please send me a message and I will make sure you receive the data. An overview of the data, variables and sample (including the downloadable file) In this lecture we learn about the practice data we will be analyzing throughout this course. You can also download the attached file and extract the sample data. If you cannot extract the sample data then please send me a message and I will make sure you receive the data. An overview of the data, variables and sample (including the downloadable file) In this lecture we learn about the practice data we will be analyzing throughout this course. You can also download the attached file and extract the sample data. If you cannot extract the sample data then please send me a message and I will make sure you receive the data. An overview of the data, variables and sample (including the downloadable file) In this lecture we learn about the practice data we will be analyzing throughout this course. You can also download the attached file and extract the sample data. If you cannot extract the sample data then please send me a message and I will make sure you receive the data. In this lecture we learn about the practice data we will be analyzing throughout this course. You can also download the attached file and extract the sample data. If you cannot extract the sample data then please send me a message and I will make sure you receive the data. In this lecture we learn about the practice data we will be analyzing throughout this course. You can also download the attached file and extract the sample data. If you cannot extract the sample data then please send me a message and I will make sure you receive the data. Beginner / Intermediate: Some Microsoft Excel tips and tricks to help you 5 lectures 39:55 How to select and navigate large tables of data in Excel How to quickly sort, filter and search for data in tables Using the =Average function in Excel Using the =AverageIF function in Excel Using the =AverageIFS function in Excel Beginner / Intermediate: Some Microsoft Excel tips and tricks to help you 5 lectures 39:55 How to select and navigate large tables of data in Excel How to quickly sort, filter and search for data in tables Using the =Average function in Excel Using the =AverageIF function in Excel Using the =AverageIFS function in Excel How to select and navigate large tables of data in Excel How to select and navigate large tables of data in Excel How to select and navigate large tables of data in Excel How to select and navigate large tables of data in Excel How to quickly sort, filter and search for data in tables How to quickly sort, filter and search for data in tables How to quickly sort, filter and search for data in tables How to quickly sort, filter and search for data in tables Using the =Average function in Excel Using the =Average function in Excel Using the =Average function in Excel Using the =Average function in Excel Using the =AverageIF function in Excel Using the =AverageIF function in Excel Using the =AverageIF function in Excel Using the =AverageIF function in Excel Using the =AverageIFS function in Excel Using the =AverageIFS function in Excel Using the =AverageIFS function in Excel Using the =AverageIFS function in Excel Beginner: Basic techniques for describing data 14 lectures 02:21:49 Using averages (means) to describe data Excel tip: how to calculate the average, median or mode How to describe categorical (non-numerical data) like gender, race or team Excel tip: creating bar graphs and pie chart to describe categorical data Data visualizations for averages and contributions Excel tip: comparing averages across different sub-categories (using =COUNTIFS) Using Scatter plots to illustrate trends or relationships between variables Excel tip: how to draw scatter plots in Excel Using box-plots to better illustrate and compare averages and data Excel tip: how to draw and edit box plots Describing the shape and frequency of data using a Histogram chart Excel tip: how to create and edit histograms in Excel How to calculate and use the correlation coefficient The correlation coefficient measures the strength of how close two (continuous) variables follow or relate to each other. Very useful to use with scatter-plot graphs Excel tip: how to calculate the correlation coefficient Beginner: Basic techniques for describing data. 14 lectures 02:21:49 Using averages (means) to describe data Excel tip: how to calculate the average, median or mode How to describe categorical (non-numerical data) like gender, race or team Excel tip: creating bar graphs and pie chart to describe categorical data Data visualizations for averages and contributions Excel tip: comparing averages across different sub-categories (using =COUNTIFS) Using Scatter plots to illustrate trends or relationships between variables Excel tip: how to draw scatter plots in Excel Using box-plots to better illustrate and compare averages and data Excel tip: how to draw and edit box plots Describing the shape and frequency of data using a Histogram chart Excel tip: how to create and edit histograms in Excel How to calculate and use the correlation coefficient The correlation coefficient measures the strength of how close two (continuous) variables follow or relate to each other /p Excel tip: how to calculate variance Excel tip: how to calculate variance Excel tip: how to calculate variance Excel tip: how to calculate variance The what and how of standard Deviation (a super powerful measure) The what and how of standard Deviation (a super powerful measure) The what and how of standard Deviation (a super powerful measure) The what and how of standard Deviation (a super powerful measure) Excel tip: calculating standard deviation Excel tip: calculating standard deviation Excel tip: calculating standard deviation Excel tip: calculating standard deviation Beginner / Intermediate: Measuring accuracy and confidence 6 lectures 46:02 Why "normally distributed" data is so important What the Central Limit Theorem tells us - see it in action! Introduction to Confidence Intervals How to use Confidence Intervals in your graphs and work Excel tip: how to calculate confidence intervals in Excel Excel tip: how to add confidence intervals to graphs in Excel Beginner / Intermediate: Measuring accuracy and confidence 6 lectures 46:02 Why "normally distributed" data is so important What the Central Limit Theorem tells us - see it in action! Introduction to Confidence Intervals How to use Confidence Intervals in your graphs and work Excel tip: how to calculate confidence intervals in Excel Excel tip: how to add confidence intervals to graphs in Excel Why "normally distributed" data is so important Why "normally distributed" data is so important Why "normally distributed" data is so important Why "normally distributed" data is so important What the Central Limit Theorem tells us - see it in action! What the Central Limit...

Additional information

High school mathematics and some basic statistics Some experience with Microsoft Excel

See related categories

Introduction to Data Analytics (techniques you can apply today)

£ 10 + VAT

The best Other Education courses

See all

See all