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.

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

"Use Excel to calculate your answers.

please mention excel formulas along with answers wherever possible. "

Q. Compute the following descriptive statistics:

n =?

mean =?

median = ?

stand dev = ?

variance = ?

range= ?

Q. Find the 15th and 85th percentile. Explain your answer.

P.15 = ?

P.85 = ?

Explanation:

Q. Find the percent rank of scores 1000 and 2000. Explain your answer.

P(1000) = ?

P(2000) = ?

Explanation:

Q. Assuming SAT scores are normally distributed, compute the following:

P(SAT < 950)= ?

P(SAT > 1350)= ?

P(1000 < SAT < 2100)= ?

Q. 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%= ?

Q. Make a frequency and relative frequency distribution of the SAT scores.

The first class should start at 800. Use class width of 200.

Q. Make a histogram of the frequency distribution.attach picture