Use the data in the table, which shows the average annual salaries (both in thousands of dollars) for public school principals and teachers in the U.S. for 11 years. Apply what you have learned in the...

Extracted text: Use the data in the table, which shows the average annual salaries (both in thousands of dollars) for public school principals and teachers in the U.S. for 11 years. Apply what you have learned in the previous tab to complete this graded lab questions. 1. Repeat the steps from tab #1 using this data to construct a scatter plot graph and calculate the correlation coefficient R. (Recall the corelation coefficient is R and not R Teachers y Principalsx 77.8 43.7 78.4 43.8 80.8 45.0 R= 80.5 45.6, 2. Does the R value represent a positive, negative or no correlation between the salaries ol the teachers and principals? As teacher salaries increase, what happens to prinicipal salaries? 10 11 81.5 45.9 84.8 48.2 12 13 87.7 49,3 3. Write the equation of the regression line for the data below. The equation is y= 14 91.6 51.3 52.9 Teachers y 15 16 95.7 54.4 COD 54.2 =D0.5873x-2.0s07o R=0.995, 17 95.7 4. Use the regression equation that you found in exercise #3 to predict the average annual salary of public school classroom teachers when the average annual salary of public school principals is $139,723. Show your work in the cells to the right. 18 19 400 20 (Be careful when entering the x-value in the equation. The table shows numbers that have been adjusted in terms of the thousands. Example if the salary is $82,500, then use x 82.5) 21 300 22 23 200 The predicted salary for teachers is $ when the principal makes $139,723. 24 25 26 27 20.0 400 G0.0 100.0 120.0 28 29 30 31 32 EE 34 35 36 37 38 39 40 41 42 43 44 45 46 4了 48 49 50 51 52 53 54 55 56 Ave Lab 6-#1 Lab 6-#2 Ready