A local company of sales professionals in Abu Dhabi conducted a survey of its employees to study the relationship, if any, between the years of experience and salary for individuals employed inside and outside sales positions. On the survey, respondents were asked to specify one of three levels of years of experience: low (1-10 years), medium (11-20 years), and high (21 or more years). The complete data set, consisting of 184 observations, is stored in the Excel file SalesSalary.xlsx. Please download the file. 1. Use descriptive statistics to summarize the data. 2. Is the mean annual salary for all salespersons different than 20000 AED? Use a 0.05 level of significance, and Construct a 95% confidence interval of the mean annual salary for all salespersons (test the hypotheses using both p value and C.I method) 3. Is there any significant difference of the mean salary due to position? Use a 0.05 level of significance Compensation for Sales Professionals A local company of sales professionals in Abu Dhabi conducted a survey of its employees to study the relationship, if any, between the years of experience and salary for individuals employed inside and outside sales positions. On the survey, respondents were asked to specify one of three levels of years of experience: low (1-10 years), medium (11-20 years), and high (21 or more years). The complete data set, consisting of 184 observations, is stored in the Excel file SalesSalary.xlsx. Please download the file. You should consider the following instructions when answering the case study question and preparing your report: 1) For confidence intervals: Check all assumptions. Interpret the results. After each question, paste the Mega-Stat output. II) For testing hypothesis: State the null and alternative hypotheses. Check the necessary assumptions. Report the P-value and the test statistic. Make a conclusion statement in the words of the original problem. I After each question, paste the Mega-Stat output. III) For the report Should be written on word document, On the first page, write the names, student numbers, and section number, Show all the steps of the solution and after each question paste the Mega-Stat output. The report should have the following item # Title # Introduction # Main text # Conclusion . Paste BIVE G4 Low A C D 1 ObservationSalary (AED) Position Experience 2 1 173154 Inside Low 3 2 145863 Inside Low 4 3 166896 Inside Low $ 4 155844 Inside Low 6 5 160392 Inside 7 6 158499 Inside Low 8 7 167877 Inside Low 9 8 191397 Inside Low LO 9 162366 Inside Low 11 10 176442 Inside Low 12 177828 Inside Low 13 12 170970 Inside Low 14 13 169383 Inside Low IS 148266 Inside Low 16 15 173010 Inside Low 17 16 156216 Inside Low 18 17 153357 Inside Low 19 18 169056 Inside Low 20 19 164673 Inside Low 21 20 160392 Inside Low 22 21 211545 Outside Low 23 186849 Outside Low 23 191568 Outside 25 24 206574 Outside Low 26 25 190434 Outside Low 27 26 192864 Outside Low 28 27 214035 Outside Low 29 28 196635 Outside Low 30 29 198072 Outside Low 31 30 183384 Outside Low 32 31 182979 Outside Low 32 183897 Outside Low 34 33 20560 Outside Low 35 201711 Outside Law 36 35 186675 Outside Low 37 36 8643 Outside Low 38 37 185040 Outside Low 39 207416 Outside Low 16 Inside Low 41 0777 Inside Low 1934 Inside Low 43 192979 Inside Low 44 4 1935 Low Low LI D E 5 6 44 45 46 47 48 49 50 31 52 L SO 51 52 53 54 55 56 53 58 59 60 61 62 63 64 65 66 67 6 69 70 71 72 54 55 36 57 58 59 60 61 62 53 64 65 66 67 65 699 70 71 72 73 74 75 76 77 71 79 10 31 12 33 215680 211711 196675 198643 195040 217426 191683 190777 148266 173010 196216 153357 189056 164673 160392 211545 186849 191568 206574 19043 192866 214035 196638 211711 207864 221574 175392 211635 206197 TIN96 177566 2345 21:3072 170144 1966 Low Outside Low Outside Low Outside Low Outside Low Outside Low Datside Low Outside Low Outside Low Inside Lew Inside Low Inside Low Inside Low Inside Low Inside Inside Low Outside Low Outside Law Outside Outside Low Outside Low Outside Low Outside Low Outside Low Outside Law Inside Medium Inside Medium Inside Medium Inside Medium Inaide Medium Inside Medium Inside Medium Inside Medium side Media Inside Medium Outside Medium Dutade Media Chie Malim Ode Medium Oude Mom de Med thide Me Die Med 74 75 76 163 1937 35 6 220630 12 1994 10121 21 6 NY 90 Outside Quinte Oude CdM 2011 93 50 IH D DO Times New Roman Pusto G4 V 11 93 200040 Outside w SE 95 06 97 utade M CM VE BE WS 55 1002 101 102 101 101 193 105 Ode Ma Old Mac Dende a 175391 TE 184056 17326 199673 195970 20364 1900 211673 210040 226711 TE 190 15656 175293 TON 184056 17326 19673 195970 100 101 102 103 104 105 100 107 100 100 110 111 112 EL NOT Side Mim 100 110 111 113 OG Outside Out Me Outside a Oude M OM wide Out Outi Mad 115 116 117 115 116 In de 120 121 122 119 120 121 122 120 1010 211675 210040 226711 1252 1943 1906 21004 side de 124 225 126 127 121 2069 de 125 124 IRRI 309104 13 129 Inside 2015 2020 130 131 132 133 154 135 136 131 193 10 TE 2016 215505 155 Quad LEL TRAIL 13 139 140 2012 21413 143 140 161 Oude 22 2120 10 163 166 165 146 HVIS 161 Bu Dit G4 TE 139 140 High High High High High High 14 135 145 147 High High High High 1:49 250 251 152 153 154 155 156 141 162 103 144 145 146 147 145 149 150 151 152 153 154 155 156 157 15 159 160 161 162 Outside Outside Outside Outside Outside Ostside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Taide Inside inside Inside Inside Inside Inside Inside Teslide High High High High High High Hish High High Tigh 157 13 199 160 161 2013 232209 236508 223167 212065 233460 233403 198960 231933 230589 227173 225976 205707 223122 232866 20209 267243 243403 208960 241933 240589 237373 235978 215707 233122 242866 212509 277243 10KT 209304 199704 203157 20209 196416 204240 2033 213505 21872 21222 236130 212209 2360 223167 232068 23460 21.1403 19960 262 163 164 163 165 166 167 168 169 166 165 166 167 168 High ligh High High High High 170 169 170 171 172 175 High High High High 171 172 173 174 175 176 177 176 179 High 175 176 177 17 High Inside Inside Inside Outside Outside Outside Outside Outside Outside Outside Outside Outside thi 19 EEEE lich 158 190 Data A local company of sales professionals in Abu Dhabi conducted a survey of its employees to study the relationship, if any, between the years of experience and salary for individuals employed inside and outside sales positions. On the survey, respondents were asked to specify one of three levels of years of experience: low (1-10 years), medium (11-20 years), and high (21 or more years). The complete data set, consisting of 184 observations, is stored in the Excel file SalesSalary.xlsx. Please download the file. 1. Use descriptive statistics to summarize the data. 2. Is the mean annual salary for all salespersons different than 20000 AED? Use a 0.05 level of significance, and Construct a 95% confidence interval of the mean annual salary for all salespersons (test the hypotheses using both p value and C.I method) 3. Is there any significant difference of the mean salary due to position? Use a 0.05 level of significance Compensation for Sales Professionals A local company of sales professionals in Abu Dhabi conducted a survey of its employees to study the relationship, if any, between the years of experience and salary for individuals employed inside and outside sales positions. On the survey, respondents were asked to specify one of three levels of years of experience: low (1-10 years), medium (11-20 years), and high (21 or more years). The complete data set, consisting of 184 observations, is stored in the Excel file SalesSalary.xlsx. Please download the file. You should consider the following instructions when answering the case study question and preparing your report: 1) For confidence intervals: Check all assumptions. Interpret the results. After each question, paste the Mega-Stat output. II) For testing hypothesis: State the null and alternative hypotheses. Check the necessary assumptions. Report the P-value and the test statistic. Make a conclusion statement in the words of the original problem. I After each question, paste the Mega-Stat output. III) For the report Should be written on word document, On the first page, write the names, student numbers, and section number, Show all the steps of the solution and after each question paste the Mega-Stat output. The report should have the following item # Title # Introduction # Main text # Conclusion . Paste BIVE G4 Low A C D 1 ObservationSalary (AED) Position Experience 2 1 173154 Inside Low 3 2 145863 Inside Low 4 3 166896 Inside Low $ 4 155844 Inside Low 6 5 160392 Inside 7 6 158499 Inside Low 8 7 167877 Inside Low 9 8 191397 Inside Low LO 9 162366 Inside Low 11 10 176442 Inside Low 12 177828 Inside Low 13 12 170970 Inside Low 14 13 169383 Inside Low IS 148266 Inside Low 16 15 173010 Inside Low 17 16 156216 Inside Low 18 17 153357 Inside Low 19 18 169056 Inside Low 20 19 164673 Inside Low 21 20 160392 Inside Low 22 21 211545 Outside Low 23 186849 Outside Low 23 191568 Outside 25 24 206574 Outside Low 26 25 190434 Outside Low 27 26 192864 Outside Low 28 27 214035 Outside Low 29 28 196635 Outside Low 30 29 198072 Outside Low 31 30 183384 Outside Low 32 31 182979 Outside Low 32 183897 Outside Low 34 33 20560 Outside Low 35 201711 Outside Law 36 35 186675 Outside Low 37 36 8643 Outside Low 38 37 185040 Outside Low 39 207416 Outside Low 16 Inside Low 41 0777 Inside Low 1934 Inside Low 43 192979 Inside Low 44 4 1935 Low Low LI D E 5 6 44 45 46 47 48 49 50 31 52 L SO 51 52 53 54 55 56 53 58 59 60 61 62 63 64 65 66 67 6 69 70 71 72 54 55 36 57 58 59 60 61 62 53 64 65 66 67 65 699 70 71 72 73 74 75 76 77 71 79 10 31 12 33 215680 211711 196675 198643 195040 217426 191683 190777 148266 173010 196216 153357 189056 164673 160392 211545 186849 191568 206574 19043 192866 214035 196638 211711 207864 221574 175392 211635 206197 TIN96 177566 2345 21:3072 170144 1966 Low Outside Low Outside Low Outside Low Outside Low Outside Low Datside Low Outside Low Outside Low Inside Lew Inside Low Inside Low Inside Low Inside Low Inside Inside Low Outside Low Outside Law Outside Outside Low Outside Low Outside Low Outside Low Outside Low Outside Law Inside Medium Inside Medium Inside Medium Inside Medium Inaide Medium Inside Medium Inside Medium Inside Medium side Media Inside Medium Outside Medium Dutade Media Chie Malim Ode Medium Oude Mom de Med thide Me Die Med 74 75 76 163 1937 35 6 220630 12 1994 10121 21 6 NY 90 Outside Quinte Oude CdM 2011 93 50 IH D DO Times New Roman Pusto G4 V 11 93 200040 Outside w SE 95 06 97 utade M CM VE BE WS 55 1002 101 102 101 101 193 105 Ode Ma Old Mac Dende a 175391 TE 184056 17326 199673 195970 20364 1900 211673 210040 226711 TE 190 15656 175293 TON 184056 17326 19673 195970 100 101 102 103 104 105 100 107 100 100 110 111 112 EL NOT Side Mim 100 110 111 113 OG Outside Out Me Outside a Oude M OM wide Out Outi Mad 115 116 117 115 116 In de 120 121 122 119 120 121 122 120 1010 211675 210040 226711 1252 1943 1906 21004 side de 124 225 126 127 121 2069 de 125 124 IRRI 309104 13 129 Inside 2015 2020 130 131 132 133 154 135 136 131 193 10 TE 2016 215505 155 Quad LEL TRAIL 13 139 140 2012 21413 143 140 161 Oude 22 2120 10 163 166 165 146 HVIS 161 Bu Dit G4 TE 139 140 High High High High High High 14 135 145 147 High High High High 1:49 250 251 152 153 154 155 156 141 162 103 144 145 146 147 145 149 150 151 152 153 154 155 156 157 15 159 160 161 162 Outside Outside Outside Outside Outside Ostside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Taide Inside inside Inside Inside Inside Inside Inside Teslide High High High High High High Hish High High Tigh 157 13 199 160 161 2013 232209 236508 223167 212065 233460 233403 198960 231933 230589 227173 225976 205707 223122 232866 20209 267243 243403 208960 241933 240589 237373 235978 215707 233122 242866 212509 277243 10KT 209304 199704 203157 20209 196416 204240 2033 213505 21872 21222 236130 212209 2360 223167 232068 23460 21.1403 19960 262 163 164 163 165 166 167 168 169 166 165 166 167 168 High ligh High High High High 170 169 170 171 172 175 High High High High 171 172 173 174 175 176 177 176 179 High 175 176 177 17 High Inside Inside Inside Outside Outside Outside Outside Outside Outside Outside Outside Outside thi 19 EEEE lich 158 190 Data