ABC Auctions

ABC Auctions

 

1. Create a series of correlation matrices to examine HR practices and performance.

a. Turnover (full time and part time) and HR practices
b. Financials (earnings as a % of revenue, revenue per car) and HR practices
c. Safety (WC per 10,000 cars , OSHA per 10,000 cars , lot damage per car) and HR practices

Which HR practices are significantly correlated with (a) turnover, (b) financial results, and (c) safety? HINT: PLEASE DON’T PASTE THE CORRELATION TABLES INTO WORD (THEY ARE TOO BIG!). INSTEAD USE THE FOLLOWING TABLE AND NOTE WHICH PRACTICES ARE SIGNIFICANTLY RELATED AT p<.05 WITH THE OUTCOMES.

Full time turnover % Part time turnover % Earnings as % of Revenue Revenue per Car WC claims per 10000 cars OHSA accidents per 10000 cars Lot damage per car
Auction Provides Formal Training
New Hire Orientation
Managerial Supervisory Training
Vehicle Inspection Training
Training hours per year
% of Workers Given Performance Eval
% of Workers with Job Descriptions
Selection Tests
Grievance Procedures
Share Financial Information
Share Business Information
Job Rotation
Cross Training
Bonus or Profit Sharing
Merit Raises
Seniority Based Pay
Internal Promotion
Internal Job Posting

Examine the following HR practices:
Training Auction Provides Formal Training
t1 New Hire Orientation
t2 Managerial Supervisory Training
t3 Vehicle Inspection Training
Trhrs Training hours per year
Pfevale % of Workers Given Performance Eval
Jobdesc % of Workers with Job Descriptions
Selection Selection Tests
Griev Grievance Procedures
Fininf Share Financial Information
Plninf Share Business Information
Rotat Job Rotation
Cross Cross Training
Bonus Bonus or Profit Sharing
Merit Merit Raises
Senpay Seniority Based Pay
Intprom Internal Promotion
Intpost Internal Job Posting
2. Conduct appropriate t-tests and/or ANOVA’s. Include test output with your answers. Use p < .05 for hypotheses tests.
a. Is auction type related to auction size (cars consigned) or financial results (ebitdal % of revenue and gross revenue per car consigned)?

HINT: YOU CAN RUN AN ANOVA OR TTEST FOR MULTIPLE DEPENDENT VARIABLES AT THE SAME TIME BY ENTERING THEM INTO ONE COMMAND. FOR EXAMPLE:

ONEWAY consign earningspercent revpercar BY type
/MISSING ANALYSIS.

b. Is formal training related to auction performance (turnover, financials, and safety)?
c. Is the frequency of performance evaluations related to auction performance (turnover, financials, and safety)?
d. Are selection tests related to part time and full time turnover?

3. Create a bar chart that illustrates one of the significant relationships found in #2.

4. Create a contingency table and conduct a Chi Square test. Is auction legacy status related to auction type?

Please turn in a copy of your syntax file and a word document with your findings summarized. For each test paste the important output into the document and please INTERPRET EACH TEST IN A SENTENCE OR TWO with your conclusion.
ORDER THIS ESSAY HERE NOW AND GET A DISCOUNT !!!

 

 

order