20250317 Quantitative Data (Making Histogram, Line Chart, Scatter Plot)

Data are from Statisic with Technology, Dr. Kozak https://stats.libretexts.org/Bookshelves/Introductory_Statistics/Statistics_with_Technology_2e_(Kozak)/02%3A_Graphical_Descriptions_of_Data/2.01%3A_Qualitative_Data

https://stats.libretexts.org/Bookshelves/Introductory_Statistics/Statistics_with_Technology_2e_(Kozak)/02%3A_Graphical_Descriptions_of_Data/2.03%3A_Other_Graphical_Representations_of_Data

Example 2.2.1

(20mins ss) https://youtu.be/Y5wyPZh6YFA 

Table 2.2.2 Frequency Distribution for Monthly Rent

Class Limits	Class Boundaries	Class Midpoint	Tally	Frequency
350-664	349.5-664.5	507	||||	4
665-979	664.5-979.5	822	|||| |||	8
980-1294	979.5-1294.5	1137	||||	5
1295-1609	1294.5-1609.5	1452	|||| |	6
1610-1924	1609.5-1924.5	1767		0
1925-2239	1924.5-2239.5	2082		0
2240-2554	2239.5-2554.5	2397	|	1

How to make Histogram?

a. Copy and paste the data sample using Google sheet

b. Select the column "Class Midpoint" and "Frequency" then copy and paste on the side.

see the image below: (This image the one I made in my own Google Sheet)

Class Limits	Class Boundaries	Class Midpoint	Tally	Frequency
350-664	349.5-664.5	507	||||	4
665-979	664.5-979.5	822	|||| |||	8
980-1294	979.5-1294.5	1137	||||	5
1295-1609	1294.5-1609.5	1452	|||| |	6
1610-1924	1609.5-1924.5	1767		0
1925-2239	1924.5-2239.5	2082		0
2240-2554	2239.5-2554.5	2397	|	1

c. After that, select the column of the "Class Midpoint" and "Frequency" you created and click "insert" -choose "chart".

350-664	4
665-979	8
980-1294	5
1295-1609	6
1610-1924	0
1925-2239	0
2240-2554	1

(image shows "Class Midpoint" and "Frequency")
d. now you have a column chart, you can customize it by choosing your desired color or font.

Figure  2.2.1: Histogram for Monthly Rent

Cumulative Frequency vs. Class Midpoint

In making Line chart, it is the same process as the previous example. Copy and paste to the sheet. 

Class Limits	Class Boundaries	Class Midpoint	Cumulative Frequency
350-664	349.5-664.5	507	4
665-979	664.5-979.5	822	12
980-1294	979.5-1294.5	1127	17
1295-1609	1294.5-1609.5	1452	23
1610-1924	1609.5-1924.5	1767	23
1925-2239	1924.5-2239.5	2082	23
2240-2554	2239.5-2554.5	2397	24

Select the column of "Class Midpoint" and "Cumulative Frequency", then Click "insert" then "chart" to make a line chart. Just click "insert" then "chart (line chart)".

Class Midpoint	Cumulative Frequency
507	4
822	12
1127	17
1452	23
1767	23
2082	23
2397	24

Line Chart:

You can customize the line chart to your desired color or fonts.

Example  2.3.2: scatter plot

Temperature Vs. Elevation

Elevation (in feet)	7000	4000	6000	3000	7000	4500	5000
Temperature (°F)	50	60	48	70	55	55	60

In making Scatter Plot, the process is the same as making histogram and line chart. However, instead, we will choose the "scatter plot" in the chart choices

References:

Textbook: https://stats.libretexts.org/Bookshelves/Introductory_Statistics/Statistics_with_Technology_2e_(Kozak)/02%3A_Graphical_Descriptions_of_Data/2.02%3A_Quantitative_Data

https://stats.libretexts.org/Bookshelves/Introductory_Statistics/Statistics_with_Technology_2e_(Kozak)/02%3A_Graphical_Descriptions_of_Data/2.03%3A_Other_Graphical_Representations_of_Data

Youtube video reference from I-Yuan Chiang:  https://youtu.be/Y5wyPZh6YFA 

You can view my Google sheet here: https://docs.google.com/spreadsheets/d/1sQn6m4kll25mHpY3kWn-0ozx5h3AUngyugaQ8NvQsbo/edit?usp=sharing