Table 1
Excel Calculation of the Various Statistical Parameters to Determine the Difference between Females and Males on the Mathematics Assessment Scale Scores
| Male Math Scale Scores | Female Math Scale Scores | |
| 1. |
489 |
578 |
| 2. |
506 |
552 |
| 3. |
607 |
574 |
| 4. |
543 |
683 |
| 5. |
559 |
520 |
| 6. |
496 |
556 |
| 7. |
451 |
566 |
| 8. |
517 |
552 |
| 9. |
471 |
563 |
| 10. |
394 |
607 |
| 11. |
450 |
522 |
| 12. |
441 |
499 |
| 13. |
479 |
559 |
| 14. |
413 |
570 |
| 15. |
440 |
537 |
| 16. |
474 |
528 |
| 17. |
456 |
607 |
| 18. |
440 |
624 |
| 19. |
474 |
624 |
| 20. |
466 |
620 |
| 20. |
539 |
624 |
| 22. |
441 |
578 |
| 23. |
474 |
494 |
| 24. |
446 |
424 |
| 25. |
441 |
506 |
| 26. |
563 |
501 |
| 27. |
424 |
471 |
| 28. |
380 |
504 |
| 29. |
552 |
620 |
| 30. |
394 |
556 |
| 31. |
456 |
413 |
| 32. |
486 |
496 |
| 33. |
491 |
494 |
| 34. |
520 |
471 |
| 35. |
509 |
446 |
| 36. |
419 |
470 |
| 37. |
456 |
522 |
| 38. |
476 |
441 |
| 39. |
501 |
499 |
| 40. |
563 |
424 |
| 41. |
546 |
514 |
| 42. |
496 |
450 |
| 43. |
531 |
517 |
| 44. |
531 |
476 |
| 45. |
537 |
591 |
| 46. |
525 |
556 |
| 47. |
479 |
470 |
| 48. |
430 |
|
| Mean |
483.8723404 |
529.1458333 |
| Standard deviation |
50.54383247 |
63.4323193 |
| Variance |
2554.679001 |
4023.659131 |
| Count |
47 |
48 |
| T value |
4.944277 |
|
| T test P |
0.000222646 |
|
| Cohens d |
0.788461 |
|
| df |
478.602 |
Delegate your assignment to our experts and they will do the rest.
Table 1 above shows the data set of the two groups; the females and males on the mathematics assessment scale scores. The manipulations is done in excel are also included to facilitate the comparison of the two data sets. The findings of the calculation are consolidated into a report below.
Report
There is a large statistical significant difference between the male ( M = 483.87, SD = 50.54) and the female ( M = 529.15, SD = 63.43) on the math scale score, t (478.60) = 4.94, p = .0002, 95% CI, d = 0.79 A Cohen’s d of 0.79 indicated that female scored 0.79 standard deviations higher than male. This is a statistically significant difference in the math scale score. Because it is larger than a Cohen’s d of . 5 as noted by Cumming & Calin-Jageman, (2016).
Reference
Cumming, G., & Calin-Jageman, R. (2016). Introduction to the new statistics . New York: Routledge.
