1. Create a model for the relationship between the available variables and the test scores.
enrolled students in 1,000s
per pupil expenditures for gifted programs
per pupil expenditures for athletic programs
average salary for new teachers in $1,000s
percent teaching staff with masters degrees, and
teacher turnover rate
3. From the regression equation you produced above, what would you predict to be the proportion of a district's students passing the state test if a district had the following characteristics:
40,000 enrolled students
$100 spent per pupil for gifted programs
$400 spent per pupil for athletic programs
$36,000 average (mean) salary for new teachers
25% of a teaching staff with masters degrees, and
a 15% teacher turnover rate.
4. Interpret the diagnostic tests available to you (and show the appropriate tables and charts) for detecting the presence of multicollinearity.© BrainMass Inc. brainmass.com October 25, 2018, 9:48 am ad1c9bdddf
The solution provides step by step method for the calculation of regression analysis. Formula for the calculation and Interpretations of the results are also included. Attachments are .docx, .sav and .spv.
SPSS: Regression analysis question
Wageweb conducts surveys of salary data and presents summaries on its website. Based on salary data as of October 1, 2002, Wageweb reported the average annual salary for sales vice presidents was $142,111, with an average annual bonus of $15,432. Assume the following data are a sample of the annual salary and bonus for 10 vice presidents.
Data are in thousands of dollars.
1. Compute and interpret the coefficient of determination (r2)
2. Develop a plot of the residuals against the independent variable and briefly interpret the plot
Please see attached files for description of question and data files.
This is a compute and interpret the coefficient of determination question and involves developing and interpreting a plot of residualsView Full Posting Details