Many of you took the SAT exam before college. Let’s review the latest national (U.S.) data reported by the College Board on SAT results, as posted here:
https://reports.collegeboard.org/media/2022-04/2021-total-group-sat-suite-of-assessments-annual-report%20%281%29.pdf
Complete this HW in EXCEL and submit an excel document.
What are the mean and SD for: Overall (Total) SAT score, ERW and Math?
Do these scores follow a normal curve? How do you know?
Using a normal curve table, what percentage of students have a Z score a.) below 1.5, b.) above 1.5, c.) above 2.10, d.) below 2.10, e.) below -1.5, f.) above .45, g.) below -1.78?
What is the SAT score if a student had a z score of a.) .45, b.) 1.5, c.) 2.10, d.) -1.5, e.) -1.78
What SAT score is needed to be in the a.) top 10%? b.) top 25%? c.) top 50%?
Review the differences by gender, first language learned, and parental highest education (page 3 & 6). Please write up a brief description of the pattern of results for each table.
Important - Read this before proceeding
These instructions reflect a task our writers previously completed for another student. Should you require assistance with the same assignment, please submit your homework details to our writers’ platform. This will ensure you receive an original paper, you can submit as your own. For further guidance, visit our ‘How It Works’ page.