Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Answer each question on a separate Excel Sheet using Data Analysis and Data Analysis Plus or XLSTAT. Analysis: 1) State your chosen method of analysis;

Answer each question on a separate Excel Sheet using Data Analysis and Data Analysis Plus or XLSTAT.

Analysis: 1) State your chosen method of analysis; 2) present the test results in tables Note: If the question involves hypothesis testing present the null and alternative hypothesis.

Discussion: For each question briefly discus the findings of the study, what do they mean? how can they aide in decision making?

Estimate with 95% confidence the portion of marketing students that took part in coop (code 1 from the dataset).
Years of experince(for Accounting, HR and Marketing) Marketing Salary Human Resources Salary Accounting Salary Accounting GPA Coop for Marketing Students
between 1 and 5 46624 28724 53000 3.95 0
between 1 and 5 47624 31524 57500 2.67 1
between 1 and 5 42024 60124 45600 3 1
between 1 and 5 57024 40424 35400 3.45 0
between 1 and 5 53624 33124 55100 3.93 0
between 1 and 5 56424 38124 44300 2.65 0
between 1 and 5 58024 41924 47500 2.98 0
between 1 and 5 62124 42724 34400 3.43 1
between 1 and 5 47324 62424 47600 3.91 0
between 1 and 5 51424 29924 40200 2.63 0
between 1 and 5 43724 52124 56400 3.95 0
between 1 and 5 49024 58724 57500 2.67 0
between 1 and 5 45224 24624 38500 3 1
between 1 and 5 48924 32424 35500 3.45 0
between 1 and 5 41224 50124 51600 3.93 1
between 1 and 5 48124 60824 56100 2.65 1
between 1 and 5 38824 30324 51200 2.98 1
between 1 and 5 32324 56824 58500 3.43 0
between 1 and 5 54924 28024 42400 3.91 0
between 1 and 5 72324 58424 35700 2.63 1
between 1 and 5 49724 44924 47900 3.97 0
between 1 and 5 33624 39224 44200 2.69 1
between 1 and 5 51424 52924 47400 3.02 0
between 1 and 5 62424 42924 40300 3.47 1
between 1 and 5 53124 38924 53100 3.95 0
between 1 and 5 44724 41924 36600 2.67 0
between 1 and 5 38424 34524 39200 3 1
between 1 and 5 48424 39324 46800 3.45 0
between 1 and 5 54024 38824 58500 3.93 0
between 1 and 5 64824 24724 47300 2.65 1
between 1 and 5 40624 38524 51800 3.97 1
between 1 and 5 51124 38524 37700 2.69 1
between 1 and 5 63724 16024 38900 3.02 0
between 1 and 5 47224 48524 35400 3.47 0
between 1 and 5 36924 38824 45100 3.95 1
between 1 and 5 54824 34524 64500 2.67 0
between 1 and 5 58724 46824 47400 3.96 1
between 1 and 5 51724 63624 54700 2.68 1
between 1 and 5 41924 61024 40800 3.8 0
between 1 and 5 59924 47924 37500 2.72 0
between 1 and 5 58424 24924 37300 3.05 0
between 1 and 5 51924 34624 42800 3.5 1
between 1 and 5 47824 47124 51600 3.98 0
between 1 and 5 39324 53124 55300 2.7 1
between 1 and 5 58124 40924 42300 3.99 0
between 1 and 5 34724 35324 51500 2.71 1
between 1 and 5 52324 56024 38100 3.99 1
between 1 and 5 53424 69024 40500 2.75 0
between 1 and 5 41024 56824 41600 3.08 0
between 1 and 5 46224 48824 56400 3.53 0
between 1 and 5 44824 28424 48500 3.48 0
between 1 and 5 38424 42324 55900 3.43 1
between 1 and 5 52724 51424 40400 3.38 0
between 1 and 5 49424 54024 34500 3.33 0
between 1 and 5 63124 49824 54200 3.28 0
between 1 and 5 42524 50124 60100 3.23 0
between 1 and 5 45024 60124 25400 3.18 1
between 1 and 5 55624 43924 35100 3.13 0
between 1 and 5 56024 41224 36400 3.08 1
between 1 and 5 54924 30424 46600 3.03 0
between 1 and 5 59524 50224 55700 2.98 1
between 1 and 5 51524 54224 38900 2.93 0
less than 1 44424 32424 85100 3.7 1
less than 1 32524 35124 44600 3.84 1
less than 1 49724 52924 40700 3.22 1
less than 1 47124 44124 44800 3.78 0
less than 1 46324 37824 43500 3.26 0
less than 1 36224 41124 46800 3.21 1
less than 1 42724 43824 50700 3.16 0
less than 1 40924 37624 51100 3.11 1
less than 1 41524 36924 44600 3.19 1
less than 1 47624 44824 37500 1.95 0
less than 1 56824 31124 45700 2.28 0
less than 1 48324 55924 48800 2.73 0
less than 1 50424 50724 55800 2.68 1
less than 1 36924 51324 56300 2.63 0
less than 1 53424 36324 40900 2.58 1
less than 1 46424 65124 45000 2.53 0
less than 1 40624 42124 41300 2.48 1
less than 1 52224 57624 46400 2.43 1
less than 1 32824 53024 49200 3.92 0
less than 1 61224 54724 40600 2.64 0
less than 1 47024 43624 47900 3.96 0
less than 1 36324 44124 41700 2.68 0
less than 1 44024 42024 47900 3.01 1
less than 1 40624 51224 68600 3.46 0
less than 1 45124 43524 55100 3.94 0
less than 1 59924 46324 34200 2.66 0
less than 1 45524 46924 52300 3.95 0
less than 1 43924 31924 44000 2.67 1
less than 1 36624 40824 40400 3.99 0
less than 1 44024 39724 39100 2.71 1
less than 1 64724 37824 48500 3.04 1
less than 1 46424 48024 46200 3.49 1
less than 1 49824 44524 43000 3.97 0
less than 1 40524 40824 48300 2.69 0
less than 1 50624 57324 45300 3.98 1
less than 1 56624 57224 50600 2.7 0
less than 1 39924 41624 50000 2.66 1
less than 1 51524 51924 46800 2.99 0
less than 1 30624 44224 44000 3.44 1
less than 1 50724 62424 37000 3.92 0
less than 1 33824 33924 40200 2.64 0
less than 1 52424 38324 55400 3.96 1
less than 1 52324 41724 54000 2.68 0
less than 1 51324 57224 41500 3.01 0
less than 1 51524 52424 51000 3.46 1
less than 1 48824 37824 45500 3.94 1
less than 1 46524 56324 44800 2.66 1
less than 1 57624 42724 51100 2.99 0
less than 1 60124 39224 53300 3.44 0
less than 1 47524 38024 51500 3.92 1
less than 1 37124 35824 43200 2.64 0
less than 1 32624 61824 51900 3.98 1
less than 1 53724 46824 45900 2.7 1
less than 1 46924 34524 38900 3.03 0
less than 1 36324 33924 42900 3.48 0
less than 1 38124 34024 45400 3.96 0
less than 1 69424 46924 51600 2.68 1
less than 1 41124 38824 44600 3.01 0
less than 1 48224 18224 35900 3.46 1
less than 1 60424 43724 49600 3.58 0
less than 1 70524 62524 33400 2.66 1
less than 1 47524 23324 49300 3.98 0
more than 5 44024 62324 49500 3.4 1
more than 5 67024 63124 51600 3.76 1
more than 5 46824 32524 50000 2.96 0
more than 5 66624 52624 50000 2.45 0
more than 5 40624 46624 53700 3.46 1
more than 5 51324 38024 43000 3.59 0
more than 5 44924 47424 47900 2.66 1
more than 5 48324 53924 50400 2.99 0
more than 5 54224 54124 43600 1.86 1
more than 5 56724 24024 43500 2.19 0
more than 5 38924 43824 44500 2.64 0
more than 5 57324 53124 60000 3.12 1
more than 5 51924 56824 50600 1.84 0
more than 5 52324 46524 36600 3.18 0
more than 5 59924 46624 44000 1.9 1
more than 5 50024 23324 40100 2.23 1
more than 5 46724 43224 47700 2.68 1
more than 5 40224 44324 42500 2.66 0
more than 5 43724 55524 51100 3.98 0
more than 5 46124 64824 54300 2.7 1
more than 5 28424 17124 43500 3.03 0
more than 5 36624 56824 37600 3.48 1
more than 5 39224 53224 37200 3.55 1
more than 5 49724 34224 57500 2.68 0
more than 5 39424 42924 35100 3.97 0
more than 5 49124 39324 42300 2.69 0
more than 5 44024 37324 34500 2.65 1
more than 5 45124 55524 43300 2.98 0
more than 5 40524 32424 30400 3.43 1
more than 5 55724 43524 56400 3.91 0
more than 5 46424 41324 45800 2.63 1
more than 5 45324 44824 46500 3.56 1
more than 5 46624 50124 50300 2.67 0
more than 5 44224 37124 50100 3 0
more than 5 44624 51224 44000 3.45 0
more than 5 63124 32824 54000 3.27 0
more than 5 25524 37024 47600 3.22 1
more than 5 62024 41024 46600 3.17 0
more than 5 42624 46224 54100 3.12 0
more than 5 35124 48224 54800 3.2 0
more than 5 47224 49524 49900 1.96 0
more than 5 48924 19124 46500 2.29 1
more than 5 34724 42824 33700 2.74 0
more than 5 45824 40324 47200 2.69 1
more than 5 53624 48724 42600 2.64 1
more than 5 27224 41424 47900 2.59 1
more than 5 55124 38824 58400 2.54 0
more than 5 58124 47124 40400 2.49 0
more than 5 40224 33624 48500 2.44 1
more than 5 48324 61124 60200 3.93 0
more than 5 41924 39824 66600 2.65 1
more than 5 41224 36724 44600 3.56 0
more than 5 44624 64324 34100 2.69 1
more than 5 52324 36324 52400 3.02 0
more than 5 63824 44524 43400 3.47 0
more than 5 69724 55824 38200 3.95 1
more than 5 41624 49824 52000 2.67 0
more than 5 41524 65424 45300 3.56 0
more than 5 55224 64324 39500 2.68 0
more than 5 55624 53624 41500 3.5 1
more than 5 63024 45524 60800 2.72 0
more than 5 55824 48124 33900 3.05 0

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Algebra

Authors: Margaret L Lial, John E Hornsby, Terry McGinnis

10th Edition

0321900405, 9780321900401

More Books

Students also viewed these Mathematics questions