THE BUSINESS CASE ANALYSIS

Running head: BUSINESS CASE ANALYSIS
Business Case Analysis
Name of the Student:
Name of the University:
Author note:

BUSINESS CASE ANALYSIS
1
Executive Summary
The study is based on data visualization, summary statistics and regression analysis. The
study shows the effect of experiences on salaries. There is a sample of 50 observations has
been taken in this study. In which 24 men and 26 are women. Moreover in inferential
statistics the co linearity has been cheeked. The residual plot, scatter plot and line plot shows
the relationship among these variables.

BUSINESS CASE ANALYSIS
2
Table of Contents
Executive Summary...................................................................................................................1
Introduction................................................................................................................................3
Data Visualization and Descriptive Statistics............................................................................4
Relationship between Salary and Gender..................................................................................7
Relationship between Experience and Gender...........................................................................8
Relationship between Salary and Experience............................................................................9
Relationship between Salary, gender and Experience.............................................................12
Improving the model................................................................................................................12
Conclusion................................................................................................................................14
Bibliography.............................................................................................................................15
Appendices...............................................................................................................................16

BUSINESS CASE ANALYSIS
3
Introduction
The study is based on data visualization, summary statistics and regression analysis.
The study shows the effect of experiences on salaries. There is a sample of 50 observations
has been taken in this study. In which 24 men and 26 are women. Moreover in inferential
statistics the co linearity has been cheeked. The histogram shows that the data of this study is
normal or skewed. There are 4 regression analysis has been done, in which one is multiple
regression.
Hypothesis:
 To determine the difference on salaries among the gender.
 To test the difference on salaries among the gender.
 To test the differences on experiences among the gender.
 To test the differences on experiences among the gender, experiences and salaries.
Moreover to cheek the multi co linearity.

BUSINESS CASE ANALYSIS
4
Data Visualization and Descriptive Statistics
Table 1 Descriptive Statistics on Employee’s Salary
Table 1 shows the descriptive statistics on salary among gender. It has been seen that
the mean salary of employees is 66624 €. The median salary of employee is 66750 €.
Similarly the mode salary of employees is 76400 €. Moreover the standard deviation of
salaries among all employees is 7375.049 €. The range and variance about employees salary
is 36400€ and 70141453€.

BUSINESS CASE ANALYSIS
5
Table 2 Descriptive Statistics on Employees experience
Table 2 shows the descriptive statistics on experience of employees. It has been seen
that the mean experience of employees is 13.9 years. The median experience of employee is
15 year. Similarly the mode experience of the employees is zero. Because the employees with
no experience has repeated. Moreover the standard deviation of experience of employees is
11.87. The range and variance about employees experience is 44 and 141.