Please use theattached worksheetDownload attached worksheet to answer the following questions. Please show your answers to each question clearly in the Excel file, and upload your final Excel file to receive full credit.

1. What is the data type of the Department variable?
2. What is the mode of the Commute variable?
3. For the Satisfaction variable, please calculate the following statistics:
   1. Minimum
   2. Maximum
   3. Range
   4. Median
   5. Average
   6. Standard Deviation
4. Find the average and median of the Tenure variable. Based on this information, would you expect the data to be symmetrically distributed or skewed?

View Rubric

Column Label Description A Obs Simply the observation number, 1-150. Could also be thought of as an ID number. B Department Department of the employee: 1 = Research 2 = Operations 3 = Portfolio Management 4 = Credentialing 5 = IT C Commute Employee's self-reported commute length as: 1 = Short 2 = Moderate 3 = Long D Education Employee's number of years of education. Twelve (12) signifies high school diploma. E Tenure Number of years the employee has been at the company. F Salary Employee's salary in dollars. G Satisfaction Employee's rating of their satisfaction with National Teachers of Excellence. An empirically-validated organizational satisfaction inventory was used to collect the data. This is the final score for how the employee rated the organization, with higher numbers referring to higher satisfaction.

Obs Department Commute Education Tenure Salary Satisfaction 1 1 1 21 13 49962 35 2 1 3 24 7 60000 61 3 1 2 21 21 44383 55 4 1 1 18 16 36875 40 5 1 3 18 18 38488 41 6 1 3 19 25 43796 43 7 1 3 21 25 47154 44 8 1 2 22 9 52975 36 9 1 3 18 23 36309 37 10 1 1 16 20 28088 49 11 1 2 17 11 32380 43 12 1 3 17 16 37420 54 13 1 2 18 13 36757 46 14 1 1 21 26 48683 30 15 1 2 21 12 48497 56 16 2 1 21 16 45613 7 17 2 3 19 16 49181 8 18 2 3 14 9 28434 12 19 2 2 19 19 48412 6 20 2 2 18 1 35309 13 21 2 2 18 21 49379 13 22 2 3 17 20 43815 11 23 2 3 17 14 33062 15 24 2 1 16 19 39712 24 25 2 3 22 26 59824 20 26 2 2 18 14 43608 25 27 2 1 17 5 37003 13 28 2 1 21 12 51332 15 29 2 3 20 17 54583 15 30 2 1 20 16 46313 4 31 2 1 17 12 41393 22 32 2 1 22 18 57514 12 33 2 2 23 13 57510 21 34 2 2 20 18 46476 14 35 2 3 17 20 34908 22 36 2 2 16 16 38694 22 37 2 1 15 22 39839 24 38 2 1 15 23 41467 26 39 2 3 16 18 39384 33 40 2 1 19 32 47548 17 41 2 1 15 15 32605 22 42 2 2 17 10 41643 32 43 2 1 21 25 57144 19 44 2 2 18 12 45045 21 45 2 1 19 24 49667 23 46 2 3 19 15 47033 14 47 2 2 19 18 44832 20 48 3 2 20 19 52866 86 49 3 1 19 15 49426 84 50 3 3 17 25 43106 79 51 3 1 20 16 47944 81 52 3 1 17 6 38216 73 53 3 3 22 7 51234 79 54 3 3 17 22 47215 87 55 3 1 19 17 41909 77 56 3 1 21 15 42750 82 57 3 1 20 17 47800 74 58 3 1 21 11 53866 84 59 3 3 17 16 40317 89 60 3 1 16 19 39912 79 61 3 2 20 12 42035 73 62 3 1 21 22 49215 86 63 3 3 21 18 59228 76 64 3 1 14 17 32662 77 65 3 2 22 16 52131 71 66 3 2 23 13 55025 65 67 3 2 18 16 41783 90 68 3 3 12 17 30461 75 69 3 1 23 17 57498 78 70 3 2 20 9 40040 78 71 3 3 17 18 39916 68 72 3 3 18 16 41137 67 73 3 1 19 8 42911 64 74 3 3 19 9 38148 75 75 3 3 15 5 22500 70 76 3 3 15 16 43774 74 77 3 1 22 15 56665 92 78 3 2 17 22 46118 71 79 3 3 21 23 51820 79 80 3 3 18 4 36532 86 81 4 2 22 13 50206 49 82 4 2 21 8 50979 61 83 4 1 16 15 29606 43 84 4 1 13 6 32440 58 85 4 1 18 13 44492 43 86 4 3 18 16 44378 53 87 4 1 20 17 53075 49 88 4 3 15 22 30365 55 89 4 3 14 11 30512 70 90 4 1 18 14 45584 47 91 4 1 19 20 46429 46 92 4 2 18 22 42835 55 93 4 1 15 17 34273 58 94 4 3 21 13 51248 55 95 4 3 16 8 33283 38 96 4 2 20 15 44901 40 97 4 3 19 7 31784 61 98 4 1 14 15 24380 43 99 4 3 16 15 37256 47 100 4 2 21 18 48302 45 101 4 1 21 20 50257 55 102 4 1 21 17 49093 67 103 4 2 21 8 47344 51 104 4 2 21 21 54942 34 105 4 3 18 18 46553 48 106 4 1 22 24 52569 43 107 4 3 19 17 48979 56 108 4 2 13 14 26434 31 109 4 2 15 15 39314 45 110 4 2 19 23 50061 56 111 4 3 18 15 48402 42 112 4 1 23 22 51647 48 113 5 1 22 20 57937 62 114 5 2 18 25 51315 41 115 5 1 20 7 42958 45 116 5 1 18 23 43267 58 117 5 3 14 14 35919 46 118 5 2 13 24 30642 42 119 5 2 19 21 37632 57 120 5 1 15 14 35115 56 121 5 2 18 18 42944 31 122 5 3 15 13 32463 54 123 5 2 19 22 48971 60 124 5 1 14 13 30826 46 125 5 3 20 15 51106 44 126 5 2 18 14 37728 44 127 5 1 17 2 35531 58 128 5 3 24 4 48118 50 129 5 2 14 12 29637 49 130 5 1 13 20 30948 47 131 5 3 16 13 30974 52 132 5 3 21 20 57480 53 133 5 2 18 17 39202 45 134 5 2 12 7 28843 39 135 5 2 16 13 32371 45 136 5 1 22 18 57844 54 137 5 1 12 14 26406 59 138 5 2 17 17 42309 50 139 5 1 15 15 32899 51 140 5 2 20 11 49443 50 141 5 1 19 16 53785 50 142 5 1 19 22 44836 39 143 5 2 22 20 48788 50 144 5 1 18 12 40475 52 145 5 3 15 17 39490 45 146 5 2 18 35 48557 49 147 5 1 22 10 49790 47 148 5 1 19 17 47552 58 149 5 2 18 12 42824 56 150 5 1 14 13 36936 45