Question

In: Statistics and Probability

The data in the table below show years of teaching experience and annual salary in dollars...

The data in the table below show years of teaching experience and annual salary in dollars for 12 randomly selected mathematics instructors in Illinois colleges/ universities for the 2013-2014 school year. Is there a linear correlation between a mathematics instructor's years of experience and their annual salary?

a. Draw the scatterplot for the variables.

b. Describe the relationship, if any, shown by the scatterplot.

c. Calculate r, the correlation coefficient. How does the correlation coefficient compare to the relationship you saw in the scatterplot?

Number of years: 7 9 6 7 11 12 11 3 3 7 9 1

Salary(in dollars): 48,897 62,866 54,585 56,611 53,541 53,541 47,027 47,970 46,668 48,029 46,735 45,000

Solutions

Expert Solution

a. The scatter plot is given below:

b. There seems to some weak positive linear relationship between the two variables : Number of years and Salary(in dollars)

c.

The provided data are shown in the table below

X Y
7 48897
9 62866
6 54585
7 56611
11 53541
12 53541
11 47027
3 47970
3 46668
7 48029
9 46735
1 45000

Also, the following calculations are needed to compute the correlation coefficient:

X Y X*Y X2 Y2
7 48897 342279 49 2390916609
9 62866 565794 81 3952133956
6 54585 327510 36 2979522225
7 56611 396277 49 3204805321
11 53541 588951 121 2866638681
12 53541 642492 144 2866638681
11 47027 517297 121 2211538729
3 47970 143910 9 2301120900
3 46668 140004 9 2177902224
7 48029 336203 49 2306784841
9 46735 420615 81 2184160225
1 45000 45000 1 2025000000
Sum = 86 611470 4466332 750 31467162392

The correlation coefficient r is computed using the following expression:

Therefore, based on this information, the sample correlation coefficient is computed as follows

the correlation coefficient is in line with the relationship seen in the scatterplot - a weak positive association.

Please let me know in comments if anything is unclear. Will reply ASAP. Please upvote if satisfied!


Related Solutions

Question 5 The data in the incomplete table below represent annual Savings (in thousands of dollars)...
Question 5 The data in the incomplete table below represent annual Savings (in thousands of dollars) and annual Income (in thousands of dollars) for a sample of 7 families in Brisbane: Annual Income X ('000 dollars) Annual Saving Y ('000 dollars) X2 Y2 XY 60 10 80 40 100 30 120 49 140 57 180 50 200 70 Total= Total= Total= .    Total= Total=    a. Complete the necessary additional columns on the above table to calculate the required...
2. The following data represent Salary, years of experience, and rank (A, B, or C). Salary...
2. The following data represent Salary, years of experience, and rank (A, B, or C). Salary is the dependent variable. For class and the interaction effect between class and years of experience, do the following: a. Indicate a scheme (method) of coding “Rank”. How many variables are needed? b. Using the coding method given in Part a, give the data (the numbers) that you would input for the following cases including the interaction term between rank and experience: Absenteeism (Hrs/Yr)...
Predict the annual salary in dollars for females who are at least 25 years old with...
Predict the annual salary in dollars for females who are at least 25 years old with 15 years of education. Years of education            Annual Salary(in dollars) 18                                           52,866 16                                            40393 14                                          27062 12                                        21427 10                                        14470 15                                        41010 13                                         31376 18                                         79962 12                                         21387 16                                          39925 16                                         57815
(1 point) Suppose the relation between CEO’s annual salary in thousands of dollars, salary, and the...
(1 point) Suppose the relation between CEO’s annual salary in thousands of dollars, salary, and the return on equity, roe, measured as a percentage, is estimated to be: . Now, suppose that salary is measured in hundreds of dollars, rather than in thousands of dollars, say, salarhun. What will be the OLS intercept and slope estimates in the regression of salarhun on roe? The new estimates will be equal to the original estimates divided by 10. The new estimates will...
The annual earnings​ (in dollars) of 35 randomly selected microbiologists are shown in the data table....
The annual earnings​ (in dollars) of 35 randomly selected microbiologists are shown in the data table. Use the data to​ (a) find the sample​ mean, (b) find the sample standard​ deviation, and​ (c) construct a​ 98% confidence interval for the population mean. 100,095 81,395 77,851 68,184 51,784 68,158 94,436 66,446 75,556 78,621 74,185 44,588 86,744 60,998 57,664 55,388 78,844 61,904 47,480 98,368 80,618 93,023 63,344 75,122 51,049 60,873 82,029 91,267 84,094 79,834 63,872 73,989 57,207 46,919 88,912 The monthly incomes...
The annual earnings​ (in dollars) of 35 randomly selected microbiologists are shown in the data table....
The annual earnings​ (in dollars) of 35 randomly selected microbiologists are shown in the data table. Use the data to​ (a) find the sample​ mean, (b) find the sample standard​ deviation, and​ (c) construct a​ 98% confidence interval for the population mean. 100,700 81,419 77,543 68,099 51,620 67,741 94,804 66,410 79,448 73,448 44,319 86,757 60,644 58,151 54,634 78,891 47,896 98,388 80,793 92,543 63,410 75,100 50,972 60,936 91,207 84,375 80,002 63,941 74,232 56,985 46,910 89,548 76,023 62,168 82,712
Suppose the following data were collected relating CEO salary to years of experience and gender. Use...
Suppose the following data were collected relating CEO salary to years of experience and gender. Use statistical software to find the regression equation. Is there enough evidence to support the claim that on average female CEOs have higher salaries than male CEOs at the 0.01 level of significance? If yes, type the regression equation in the spaces provided with answers rounded to two decimal places. Else, select "There is not enough evidence." Salary Experience Female (1 if female, 0 if...
Suppose the following data were collected relating CEO salary to years of experience and gender. Use...
Suppose the following data were collected relating CEO salary to years of experience and gender. Use statistical software to find the regression equation. Is there enough evidence to support the claim that on average male CEOs have higher salaries than female CEOs at the 0.010.01 level of significance? If yes, type the regression equation in the spaces provided with answers rounded to two decimal places. Else, select "There is not enough evidence." Copy Data CEO Salaries Salary Experience Male (1...
Suppose the following data were collected relating CEO salary to years of experience and gender. Use...
Suppose the following data were collected relating CEO salary to years of experience and gender. Use statistical software to find the regression equation. Is there enough evidence to support the claim that on average male CEOs have higher salaries than female CEOs at the 0.050.05 level of significance? If yes, type the regression equation in the spaces provided with answers rounded to two decimal places. Else, select "There is not enough evidence." Copy Data CEO Salaries Salary Experience Male (1...
The following sample data contains the number of years of college and the current annual salary...
The following sample data contains the number of years of college and the current annual salary for a random sample of heavy equipment salespeople. A researcher believes that spending more years in college leads to higher annual income. Annual Income (In Thousands) Years in College 20 2 23 2 25 3 35 4 28 3 18 1 37 4 30 3 40 4 39 4 a) Which variable is the dependent variable? Which is the independent variable? b) What is...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT