03-29-2016, 02:34 PM | #1 | ||
College Starter
Join Date: Oct 2000
Location: Midwest
|
Statistics Help Needed
I've got a problem that I'm hoping the wealth of math talent on this board can help me with.
Our school district has recently adopted a traveling trophy program based on the district wide reading program. Initially the schools were ranked 1 to 4 in percentage on reading tests and 1 to 4 on reading points earned. They've now changed the system to this: Reading Points x Percentage on tests = Ranked Score This issue with this is it severely undervalues the percentages students score on tests. I think it value quantity (books read) over quality (how well the comprehend the material). Full disclaimer, our school is typically the leader when it comes to percentages. In the old system, we had won the trophy 4 of the 5 months. Since the change, we've had situations like this: Our school averaged 13 pts per student, averaged 90% on tests, and gets an aggregate score of 11.7. Another school averaged 15 pts per student, averaged 80% on tests (5% below the recommended level for the program), and gets an aggregate score of 12. So, my question is, how do you equally weight percentages with a point value? I'm pretty good at math but admit this is beyond my level of statistical analysis. Any thoughts on ways to balance the two would be greatly appreciated. |
||
03-29-2016, 02:58 PM | #2 |
Grizzled Veteran
Join Date: Nov 2006
Location: Backwoods, SC
|
Just thinking out loud and havent ran much analysis....but if I am reading correct and an 85% is the recommended level, then an aggregate based on 85 percentile performance would make the difference.
So instead of 13 x .9 = 11.7 15 x .8 = 12 You would have 13 x (.9/.85)=13.76 15 x (.8/.85) = 14 It doesnt give you the result you want, still. But a difference of 2 points per student seems fairly significant. |
03-29-2016, 03:05 PM | #3 |
College Starter
Join Date: Oct 2000
Location: Midwest
|
Nice thought. Much easier than some sort of efficiency rating u was trying to work on. Yes, the goal isn't to make my school tops. But I know the spirit of the competition is to make sure students are gaining in their reading through age level appropriate books while maintaining strong comprehension levels. Trying to think like an admin here, and I don't want to see the program fall into the trap of simply chasing points.
Just on a side note, I grabbed the points for their ease of computing. Last month saw the winner edge out two other schools by something like 24 to 22 pts per student while finishing several percentage points lower. |
03-29-2016, 03:48 PM | #4 |
Banned
Join Date: Oct 2003
|
Maybe express the percentages as a z-score?
|
03-29-2016, 04:33 PM | #5 |
Coordinator
Join Date: May 2002
Location: Jacksonville, FL
|
.85 as a pivot and the further away from the pivot the higher the weight?
__________________
Jacksonville-florida-homes-for-sale Putting a New Spin on Real Estate! ----------------------------------------------------------- Commissioner of the USFL USFL |
03-29-2016, 04:41 PM | #6 |
College Prospect
Join Date: Oct 2000
Location: The Flatlands of America
|
Not sure how to explain this in a more scientific/statistical rational, but a more 'fair' equation would be:
(Reading Points x Percentage on Tests) + (Reading Points x (Percentage on Tests - Recommended Level )) This gives a bonus/penalty for those above/below the recommended level. So in your situation: (13*.9)+(13*(.9-.85))=12.35 (15*.8)+(15*(.8-.85))=11.25
__________________
Post Count: Eleventy Billion - so deal with it! |
03-29-2016, 04:47 PM | #7 |
Banned
Join Date: Oct 2003
|
Last 3 posts: you can normalize the test scores one way or another
|
03-29-2016, 08:37 PM | #8 |
College Starter
Join Date: Oct 2000
Location: Midwest
|
Thanks, all. I really like formula Scarecrow. It doesn't change any of the current standings, but it does help keep outliners from being either penalized or rewarded depending on their performance. I'll pass it along to admin to see what they think.
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
Thread Tools | |
|
|