Transcribed TextTranscribed Text

Part 2 – Simple Linear Regression An organization wants to use interview scores to predict performance in an employee development program. Review the regression results in Figure 5 below: Figure 5. Summary output from a simple linear regression analysis produced by Excel. The results are organized in three tables - 1) regression statistics including the R squared, standard error, and number of observations, 2) ANOVA F-tests for the regression model and residuals, 3) and significance tests for the coefficients. For additional guidance regarding how to calculate simple linear regression analyses and interpret regression results in Excel, see the video located in your Week 6 course resources. ◦ Are the results significant? Explain your response. ◦ Use the summary output to find the least square regression line: y = ax + b ◦ Jeff Jones has an interview score of 3.4. Estimate the value of y (performance) when x = 3.4. Part 3 – Multiple Regression The organization wants to use a combination of interview scores (x1), scores from a role playing exercise (x2), and personality test scores (x3) to predict performance (y) in the employee development program. An I/O psychologist collected data on the 32 employees who have already participated in the program. The employee data are presented in Week 6 Data file. Open the file to the Employee Summary tab. 1 Run a multiple regression analysis in Excel (Note: See the video in the Week 6 course resources for information regarding how to run multiple regression in Excel) 2 Copy the summary output (Regression Statistics Table, ANOVA Table, and Coefficient Table) into a Word document. 3 Are the results significant? Explain your response. 4 Should all predictors be included in the least squares regression line? Should any predictors be excluded? Why or why not? 5 Use the summary output to find the least square regression line: y = ax1 + ax2 + ax3 +b 6 Estimate the y (performance) for the following two candidates (show your work): Interview Score Role Play Score Personality Test Score Laura 5 4 45 Gary 4 5 40 
7. Based on these results which candidate would you select into the employee development program? Length: 1-2 page results and summary Your results summary should demonstrate thoughtful consideration of the ideas and concepts that are presented in the course by providing new thoughts and insights relating directly to this topic. Your response should reflect graduate-level writing and APA standards.

Solution PreviewSolution Preview

This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.

    By purchasing this solution you'll be able to access the following files:
    Solution.docx and Solution.xlsx.

    for this solution

    or FREE if you
    register a new account!

    PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

    Find A Tutor

    View available Applied Statistics Tutors

    Get College Homework Help.

    Are you sure you don't want to upload any files?

    Fast tutor response requires as much info as possible.

    Upload a file
    Continue without uploading

    We couldn't find that subject.
    Please select the best match from the list below.

    We'll send you an email right away. If it's not in your inbox, check your spam folder.

    • 1
    • 2
    • 3
    Live Chats