ers resulted in the following data. Principal's Rating 96 52 75 Master's Degree 1 80
Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.6: Summarizing Categorical Data
Problem 10CYU
Related questions
Question
Please assist and answer questions: D, E, F, G, & H
Thank you.
![Mike Jimenez is president of the teachers' union for Preston School District. In preparing for upcoming negotiations, he would like to
investigate the salary structure of classroom teachers in the district. He believes there are three factors that affect a teacher's salary:
years of experience, a rating of teaching effectiveness given by the principal, and whether the teacher has a master's degree (O = No, 1
= Yes). A random sample of 20 teachers resulted in the following data.
Years of
Experience
Principal's
Rating
96
52
75
80
62
Salary ($
Thousands)
Master's
Degree
51.1
8
43.6
39.3
53
48.6
55
52
46.8
58.6
41.7
35.7
40.6
61.8
46.7
2
15
1
11
14
68
1
94
64
54
57
66
63
92
64
88
7
1
22
1
1
1
23
17
12
48.4
43.6
51.8
40.7
14
57
63
1
74
78
70
42.8
42.9
Click here for the Excel Data File. Data file should open in a new browswer window. Select "File" then "Save As" to download the file to
your computer and be able to use it in Excel.
a. What is the question being asked?
b. Label your dependent variable: y =](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F54bdc5e6-64d3-401e-934d-06f755fd4441%2F6e486fd1-0604-4849-bd2a-2754cfebdffe%2Fsyh26t4_processed.png&w=3840&q=75)
Transcribed Image Text:Mike Jimenez is president of the teachers' union for Preston School District. In preparing for upcoming negotiations, he would like to
investigate the salary structure of classroom teachers in the district. He believes there are three factors that affect a teacher's salary:
years of experience, a rating of teaching effectiveness given by the principal, and whether the teacher has a master's degree (O = No, 1
= Yes). A random sample of 20 teachers resulted in the following data.
Years of
Experience
Principal's
Rating
96
52
75
80
62
Salary ($
Thousands)
Master's
Degree
51.1
8
43.6
39.3
53
48.6
55
52
46.8
58.6
41.7
35.7
40.6
61.8
46.7
2
15
1
11
14
68
1
94
64
54
57
66
63
92
64
88
7
1
22
1
1
1
23
17
12
48.4
43.6
51.8
40.7
14
57
63
1
74
78
70
42.8
42.9
Click here for the Excel Data File. Data file should open in a new browswer window. Select "File" then "Save As" to download the file to
your computer and be able to use it in Excel.
a. What is the question being asked?
b. Label your dependent variable: y =
![c. Label your independent variables:
X1 =
X2 =
X3 =
d. Develop a correlation matrix and state the correlation for each independent variable as it relates to the dependent
variable.
(Round all correlation coefficients to 4 decimal places.)
X1: r =
X2:r =
X3: r =
e. Compute and state the regression equation:
(Round the intercept and the regression coefficients to 2 decimal places.)
x3
x1 +
X2
f. What salary would you estimate for a teacher with 9 years of experience, a rating by the principal of 64, and who has a master's
degree?
Salary:
(Round to the nearest dollar)
g. What does the value of the Coefficient of Determination tell you about the data?
h. Run a diagnosis to deterime if the model is significant at a = 0.05. (Round test statistic to 2 decimal places and p-value to 4
decimal places)
h1. Select the correct hypothesis statements.
Ho: (Click to select)
H1: (Click to select)
h2. Test Statistic:
Һ3: р-value:
h4: What is your decision regarding the null hypothesis?.
(Click to select)
h5: What does this mean?](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F54bdc5e6-64d3-401e-934d-06f755fd4441%2F6e486fd1-0604-4849-bd2a-2754cfebdffe%2Fvljnzof_processed.png&w=3840&q=75)
Transcribed Image Text:c. Label your independent variables:
X1 =
X2 =
X3 =
d. Develop a correlation matrix and state the correlation for each independent variable as it relates to the dependent
variable.
(Round all correlation coefficients to 4 decimal places.)
X1: r =
X2:r =
X3: r =
e. Compute and state the regression equation:
(Round the intercept and the regression coefficients to 2 decimal places.)
x3
x1 +
X2
f. What salary would you estimate for a teacher with 9 years of experience, a rating by the principal of 64, and who has a master's
degree?
Salary:
(Round to the nearest dollar)
g. What does the value of the Coefficient of Determination tell you about the data?
h. Run a diagnosis to deterime if the model is significant at a = 0.05. (Round test statistic to 2 decimal places and p-value to 4
decimal places)
h1. Select the correct hypothesis statements.
Ho: (Click to select)
H1: (Click to select)
h2. Test Statistic:
Һ3: р-value:
h4: What is your decision regarding the null hypothesis?.
(Click to select)
h5: What does this mean?
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps with 5 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Glencoe Algebra 1, Student Edition, 9780079039897…](https://www.bartleby.com/isbn_cover_images/9780079039897/9780079039897_smallCoverImage.jpg)
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
![Big Ideas Math A Bridge To Success Algebra 1: Stu…](https://www.bartleby.com/isbn_cover_images/9781680331141/9781680331141_smallCoverImage.jpg)
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
![Holt Mcdougal Larson Pre-algebra: Student Edition…](https://www.bartleby.com/isbn_cover_images/9780547587776/9780547587776_smallCoverImage.jpg)
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
![Glencoe Algebra 1, Student Edition, 9780079039897…](https://www.bartleby.com/isbn_cover_images/9780079039897/9780079039897_smallCoverImage.jpg)
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
![Big Ideas Math A Bridge To Success Algebra 1: Stu…](https://www.bartleby.com/isbn_cover_images/9781680331141/9781680331141_smallCoverImage.jpg)
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
![Holt Mcdougal Larson Pre-algebra: Student Edition…](https://www.bartleby.com/isbn_cover_images/9780547587776/9780547587776_smallCoverImage.jpg)
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
![College Algebra (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781305652231/9781305652231_smallCoverImage.gif)
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning
![College Algebra](https://www.bartleby.com/isbn_cover_images/9781938168383/9781938168383_smallCoverImage.gif)