Reference no: EM131061745
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
|
Economies on the global market
: a) Explain some of the disadvantages that Fiji faces when competing with bigger economies around the world. b) Explain why countries like Singapore and Mauritius have been so successful competing bigger economies on the global market.
|
|
What characteristics make these articles high quality
: From an ethical standpoint, is it inappropriate that teachers (and police officers, firefighters, EMT workers, etc.) get paid so little compared to professional athletes, actors, or corporate CEOs? Explain your answer from a Christian perspective
|
|
What is the inductance per unit length of the wires
: What is the inductance per unit length of the wires
|
|
Find the probabilities of the particle being between 0 and ,
: Consider a wave packet formed by using the wave function , where A is a constant to be determined by normalization. Normalize this wave function
|
|
Find correlation coefficients for business generated score
: Quantitative Methods Assessed Coursework. Find the correlation coefficients for business generated and psychometric test score, business generated and experience, and business generated and qualifications
|
|
Level of the money supply
: Explain the three traditional policy tools that the Federal Reserve can use to influence the level of the money supply
|
|
Functions equal the square of its output
: Oligopoly problem - Let the profit and cost functions be p(yT) = 60 - yT, Each firms cost functions equal the square of its output.
|
|
Examples of service busineses
: Examples of service busineses that would use job order costing would inlude all of folloing: A. an accounting firm that has audit clients of various sizes and complexities. B. a "quick oil change " shop that offers only basic maintenance services.
|
|
Explain how the money multiplier works
: Explain the three functions of money defined by neoclassical economic theory. What does it mean to say that money is neutral? Explain how the money multiplier works. That is, why does an initial net change in deposits lead to a greater change in the ..
|