Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit

Individual Assignment 10%

Please upload Parts A & B on one word document.  The excel spread sheet may be uploaded separately or merged onto the Word doc assignment.  Due Date March 3 

Part A 5%

Using the data below, develop an Excel spreadsheet to complete the following activities:

1. Create a scatterplot of the data;

2. Calculate a correlation between IQ scores and EQ scores;

3. Calculate a correlation between IQ scores and performance;

4. Calculate a correlation between EQ scores and performance; and

5. Interpret the scores (200 – 300 word discussion).

Part B  5% Chapter 2 Exercise 1

You will complete a written analysis (200 – 300 word maximum) about the reliability and validity of an example data set. You will make recommendations about how to improve the assessments and how to apply the assessments in a selection context.

A marketing company is evaluating a new employment test that measures advertising aptitude of job candidates. You have used the new measure on a trial basis over the past year, while you have continued to make selections using your established procedures. You have developed the following database, which includes information on gender, a score from the first administration of the test given during the selection process before the applicant was hired (Test 1), a score from a second administration of the test given at the end of the first year on the job (Test 2), and a performance score assigned by the supervisor at the end of the employee’s first year of employment (Performance). You are asked to evaluate the reliability, validity, and any gender bias of the new test.

Complete:

A. What is the reliability of the new test?

B. What is the predictive validity of the new test?

C. What is the concurrent validity of the new test?

D. Is the test biased towards either male or female?

E. Would you recommend that the company adopt the new test as part of its hiring procedures? Argue your position in a 200 – 300 word recommendation to the company.