De La Salle University – Dasmariñas
COLLEGE OF SCIENCE AND COMPUTER STUDIES
MATHEMATICS AND STATISTICS DEPARTMENT
City of Dasmariñas, Cavite
SMATH001LA – Data Analytics for Engineering
2nd Semester / Midterm Period / S.Y. 2022-2023
LABORATORY ACTIVITY #1
Descriptive Statistics for Qualitative Data
NAME: __________________________________ DATE: ____________________
Score:
COURSE/YEAR & SECTION: __________________ PROF.: ____________________
OBJECTIVES:
1. Create a pivot table and data visualization in Microsoft Excel.
2. Clearly organize and compute detailed information about the three data sets.
3. Graph and calculate several descriptive measures of the data set using a variety of
methods
Data Set 1: Categorical Data
The class levels of a simple random sample of students are as follow: Senior
Senior Senior Freshman Junior Senior Senior Sophomore
Junior Junior Senior Senior Freshman Senior Senior
Senior Sophomore Sophomore Sophomore Sophomore Senior Sophomore
Junior Junior Senior Senior Freshman Senior Senior
Senior Senior Freshman Junior Senior Senior Sophomore
Junior Junior Senior Senior Freshman Senior Senior
Senior Sophomore Sophomore Sophomore Sophomore Senior Sophomore
Junior Junior Senior Senior Freshman Senior
Tasks: (10-point each)
a. Construct a table that gives the frequency distribution of this data. Interpret the result.
b. Construct a table that gives the relative frequency distribution of this data. Interpret the
result.
c. Construct a pie chart of this data that displays the percentage of students at each class
level. Interpret the result.
d. Construct a bar graph of this data that displays the frequency of students at each class
level. Interpret the result.
Data Set 2: Categorical Data
The preferred mode of learning of a simple random sample of students are as follow:
Online modular face-to-face blended
Online Online Online face-to-face
face-to-face face-to-face face-to-face blended
blended blended modular modular
modular modular Online blended
blended Online Online face-to-face
face-to-face face-to-face face-to-face face-to-face
Tasks: (10-point each)
a. Construct a table that gives the frequency distribution of this data. Interpret the result.
b. Construct a table that gives the relative frequency distribution of this data. Interpret the
result.
c. Construct a pie chart of this data that displays the percentage of students at each class
level. Interpret the result.
d. Construct a bar graph of this data that displays the frequency of students at each class
level. Interpret the result.
