Course Project - Phase 4
Running Head: Analysis of the job salaries
Examine Job salaries for the state of Minnesota.
Jessica Seifert
Rasmussen College
January 6, 2018
Background of the data
The provided data in excel sheet is all about different job types in a specific area Minnesota.
The data shows and explains us about the Salary of given job type. The salary gets presented in per annum terms. The objective of this analysis is to understand the salary distribution for different types of jobs.
The provided excel sheet data contains 364 various job types. The given excel gets supplied by Bureau of Labor Statistics.
In the given data there are two types of attributes (variables).
1) Job title
2) Salary
The job title is qualitative, and the level of measurement of the job title is nominal.
The salary gets presented in digits that are quantitative and discrete data, and the level of measurement of the wage is the ratio.
Importance of the measure of variation and central tendency
The size of the center tendency plays a substantial and essential in our daily life. It helps us to figure out the single center point and help us to figure out reference point of the whole data. The most well-known and commonly used measure of central tendency is mean. The mode shows the most data value in the data and median tells help us to find middle amounts of the arranged data. So, the measure of center is significant as they help us to use reference point of the whole data from that we can analyze different real-life problems. (Pharmacother, 2011)
The Measures of variation shows and make the data accessible to know the consistency in the entire data or a specific data values, the measure of change shows us that how the data varied in the data set and we can easily compare the two data sets. The different types of sizes of variation, like standard deviation, mean deviation, quartile deviation, the coefficient of variation these all get used in the different scenarios in various aspects which help us understand the data efficiently. (Pharmacother, 2011)
Using excel command the output of the descriptive statistics gets presented below.
|
Salary |
|
|
|
|
|
Mean |
62306.13 |
|
Standard Error |
1003.692 |
|
Median |
56520 |
|
Mode |
46100 |
|
Standard Deviation |
19149.21 |
|
Sample Variance |
3.67E+08 |
|
Kurtosis |
0.258251 |
|
Skewness |
1.028919 |
|
Range |
79680 |
|
Minimum |
40170 |
|
Maximum |
119850 |
|
Sum |
22679430 |
|
Count |
364 |
|
Confidence Level (95.0%) |
1973.78 |
|
Mid-range = (min+ max) / 2 |
|
|
Mid-Range |
80010 |
References Pharmacother, J. P. (2011). Measures of central tendency.