Question 1 (10 marks) Excel was used to analyze the number of employees for the

Question

Question 1 (10 marks) Excel was used to analyze the number of employees for the top 60 employers with headquarters around the world outside of the United States. The data was compiled by myglobalcareer.com, extracted from My Global Career 500, and was analyzed using Excel's descriptive statistics feature. Summarize what you have learned about the number of employees for these companies by studying the output (about 250 words). Top GO Employers Outside of the U.S 2119429 2415.31 175660 150000 96168 57 9.25E+09 .090976 1.356847 387245 115300 502545 Standard error Standard deviation Sample variance Count 60 In your summary description the following should be highlighted. Number of employees, minimum, maximum and range, the mean, median and mode number of employees, skewness, standard deviation. Carefully describe the indicators and its implications.

Explanation / Answer

Number of employees of the 60 employers with headquaters around the world outside of US are 12716575.

The Minimum number of employees out of the 60 employers is 115300. The employers who have this number of employee have minium employees.

The Maximum number of employees out of the 60 employers is 502545.

The difference between the Maximum emplyees the employer have to the minimum number of employees the employer have (That is range) is 387245 employees.

The average number of employees this 60 employers have is 211942.9 employees.

The emploers having employees 175660 have the lies in the middle if we arranged the employers according to their employee strength.

Skewness =1.35 represents that the distribution of data is positively skewed.

Kurtosis =1.09 represents that the Number of employees of the employers are more concentrated near the mean.

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.