Now we will enter the data that we have collected into the spreadsheet.
For each month we will create two columns one for boys and one for girls.
We will enter the recorded data into the respective cells.
We will do this by entering value 1 in each cell where there is one birthday.
If there are more than two birthdays on a given date, we will enter 2 and so on
Entering these numbers will help us to plot various graphs
The image below shows the filled spreadsheet with the data shown above.
In this figure Total at the bottom left gives us Total births in that column. The total column at the right end gives us the total births on that day of the month. Please note that all values in the Total column are computed and are not entered by hand. Think about how you will achieve this.
For easier plotting we can make a smaller column as shown below:
In this case also the values are computed by the spreadsheet and not entered by hand.
[Contributed by administrator on 15. März 2018 15:09:33]
For easier plotting we can make a smaller column as shown below: