Question

The SAT is a standardized test used by many colleges and universities in their admission decisions. More than one million high school students take the SAT each year. A perfect score of all three parts of the SAT is 2400. The data set contains a sample of SAT scores for a graduating high school class. Using Excel, Show your work.

SAT Scores

1665

1275

1650

1590

1475

1490

1525

2135

1560

1880

1680

1560

1355

1280

1150

1420

1440

940

1645

1060

1485

1755

1260

1390

1780

1585

1990

1375

1730

1175

1. Assuming SAT scores are normally distributed, compute the following?

P(SAT < 950)
P(SAT > 1350)
P(1000 < SAT < 2100)

2. What SAT score would you need to be in the top 75%?

What SAT score would you need to be in the lowest 25%?

Top 75%
Lowest 25%

3. Create a frequency and relative frequency distribution of the SAT scores. The first class should start at 800. Use class width of 200. Create a histogram of the frequency distribution.

Answer 1

Here is the R code I used for above:

Here is the histogram