I would like to calculate the score difference between the lastest score and its closest past score of the same Name, and then show the difference by show the green up, red down and no change symbol. Also, I would like to test whether the change has a significant change in the difference by one-tail t test when comparing it, and show it as a filled circle and non-filled circle. Below is the small sample data.
| Index | Name | ID | Question | Score | Date |
| 1 | A | 1 | Q1_A1 | 10 | 1/9/2022 |
| 2 | A | 2 | Q1_A2 | 8 | 3/9/2022 |
| 3 | C | 1 | Q1_A5 | 0 | 5/9/2022 |
| 4 | A | 3 | Q1_A4 | 2 | 11/9/2022 |
| 5 | B | 1 | Q1_A2 | 8 | 18/9/2022 |
| 6 | C | 2 | Q1_A3 | 5 | 19/9/2022 |
| 7 | A | 4 | Q1_A3 | 5 | 20/9/2022 |
| 8 | A | 5 | Q1_A2 | 8 | 21/9/2022 |
| 9 | B | 2 | Q1_Q1 | 10 | 22/9/2022 |
| 10 | C | 3 | Q1_A1 | 10 | 24/9/2022 |
| Q & Ans no. | Score |
| Q1_A1 | 10 |
| Q1_A2 | 8 |
| Q1_A3 | 5 |
| Q1_A4 | 2 |
| Q1_A5 | 0 |
