Book1 - Employee 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Employee # 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 Annual Income [$] Help Desk Certified? 21135 no 33037 yes 28155 no 13682 no 23919 no 43795 yes 31122 yes 28137 no 22471 no 38570 yes 27654 no 31277 yes 24191 no 30854 yes 28788 no 18342 no 19768 no 23828 no 34451 yes 30591 yes 29463 no 31294 yes 30410 yes 33141 yes 9933 no 24909 no 21986 no 20183 no 37231 yes 22858 no 31765 yes 28003 no 14680 no 25405 no 34258 yes 23728 no 15281 no 23751 no 38394 yes 17825 no 28037 no 25767 no 28115 no 40756 yes Max Min # of classes Class Width Round to Classes Lower limits 9900 12600 15300 18000 20700 23400 26100 28800 31500 34200 36900 39600 42300 Skewness Kurtosis Do annual income figures follow or are roug Since SKEW does fall within +/­ .608 and Annual 12 10 8 Frequency 6 4 2 0 15300-179 9900-12599 2 0 15300-179 9900-12599 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 17098 30411 40125 12751 13011 18486 26233 26879 19840 32069 25073 29773 25845 20228 25745 19892 22736 19407 41692 28109 28034 no yes yes no no no no no no yes no no no no no no no no yes no no 43795 9933 13 2604.77 2700 Classes Upper limits (bin) 12599 15299 17999 20699 23399 26099 28799 31499 34199 36899 39599 42299 44999 0.12 ­0.15 Bin Total 12599 15299 17999 20699 23399 26099 28799 31499 34199 36899 39599 42299 44999 Frequency 1 5 2 8 5 11 11 9 4 2 3 3 1 65 0.61 1.22 Class 9900­12599 12600­15299 15300­17999 18000­20699 20700­23399 23400­26099 26100­28799 28800­31499 31500­34199 34200­36899 36900­39599 39600­42299 42300­44999 Frequency 1 5 2 8 5 11 11 9 4 2 3 3 1 Pass Pass nual income figures follow or are roughly approximate to a normal distribution? SKEW does fall within +/­ .608 and KURT does fall within +/­ 1.216, I conclude that 1and1 Web Hosting Co Intl. rough Annual Income Distribution 12 10 8 Frequency 6 4 2 0 15300-17999 26100-28799 36900-39599 9900-12599 20700-23399 31500-34199 42300-44999 Annual Income 2 0 15300-17999 26100-28799 36900-39599 9900-12599 20700-23399 31500-34199 42300-44999 Annual Income sting Co Intl. roughly approximates a normal distribution. Employee # 22 9 21 55 5 52 37 46 2 24 36 63 15 3 53 14 32 59 57 6 23 61 40 47 18 60 7 38 42 25 20 27 45 26 41 44 11 33 10 39 12 28 43 16 Annual Income [$] Help Desk Certified? Random # New Position 31294 yes 0.93 1 22471 no 0.23 2 29463 no 0.07 3 25073 no 0.36 4 23919 no 0.31 5 26879 no 0.71 6 15281 no 0.63 7 30411 yes 0.38 8 33037 yes 0.19 9 33141 yes 0.9 10 23728 no 0.9 11 41692 yes 0.12 12 28788 no 0.41 13 28155 no 0.77 14 19840 no 0.15 15 30854 yes 0.99 16 28003 no 0.18 17 25745 no 0.28 18 25845 no 0.1 19 43795 yes 0.7 20 30410 yes 0.59 21 22736 no 0.15 22 17825 no 0.34 23 40125 yes 0.51 24 23828 no 0.75 25 19892 no 0.15 26 31122 yes 0.02 27 23751 no 0.72 28 25767 no 0.91 29 9933 no 0.05 30 30591 yes 0.89 31 21986 no 0.84 32 17098 no 0.28 33 24909 no 0.96 34 28037 no 0.21 35 40756 yes 0.6 36 27654 no 0.67 37 14680 no 0.84 38 38570 yes 0.98 39 38394 yes 0.86 40 31277 yes 0.74 41 20183 no 0.88 42 28115 no 0.98 43 18342 no 0.14 44 62 64 54 4 31 34 30 1 35 29 65 19 8 49 51 48 17 50 58 56 13 19407 28109 32069 13682 31765 25405 22858 21135 34258 37231 28034 34451 28137 13011 26233 12751 19768 18486 20228 29773 24191 no no yes no yes no no no yes yes no yes no no no no no no no no no 0.65 0.13 0.14 0.84 0.41 0.24 0.54 0.99 0.38 0.88 0.51 0.13 0.03 0.52 0.85 0.95 0.57 0.74 0.79 0.86 0.7 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 Select a random sample of 10 employees using the Random Function Population Sample Mean 26375.03 27096.9 Std Dev 7430.43 5590.37 Training Proportion 0.31 0.4 Employee # (original #) Annual Income [$] Help Desk Certified? 22 31294 yes 9 22471 no 21 29463 no 55 25073 no 5 23919 no 52 26879 no 37 15281 no 46 30411 yes 2 33037 yes 24 33141 yes Random # 0.05 0.64 0.92 0.6 0.81 0.51 0.98 0.76 0.04 0.17 ...
View Full Document

This note was uploaded on 06/09/2011 for the course ENGLISH English 10 taught by Professor Staff during the Spring '11 term at Oglethorpe.

Ask a homework question - tutors are online