Reference no: EM131907008

This Excel file Undergrad Survey shows the data resulting from a survey of 50 undergraduate students at Clemson University. Majors of students in the survey are accounting (A), economics and finance (EF), management (M), marketing (MR), computer information systems (IS), other (O), and undecided (UN). "Number of affiliations" is the number of social networking sites at which the student is registered; "Spending" is the amount spent on textbooks for the current semester. The other variables are self-explanatory.

We will assume that this sample is a representative sample of all Clemson undergraduates. Use Excel or statcrunch to make a histogram of GPA to verify that the distribution of GPA can be approximated by the N(3.12, 0.4) normal model.

Question 1. The School of Business at Clemson has created a rigorous new International Business Studies major to better prepare their students for the global marketplace. A GPA of 3.75 or higher is required for a Clemson undergraduate to change his/her major to International Business Studies. What is the probability that a randomly selected Clemson undergraduate has a GPA of at least 3.75? (Use 4 decimal places in your answer).

Question 2. To attract high-quality current Clemson undergraduates into the new International Business Studies major, scholarships in International Business Studies will be offered to a Clemson undergraduate if his/her GPA is at or above the 96.56^th percentile. What is the minimum GPA required to meet this criterion?