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
-
In cats, a temperature-sensitive allele produces the Siamese phenotype in which the cooler extremities are dark and the warmer trunk area is lighter. A Siamese cat that spends most of its time...
-
The demand and supply schedules in the market for shoes are given in the following table. a. Find the initial equilibrium price and quantity. b. Suppose the government imposes a new $1.00/unit tax on...
-
Apex Accounting, Inc., has cash of \($2,000\), supplies costing \($800\), and stockholders equity of \($1,300\). Determine the liabilities of the business. Write the accounting equation for Apex...
-
Why are value-added activities defined from a customer viewpoint?
-
(a) The following was extracted from the standard cost card of Kafue Cement plc. Selling price 100kg pocket of cement K360 Direct material cost per 100kg pocket of cement K50 Direct labour cost per...
-
On December 31, the Income Summary account of Johnson Company has a Credit balance of $226,000 after revenue of $519,000 and expenses of $293,000 were closed to the account. Gloria Johnson, Drawing...
-
Mr. Seaman loloko, an OFW, seaman, working in the United States of America arrived here in the Philippines on August 8, 2019 to visit his family in Pampanga after 4 years of work (was hired August 3,...
-
Should the auditors comment on the satisfactory review and testing of the accounting and internal control systems in the auditors report?
-
Outline three approaches to conflict management when it occurs within an organization.
-
What is the purpose of tests of control, and what type of audit procedures can be used in undertaking tests of control?
-
Should a task be allowed to interrupt itself? If it does, what does this mean?
-
What are the primary sources of conflict between auditees and auditors? Discuss each.
-
Assess existing cost and profitability trends based on the comparative financial statements and supplemental data. Evaluate the potential impact of pricing decisions on long-term revenue growth and...
-
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...
-
Solve Problem 33 with (a) \(T=2 \mathrm{~s}\), and (b) \(T=\) \(0.5 \mathrm{~s}\).
-
Solve Problem 33 with \(\zeta=1.0\).
-
A body is subjected to the two harmonic motions, \[ \begin{aligned} & x_{1}(t)=100 \sin \left(\omega t+\frac{\pi}{3} ight) \mathrm{mm} \\ & x_{2}(t)=50 \sin \left(\omega t+\frac{\pi}{6} ight)...
Study smarter with the SolutionInn App