Question

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.61or 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.61? (Use 4 decimal places in your answer).

ANSWER: .1103

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 97.74^th percentile. What is the minimum GPA required to meet this criterion?

ID Num	Gender	Age	Height	Class	Major	Grad School	GPA	Expected Salary	Annual Salary in 5 Years	Employment Status	Number of Affiliations	Satisfaction Advisement	Spending
ID01	M	19	69	SO	MR	Y	3.19	40	70	UN	0	2	550
ID02	M	21	67	SR	M	UN	3.11	50	60	PT	0	2	400
ID03	M	20	68	JR	EF	N	3.02	50	60	PT	0	5	450
ID04	M	18	79	FR	EF	Y	4.00	50	57	PT	0	5	360
ID05	M	19	67	SO	M	Y	2.75	40	100	PT	1	1	500
ID06	M	21	70	JR	A	Y	3.24	60	100	PT	2	5	650
ID07	M	20	68	JR	EF	Y	2.93	50	75	UN	0	4	500
ID08	M	21	71	JR	M	Y	3.26	40	60	PT	0	1	500
ID09	F	20	62	SO	MR	N	3.21	45	65	PT	0	4	350
ID10	M	19	70	SO	A	Y	3.23	50	70	PT	0	6	300
ID11	M	36	67	SO	A	UN	3.77	60	120	PT	1	4	200
ID12	F	19	65	SO	A	UN	3.71	40	60	UN	0	5	550
ID13	F	20	65	JR	A	UN	3.20	45	65	PT	3	5	425
ID14	F	21	65	JR	MR	Y	2.94	40	60	PT	0	4	600
ID15	F	19	66	SO	MR	Y	3.22	40	80	PT	0	3	600
ID16	M	20	69	JR	UN	UN	3.34	60	90	PT	0	5	400
ID17	F	19	64	FR	IS	UN	3.09	40	65	UN	1	4	250
ID18	M	20	67	JR	MR	N	3.72	50	80	PT	2	4	350
ID19	M	23	70	JR	EF	UN	2.50	50	75	UN	0	2	400
ID20	M	20	70	SO	EF	Y	2.74	60	75	UN	0	4	400
ID21	F	20	63	SO	MR	Y	3.55	60	100	PT	2	5	500
ID22	F	19	67	SO	M	UN	3.00	45	65	PT	0	3	600
ID23	F	19	65	SO	MR	Y	3.62	40	90	PT	0	3	400
ID24	F	20	63	JR	M	UN	2.60	40	60	PT	1	3	500
ID25	F	22	63	SR	EF	Y	3.63	50	150	PT	3	6	1000
ID26	F	21	65	SR	O	N	2.38	40	60	PT	2	4	300
ID27	M	21	73	JR	M	Y	2.45	40	65	PT	0	2	450
ID28	M	30	71	JR	M	N	3.28	50	75	PT	0	5	550
ID29	F	20	66	SO	IS	UN	3.18	50	75	UN	1	5	600
ID30	M	24	62	SO	A	N	3.33	55	85	PT	0	4	400
ID31	F	19	69	SO	MR	UN	2.87	30	50	PT	0	3	700
ID32	F	33	67	SR	A	N	3.14	45	75	FT	0	5	500
ID33	F	19	64	FR	IS	N	3.44	45	90	PT	1	6	350
ID34	M	20	72	SO	M	Y	3.85	60	100	PT	1	1	450
ID35	F	22	61	JR	O	Y	3.50	45	60	UN	0	7	600
ID36	M	21	69	SO	EF	N	2.92	55	85	PT	0	5	400
ID37	F	19	60	FR	A	UN	2.80	55	80	PT	0	3	450
ID38	F	21	66	JR	MR	UN	2.67	40	65	PT	0	3	800
ID39	M	20	69	SO	A	UN	2.65	45	80	UN	0	3	400
ID40	F	20	63	SO	IS	N	2.88	50	80	UN	1	4	375
ID41	F	19	65	SO	EF	UN	3.43	50	100	PT	0	3	400
ID42	F	21	63	JR	EF	Y	3.48	60	110	PT	0	5	500
ID43	M	20	68	SO	A	UN	2.91	45	90	PT	1	4	350
ID44	M	19	72	SO	A	N	2.75	50	80	PT	0	5	525
ID45	M	22	69	JR	IS	Y	3.62	55	85	UN	2	4	400
ID46	M	21	68	JR	M	N	2.42	35	60	PT	1	3	450
ID47	F	22	66	JR	MR	N	2.76	40	65	PT	0	3	500
ID48	M	19	69	FR	UN	UN	3.10	45	70	PT	0	4	400
ID49	M	20	68	SO	IS	N	2.61	40	65	PT	1	3	450
ID50	F	20	66	SO	IS	N	3.13	45	80	PT	0	2	500

Answer 1