Homework Assignment 2

Milestone 2 is due during Module Six. For this milestone, you will submit your plan of analysis, (establish statistical task, appropriate statistical tools and method for data analysis) and data analysis outcomes.

You will need to provide justification for the appropriate statistical methods and or tools needed to analyze the company’s data, a hypothesis, the results of your analysis to address the company’s problem.

Problem Statement

We want to examine the relationship between the employees salary to the years of education in which they have completed. We will also show if the years of education is more valuable than the years of experience or vice versa.

 Specifically, the following critical elements must be addressed:

1. Determine your plan of analysis in addressing the problem
    
2. Identify statistical methods and tools that are appropriate for your data analysis. Explain why you select each method and/or tool.  
    
3. Analyze data to determine the appropriate decision for the identified problem (final report case scenario salary data):
   --- Outline the process for each data analysis
   --- Analyze the data
   --- Provide your statistical conclusions. Make sure you provide statistical evidences to support your conclusions.
   --- Provide managerial conclusions based on your statistical conclusions.
    
4. Suggest appropriate data driven decision that addresses the given problem. Explain how effective your decision can address the given problem.

Attachment

• data file for final project.xlsx (15 KB)