please check the attached case study carefully

and answer allthe questions

Case-Study 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 in 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 provided. You should consider the following instructions when answering the case study question and preparing your report: I) For confidence intervals: Check all assumptions. Interpret the results. 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. For the report The report should have the following item # Title # Table of Contents # Executive Summary # Introduction # Main text # Conclusions # Recommendations II) III) Case Study Questions: answer ALL of the following questions to help the manager preparing his report. 1. Use descriptive statistics to summarize the data. Name: ID # 2. Construct a 95% confidence interval of the mean annual salary for all salespersons. 3. Construct a 95% confidence interval of the mean salary for inside salespersons. 4. Is there any significant difference of the mean salary due to position? Use a 0.05 level of significance 5. Construct a 95% confidence interval estimate of the mean salary difference for inside and outside salespersons. 6. Explain how your conclusion in part 4 can be derived from part 5. 7. Is there any significant difference of the mean salary due to years of experience? Use a 0.05 level of significance. 8. Give point estimates for the proportion of salespersons according to their positions. 9. Is there a difference between the proportions of inside salesperson between Low and High experience? Use a 0.05 level of significance. 10. Construct a 95% confidence interval of the difference in proportion of inside salespersons between Low and High experience. 11. Is the salesperson position dependent (related to) on the salesperson experience? Use a 0.05 level of significance. Note: Data provided Below: Use Excel to solve. Upload BOTH word File and Excel file Name: ID # DATA: Observatio n 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 Name: Salary (AED) 173154 145863 166896 155844 160392 158499 167877 191397 162366 176442 177828 170970 169383 148266 173010 156216 153357 169056 164673 160392 211545 186849 191568 206574 190434 192864 214035 196638 198072 183384 182979 183897 205680 201711 186675 188643 185040 Positio n Inside Inside Inside Inside Inside Inside Inside Inside Inside Inside Inside Inside Inside Inside Inside Inside Inside Inside Inside Inside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Experienc e Low Low Low Low Low Low Low Low Low Low Low Low Low Low Low Low Low Low Low Low Low Low Low Low Low Low Low Low Low Low Low Low Low Low Low Low Low ID # 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 Name: 207426 181683 180777 193384 192979 193897 215680 211711 196675 198643 195040 217426 191683 190777 148266 173010 156216 153357 169056 164673 160392 211545 186849 191568 206574 190434 192864 214035 196638 211711 207864 221574 175392 211638 206397 181896 177366 238545 213072 170844 196683 Outside Inside Inside Inside Inside Inside Outside Outside Outside Outside Outside Outside Outside Outside Inside Inside Inside Inside Inside Inside Inside Outside Outside Outside Outside Outside Outside Outside Outside Outside Inside Inside Inside Inside Inside Inside Inside Inside Inside Inside Outside Low Low Low Low Low Low Low Low Low Low Low Low Low Low Low Low Low Low Low Low Low Low Low Low Low Low Low Low Low Low Medium Medium Medium Medium Medium Medium Medium Medium Medium Medium Medium ID # 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 Name: 222426 168357 195777 198897 220680 192828 197979 171216 163266 179673 185970 203643 188010 201675 200040 216711 175392 184383 184056 173266 189673 195970 213643 198010 211675 210040 226711 185392 194383 194056 175392 184383 184056 173266 189673 195970 213643 198010 211675 210040 226711 Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Inside Inside Inside Inside Inside Outside Outside Outside Outside Outside Outside Outside Outside Outside Inside Inside Medium Medium Medium Medium Medium Medium Medium Medium Medium Medium Medium Medium Medium Medium Medium Medium Medium Medium Medium Medium Medium Medium Medium Medium Medium Medium Medium Medium Medium Medium Medium Medium Medium Medium Medium Medium Medium Medium Medium Medium Medium ID # 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 Name: 185392 194383 194056 210040 226711 206598 206247 183081 209304 199704 203159 202098 196447 204241 203365 218505 218742 234222 236130 232209 236808 223167 232068 233460 233403 198960 231933 230589 227373 225978 205707 223122 232866 202809 267243 243403 208960 241933 240589 237373 235978 Inside Inside Inside Inside Inside Inside Inside Inside Inside Inside Inside Inside Inside Inside Inside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Medium Medium Medium Medium Medium High High High High High High High High High High High High High High High High High High High High High High High High High High High High High High High High High High High High ID # 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 Name: 215707 233122 242866 212809 277243 183081 209304 199704 203157 202098 196446 204240 203364 218505 218742 234222 236130 232209 236808 223167 232068 233460 233403 198960 Inside Inside Inside Inside Inside Inside Inside Inside Inside Inside Inside Inside Inside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside Outside High High High High High High High High High High High High High High High High High High High High High High High High ID #