Q1) Answer the following questions below a) (2 points each) For each variable from the Data listed in the "Data 1" worksheet, indicate whether it is Quantitative () of Categorical (c) Qor C? Q a Variable Children Region State Traveling Expense OUUO b) (2 points each) Find the summary statistics of Salary that are listed. For convenience, the Salary column is copied on this sheet Compute below 13278438859 (b) Salary statistics Median Standard deviation Coefficient of variation Range 46th Percentile Mode 1 Mode 2 1st Quartile 14 point) Computer the scores of Salary data in the colored column d) 14 points) huht all the others if any exists in the Salary data based on computed -scores in part Cz-scores 01) Answer the following qu a) (2 points each) For each a) Variable Children Region State Traveling Expense b) (2 points each) Find the 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 $ 45$ 46 $ 47 $ 48$ 49 $ 50 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 97400 40,033 47.500 18,364 41,600 64,000 23,185 20,900 63,700 82,000 32391 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 (b) Salary statistics Median Standard deviation Coefficient of variation Range 46th Percentile Mode 1 Mode 2 1st Quartile c) (4 points) Compute the -- d) (4 points) Highlight all the G H 50 $ 51 $ 52 $ 53s 54 $ 55 $ 56 $ 57 $ 58 $ 59 $ 60 $ 61 $ 62 $ 635 64 $ 65 $ 66 $ 67 $ 68 $ 69 $ 70$ 71 $ 72$ 73 $ 74 $ 75$ 76 $ 77 $ 78 $ 79 $ 80 $ 81 $ 82 $ 83 $ 84 $ 85 $ 86 $ 87 $ 885 B9 5 90 5 91 $ 925 98 $ 94 5 95 $ 965 97 $ 985 99 $ 100 $ 101 $ 102 103 5 1045 1055 106 5 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 83,100 84 300 88,000 65,400 51.900 79,300 105,300 43.300 73.200 66.800 97500 96.100 47,600 52,500 67.900 46.100 38,700 84,100 51200 87,200 49 200 88,500 79,500 15,900 181,700 62,700 51 900 22,000 36,500 23.200 16,400 93400 63.300 52.000 75,900 49,700 63,500 50 5 95 $ 96 S 9715 98 $ 99 $ 100 $ 101 $ 102 $ 103 $ 104 $ 105 $ 106 $ 107 $ 108 $ 1.09 $ 110 $ 111 $ 112 $ 1131$ 114 $ 115 $ 116.5 117 $ 118 $ 119 $ 120 $ 121 $ 122 $ 123 $ 124 $ 125 $ 126 $ 1275 128 $ 129 $ 130$ 131 $ 132 $ 1335 134 $ 135 $ 136 $ 137$ 138 $ 1395 140 $ 1413 1425 1435 1445 145 5 146 $ 1473 14s 14915 150 $ 151 $ 152 153 156 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 55600 79400 17200 94,200 57600 56,300 55,600 27,100 75,500 63800 15,000 31600 34,700 64 300 44500 62,800 72,200 27,639 64,100 51,900 70400 65800 58.200 52.900 88200 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 62200 84 700 Q1) Answer the following questions below a) (2 points each) For each variable from the Data listed in the "Data 1" worksheet, indicate whether it is Quantitative () of Categorical (c) Qor C? Q a Variable Children Region State Traveling Expense OUUO b) (2 points each) Find the summary statistics of Salary that are listed. For convenience, the Salary column is copied on this sheet Compute below 13278438859 (b) Salary statistics Median Standard deviation Coefficient of variation Range 46th Percentile Mode 1 Mode 2 1st Quartile 14 point) Computer the scores of Salary data in the colored column d) 14 points) huht all the others if any exists in the Salary data based on computed -scores in part Cz-scores 01) Answer the following qu a) (2 points each) For each a) Variable Children Region State Traveling Expense b) (2 points each) Find the 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 $ 45$ 46 $ 47 $ 48$ 49 $ 50 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 97400 40,033 47.500 18,364 41,600 64,000 23,185 20,900 63,700 82,000 32391 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 (b) Salary statistics Median Standard deviation Coefficient of variation Range 46th Percentile Mode 1 Mode 2 1st Quartile c) (4 points) Compute the -- d) (4 points) Highlight all the G H 50 $ 51 $ 52 $ 53s 54 $ 55 $ 56 $ 57 $ 58 $ 59 $ 60 $ 61 $ 62 $ 635 64 $ 65 $ 66 $ 67 $ 68 $ 69 $ 70$ 71 $ 72$ 73 $ 74 $ 75$ 76 $ 77 $ 78 $ 79 $ 80 $ 81 $ 82 $ 83 $ 84 $ 85 $ 86 $ 87 $ 885 B9 5 90 5 91 $ 925 98 $ 94 5 95 $ 965 97 $ 985 99 $ 100 $ 101 $ 102 103 5 1045 1055 106 5 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 83,100 84 300 88,000 65,400 51.900 79,300 105,300 43.300 73.200 66.800 97500 96.100 47,600 52,500 67.900 46.100 38,700 84,100 51200 87,200 49 200 88,500 79,500 15,900 181,700 62,700 51 900 22,000 36,500 23.200 16,400 93400 63.300 52.000 75,900 49,700 63,500 50 5 95 $ 96 S 9715 98 $ 99 $ 100 $ 101 $ 102 $ 103 $ 104 $ 105 $ 106 $ 107 $ 108 $ 1.09 $ 110 $ 111 $ 112 $ 1131$ 114 $ 115 $ 116.5 117 $ 118 $ 119 $ 120 $ 121 $ 122 $ 123 $ 124 $ 125 $ 126 $ 1275 128 $ 129 $ 130$ 131 $ 132 $ 1335 134 $ 135 $ 136 $ 137$ 138 $ 1395 140 $ 1413 1425 1435 1445 145 5 146 $ 1473 14s 14915 150 $ 151 $ 152 153 156 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 55600 79400 17200 94,200 57600 56,300 55,600 27,100 75,500 63800 15,000 31600 34,700 64 300 44500 62,800 72,200 27,639 64,100 51,900 70400 65800 58.200 52.900 88200 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 62200 84 700