Use the following set of independent variables ? SALTEACH, REVPUB, CLASS, and PECD ? to explain teacher
Question:
Use the following set of independent variables ? SALTEACH, REVPUB, CLASS, and PECD ? to explain teacher turnover rates (TETURN).
Do the full regression analysis. This means that you have to:
Estimate (multiple) regression equation
Interpret the intercept.
Which independent variables appear to have a significant effect on the dependent variable? Why?
For significant independent variables interpret the magnitude (b) of the relationships.
Interpret the beta weights: which variables appear to be the most important predictors of the on teacher turnover rates?
R Square (what percentage of the variation in the dependent variable could you explain? What percentage did you fail to explain?)
Is your model overall significant?
teacher turnover rate average teacher salary total revenue per pupil average class size Descriptive Statistics percent econ. disadvantag. students Mean 17.449 36570.46 7907.20 12.353 48.264 Std. Deviation 8.9800 2675.934 2944.828 2.3354 19.6104 N 1040 1040 1040 1040 1040 Pearson Correlation Sig. (1-tailed) N teacher turnover rate average teacher salary total revenue per pupil average class size percent econ. disadvantag. students teacher turnover rate average teacher salary total revenue per pupil average class size percent econ. disadvantag. students teacher turnover rate average teacher salary total revenue per pupil average class size percent econ. disadvantag. students Correlations teacher turnover rate 1.000 -317 .123 -.090 .078 .000 .000 .002 .006 1040 1040 1040 1040 1040 average teacher salary -.317 1.000 .025 .335 -.121 .000 .210 .000 .000 1040 1040 1040 1040 1040 total revenue per pupil .123 .025 1.000 -.580 .001 .000 .210 .000 .483 1040 1040 1040 1040 1040 average class size -.090 .335 -.580 1.000 -.119 .002 ,000 .000 .000 1040 1040 1040 1040 1040 percent econ. disadvantag. students .078 -.121 .001 -.119 1.000 .006 .000 .483 .000 1040 1040 1040 1040 1040 Model 1 Variables Entered/Removed Variables Entered percent econ. disadvantag. students, total revenue per pupil, average teacher salary, average class sizeb Variables Removed Method Enter a. Dependent Variable: teacher turnover rate b. All requested variables entered. Model Summary R Adjusted R Square Std. Error of the Estimate Model R Square 1 .369² .136 .133 8.3610 a. Predictors: (Constant), percent econ. disadvantag, students, total revenue per pupil, average teacher salary, average class size Model 1 Sum of Squares 11431.373 72353.725 83785.098 a. Dependent Variable: teacher turnover rate b. Predictors: (Constant), percent econ. disadvantag. students, total revenue per pupil, average teacher salary, average class size Model 1 ANOVA df Regression Residual Total 4 1035 1039 (Constant) average teacher salary total revenue per pupil average class size percent econ. disadvantag. students a. Dependent Variable: teacher turnover rate Mean Square 2857.843 69.907 Sig. F 40.881 .000 B Coefficients Unstandardized Coefficients 48.269 -.001 .001 .690 .025 Std. Error 3.858 .000 .000 .152 .013 Standardized Coefficients Beta Sig. 12.512.000 -.377 -11.747.000 .236 6.366 .000 4.546 .000 1.840 .066 t .179 .054 teacher turnover rate average teacher salary total revenue per pupil average class size Descriptive Statistics percent econ. disadvantag. students Mean 17.449 36570.46 7907.20 12.353 48.264 Std. Deviation 8.9800 2675.934 2944.828 2.3354 19.6104 N 1040 1040 1040 1040 1040 Pearson Correlation Sig. (1-tailed) N teacher turnover rate average teacher salary total revenue per pupil average class size percent econ. disadvantag. students teacher turnover rate average teacher salary total revenue per pupil average class size percent econ. disadvantag. students teacher turnover rate average teacher salary total revenue per pupil average class size percent econ. disadvantag. students Correlations teacher turnover rate 1.000 -317 .123 -.090 .078 .000 .000 .002 .006 1040 1040 1040 1040 1040 average teacher salary -.317 1.000 .025 .335 -.121 .000 .210 .000 .000 1040 1040 1040 1040 1040 total revenue per pupil .123 .025 1.000 -.580 .001 .000 .210 .000 .483 1040 1040 1040 1040 1040 average class size -.090 .335 -.580 1.000 -.119 .002 ,000 .000 .000 1040 1040 1040 1040 1040 percent econ. disadvantag. students .078 -.121 .001 -.119 1.000 .006 .000 .483 .000 1040 1040 1040 1040 1040 Model 1 Variables Entered/Removed Variables Entered percent econ. disadvantag. students, total revenue per pupil, average teacher salary, average class sizeb Variables Removed Method Enter a. Dependent Variable: teacher turnover rate b. All requested variables entered. Model Summary R Adjusted R Square Std. Error of the Estimate Model R Square 1 .369² .136 .133 8.3610 a. Predictors: (Constant), percent econ. disadvantag, students, total revenue per pupil, average teacher salary, average class size Model 1 Sum of Squares 11431.373 72353.725 83785.098 a. Dependent Variable: teacher turnover rate b. Predictors: (Constant), percent econ. disadvantag. students, total revenue per pupil, average teacher salary, average class size Model 1 ANOVA df Regression Residual Total 4 1035 1039 (Constant) average teacher salary total revenue per pupil average class size percent econ. disadvantag. students a. Dependent Variable: teacher turnover rate Mean Square 2857.843 69.907 Sig. F 40.881 .000 B Coefficients Unstandardized Coefficients 48.269 -.001 .001 .690 .025 Std. Error 3.858 .000 .000 .152 .013 Standardized Coefficients Beta Sig. 12.512.000 -.377 -11.747.000 .236 6.366 .000 4.546 .000 1.840 .066 t .179 .054
Expert Answer:
Regression equation will be Teacher turnover rate 48269 0001 average teacher salary 0001 total revenue per pupil 0690 average class size 0025 percent ... View the full answer
Elementary Statistics
ISBN: 978-0538733502
11th edition
Authors: Robert R. Johnson, Patricia J. Kuby
Students also viewed these organizational behavior questions
-
The Ajax Corporation has the following set of projects available to it: *Note: All projects have equal risk. Ajax can raise funds with the following marginal costs: First $250 million..............
-
The following set of 25 scores was randomly selected from a teachers class list. Let x be the pre-final average and y be the final examination score. (The final examination had a maximum of 75...
-
Use the following set of pressure-volume data to find the best possible virial constants (A1 and A2) for the equation of state shown below. R = 82.05 ml atm/gmol K and T = 303K. PV RT =I+ 1.108 1.363...
-
The data below are the calories and grams of sugar in some popular store bought cookies. Calories 143 Grams of Sugar 12 97 9 200 11 149 19 84 4 57 9 198 21
-
Pharmaceutical companies work very hard to get the ward out to patients with specific illnesses when they have a new drug to treat that illness. People with a wide range of diseases have benefited...
-
Optix Camera Shop uses the lower-of-cost-or-market basis for its inventory. The following data are available at December 31. Instructions Determine the amount of the ending inventory by applying the...
-
The mean annual salary for a sample of electrical engineers is \($86,500\), with a standard deviation of \($1500\). The data set has a bell-shaped distribution. (a) Use the Empirical Rule to estimate...
-
Coney Island enters into a lease agreement for a new ride valued at $2 million. Prior to this agreement, the companys total assets are $25 million and its total liabilities are $15 million. Required:...
-
Retained Earnings Balance (before Net Income) Paid-in Capital in Excess of Par Totals 80,690 82,690 $12,352,970 $12,352,970 -/50 !!! Prepare a balance sheet at December 31, 2025, for Novak...
-
2. The Global Tea and Organic Juice companies have merged. The following information has been collected for the "Consolidation Project." Chapter 7 Managing Risk 245 Activity Description Predecessor a...
-
Company borrowed fund for the construction of manufacturing plant at Multan of Rs. 300 million from ABL bank dated 1-1-2016 for years' period @15% pa. Construction was completed on 30 June 2017....
-
Show that if the sum and difference between two vectors are perpendicular, then the magnitudes of the two vectors are equal.
-
If two planets have the same mass, but \(A\) has twice the radius of \(B\), determine what the ratio of the accelerations of gravity is worth \(g_{A} / g_{B}\).
-
Show that if the magnitudes of the sum and difference between two vectors are equal, then the vectors are perpendicular to each other.
-
Show that the force field expressed in spherical coordinates \(\mathbf{F}=f(r, \theta) \mathbf{r}\) is conservative if and only if the function \(f\) is independent of \(\theta\).
-
The equation of motion of a material point is expressed by the relation \(x(t)=\alpha t^{3}-\beta t^{2}-\gamma\), with the constants \(\alpha, \beta, \gamma\) real positive. Determine velocity and...
-
Tyrone's hourly wage is $18 and his net pay is 72% of his earnings. Tyrone spends about $1,800 on his monthly expenses. If Tyrone works 40 hours per week and has no other sources of income, what is...
-
Rewrite Programming Exercise 7.5 using streams. Display the numbers in increasing order. Data from Programming Exercise 7.5 Write a program that reads in 10 numbers and displays the number of...
-
Question 3 (10 Points): Set theory and logics (02) - a) Identify the truth value of the proposition "For arbitrary sets A, B, C, D, (A B) (C D) = (A x C) (B x D)". Prove your claim. (5 Points) b) For...
-
The table here shows the average number of births per day in the United States as reported by the CDC (Centers for Disease Control). Based on this information, what is the probability that one baby...
-
A study in the Journal of Range Management examines the relationships between elements in Russian wild rye. The correlation coefficient between magnesium and calcium was reported to be 0.69 for a...
-
A scatter diagram is drawn showing the data for x and y, two normally distributed variables. The data fall within the intervals 20 x 40 and 60 y 100 Where would you expect to find the data on the...
-
December 2007. When she joined, she signed a membership agreement that had a release of liability that stated: 24 Hour. will not be liable for any injury, including, without limitation, personal,...
-
Recall the facts in Leonard v. Pepsico Had this been a contract, would it have been subject to the Statute of Frauds?
-
John J. Williams began working at Delaware Elevator as a branch sales manager in late 2004. The company manufactures components for elevators and installs and repairs elevators. It employs 175 people...
Study smarter with the SolutionInn App