I need this SPSS file completed along with a word document.
KNR 445 – Statistics in Applied Science and Technology PAGE 1 KNR 445 – Statistics in Applied Science and Technology Spring 2020 Midterm Examination – Out-of-class Portion Directions As stated on our syllabus, the midterm examination represents 20 percent of your overall course grade. The midterm will contain both a “take home” and an in-class component. This out-of-class portion has 60 possible points (weighted as 60% of your midterm grade). This portion of your midterm exam is to be submitted to the “Midterm Exam” Assignment folder on Reggienet by the start of class, on March 16th. At that time (3/16/20), you will take the in-class portion of the exam. Please note that university academic dishonesty policies apply to both portions of the exam. The work you complete and submit must be your own. If it is at all apparent that your work is not entirely your own, possible consequences include a score of zero on the exam, an F in the course, and expulsion from the university. Remember that this is intended to be an assessment of your capabilities, not someone else’s. Please turn in separate SPSS output and interpretation sections – provide your interpretation using a MS Word rather than attempting to annotate on the SPSS output itself. Specifically, explain your answers fully on your MS Word file rather than simply telling me to refer to the output. Make sure both have your name on each file and that each is clearly labeled so your answers are easy to identify. The data set to be used for this exam is labeled, “takehomemidtermdata” and is available in the “Midterm Exam” assignment folder on the course Reggienet site. The following is a description of each of the variables included in that data set: 1. State: Name of state (in quotation marks) [nominal] 2. Spend: Current expenditure per pupil in average daily attendance in public elementary and secondary schools, 2018-19 (in thousands of dollars) 3. Ptratio: Average pupil/teacher ratio in public elementary and secondary schools, Fall 2019 4. Tsalary: Estimated average annual salary of teachers in public elementary and secondary schools, 2018-19 (in thousands of dollars) 5. Persat: Percentage of all eligible students taking the SAT, 2018-19 6. Satverb: Average verbal SAT score, 2018-19 7. Satmath: Average math SAT score, 2018-19 8. Sattot: Average total score on the SAT, 2018-19 Please address each of the following questions related to this data set. Assume an alpha level = .05 for all tests. TAKE-HOME MIDTERM EXAM QUESTIONS PROVIDED ON THE NEXT PAGE Question 1: Descriptive statistics (10 points) Assume that spend, ptratio, and tsalary are all variables that are indicative regarding how much a state cares about its students. A. First, provide the mean and standard deviations measures for all states with each of these three variables. (5 points) B. Second, compare Illinois to Montana in each of these three “caring” variables. Which of the two states cares more about its students? Standardize the data (use z-scores) on these three tests to provide the data to support your answer. (5 points) Question 2: Distributions & Correlation (10 points) A. Assess the distribution (i.e., skewness & kurtosis) for all of the study’s variables (w/the exception of “state”). Indicate if the distributions for each of these variables are within an acceptable level and adjust accordingly. (5 points) B. Generate correlations among all possible pairs of the following variables: spend, ptratio, tsalary, and sattot. Provide formal interpretations for each correlation coefficient. Make sure that you clearly describe and identify which bivariate correlations are significant and which are not, as well as the direction and strength of the significant ones. (5 points) Question 3: Regression (40 points) A. Create a model to predict average total SAT (sattot) score based upon a state’s expenditure (spend) per pupil. Develop a formal interpretation of your findings for this statistical test. (5 points) B. What is the regression equation for the model you just created? If a state spent $8,500 per pupil, what would you predict their average total SAT score to be? What if they spent $7,000 per pupil? (10 points) C. Create a model to predict average total SAT score using spend, ptratio, tsalary, and persat. Develop a formal interpretation of your findings for this statistical test. (10 points) D. What is the regression equation for the model you just created? What would your model expect to happen if a state’s teacher salaries decreased by $2,000 per teacher due to ongoing financial problems (use mean scores/values for all other independent variables)? (10 points) E. Examine a correlation matrix (using variables: sattot, spend, ptratio, tsalary, and persat) and assume that you have been instructed to treat bivariate independent variable correlations stronger than .5 to be worrisome and those stronger than .8 to be extremely problematic in terms of multicollinearity. If you were interested in predicting average total SAT score, which IV’s might you consider eliminating? Explain your rationale for doing this. Run multiple regression analysis on your reduced model (after eliminating “extremely problematic” IV’s) and compare the results with the overall model (all IV’s included). Which one would you choose as your final model? Support this choice. (5 points) Please make sure that you submit all of the relevant SPSS output and the MS Word file that contains your data interpretations to thoroughly answer each question. This portion of your midterm exam is worth 60 points and is to be submitted to the “Midterm Exam” Assignment folder on the course Reggienet site by the start of class, on March 16th.