Aug 15 2019 07:34 AM
Hey guys,
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.
If anyone could help that would be great!!
Thanks
Aug 15 2019 07:43 AM
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.
Aug 15 2019 12:21 PM
okay so...… how do I do this? I have there attendance, the beginning of the year performance and the end of the year in percent @Sergei Baklan
Aug 17 2019 05:34 AM
It looks like
with random numbers for attendance and performance. You may plot scatter chart on these two columns adding names as labels.