Additional Note: I decided to use Column I as the trend rather than than Column Q, because I want to see their trend without their current season points affecting it. I want to see their cumulative historical trends (Column D-H).
For the Trend chart, Ham do have the highest number because of his historical stats. That number is calcuated from his career statistic (% of pole, wins, fastest lap, retirement, pts/race), so yes, he is the most successful racer currently. However, this does not mean he is the best driver currently. Also, the trend chart is meant to see if they are getting higher or declining, regardless of their numbers in comparsion to each other. Hope this help!
That's very true. Unfortunately that adds to his retirement percentage and cratered his score. It would be interesting to see if his score will pop back up once he have a reliable car. If so, he would definitely be a very exciting driver to watch.
Additional Note: I decided to use Column I as the trend rather than than Column Q, because I want to see their trend without their current season points affecting it. I want to see their cumulative historical trends (Column D-H).
Am I reading this wrong or do you have Hamilton as the highest performing racer?
For the Trend chart, Ham do have the highest number because of his historical stats. That number is calcuated from his career statistic (% of pole, wins, fastest lap, retirement, pts/race), so yes, he is the most successful racer currently. However, this does not mean he is the best driver currently. Also, the trend chart is meant to see if they are getting higher or declining, regardless of their numbers in comparsion to each other. Hope this help!
Zhou had multiple DNFs past few races, with a DNF at Azerbaijan GP due to engine issues, most of these with no fault of his own
That's very true. Unfortunately that adds to his retirement percentage and cratered his score. It would be interesting to see if his score will pop back up once he have a reliable car. If so, he would definitely be a very exciting driver to watch.