Page |1

Republic of the Philippines

BATANGAS STATE UNIVERSITY
ARASOF-Nasugbu
Nasugbu, Batangas

COLLEGE OF ENGINEERING AND COMPUTING SCIENCES

Information Technology Education Programs Department

DATA VISUALIZATION
AND SUMMARIZATION

NAME SECTION

DATE PERFORMED DATE FINISHED

GJPRosales
 Page |2

I. OBJECTIVES

At the end of this exercise, students must be able to:

a) Visualize Data with the use of different graphs and charts
b) Interpret data summarized in various graphs and charts

II. BACKGROUND INFORMATION

The data analytics process has some key components that are needed for
any initiative. By combining these components, a successful data analytics
initiative will provide a clear picture of where you are, where you have been
and where you should go.

Descriptive analytics helps answer questions about what happened.

These techniques summarize large datasets to describe outcomes to
stakeholders. By developing key performance indicators (KPIs,) these
strategies can help track successes or failures. Metrics such as return on
investment (ROI) are used in many industries. Specialized metrics are
developed to track performance in specific industries. This process
requires the collection of relevant data, processing of the data, data
analysis and data visualization. This process provides essential insight
into past performance.

Predictive analytics helps answer questions about what will happen in the
future. These techniques use historical data to identify trends and
determine if they are likely to recur. Predictive analytical tools provide
valuable insight into what may happen in the future and its techniques
include a variety of statistical and machine learning techniques, such as:
neural networks, decision trees, and regression.

Prescriptive analytics helps answer questions about what should be done.

By using insights from predictive analytics, data-driven decisions can be
made. This allows businesses to make informed decisions in the face of
uncertainty. Prescriptive analytics techniques rely on machine learning
strategies that can find patterns in large datasets. By analyzing past
decisions and events, the likelihood of different outcomes can be
estimated.

Data visualization is the representation of data or information in a graph,

chart, or other visual format. It communicates relationships of the data with
images. This is important because it allows trends and patterns to be more
easily seen. With the rise of big data upon us, we need to be able to
interpret increasingly larger batches of data. Machine learning makes it
easier to conduct analyses such as predictive analysis, which can then
serve as helpful visualizations to present. But data visualization is not only

GJPRosales
 Page |3

important for data scientists and data analysts, it is necessary to

understand data visualization in any career. Whether you work in finance,
marketing, tech, design, or anything else, you need to visualize data. That
fact showcases the importance of data visualization.

III. EXPERIMENTAL PROCEDURE

1. [Single Line Graphing] Graph the given information as a line graph:

10 Year Savings in Bank

Year ₱ in Bank
2018 6000
2019 8000
2020 5000
2021 7000
2022 5000
2023 3000
2024 2000
2025 1500
2026 6000
2027 10500

Answer here:

10 Year Savings in Bank

120

100

80

60

40

20

0
Monday Tuesday Wednesday Thursday Friday Saturday Sunday

10 Year Savings in Bank

GJPRosales
 Page |4

2. [Double Line Graphing] Graph the given information as a line graph:

Weekly Sales of Hot Dog Stand

BRANCH
Day
Zobel PanDog Marci Hahatdog
Monday 60 72
Tuesday 36 96
Wednesday 96 48
Thursday 72 84
Friday 84 60
Saturday 24 12
Sunday 12 12

Answer here:

3. [Bar Graphing] Graph the given information as a bar graph

Monthly Sale of maluPet Shop

Month # of Pet Sold
January 36
February 96
March 48
April 12
May 84
June 60
July 24
August 10
September 50
October 35
November 41
December 70

Answer here:

4. [Reading Pie Graphs] Answer the questions based on the pie graphs provided.

GJPRosales
 Page |5

1. Did Daniel and Sarah get

more votes than Kelly and
Miles or did they get an
equal number of votes?
Answer: ____________
2. If there are 200 students
that voted, how many votes
for Miles?
Answer: ____________
3. What Percentage of
student voted for either
Lizzy or Piper?
Answer: ____________
4. Combined, which two
students have the most
votes?
Answer: ____________
5. Who got more votes,
Daniel or Sarah; or did they
get an equal number of
votes?
Answer: ____________

6. If there were 100 customers

that were tracked, how many
bought chicken toppings?
Answer: ____________
7. Combined, which two toppings
did the greatest number of
customers choose?
Answer: ____________
8. What percentage of customer
chose either beef or the
salami?
Answer: ____________
9. Were spinach and olives
picked more than the ham and
chicken; or where they equally
bought?
Answer: ____________
10. Between spinach and olives
which two toppings was more
popular; or were they equally
popular?
Answer: ____________

5. [Interpreting Pictographs] a local baseball team tracked its homerun over the
seven months. Answer the question based on the pictograph below

GJPRosales
 Page |6

1. How many homeruns were recorded in both January

and April?
2. What was the mean or average number of homeruns
per month? Round your answer to the nearest
hundredth if necessary
3. Which two consecutive months had the greatest
number of homeruns? If multiple consecutive months
tied, write them all
4. How many homeruns were recorded in both May and
February?
5. Were more homeruns hit during the months of March
and April or in the months of June and July? Or were
there equal number of homeruns?

IV. QUESTION AND ANSWER

1. Cite reasons why do we need to summarize data?

2. Why is Analytics being important?

V. REFERENCES

Import. (2020). Retrieved from https://www.import.io/post/what-is-data-visualization/

GJPRosales
 Page |7

Master in Data Science . (2020). Retrieved from

https://www.mastersindatascience.org/resources/what-is-data-analytics/

GJPRosales