The provost at SWC, based on anecdotal evidence, is convinced that the student-faculty ratio (# of students

Fantastic news! We've Found the answer you've been seeking!

Question:

The provost at SWC, based on anecdotal evidence, is convinced that the student-faculty ratio (# of students divided by the number of faculty) is an important determinant of student success after graduation. The university president believes the overall prestige of the university is a bigger factor, and other administrators believe it is largely the academic quality of the students admitted that matters most. SWC has purchased some data that shows students’ starting salaries along with various characteristics of the universities the students attended. SWC wants to know if you can determine how the student starting salaries are related to the following variables in the data set: the per-semester cost of attendance, the region of the country in which the school is located, the student-faculty ratio, average high school GPA of students admitted, the size of the school’s library, and the school’s national rank. Specifically, the administrators want answers to the following questions

• What is the appropriate quantitative technique to determine how the variables are related?

• Which variables are important determinants of starting salaries? Be sure to explain how you are arriving at this conclusion.

• What strategy would you recommend for improving the starting salaries of SWC graduates? In addition to the questions above, SWC has requested a data visualization component in the report. You are to use multiple diagrams and appropriately formatted charts following the principles you learned in this course to help illustrate key findings. The data SWC has purchased can be found in Tab 1 of Excel file “Case 2 Data” located in the D2L course shell.

OBS	SALARY	REGION	COST	TOTSTUD	FACULTY	HSGPA	LIBVOL	RANK
1	34928	North	4214	2310	50	3.15	216	128
2	63122	South	7012	2090	48	3.50	256	104
3	80366	East	6398	2970	86	3.25	424	34
4	72859	East	7611	3047	150	3.20	329	49
5	67178	West	7100	1650	62	3.38	332	95
6	55443	West	6197	1716	44	3.40	311	98
7	55442	South	6776	1661	44	3.16	220	124
8	41289	South	4926	1639	50	3.12	230	157
9	43117	East	6318	3542	111	3.12	230	145
10	66851	South	6481	770	48	3.66	157	91
11	77222	East	6708	2959	86	3.55	320	50
12	88474	East	8036	4191	141	3.42	470	23
13	64935	West	6415	1683	53	3.60	330	78
14	104264	West	8373	2959	88	3.70	600	5
15	84342	West	7059	1760	42	3.45	371	27
16	97301	West	8568	4609	125	3.55	542	19
17	94940	West	7260	3850	106	3.57	470	13
18	49717	West	6553	4125	88	3.20	208	115
19	43045	East	7250	1309	39	3.20	147	171
20	39206	North	5388	2882	34	3.25	215	131
21	66120	East	6146	2805	79	3.30	352	72
22	65531	North	6602	2420	92	3.30	305	55
23	97623	North	7347	1958	44	3.75	555	4
24	67282	North	7197	1474	56	3.37	339	90
25	41472	North	4710	3300	79	3.35	290	133
26	73215	West	7520	1837	68	3.31	280	65
27	102628	East	8632	3795	111	3.60	735	7
28	66879	East	6918	1463	105	3.29	383	84
29	87574	East	7308	2101	62	3.55	400	10
30	59964	West	7555	2068	56	3.20	198	112
31	45031	South	6034	2585	64	3.10	210	137
32	42637	North	5596	2035	30	3.20	208	141
33	71551	West	6536	3751	91	3.20	275	47
34	73524	North	8244	4103	120	3.27	312	82
35	39055	North	6804	1606	66	3.00	200	144
36	62583	North	6405	1705	31	3.30	190	76
37	67058	East	8402	1947	67	3.40	325	94
38	58867	West	5889	2574	72	3.23	240	88
39	91795	East	6817	1056	90	3.70	450	9
40	62536	East	8327	2200	64	3.30	192	89
41	76822	South	7185	2596	86	3.40	260	43
42	78177	South	5715	2200	75	3.53	530	59
43	63693	South	5899	2244	64	3.30	346	81
44	90325	East	8034	6017	206	3.30	410	22
45	46043	East	7061	1474	56	3.00	186	142
46	44575	East	6014	2761	55	3.27	260	127
47	88795	East	8747	5225	216	3.51	403	31
48	94507	East	7295	7073	270	3.52	728	18
49	88061	South	8428	2651	57	3.40	456	46
50	27073	South	5867	2145	45	3.12	221	175
51	56755	West	6030	2607	120	3.14	200	79
52	60228	West	5803	2134	47	3.16	197	74
53	134187	East	5919	6083	124	3.75	1745	1
54	53598	West	7008	836	40	3.42	231	139
55	78557	East	6804	3124	74	3.25	395	28
56	82714	South	8368	3410	124	3.30	400	48
57	46989	East	7215	1771	46	2.85	240	116
58	30342	West	5075	1056	24	3.25	146	132
59	79879	North	6301	2255	72	3.40	593	38
60	91453	North	7556	2299	59	3.49	510	30
61	54181	North	5369	2904	69	3.30	410	109
62	25103	South	4387	1936	42	3.15	161	172
63	95437	West	7665	2563	59	3.49	727	17
64	50703	North	5228	2860	207	3.20	280	113
65	68746	West	6686	3322	43	3.43	325	62
66	59030	South	5354	1485	53	3.30	329	92
67	63111	West	9011	2706	110	3.20	325	123
68	78538	South	6586	3124	52	3.35	540	83
69	70482	South	7652	1562	43	3.20	236	93
70	66394	North	6756	2706	169	3.24	285	73
71	85992	West	9038	2046	106	3.35	341	36
72	40261	South	6137	2475	67	3.10	230	155
73	44082	East	6455	1045	25	3.30	280	150
74	69731	North	7309	1859	56	3.20	220	40
75	65291	East	5012	2871	113	3.35	325	57
76	67612	West	5616	4807	97	3.24	285	37
77	43891	South	5138	1826	45	3.20	246	140
78	55606	South	5765	1705	54	3.10	252	105
79	64171	South	6722	5302	152	3.20	392	107
80	105609	North	6952	4191	107	3.67	750	2
81	98003	North	7080	2970	141	3.56	800	20
82	71979	South	7801	1870	35	3.30	260	54
83	57516	South	6833	1661	39	3.00	220	85
84	67866	West	8605	1749	63	3.28	245	96
85	37778	North	5283	847	30	3.20	124	122
86	54679	West	6354	1782	62	3.40	304	97
87	49542	East	7100	4422	113	3.07	242	114
88	50577	South	6588	1199	53	3.20	350	125
89	63377	East	6888	4917	165	3.00	377	86
90	106459	East	8243	4730	116	3.25	888	11
91	33634	North	4053	2200	95	3.22	250	163
92	51727	East	7048	2299	61	3.23	165	110
93	28609	North	5571	1298	39	3.00	200	160
94	31371	South	4362	1892	52	3.31	234	167
95	98041	North	8295	2233	122	3.60	557	14
96	86215	North	8598	1925	66	3.45	340	35
97	42651	North	5916	1529	45	3.00	225	136
98	87986	North	6495	2475	63	3.50	590	33
99	59239	South	5120	2343	44	3.28	262	80
100	45213	South	6666	2607	53	3.03	216	134
101	69686	West	5786	1639	44	3.50	291	53
102	36494	East	6329	2552	86	3.30	280	162
103	103969	East	10133	2618	102	3.70	540	8
104	34924	South	6093	1639	62	3.38	211	165
105	48317	West	6300	3355	72	3.30	301	129
106	56172	South	9877	1793	96	3.23	216	148
107	74613	East	9769	2442	41	3.22	450	64
108	72362	East	8976	2662	39	3.39	393	60
109	66443	East	8832	3355	69	3.20	409	70
110	82362	South	10959	2849	65	3.30	400	68
111	41392	South	7391	2959	76	3.00	268	151
112	76513	West	9702	3707	125	3.25	320	52
113	68263	West	8184	2651	100	3.17	245	56
114	65504	West	8046	3146	58	3.32	210	61
115	73102	East	11028	4994	163	3.16	316	87
116	55004	East	8495	2640	76	3.20	326	118
117	36960	West	8783	847	20	3.24	156	153
118	33512	South	8387	5104	98	3.00	290	168
119	83379	West	8594	2200	53	3.50	330	26
120	54208	North	7988	1397	36	3.30	302	106
121	72854	South	7776	2816	45	3.18	440	42
122	72459	West	9601	4510	86	3.15	340	75
123	100956	West	11500	1980	57	3.78	414	6
124	46474	South	8317	2387	91	3.20	316	146
125	59087	East	8854	5720	143	3.30	300	108
126	70013	East	8864	3245	83	3.20	319	51
127	87150	East	11536	4356	209	3.30	439	45
128	55178	South	8599	1859	205	3.10	345	117
129	109536	South	10415	5753	155	3.50	850	12
130	37256	South	7499	2530	50	2.73	300	170
131	59986	South	9633	2552	64	3.10	260	101
132	45851	North	7558	3135	56	3.01	305	121
133	33967	North	7329	2552	64	3.10	260	154
134	33680	East	8320	3146	72	2.80	310	174
135	59216	South	8548	2376	62	3.00	260	100
136	83480	West	9953	1364	61	3.55	264	29
137	61585	North	7750	1925	46	3.30	215	69
138	89964	South	8637	2057	83	3.62	329	16
139	40265	East	8147	1793	58	3.20	175	152
140	72225	East	9274	2508	81	3.41	420	63
141	101428	East	9439	4180	118	3.60	700	15
142	62782	East	11361	1815	74	3.31	250	111
143	55518	West	8737	1628	65	3.27	251	102
144	98675	West	11866	1628	76	3.63	450	25
145	85578	East	10237	1375	53	3.47	297	16
146	75468	West	7832	2310	95	3.20	476	41
147	69287	North	8361	2574	73	3.35	415	67
148	50272	East	9361	2761	65	3.08	301	135
149	30568	West	6643	2717	44	3.00	230	156
150	53511	East	9232	7469	227	3.10	481	138
151	64028	East	7742	2002	43	3.20	244	66
152	98075	East	12431	1958	55	3.34	300	17
153	79174	North	6943	3135	52	3.40	450	21
154	36855	West	6619	869	19	3.40	174	143
155	102569	East	8462	1111	110	3.82	850	3
156	36130	North	4935	3597	39	3.15	200	120