How to Hedge the Currency Risk of Aifs

GROUP REGRESSION PROJECT

100 POINTS

ITPro is a large national systems company that specializes in programming and system development for client companies. Your consulting firm has been approached by the HR Director to perform an independent analysis to develop a model to explain the firm’s salary structure and to provide an opinion to ITPro concerning the adherence to state and federal equal employment opportunity (EEO) practices relating to factors such as age and gender.

A sample of 40 analyst’s annual salaries ($K) and the following factors believed to impact salary is included in your Course Data File:

Tenure: Years employed by ITPro

Gender: Male or Female

Age: Age in years of the employee.

Degree: Highest degree obtained as follows:

H: High School

B: Bachelors

M: Masters (or higher)

Position: Two levels defined as follows:

Jr: Junior

Sr: Senior – reserved for those who have demonstrated project leadership capabilities and the ability to be mentors for the Junior Analysts.

PART I: Descriptive Analysis and Difference in Means.

• Are there any outliers in the data of Salaries?

• Perform a descriptive analysis on the data. The analysis should include descriptive summaries on the key attributes.

• The descriptive analysis should help you identify issues such as differences in means of Salaries across the independent variables of Gender, Degree and Position.

• Did your analysis of difference in means identify any potential EEO concerns?

PART II: Regression Modeling

Using EXCEL, build a regression model to explain Salary. In your report I will be looking for such items as:

• A multiple regression model that you recommend or one you found to be the “best” from all the models you considered.

• The logic you used in selecting the model.

• A clear explanation of the model and its elements.

• A detailed statistical analysis of the model...