Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please refer to the last 3 images are the data for question 2 In the Gamma worksheet of the le hw3.xlsx i, , you will

please refer to the last 3 images are the data for question 2

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
In the \"Gamma\" worksheet of the le hw3.xlsx i, , you will nd current annual salary data and related information for 30 employees at Gamma Technologies, Inc. These data include each selected employee's gender (0 = male, 1 = female), age, number of years of relevant work experience prior to employment at Gamma, number of years of employment at Gamma, the number of years of post-secondary education, and annual salary. Create a scatter plot to show the relationship between prior experience and annual salary. What does the scatter plot reveal about the relationship? The relationship is positive. The relationship is negative. There is no relationship between the variables. ' Question 2 O I 2 pts Refer to the problem above and its associated scatter plot. The fth observation (the one in the 8th row of the "Gamma" worksheet) is unusual and a potential outlier. Using the information in the data set, can you explain the "special cause" of the difference between that observation and the others in the scatter plot? I see at least two explanations and am hoping that you identify both. (NOTE: It is difcult to predict exactly how you will enter your answer in text form because there are many possible ways to word things. My answers assume that you are using the variable names that are found in the data set itself. If you try this a couple of times and don't get full credit, it may be because of the way I am checking for the right answer. In that case, send me an e-mail before your last submission and I will grade your question manually.) and According to Vickers, a box plot is best when both variables are continuous. When one variable is categorical, however, it makes sense to use a line graph Gamma Technologies, Inc. Employee Salary Structure Gender Age Prior Experience Gamma Experience Education Annual Salary 1 39 5 12 4 $37,500 0 44 12 8 6 $50,912 0 24 0 2 4 $29,356 1 25 2 1 4 $27,750 0 56 5 24 8 $97,844 1 41 9 10 4 $48,442 1 33 6 2 6 $40,207 0 37 11 6 4 $42,331 1 51 12 16 6 $87,489 0 23 0 1 4 $26,118 1 36 5 5 6 $40,025 0 58 9 22 4 $88,763 0 31 1 1 6 $35,829 1 21 0 1 2 $17,784 0 47 5 16 4 $54,199 1 35 3 7 4 $36,932 1 52 12 14 8 $93,278 0 29 3 3 2 $22,100 1 42 11 7 4 $49,987 0 60 10 21 4 $85,471 1 50 8 l3 4 $52,220 1 33 1 2 6 $36,109 0 26 0 5 2 $23,105 0 38 6 6 6 $39,455 1 44 7 12 4 $49,861 0 25 0 3 4 $30,327 1 37 8 5 4 $31,008 0 53 13 13 6 $90,874 0 46 7 18 4 $57,966 1 20 0 1 0 $16,500 Gamma A B C 1 Monthly DVD Player Sales at a Home Appliance Store Month DVD Sales 23 156 CO OO VOJ UI A W N 330 482 1209 CO OO N O UA W N- 1756 10 2000 11 2512 12 2366 13 10 2942 14 11 2872 15 12 2937 16 13 3136 17 14 3241 18 15 3149 19 16 3524 20 17 3542 21 18 3312 22 19 3547 23 20 3376 24 21 3375 25 22 3403 26 23 3697 27 24 3495 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 K K Gamma DVD TREF +A B C D E F Stock Returns Month Stock A Stock B Stock C Stock D C N 1 6.36% 20.41% 23.39% 11.67% 9.20% 16.27% 17.97% 4.92% 4.02% -12.80% 19.99% 12.03% 6 9.48% 14.69% 8.88% 14.96% 5 3.93% 18.18% 24.30% 16.93% 8 6 9.02% 11.27% 9.85% 11.44% CO 7 8.50% 8.14% 14.78% 14.11% 10 8 7.28% 5.94% 12.98% 15.29% 11 9 6.78% 23.12% 17.48% 17.94% 12 10 10.45% 25.25% 9.91% 1.16% 13 11 8.92% 27.68% 9.39% -1.12% 14 12 7.81% 14.69% 19.19% 8.47% 15 13 8.54% 3.22% 19.63% 12.17% 16 14 9.06% -4.67% 11.20% 11.83% 17 15 8.66% 12.42% 10.11% 8.67% 18 16 11.78% 4.79% 14.76% 12.06% 19 17 10.34% 20.52% 20.55% 12.36% 20 18 10.10% 20.93% 9.51% -2.07% 21 19 9.80% 15.61% 22.10% 10.42% 22 20 8.81% 10.33% 11.82% -2.67% 23 21 8.80% -1.94% 19.06% -0.38% 24 22 5.35% 24.45% 11.93% 19.45% 25 23 8.26% 13.11% 19.09% -5.99% 26 24 10.10% 15.87% 4.22% -2.53% 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 K > Gamma DVD TREF +

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_2

Step: 3

blur-text-image_3

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

Trigonometry

Authors: Mark Dugopolski

3rd Edition

0321899830, 9780321899835

More Books

Students also viewed these Mathematics questions

Question

How easy the information is to remember

Answered: 1 week ago

Question

The personal characteristics of the sender

Answered: 1 week ago

Question

The quality of the argumentation

Answered: 1 week ago