Statistics Computer Homework Excel

profilekayladolan
homework_1_raw_data.xlsx

Raw Data

Age (months) Distance (miles) GPA Major Year Stat Class ? Anxiety Work Hours # Other Classes Study Hours
216 0 3.85 Bus. Freshman No 3 0 5 35 Age (months) Your age converted to months (e.g., 20 years and 3 months would be 243 months):
217 0 3.41 CIS Sophmore Yes 1 0 5 15 Distance (miles) Distance in miles from where you lived during high school to UofL:
219 0 4.00 Acct. Freshman Yes 2 0 6 10 GPA Your GPA:
224 1 3.20 Mktg. Freshman No 4 0 6 10 Major Your major or planned major:
224 2 4.00 Econ. Freshman No 3 0 5 100 Year Your class year at UofL (F=freshman, S=sophomore, J=junior, R=senior, G=grad, O=other):
224 2 3.10 Acct. Freshman No 4 0 5 15 Stat Class ? Have you taken statistics previously, either in high school or college? (Yes or No)
224 3 4.00 Mktg. Freshman No 3 0 5 10 Anxiety Your level of anxiety about this course on a 1-5 scale with 1 = None and 5 = very high:
225 5 3.40 Bus. Freshman No 4 17.5 5 5 Work Hours Average number of hours per week you work (for pay):
227 6 3.00 Equine Sophmore No 2 0 6 10 # Other Classes Number of other classes currently enrolled in: Indicate number (indicate 0, 1, 2 etc.)
228 8 4.00 Other Freshman No 3 0 6 14 Study Hours The average number of hours per week you study during a Normal semester.
228 8 2.90 Mktg. Sophmore No 3 15 4 20
228 9 2.90 Acct. Sophmore No 3 30 4 10
228 10 3.72 Fin. Sophmore No 5 12 5 18
228 10 3.80 Fin. Sophmore Yes 3 26 4 28
228 10 3.58 Equine Sophmore Yes 3 0 6 10
228 11 2.80 CIS Sophmore Yes 5 30 3 8
229 12 2.81 CIS Freshman No 4 0 4 12
229 12 3.00 CIS Sophmore No 3 12 4 16
230 12.8 3.45 Econ. Sophmore No 3 11 5 10
230 13 3.97 Acct. Sophmore No 2.5 0 4 15
230 13 3.00 Bus. Sophmore No 3 0 4 10
231 14.5 3.86 Econ. Sophmore No 3 0 4 10
231 15 3.10 Fin. Sophmore No 4 27 5 15
231 15 3.60 Acct. Sophmore No 3 15 4 10
231 15 2.85 Fin. Sophmore No 2 20 3 15
231 15 3.43 Econ. Sophmore Yes 3 8 4 15
233 15 3.30 Mktg. Sophmore No 3 15 5 10
233 15.3 3.25 Fin. Sophmore No 1.5 0 7 5
233 16 3.00 Mktg. Sophmore No 1 0 4 10
233 16.7 2.19 CIS Sophmore No 3 10 4 10
233 17 3.00 Acct. Sophmore Yes 1 25 4 15
233 18 2.30 Bus. Sophmore Yes 3 10 4 28
234 18 2.90 SPAD Sophmore No 3 15 5 30
235 18.4 3.76 Mktg. Sophmore No 2 7 6 20
235 20 4.00 CIS Sophmore Yes 2 0 4 6
235 20 3.91 Fin. Sophmore Yes 2 0 4 30
236 20 4.00 Fin. Sophmore No 3 0 5 10
236 20 3.00 Mktg. Sophmore No 1 0 5 10
236 20 4.00 Fin. Sophmore No 2 0 4 15
236 20 3.10 Acct. Sophmore No 2 40 6 20
236 20 3.90 Acct. Sophmore No 2 12 5 20
236 23 3.00 Fin. Sophmore No 2 40 4 30
236 25 2.72 Eng. Sophmore No 3 20 5 30
236 30 3.50 Econ. Sophmore No 4 15 4 20
236 30 3.60 Acct. Sophmore No 3 6 5 9
236 30 3.33 Mktg. Sophmore Yes 3 20 5 25
237 35 3.20 Acct. Sophmore No 3 0 5 17
237 35 3.55 Acct. Sophmore No 2 15 3 20
238 41 4.00 Acct. Sophmore No 3 3 4 8
238 45 3.79 Mktg. Sophmore No 3 30 4 8
238 45 4.00 Acct. Sophmore No 3 3 4 8
239 45 3.50 Econ. Junior No 2 10 4 30
239 48 3.57 Acct. Sophmore No 3 0 5 25
239 55.8 3.57 Acct. Sophmore No 3 0 5 25
239 60 4.00 CIS Sophmore No 2 0 3 10
239 60 3.07 Bus. Sophmore No 4 32.5 4 10
239 65 2.80 Fin. Sophmore Yes 4 20 5 25
240 75 3.05 Comm. Junior No 5 15 5 20
240 79 3.10 Other Sophmore No 1 30 4 30
240 79 3.72 Fin. Sophmore No 3 20 3 10
240 80 3.47 Mktg. Sophmore Yes 3 0 5 6
241 82.3 3.60 Acct. Junior No 2 20 5 10
241 90 3.71 Other Junior No 4 10 6 30
241 92.4 3.38 Mktg. Junior No 3 0 4 8
241 93 3.20 Bus. Junior Yes 3 25 4 6
241 94 3.22 Mktg. Sophmore No 2 0 5 20
241 96 3.60 Econ. Sophmore No 2 0 4 20
243 100 3.01 CIS Junior No 2 15 4 5
243 100 2.92 Acct. Junior Yes 3 0 4 10
243 100 2.92 Acct. Junior Yes 3 0 4 10
244 107 3.52 Mktg. Junior No 4 8 4 20
244 110 3.10 SPAD Junior No 5 16.5 5 7
244 110 3.07 Acct. Junior No 3 0 5 18
244 135 3.20 Fin. Junior Yes 4 24 4 20
245 135 2.88 Bus. Junior No 3 26 4 45
245 169 2.80 Eng. Junior No 2 45 3 10
246 185 2.60 Fin. Junior Yes 3 0 3 8
247 193 3.26 SPAD Junior No 4 30 4 5
248 196 3.22 Econ. Junior No 3 10 4 15
248 264 3.10 Bus. Sophmore No 4 36 3 3
249 274 3.10 Fin. Junior No 3 15 5 10
252 300 2.70 Mktg. Senior No 3 36 4 15
252 315 3.10 Acct. Senior Yes 5 18 3 10
255 383 3.46 Acct. Junior Yes 3 0 5 9
255 418 3.10 Fin. Sophmore No 3 0 5 6
256 427 3.00 Mktg. Junior No 3 20 4 12
259 500 3.30 Bus. Junior No 3 25 2 20
260 545 2.80 Equine Senior No 5 21 4 15
263 595 1.84 Acct. Sophmore No 1 20 3 14
265 673.69 4.00 Fin. Junior No 5 40 3 5
266 709 3.13 Acct. Junior No 4 20 4 10
267 709 2.80 Acct. Sophmore No 2 20 3 12
272 765 2.90 Comm. Senior Yes 3 25 4 15
273 767 3.00 Mktg. Junior No 3 36 3 7
280 780 1.98 Mktg. Junior Yes 3 0 3 25
288 800 3.60 Other Graduate No 2 0 3 6
313 920 2.90 Acct. Junior No 5 0 3 40
329 3000 3.00 Fin. Junior No 1 25 3 18
337 4543 3.80 CIS Senior No 3 35 4 25
344 5000 3.53 Acct. Junior No 0 0 4 70