Quantitative Methods Assessed Coursework-

You will separately receive two sets of data, use these to answer the following questions

Section A -

Jenkins and Jenkins Bank wishes to stream-line the recruitment process in their large London offices. To determine the best criteria for recruitment, it has assembled the data given in the first set. For the last thirty employees recruited this gives the value of the business generated by that employee in their first year (given in tens of thousands of pounds) plus their psychometric test score, previous experience (given in years) and their qualifications (given as an index created by the bank for this purpose).

Using Excel Regression software you are required to:

1. Find the correlation coefficients for business generated and psychometric test score, business generated and experience, and business generated and qualifications.

2. Based on these findings, which one criteria would you recommend to use in selecting employees?

3. How effective do you consider your recommendation in (2) to be as a recruitment criteria?

4. Find the regression lines (by least squares) for business generated and psychometric test score, business generated and experience, and business generated and qualifications.

5. For your chosen criteria, explain in words exactly what the line implies.

6. Use the regression lines to estimate the value of business generated in their first year by:
a. A new employee with a psychometric test score of 97.
b. A new employee with 4.3 years of previous experience.
c. A new employee with a qualification index of 40.2.

7. In which of the estimates in (6) do you have the most confidence? Why?

Section B -

Fred's Fabrications is reviewing use of spare parts by its Maintenance department. The second set of data shows parts used in the first week of each of three months.

Using Excel and the Laspeyres Method, you are required to calculate quantity indices for April and July, taking January as the base and the prices as weights.

Attachment:- Data.rar