Please help me answering this.
DETERMINING RELATIONSHIP OF TWO VARIABLES USING CORRELATION AND REGRESSION ANALYSIS Instruction: This is by individual as this will also serve as part 2 of the MIDTERM EXAM Part 2 is worth 50 points. You will prepare two sets of answers. One handwritten and one in Spreadsheet format (i.e. Excel or Google sheet), this also included the graphs. As for the handwritten, you need to write all of your answers in a set of clean papers (any paper type and size will do) and take a picture(s) of your output (make sure it is clear and not blurred). Write your name(s) and section on top of each papers. As for the spreadsheet, you have the freedom to format your answers, just make sure that it is in the right order. You may create multiple sheets in one file (only 1 file) which includes the graphs. Filename must be Module3Assessment. Write your name and section on top of each sheets. Submit all the files (image and spreadsheet files) to LMS. Problem Instructions. . Conduct a correlation and regression analysis on the two variables: Level of IT Skills and Employee Performance Score. Correlation: 1. Draw the scatterplot 2. Compute for the correlation coefficient of the data above using Pearson r. 3. Tabulate the data 4. Define the null and alternative hypothesis. 5. Compute for the test statistics at alpha level 0.05. 6. Draw the t-distribution plot. 7. Determine whether to accept or reject the null hypothesis and interpret. Regression 1. Tabulate the data 2. Find the needed summations 3. Find the slope and the y-intercept 4. Determine the regression line equation 5. Interpret the results 6. Plot the regression line using Excel . Answer the research questions based on the results of your analysis. Research Question 1: Is there a significant relationship between the Level of IT Skills and Employee Performance Score? Research Question 2: Does Level of IT Skills positively influence the Employee Performance Score? Data Numeric Interpretation of IT skills among private employees Numeric Level of IT Skills Equivalent Employee Excellent Employee Level of IT Performance Satisfactory No Skills Score -N W A UT Good Needs Improvement 81.5 Poor 89.4 88.9 80.2 99.1 95.5 90.8 78.8 75.6 94.3 86.1 69.1 75.3 83.3 94.1 90.0 70.2 83.5 87.8 98.8 Rubrics Criteria Excellent Satisfactory Good Poor No Submission 20 points 15 points 10 points points 0 point Correlation Completed the Completed at least Completed at least Completed No Submission only 1 at all. Analysis Results instructions from 1 6 instructions with 4 instructions with to 7 correctly minimal errors. minimal errors instruction. without any errors. 20 points 15 points 10 points 5 points 0 point Completed the Completed at least Completed at least Completed No Submission Regression instructions from 1 5 instructions with 4 instructions with only 1 it all Analysis Results to 6 correctly minimal errors minimal errors instruction. without any errors. 10 points points / points points 0 point Submitted I day or Submitted on the Submitted 1-2 Submitted 3 No submission Timeliness more earlier than day of the day/s late of the or more days at all the deadline deadline deadline late of the deadline
