Question

Q1. Please download the dataset “Social W orkers” from Canvas and use Minitab for all the...

Q1.

Please download the dataset “Social W orkers” from Canvas and use Minitab for all the analysis. The dataset contains salary and years of experience for 50 social workers. The consulting group working on these data is interested in evaluating how salary ($) changes as a person builds up years of experience (x) in the job. Let’s investigate this question using some of the concepts of linear regression discussed in class this far.

a)Fit a linear regression model to these data. Provide the fitted regression equation

b)Are there any unusual observations? If yes, how many unusual observations and what type of unusual observations they are (outlier or high leverage)?

c)Construct a residual plot against fitted values (^y ) Comment on whether the assumption of constant error variance is reasonably satisfied.

d)Construct a normal probability plot. Comment on whether the assumption that E has a normal distribution is reasonably satisfied.

here is data

years salary

7 26075

28 79370

23 65726

18 41983

19 62308

15 41154

24  53610

13  33697

2  22444

8  32562

20  43076

21  56000

18  58667

7  22210

2  20521

18  49727

11  33233

21 43628

4  16105

24  65644

20  63022

20  47780

15  38853

25  66537

25  67477

28  64785

26  61581

27  70678

20  51301

18  39346

1  24833

26 65929

20  41721

26  82641

28  99139

23  52624

17  50594

25  53272

26  65343

19  46216

16  54288

3  20844

12  32586

23  71235

20  36530

19 52745

27  67282

25  80931

12  32303

11  38371

Homework Answers

Answer #1

1.

Estimate Std. Error t value Pr(>|t|)
Intercept 11368.7 3160.3 3.597 0.000758
Years 2141.4 160.8 13.314 < 2e-16

Salary = 11368.7 + 2141.4 * Years

2. From boxplot of salary we are not able to see any outliers. When we look at leverage plot there are 4 observations which have high leverage (Observation 9, Observation 31, Observation 35, Observation 45)

3. & 4.

Looking at the plots the assumption of constant variance and normality both are reasonably satisfied. Though it would be better to drop the outliers with high leverage

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Solve using Minitab. The table is observations on weekly operational downtime on a critical equipment (order...
Solve using Minitab. The table is observations on weekly operational downtime on a critical equipment (order read top to bottom and left to right). The target value for the mean is 25. (a) Estimate the process standard deviation. (b) Set up and apply a tabular cusum chart for this process, using standardized values h = 5 and k = ½. (c) Interpret the cusum chart. 24 22 27 27 25 27 23 20 28 29 24 28 20 29 21...
The Department of Energy provides fuel economy ratings for all cars and light trucks sold in...
The Department of Energy provides fuel economy ratings for all cars and light trucks sold in the United States. Offered are the estimated miles per gallon for city driving for the 186 cars classified as midsize in 2016, arranged in increasing order: 11 11 11 12 13 13 13 14 14 14 14 14 15 15 15 15 15 15 16 16 16 16 16 16 16 16 16 16 16 16 16 17 17 17 17 17 17 18...
Data set for ages of students in stats class: 17, 18, 18, 18, 18, 18, 18,...
Data set for ages of students in stats class: 17, 18, 18, 18, 18, 18, 18, 18, 18, 18, 18, 19, 19, 19, 19,19, 20, 20, 20, 21, 21, 21, 21, 21, 21, 22, 22, 22, 22, 23, 23, 23, 23, 24, 25, 25, 25, 26, 26, 27, 28, 28, 28, 28, 29, 29, 32, 36, 42 1) Compute the 5-number summary and create a modified box-plot, using the inner-quartile range to identify any outliers.
Dataset: Husband   Wife 53   50 38   34 46   44 30   36 31   23 26   31 29  ...
Dataset: Husband   Wife 53   50 38   34 46   44 30   36 31   23 26   31 29   25 48   51 65   46 29   26 28   23 29   32 25   22 22   21 21   24 43   50 24   27 38   33 33   26 35   29 40   29 27   25 27   24 49   38 48   39 27   27 26   24 40   34 35   37 21   26 32   39 30   28 60   52 36   40 25   23 66   55 52   34 41   40 43  ...
The SAT and the ACT are the two major standardized tests that colleges use to evaluate...
The SAT and the ACT are the two major standardized tests that colleges use to evaluate candidates. Most students take just one of these tests. However, some students take both. The data data18.dat gives the scores of 60 students who did this. How can we relate the two tests? (a) Plot the data with SAT on the x axis and ACT on the y axis. Describe the overall pattern and any unusual observations. (b) Find the least-squares regression line and...
e SAT and the ACT are the two major standardized tests that colleges use to evaluate...
e SAT and the ACT are the two major standardized tests that colleges use to evaluate candidates. Most students take just one of these tests. However, some students take both. The data data76.dat gives the scores of 60 students who did this. How can we relate the two tests? (a) Plot the data with SAT on the x axis and ACT on the y axis. Describe the overall pattern and any unusual observations. (b) Find the least-squares regression line and...
The following data are believed to have come from a normal distribution. Use the goodness of...
The following data are believed to have come from a normal distribution. Use the goodness of fit test and  = .05 to test this claim. Use Table 12.4. 18 23 21 24 18 22 18 22 19 13 10 20 17 20 20 20 17 14 24 23 22 43 28 27 26 29 28 33 22 28 Using six classes, calculate the value of the test statistic (to 2 decimals).______ The p value is ? _________ Conclusion? Cannot reject assumption...
You are provided with the following dataset. Come up with a research question and make a...
You are provided with the following dataset. Come up with a research question and make a prediction (hypothesis). Label each of x and y with an appropriate variable name relevant to your hypothesis. If you want, you can add a new variable to the data such as gender, age, etc, to make your hypothesis interesting however it's not mendatory and it won't lead to additional credits. Use SPSS to perform the following. Clearly state your hypothesis. What is the shape...
Show all work and graphs. Use Minitab software, Analyze the correlation for the following data: Circuit...
Show all work and graphs. Use Minitab software, Analyze the correlation for the following data: Circuit Type Response 1 19 22 20 18 25 2 20 21 33 27 40 3 16 15 18 26 17
The SAT and the ACT are the two major standardized tests that colleges use to evaluate...
The SAT and the ACT are the two major standardized tests that colleges use to evaluate candidates. Most students take just one of these tests. However, some students take both. The data data141.dat gives the scores of 60 students who did this. How can we relate the two tests? (a) Plot the data with SAT on the x axis and ACT on the y axis. Describe the overall pattern and any unusual observations. (b) Find the least-squares regression line and...