## 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.

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

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

P.O Box 12611

16541

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