How do you rank each students' scores in the four science assignments grade scores 1 through 12 where 1 is the highest score, and 12 the lowest score F?

The data are found in the following columns:

The following table contains data from four science assignments

SPSS Dataset

Student A1 A2 A3 A4

1. 97 28 89 9

2. 94 86 80 39

3. 95 80 82 10

4. 97 39 83 14

5. 96 60 87 38

6. 95 42 84 34

7. 94 38 85 31

8. 95 60 85 21

9. 98 62 84 12

10. 96 51 83 20

11. 96 53 86 38

12. 98 32 85 27

a.In a separate document, create two columns to compare the totscores (total scores) and the tot_tscores (total t-scores). Please use the following grade breakdown to rank the assignment grade scores 1 through 12, where 1 is the highest score A, and 12 the lowest score F:

a.A to rank 1

b.B to rank 2

c.B- to rank 3

d.C+ to rank 4

e.C to ranks 5, 6, 7, and 8

f.C- to rank 9

g.D+ to rank 10

h.D to rank 11

i.F to rank 12

b.Answer questions 7 through 13

1.Determine what is unusual about student 1's performances on the tests.

2.What is strange about student 2's performances? How do the performances of these two students differ, and how are they the same?

3.What grades would be assigned to these two students if the total of the raw scores were used to determine grades?

4.What grades would be assigned to these two students if the total of the t-scores were used to determine grades?