So, having done calculations on these once again, I can verify the following are the absolute values for raw scores of 77 LT testakers, 41 CP testtakers which I included for some reason since I saw you had used their values.
Sociological methods have told me in the past to use N-1, and that's what SPSS is doing, using N-1 for the statistical analysis for deviation. However. I have calculated the scores for you in both excel sheets using N only for a reference. The SPSS screenshots are reflective of N-1 only. It doesn't have a divide by N option. I understand the unmodified N value is important to you, so I have done both.
And these should be the final answers for raw combined scores.
Final draft:
Prospective Lieutenants raw combined score:
Mean:
68.2585
Std Dev (N):
09.4349
N Range:
58.8236 - 77.6934. (You can do the rounding if you wish, I left it there for technical purposes.)
Std Dev (N-1) here for "completeness":
09.4106
N-1 Range 58.8479-77.6691 (You can do the rounding if you wish, I left it there for technical purposes.)
Prospective Captains raw combined score:
Mean:
70.9756
Std Dev (N) here for "completeness":
09.1504
N Range:
61.8252 - 80.2397. (You can do the rounding if you wish, I left it there for technical purposes.)
Std Dev (N-1):
9.2641
N-1 Range:
61.7115 - 80.2397. (You can do the rounding if you wish, I left it there for technical purposes.)
Data & Proof
Read carefully if you want to check for errors or double check your answers and mistakes.
Above is excel computed data for the
Lieutenant's exam.
Above is SPSS computed data for the
Lieutenant's exam. (Again, SPSS only has N-1 values available for analysis like I said. It is here for completeness purposes)
Above is excel comuted data for the
Captain's Exam.
Above is SPSS computed data for the
Captain's exam. (Again, SPSS only has N-1 values available for analysis like I said. It is here for completeness purposes.
This concludes the Raw combined scores statistical section.
Note: I was finally able to calculate Standard Error percentage, but as jillio says this is for hypothesis testing only.