Question

question 2 refers to the chart of numbers please show work and attach files if could

sorry for the small pictures but attach files if needed thank you ! heres pictures zoomed in

Question 3 points) Suppose that someone claims that the mean income of two group of individuals is equal. In order to test that claim, a researcher earns $1,448 more on average than the other group. Is that sufficient evidence to reject the claim that the mean income in the two populations is equal? collects two samples and finds that the one group ***Continued on Page 2* (10 points) Question 2 Part (a) Open the "Union Status and Income.xlsx" file that is posted with the assignment. In order to test whether there is a difference in the variance of income between Union members and non-Union members, use Excel to carry out an "F-Test: Two-Sample for Variances" with a 0.05 You must submit your actual Excel file with the output as part of the assignment (3 points) Part (b) (3 points) Still using the "Union Status and Income.xlsx" file, carry out a t test in Excel (with α-0.05) that tests whether there is a difference in mean income between Union members and non- Union members. Note that the decision of which of the t-tests in Excel is appropriate depends on your result from Part (a). You must submit your actual Excel file with the output as part of the assignment. Part (c) Based on the t-test, what is your decision ("reject" or "do not reject") regarding the null hypothesis that the two population means are equal to each other? Indicate on which part of the Excel output you base your decision. (1 point) Part (d (3 points) Explain what your answer to part (c) means at a level that can be understood by a high school senior ndividuals Annual Salaries by Union Status Annual Salary Annual Salary f Members Members Question 3(5 points) Part (a) Using the "Experience and Income.xlsx" file, determine the sample correlation coefficient between the annual salary and the job market experience variables. You must submit your actual Excel file with the output as part of the assignment. Part (b)(2 points) Interpret the sample correlation coefficient you found in part (a). (1 point) Part (c) If we regressed income on experience, what share of the variation in income could be explained by the variation in (2 points) experience? Explain how you found your answer. ndividuals' Annual Salaries by Union Status Annual Salary Annual Salary of of Union Members Non-Union Members 1254015 75352 5 33199.5 28959 19977 19743 26341 0192 5 99715 21714 29178 74961 34540.5 28128 0191.5 37749 271815 48141 0938.5 54267 22851 74961 337275 45462 17553 16779 18427 5 71765 864345 125164 5 47553 1908 66814 225195 50083 90939 367635 31278 451995 25194 11895 441105 239355 51726 527775 62670 22740 100107 50247 447135 227895 127475 125353.5 18 38 44 54 33 17 34 25 10 18 6 4 4 39 13 40 4 26 22 10 6 0 42 38 31 8 5 26 44 39 9 10 21 22ア15 38 27 25 4 6 9 9 10 28 2 9 9 21 45 29 4 20 29 15 34 12 45 29 14 15 14ァ38ァァ28 6 26 5

Answer 1

Answer Suestiont Clive -HAat Sue oe clain thot the mean income dtioo でcup od individuals i eawal. Zn edev to test -that clain, a ree Collects toe samptes and findr that tthe one qsoup eavns uus mone on avera No,tht t not Sutficteut evidence to reject 4lhe claim Hiat the meau tucome ol the tue poputatt ons Jur Comp meant ad eei ttat the mean to deteami'ne cohether the poplation mean nceme tor the tS tthan -the other not enough one To underctand tic e at tie test Statictics cohich coul be -t clenominatw, -tlfi test Stah'stic μ oolcug at tihe hi 1Ydependeut upon -the Qample Standod deviation-tov ore tueo qsoupe. So even ttre mean diffevence Geems ligi, if the Standad deviation are We h enough -ften ttne Value 0€-fae above Stat&tic coould b。FLduced

and on urther testing, there chauce that coe Couclude that tthe mean come e tthe popeulationg ave the Came ON