Quantitative & Qualitative using Microsoft Excel Course

  • Program Overview

Data professionals work with two types of data: Quantitative and qualitative. In simple terms, quantitative data is measurable while qualitative data is descriptive—think numbers versus words.
If you plan on working as a data analyst or a data scientist (or in any field that involves conducting research), you will need to get to grips with both.
In this Course, we will focus on quantitative data. We will explain exactly what quantitative data is, including plenty of useful examples. We will also show you what methods you can use to collect and analyze quantitative data.

Image

Duration

Hours 18 

The Main Outlines

What is quantitative data? (With examples)

Summarizing Qualitative Data

What is the difference between quantitative and qualitative data?

Organizing Quantitative Data

What are the different types of quantitative data?

Performing Quantitative Data

How is quantitative data collected?

Displaying Qualitative Data

What methods are used to analyze quantitative data?

Data & Scales/Levels of Measurement

What are the advantages and disadvantages of quantitative data?

Descriptive & Inferential Statistics

Categorical Frequency Distribution with Formulas

Relative Frequency Distribution of Qualitative Data

Column Chart from Frequency Distribution

Creating a Pie Chart from Summarized Qualitative Data

Category Frequency Distribution with Pivot Table & Pie Chart

Categorical Cross Tabulation with Pivot Table

Categorical Cross Tabulation with Formulas

Pareto Chart for Categorical Data

Grouping Categories with Formula & Pivot Table

Quantitative Frequency Distribution with Formulas (part 1)

Quantitative Frequency Distribution with Formulas (Part 2)

Histogram & Ogive Charts & percentage Cumulative Frequency

Skew in Histograms

Quantitative Frequency Distribution with Pivot Table

Percentage Frequency Distribution & Histogram with Pivot Table

Cumulative Frequency Distribution with Pivot Table (Running Total)

Dot Plot Chart with REPT & COUNTIF functions

Stem & Leaf Chart with REPT & COUNTIF functions

 

Other Branches

Contact us

33 El Messaha Street, Dokki A, Dokki, Giza, Egypt

P.O Box 12611

16541 - 33318403 - 33318506

01065174761

This email address is being protected from spambots. You need JavaScript enabled to view it.

www.eelu.edu.eg

Contact information

  • dummy33 El Messaha Street, Dokki A, Dokki, Giza Governorate, Egypt

  • dummyP.O Box 12611

  • dummy 16541 - +2 02 33318498

  • dummy+2 02 37497928

  • dummyinfo@eelu.edu.eg

Our site on Google map