Hello everyone,
I'm trying to calculate the "trend" in student GPAs as a value of some sort, indicating if the overall trend is negative, positive, or flat. I've done some digging but can seem to figure out what this value would even be called. Possibly r-squared when you add a trendline to a scatter plot, but I don't know how to get that just as a formula calculation with the data I have. Here's an example of what I have:
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]gpa1[/TD]
[TD]gpa2[/TD]
[TD]gpa3[/TD]
[TD]gpa4[/TD]
[TD]gpa5[/TD]
[TD]gpa6[/TD]
[/TR]
[TR]
[TD]student1[/TD]
[TD]3.8[/TD]
[TD]3.0[/TD]
[TD]3.4[/TD]
[TD]3.2[/TD]
[TD]3.0[/TD]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD]student2[/TD]
[TD]3.0[/TD]
[TD]3.1[/TD]
[TD]2.9[/TD]
[TD]3.0[/TD]
[TD]3.0[/TD]
[TD]3.0[/TD]
[/TR]
</tbody>[/TABLE]
So for example, student2's GPA remains relatively flat, so I would think a value of their trend would be close to 0. Whereas a student showing upward trend would have a value that's positive, and for a downward trend, a negative value.
Another tricky thing about this is that the student's most recent quarterly GPA is the "GPA1" column. If there's a way to account for this, that'd be awesome, but I can obviously reorder these so that the most recent GPA is in the furthest right-hand column. Any help is appreciated!
I'm trying to calculate the "trend" in student GPAs as a value of some sort, indicating if the overall trend is negative, positive, or flat. I've done some digging but can seem to figure out what this value would even be called. Possibly r-squared when you add a trendline to a scatter plot, but I don't know how to get that just as a formula calculation with the data I have. Here's an example of what I have:
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]gpa1[/TD]
[TD]gpa2[/TD]
[TD]gpa3[/TD]
[TD]gpa4[/TD]
[TD]gpa5[/TD]
[TD]gpa6[/TD]
[/TR]
[TR]
[TD]student1[/TD]
[TD]3.8[/TD]
[TD]3.0[/TD]
[TD]3.4[/TD]
[TD]3.2[/TD]
[TD]3.0[/TD]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD]student2[/TD]
[TD]3.0[/TD]
[TD]3.1[/TD]
[TD]2.9[/TD]
[TD]3.0[/TD]
[TD]3.0[/TD]
[TD]3.0[/TD]
[/TR]
</tbody>[/TABLE]
So for example, student2's GPA remains relatively flat, so I would think a value of their trend would be close to 0. Whereas a student showing upward trend would have a value that's positive, and for a downward trend, a negative value.
Another tricky thing about this is that the student's most recent quarterly GPA is the "GPA1" column. If there's a way to account for this, that'd be awesome, but I can obviously reorder these so that the most recent GPA is in the furthest right-hand column. Any help is appreciated!