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 annual salary for individuals employed, and the position of working inside Abu Dhabi town, and outside Abu Dhabi town. 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 Sales Salary.xIsx. Please download the file. Variable Names: Salary: annual salespersons salary in AED Position: (inside, inside) Experience: (low, medium, high) You should consider the following instructions when answering the case study question and preparing your report: 1) For confidence intervals: Construct a 95% confidence interval. After each question, paste the Mega-Stat output. For testing hypothesis: State the null and alternative hypotheses. Check the necessary assumptions. Find the P-value and the test statistic. Make the test using the P-value with 0.05 level of significance. Make a conclusion statement in the words of the original problem. After each question, paste the Mega-Stat output. For the reportShould 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 conclusion, which is the summary of all the questions. Analyze the case Study project by answering the following questions 1. Use descriptive statistics to summarize the data of the salespersons. a) For the quantitative variable (Salary): Find boxplot and use the boxplot to determine the shape of the data Find mean, median, mode, standard deviation, C.V, five summary measures b) For each of the qualitative variables (Position and Experience) Find frequency table with relative frequencies, and use it to describe the descript the percentage of the categories of each variable Find bar chart 2. Is the mean annual salary for salespersons different from 20000 AED? Use a 0.05 level of significance, test the hypotheses using both p value 3. Is there any significant difference of the mean salary due to position? Use a 0.05 level of significance Hint: Find the mean salary for the salespersons working inside Abu Dhabi town and the mean salary for the salespersons working outside Abu Dhabi town, and compare between them. 4. Is there any significant difference of the mean salary due to years of experience? Use a 0.05 level of significance. Hint: Find the mean salary for the salespersons with low experience, and meansalary for the salespersons with medium experience and mean salary for the salespersons with high experience, and compare between them. 5. Is the salesperson position depend on the salesperson experience? Use a 0.05 level of significance. 6. Write your conclusions.Observation Salary (AED) Position Experienc 173154 Inside Low 145863 Inside Low 166896 Inside Low 155844 Inside Low 160392 Inside Low 158499 Inside Low 167877 Inside Low 191397 Inside Low 162366 Inside Low 10 176442 Inside Low 11 177828 Inside Low 12 170970 Inside Low 13 169383 Inside Low 14 148266 Inside Low 15 173010 Inside Low 16 156216 Inside Low 17 153357 Inside Low 18 169056 Inside Low 19 164673 Inside Low 20 160392 Inside Low 21 211545 Outside Low 22 186849 Outside Low 23 191568 Outside Low 24 206574 Outside Low 25 190434 Outside Low 26 192864 Outside Low 27 214035 Outside Low 28 196638 Outside Low 29 198072 Outside Low 30 183384 Outside Low 31 182979 Outside Low 32 183897 Outside Low 33 205680 Outside Low 34 201711 Outside Low 35 186675 Outside Low 36 188643 Outside Low 37 185040 Outside Low 38 207426 Outside Low 39 181683 Inside Low 40 180777 Inside Low 41 193384 Inside Low 42 192979 Inside Low 43 193897 Inside Low44 215680 Outside Low 45 211711 Outside Low 46 196675 Outside Low 47 198643 Outside Low 48 195040 Outside Low 49 217426 Outside Low 50 191683 Outside Low 51 190777 Outside Low 52 148266 Inside Low 53 173010 Inside Low 54 156216 Inside Low 55 153357 Inside Low 56 169056 Inside Low 57 164673 Inside Low 58 160392 Inside Low 59 211545 Outside Low 60 186849 Outside Low 61 191568 Outside Low 62 206574 Outside Low 63 190434 Outside Low 64 192864 Outside Low 65 214035 Outside Low 66 196638 Outside Low 67 211711 Outside Low 68 207864 Inside Medium 69 221574 Inside Medium 70 175392 Inside Medium 71 211638 Inside Medium 72 206397 Inside Medium 73 181896 Inside Medium 74 177366 Inside Medium 75 238545 Inside Medium 76 213072 Inside Medium 77 170844 Inside Medium 78 196683 Outside Medium 79 222426 Outside Medium 80 168357 Outside Medium 81 195777 Outside Medium 82 198897 Outside Medium 83 220680 Outside Medium 84 192828 Outside Medium 85 197979 Outside Medium 86 171216 Outside Medium 87 163266 Outside Medium88 179673 Outside Medium 89 185970 Outside Medium 90 203643 Outside Medium 91 188010 Outside Medium 92 201675 Outside Medium 93 200040 Outside Medium 94 216711 Outside Medium 95 175392 Outside Medium 96 184383 Outside Medium 97 184056 Outside Medium 98 173266 Outside Medium 99 189673 Outside Medium 100 195970 Outside Medium 101 213643 Outside Medium 102 198010 Outside Medium 103 211675 Outside Medium 104 210040 Inside Medium 105 226711 Inside Medium 106 185392 Inside Medium 107 194383 Inside Medium 108 194056 Inside Medium 109 175392 Outside Medium 110 184383 Outside Medium 111 184056 Outside Medium 112 173266 Outside Medium 113 189673 Outside Medium 114 195970 Outside Medium 115 213643 Outside Medium 116 198010 Outside Medium 117 211675 Outside Medium 118 210040 Inside Medium 119 226711 Inside Medium 120 185392 Inside Medium 121 194383 Inside Medium 122 194056 Inside Medium 123 210040 Inside Medium 124 226711 Inside Medium 125 206598 Inside High 126 206247 Inside High 127 183081 Inside High 128 209304 Inside High 129 199704 Inside High 130 203159 Inside High 131 202098 Inside High132 196447 Inside High 133 204241 Inside High 134 203365 Inside High 135 218505 Outside High 136 218742 Outside High 137 234222 Outside High 138 236130 Outside High 139 232209 Outside High 140 236808 Outside High 141 223167 Outside High 142 232068 Outside High 143 233460 Outside High 144 233403 Outside High 145 198960 Outside High 146 231933 Outside High 147 230589 Outside High 148 227373 Outside High 149 225978 Outside High 150 205707 Outside High 151 223122 Outside High 152 232866 Outside High 153 202809 Outside High 154 267243 Outside High 155 243403 Outside High 156 208960 Outside High 157 241933 Outside High 158 240589 Outside High 159 237373 Outside High 160 235978 Outside High 161 215707 Inside High 162 233122 Inside High 163 242866 Inside High 164 212809 Inside High 165 277243 Inside High 166 183081 Inside High 167 209304 Inside High 168 199704 Inside High 169 203157 Inside High 170 202098 Inside High 171 196446 Inside High 172 204240 Inside High 173 203364 Inside High 174 218505 Outside High 175 218742 Outside High