Reference no: EM132377694

Are the data Normal? SAT mathematics scores. Georgia Southern University (GSU) had 2718 students with regular admission in its freshman class of 2013. For each student, data is available on their SAT and ACT scores, if taken, high school GPA, and the college within the university to which they were admitted. See the Excel Spreadsheet for the data

a) Use Excel to make a histogram of the distribution. Although the resulting histogram depends a bit on your choice of classes, the distribution appears roughly symmetric with no outliers.

b) Find the mean, median, standard deviation, and quartiles for these data. Comparing the mean and the median and comparing the distances of the two quartiles from the median suggest that the distribution is quite symmetric. Why?

c) In 2013, the mean score on the mathematics portion of the SAT for all college-bound seniors was 514. If the distribution were exactly Normal with the mean and standard deviation you found in part

(b), what proportion of GSU freshmen scored above the mean for all college-bound seniors? d) Compute the exact proportion of GSU freshmen who scored above the mean for all college bound seniors. It will be simplest to use the ordered scores in the SATMATH file to calculate this. How does this percentage compare with the percentage calculated in part (c)? Despite the discrepancy, this distribution is "close enough to Normal" for statistical work in later chapters.

Note: it did not let me attach the excel spreadsheet (what should I do? )