So I haven't used Excel in the way I need to know and I could use some assistance. I have to do a correlation between the beginning of the school year and the end of the school year with including attendance. Trying to show that the more you attend the more successful children are at the end of the year. I truly don't have an idea on how to show this but I was told to use excel to create this piece.
As variant, if you have an attendance rate for each person during the year (e.g. in %) and how the average rank is increased for the same year, you may plot scatter chart against these data to show dependence.