# GeoGebra Tutorial 23 – Spreadsheet, Barchart and Histogram

Note: Although this is the 23rd of the GeoGebra Tutorial Series, just like other GeoGebra tutorials, it is independent from others.  This means that you can follow this tutorial step-by-step, without needing to learn the previous twenty two tutorials.

In this tutorial, we are going to use the spreadsheet to perform basic data representation.  We will plot a frequency table of  grouped data and perform basic computations using the spreadsheet window.  After the data is completed, we will construct a histogram.

Figure 1

Problem: Mr. Pi gave 50-item exam to his class.  He has 45 students. The scores and frequencies of the grouped data is shown below. Use GeoGebra to create a histogram.

Figure 2

If you want to follow this tutorial step-by-step, you can open the GeoGebra window in your browser by clicking here.  You can view the output of this tutorial here.

Step-by-Step Instructions

You can create the histogram using the Barchart command. Here are the steps to do it:

1. Delete L1 and L2 in the Algebra window.
2. Construct a new  L1 using the Group Averages (cells D2 to D11). Refer to step 12.
3. Construct a new L2 using Frequencies (C2 to C11).
4. Type Barchart[L_1, L_2] in the Input box and press the ENTER key.

## 7 thoughts on “GeoGebra Tutorial 23 – Spreadsheet, Barchart and Histogram”

1. Thanks for all these Tutorials. I have known GeoGebra since a long time but I was kinda lazy to try it. By the way, is there any translations to these material in other languages but English?

Thanks again!

2. You’re welcome. Not available in other languages yet.

• you’re welcome Rencia. 🙂

3. Great tutorial as per usual, Guillermo.

I’ve got a question. Let’s say that the first interval is ]150;160]. Is it possible to “cut” the x-axis so it starts at fx. 140?

Kind regards,
Kenneth

• Hi Kenneth. I’ll get back to your question this wekend okey? I’m a little busy. 🙂