ASSIGNMENT INSTRUCTIONS Need Answers to these Question in A report Format based on the excel Data Attached Consider the following dataset with several variables: Regression Dataset_Personality.xlsx For this assignment, your

focus should be on these seven variables: negative affect, positive affect, openness to experience, extraversion, neuroticism, trait anxiety, and self-esteem. Use self-esteem as the dependent variable and negative affect, positive affect, openness to experience, extraversion, neuroticism, and trait anxiety predictor variables Based on the provided dataset, address the following: Write out a hypothesis you could test using the variables in the dataset Clean the data and check whether there are any missing values. Discuss how will you deal with missing values if any are present? Are there any outliers in the cleaned dataset? Discuss how will you deal with outliers if any are present? Check statistical assumptions. What will you recommend if there are any violations? Run a stepwise regression on the dataset. Do the predictors correlate statistically significantly and practically with the dependent variable? What is the R and adjusted R Square for all predictors? Interpret the values. What variable(s) provide a significant unique contribution(s)? Write out the prediction equation. Write one to two paragraphs of how you will report this results in finding section of a dissertation or journal article. The instructor send these notes for this assignment: ensure that you use the following variables as directed in the assignment: negative affect: mpq (negafect), positive affect: mpq (posafect), openness to experience: neo (neoopen), extraversion: neo (neoextra), neuroticism: neo (neoneuro), trait anxiety: spielberger (tanx), and self esteem: coopersmith (esteem). The Excel dataset has several variables and make sure there is no confusion on which variables to utilize. NOTE Can use Excel or SPSS This is research lab: multiple regression analysis The data are provided and the action items are listed for what we should do in this report Assignment Overview And dataset Are attached Please do check that