Business Statistics Report: Data Analysis and Findings

Verified

Added on  2020/02/24

|5
|688
|114
Report
AI Summary
This business statistics report analyzes a dataset containing variables like area of employment, gender, satisfaction level, search frequency, and salary. The report begins with a variable list, followed by a histogram analysis suggesting a symmetric distribution, with the median as the preferred measure of central tendency due to outliers. Descriptive statistics are presented, revealing that the finance department has the highest average salary, while the 'Other' department has the lowest. A pivot table and bar chart are used to analyze satisfaction levels across different employment areas, with marketing/sales showing the highest satisfaction. The report concludes with observations on salary distribution, satisfaction levels, and gender segregation in employment areas, with the finance department having the lowest satisfaction and a gender imbalance.
Document Page
Running Head: BUSINESS STATISTICS 1
Business Statistics
Name
University
26th August 2017
tabler-icon-diamond-filled.svg

Paraphrase This Document

Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
Document Page
BUSINESS STATISTICS 2
Task 1: variable list
There are five variables listed in the dataset.
Variable Type Measure
Area Qualitative variable Nominal
Gender Qualitative variable Nominal
Satisfaction Qualitative variable Ordinal
Search Quantitative variable Discrete
Salary Quantitative variable Continuous
Task 2: Histogram
Document Page
BUSINESS STATISTICS 3
Looking at the histogram, the shape of the histogram suggests that symmetric (following a
normal distribution). Yes there are few outliers but they are of no significant effect or interest.
Median would be an ideal measure of central tendency in describing the center of the distribution
since there are a few outliers and it’s only the median that is not affected by the presence of
outliers.
Task 3: Descriptive Statistics
Descriptive Statistics
Area N Mean Std. Deviation
Accounting Salary 40 50.4000 5.02200
Finance Salary 29 52.2759 7.21554
General management Salary 22 43.1364 3.70708
Marketing/Sales Salary 42 44.5952 4.26591
Other Salary 17 40.5294 7.21212
Document Page
BUSINESS STATISTICS 4
As can be seen from both the table and the side-by-side boxplot, those working at the finance
department have highest average salary compared to all the other five departments. Other, have
the lowest average salary. It is important to note that the general management had some few
outliers. In terms of data being spread out, the salary for other departments was much spread out
from the mean as compared to all other departments while general management had the lowest
spread.
Task 4: pivot table and bar chart
Count of
Satisfaction Area
Satisfaction Accounting Finance
General
management Marketing/Sales Other Grand Total
None 8 15 10 14 2 49
Little 23 10 7 16 11 67
Quite 9 4 5 11 3 32
Very 1 1 2
Grand Total 40 29 22 42 17 150
Count of
Satisfaction Area
Satisfaction Accounting Finance
General
management Marketing/Sales Other
Grand
Total
None 20.00% 51.72% 45.45% 33.33% 11.76% 32.67%
Little 57.50% 34.48% 31.82% 38.10% 64.71% 44.67%
Quite 22.50% 13.79% 22.73% 26.19% 17.65% 21.33%
Very 0.00% 0.00% 0.00% 2.38% 5.88% 1.33%
Grand Total 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%
If business school graduate wanted to get most satisfaction from their job, based on the
information in the table marketing/sales area would be an ideal area of employment they should
choose since 28.57% were either quite or very satisfied (highest among all the areas of
employment).
tabler-icon-diamond-filled.svg

Paraphrase This Document

Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
Document Page
BUSINESS STATISTICS 5
Yes the employment areas differ in percentage of female/male graduates. For instance, in
Accounting and finance majority are males (55% and 62% respectively). Majority of females are
in General management (55%), Marketing/sales (64%) and other employment areas (59%).
Conclusion
This study sought to understand salary distribution as well as satisfaction of the employees. It
was established that the average salaries of employees differ across the area of employment with
finance area having the highest average salary. In terms of satisfaction levels, the most
dissatisfied lot were those working in the finance department (52% said to have none satisfaction
level) while the most satisfied were those in the marketing/sales department. There seems to be
gender segregation when it comes to areas of employment. Most females were in general
management, marketing/sales and other areas of employment while few females were in finance
and accounting departments.
chevron_up_icon
1 out of 5
circle_padding
hide_on_mobile
zoom_out_icon
[object Object]