Data analytics case study

Complete the following assignments using excel and the following template:

· Assignment – Statement

· Identify Business Problem -

“Define Problem statement [aka Case Analysis Assignment]”

· Analytics Tools and Models used and results

· Interpretation, Discussion, and Analysis of Findings and Results –

Interpretation, Discussion, and Analysis of outcomes and results of Analytics Tools and Models used

· Tip: Support your Interpretation, Discussion, and Analysis of Results with the numbers you developed in your:

· Analytics Tools and Models used results

· Business Analytics Case Analysis EXCEL model(s) and outcomes and results

· Recommendations

Assignment 1

 

In meeting with PLE’s human resources director, Elizabeth also discovered a concern about the high rate of turnover in its field service staff. Senior managers have suggested that the department look closer at its recruiting policies, particularly to try to identify the characteristics of individuals that lead to greater retention. However, in a recent staff meeting, HR managers could not agree on these characteristics.

 

Some argued that years of education and grade point averages were good predictors. Others argued that hiring more mature applicants would lead to greater retention. To study these factors, the staff agreed to conduct a statistical study to determine the effect that years of education, college grade point average, and age when hired have on retention. A sample of 40 field service engineers hired 10 years ago was selected to determine the influence of these variables on how long each individual stayed with the company. Data are compiled in the Employee Retention worksheet.

 

Use techniques of regression analysis to assist her in evaluating the data in these three worksheets and reaching useful conclusions.

 

Summarize your work in a formal report with all appropriate results and analyses.

 

 

Assignment 2

 

An important part of planning manufacturing capacity is having a good forecast of sales. Elizabeth Burke is interested in forecasting sales of mowers and tractors in each marketing region as well as industry sales to assess future changes in market share. Develop forecasting models for these data and prepare a report of your results with appropriate charts and output from Excel.

 

Assignment 3

 

She also wants to forecast  future increases in production costs. Develop forecasting models for these data and prepare a report of your results with appropriate charts and output from Excel.