A-Level Essay On Excel Analysis Results For Free Use

After the analysis, the histogram got indicates that there is a reasonable promotion rate for new employees. The distribution is bimodal as the distribution has a continuous probability that has distinct peaks. It can be seen that the distribution of salaries paid to employees has two or more modes which can be established by looking at the peaks of the histogram. Also, looking at the limits of salaries paid and their corresponding frequencies indicate that the peaks presented by the histogram have significant differences when it comes to their length. The descriptive statistics for salary, hourly rate, years of service, education, and age was also ran. The results showed that the mean salary offered by the company is $53,114, the mean hourly rate is $25.49, the average years of service by employees to the service is 6.3 years, average education is 13.70 and mean age for employees is 35.8 years. Standard deviation is another measure of statistic that cannot be overlooked. The standard deviation for the salary is $1125.71. The standard deviation is large meaning that salaries are not closely distributed around the mean. This is also the case in the hourly rate, years of service, education, and age. It can further be established that if the data points are plotted, the will appear to be scattered further from the regression line. The pie charts indicate that out of the 372 employees of the company, 300 are men, and 72 are women. The pie chart on education level shows that the largest number of staff had an HS level of education, followed by those with BA/MS level of education. Those with AA and Masters level of education were the least. The company was meeting its expectations through employing those individuals it found useful to its operations without taking into consideration its gender makeup. The number of positions that the firm should consider is 118 for sales and 254 for other posts.
The findings indicated that the male workers are make up the largest workforce of the company. Employees earning $30,000 to $90,000 are the majority in the company with those earning $100,000 to $140,000 being 11 only. None of the employees makes more than $140,000. Running an analysis of variance for the variables would help in determining if the results got are “right or wrong.”