c) z-scores Q1) Answer the following questions below. a) For each variable from the Data listed in the "Data 1" worksheet, indicate whether it is Quantitative (Q) or Categorical (C). 2 Q or C? a) Variable Children Region State Traveling Expense b) Find the summary statistics of Salary that are listed. For convenience, the Salary column is copied on this sheet. Compute below (b) Salary statistics Median Standard deviation Coefficient of variation Range 46th Percentile Mode 1 Mode 2 1st Quartile c) Compute the z-scores of Salary data in the colored column. 1 2 $ 3 $ $ 4 4 $ 5 $ 6 $ 7 7 $ 8 $ 9 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 $ 45 $ 46 $ $ 47 $ $ 48 $ 49 $ 50 $ 51 $ 52 $ 53 $ 54 $ $ 55 $ 56 $ 57 $ $ 58 $ $ 59 $ 60 60 $ 61 $ 62 $ 63 $ 64 $ $ 65 $ $ 66 $ 67 $ 68 $ $ Salary 26,909 33,600 64,700 33.200 9,600 50,500 38,200 68,600 31,500 43,700 55,100 43.100 17.300 66,200 31,300 107,300 28,300 84,800 16,794 169,900 32,700 46,600 62.600 23,935 97,400 40,033 47,500 18,364 41,600 64,000 23,185 20,900 63,700 82,000 32,391 43,700 58,600 76,800 76.400 59,600 84,800 45,600 69,400 172.700 83,700 64,100 83,000 54,200 32,400 41,300 36,900 25,800 79,900 55.900 50,500 113.400 92.400 27,036 95,800 63,500 19,900 31,392 60,300 95,900 23,200 35,200 60.300 d) Highlight all the outliers if any exists in the Salary data based on computed z-scores in part c. A B C D E F G 3 69 $ 70 $ 71 $ 72 $ 73 $ 74 $ 75 $ 76 $ 77 $ 78 $ 79 $ $ 80 81 $ $ 82 83 84 85 $ $ 86 87 $ $ $ 88 $ 89 $ $ $ 90 91 92 93 $ $ $ 94 95 96 $ 97 98 $ 99 $ 100 $ 101 $ 102 $ 103 $ 104 $ 105 $ 106 $ 107 $ 108 $ 109 $ 110 $ 111 $ 112 $ 113 $ 114 $ 115 $ 116 $ 117 $ 118 $ 119 $ 120 $ 121 $ 122 $ 123 $ 124 $ 125 $ 126 $ 127 $ 128 $ 129 $ 130 $ 131 $ 132 $ 133 $ 134 $ 135 $ 136 $ 83,100 84,300 88,000 65,400 51,900 79,300 105,300 43,300 73,200 66,800 97,500 96,100 47,600 52,500 67,900 46,100 38,700 84,100 51,200 87,200 49,200 88,500 79,500 15,900 181,700 62,700 51,900 22,000 36,500 23,200 16,400 93,400 63,300 52,000 76,900 49,700 63,500 50,500 30,400 41,200 26,386 46,600 66,900 55,600 79,400 17,200 94,200 57,600 56,300 55,600 27,100 75,500 63,800 15,000 31,600 34,700 64,300 44,500 62,800 72,200 27,639 64,100 51,900 70,400 65,800 58,200 52,900 88,200 137 $ 138 $ 139 $ 140 $ 141 $ 142 $ 143 $ 144 $ 145 $ 146 $ 147 $ 148 $ 149 $ 150 $ 151 $ 152 153 154 155 67,600 27,000 53,600 95,800 83,100 40,900 243,000 73,000 117,500 13,700 53,700 36,215 42,000 62,300 84,700 c) z-scores Q1) Answer the following questions below. a) For each variable from the Data listed in the "Data 1" worksheet, indicate whether it is Quantitative (Q) or Categorical (C). 2 Q or C? a) Variable Children Region State Traveling Expense b) Find the summary statistics of Salary that are listed. For convenience, the Salary column is copied on this sheet. Compute below (b) Salary statistics Median Standard deviation Coefficient of variation Range 46th Percentile Mode 1 Mode 2 1st Quartile c) Compute the z-scores of Salary data in the colored column. 1 2 $ 3 $ $ 4 4 $ 5 $ 6 $ 7 7 $ 8 $ 9 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 $ 45 $ 46 $ $ 47 $ $ 48 $ 49 $ 50 $ 51 $ 52 $ 53 $ 54 $ $ 55 $ 56 $ 57 $ $ 58 $ $ 59 $ 60 60 $ 61 $ 62 $ 63 $ 64 $ $ 65 $ $ 66 $ 67 $ 68 $ $ Salary 26,909 33,600 64,700 33.200 9,600 50,500 38,200 68,600 31,500 43,700 55,100 43.100 17.300 66,200 31,300 107,300 28,300 84,800 16,794 169,900 32,700 46,600 62.600 23,935 97,400 40,033 47,500 18,364 41,600 64,000 23,185 20,900 63,700 82,000 32,391 43,700 58,600 76,800 76.400 59,600 84,800 45,600 69,400 172.700 83,700 64,100 83,000 54,200 32,400 41,300 36,900 25,800 79,900 55.900 50,500 113.400 92.400 27,036 95,800 63,500 19,900 31,392 60,300 95,900 23,200 35,200 60.300 d) Highlight all the outliers if any exists in the Salary data based on computed z-scores in part c. A B C D E F G 3 69 $ 70 $ 71 $ 72 $ 73 $ 74 $ 75 $ 76 $ 77 $ 78 $ 79 $ $ 80 81 $ $ 82 83 84 85 $ $ 86 87 $ $ $ 88 $ 89 $ $ $ 90 91 92 93 $ $ $ 94 95 96 $ 97 98 $ 99 $ 100 $ 101 $ 102 $ 103 $ 104 $ 105 $ 106 $ 107 $ 108 $ 109 $ 110 $ 111 $ 112 $ 113 $ 114 $ 115 $ 116 $ 117 $ 118 $ 119 $ 120 $ 121 $ 122 $ 123 $ 124 $ 125 $ 126 $ 127 $ 128 $ 129 $ 130 $ 131 $ 132 $ 133 $ 134 $ 135 $ 136 $ 83,100 84,300 88,000 65,400 51,900 79,300 105,300 43,300 73,200 66,800 97,500 96,100 47,600 52,500 67,900 46,100 38,700 84,100 51,200 87,200 49,200 88,500 79,500 15,900 181,700 62,700 51,900 22,000 36,500 23,200 16,400 93,400 63,300 52,000 76,900 49,700 63,500 50,500 30,400 41,200 26,386 46,600 66,900 55,600 79,400 17,200 94,200 57,600 56,300 55,600 27,100 75,500 63,800 15,000 31,600 34,700 64,300 44,500 62,800 72,200 27,639 64,100 51,900 70,400 65,800 58,200 52,900 88,200 137 $ 138 $ 139 $ 140 $ 141 $ 142 $ 143 $ 144 $ 145 $ 146 $ 147 $ 148 $ 149 $ 150 $ 151 $ 152 153 154 155 67,600 27,000 53,600 95,800 83,100 40,900 243,000 73,000 117,500 13,700 53,700 36,215 42,000 62,300 84,700