I ran these figures through the SPSS, I'm not getting the same values as you are, either you or I am doing something wrong. I based the data input off Daredevel7's #236 post,
AllDeaf.com - View Single Post - Reverse Discrimination Case
Which the data of the 77 Firefighters were found here:
New Haven Firefighters File Reverse Discrimination Lawsuit
Here is a preliminary show of the data for you (if you want to double check), but trust me it is correct.
Here are the results:
??? How did you get your numbers.
This is meaningless. You are using the wrong statistical analysis. If you want to use SPSS, you need to obtain first your mean based on raw scores. You then need to obtain your standard deviation. Following that you need to obtain your z scores and your t scores. This needs to be done across all domains. You then need to do a scatter plot or a histogram based on z scores and t scores. You then need to sort by race. It doesn't appear that you have even entered your data into SPSS in the correct way that will allow you to run the applicable statistical analysis. You are running stats for hypothesis testing, and we are not testing a hypothesis. We are indicating frequency distribution as it applies to validity.
But to get the figures I have already posted on combined scores for the whole population, not sorted by race:
The sum of (X-M)squared divided by N. Then the square root of that figure. That will give you your SD. To achieve a normal curve, the majority of scores (68%) must fall around the mean of 70.98 in the range of 61.83-80.13.
If you check the raw scores and the way they are distributed, you will discover that you have a postive skew in the raw scores. When converted to z-scores, the scores are still distributed in a postive skew. When you sort by race, and domain, you will find a positive skew in all domains for the minority races, with the greatest postive skew for blacks in the written subset, and the greatest positive skew for Hispanics in the oral subset. However, because more weight was given to the written scores, the positive skew disparately shows with blacks moreso than Hispanics in the combined scores. This indicates a problem with validity for the minority populations.
Additionally, if you check your z-scores in the combined subset and you will find that in the Caucasion scores, you have 16 scores between the mean and +2 SD. You have, in this same population, 9 scores between the mean and -2 SD. This has a slightly negative skew, but approximates a normal distribution and is not cause for concern.
Check your z-scores for the Black population in the combined subset and you will find that you have 2 scores that fall between the mean and +2 SD. You have 6 scores that fall between the mean and -3 SD. The majority fall in the area between -1 SD and -2 SD. That creates a postive skew in the distribution.
Check your z-scores for the Hispanic population in the combined subset and you will find that you have 3 scores falling between the mean and +2 SD. You have 5 scores that fall between the mean and -2 SD, with the majority falling between -1 SD and -2 SD. This again creates a positive skew in the distribution.
Additionally, when using raw scores, your mean for the written portion is 72.05 with an SD of 10.30. Your mean for the oral portion is 69.45 with an SD of 11.81.
With these positively skewed distribution occurring in the minority populations only, one must question the cross cultural validity of the instrument used to obtain the scores...in this case the Lt. exam.
BTW, I just noticed that you are also using the wrong # for N. The number you should have used was 41 as the scores reported were only for the Lt. exam. Nor do the scores you have entered for the subsets reflect the raw scores reported. For instance, rank # 1 showed a raw score of 89.52 on the oral exam, a raw score of 95 on the written exam, and a raw score of 93 on the combined subset. I think you must have failed to account for the different weights, and therefore, came up with an incorrect combined score. Either that, or you attempted to use data from something other than the Lt. exam. You also have rank #6 listed as white, and rank #6 is actually Hispanic. You need to re-enter all of your data as reported in raw scores, and check your race column.
You have also listed "written, oral, and combined" as variables. Again, we are not doing hypothesis testing.
Those are the reasons that your descriptive statistics are off.