I've been struggling with this for quite some time (hours) and I keep failing at it. I want to find the average percentage for students who have a GPA less than 3.00.
Here's an example of my table
GPA Success Rate
2.56 50%
3.95 83%
2.14 29%
4.00 100%
2.01 43%
3.08 67%
I'm trying to take the GPA of students with less than a 3.00 and find their average all together.
For example the success rate for students under 3.00 should be, 40.67%
Please help me, I keep struggling with this.
Thank you in advance.
Bookmarks