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 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 133 observations, is stored in the Excel file Case_study_Sp21_1.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. 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. III) For the report Should be typed. . On the first page, write the names, student numbers, and section number. All pages must be stapled together. Show all of your work The report should have the following item # Title # Table of Contents # Executive Summary # Introduction # Main text # Conclusions # Recommendations Case Study Questions: answer ALL of the following questions to help the manager preparing his report. 1. Use descriptive statistics to summarize the data. 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. Low 16 Observation Salary (AED) PositionExperience 1 173154 Inside Low 2 145863 Inside Low 3 166896 Inside Low 4 155844 Inside Low 5 160392 Inside Low 6 158499 Inside Low 7 167877 Inside Low 8 191397 Inside Low 9 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 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 31 182979 Outside Low 32 183897 Outside Low 33 205680 Outside Low Low 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 61 62 63 64 65 66 67 68 183897 205680 201711 186675 188643 185040 207426 181683 180777 193384 192979 193897 215680 211711 196675 198643 195040 217426 191683 190777 207864 221574 175392 211638 206397 181896 177366 238545 213072 170844 196683 222426 168357 195777 198897 220680 192828 Outside Low Outside Low Outside Low Outside Low Outside Low Outside Low Outside Low Inside Low Inside Low Inside Low Inside Low Inside Low Outside Low Outside Low Outside Low Outside Low Outside Low Outside Low Outside Low Outside Low Inside Medium Inside Medium Inside Medium Inside Medium Inside Medium Inside Medium Inside Medium Inside Medium Inside Medium Inside Medium Outside Medium Outside Medium Outside Medium Outside Medium Outside Medium Outside Medium Outside Medium 67 68 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 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 206598 206247 183081 209304 199704 203157 202098 196446 204240 203364 218505 Outside Medium Outside Medium Outside Medium Outside Medium Outside Medium Outside Medium Outside Medium Outside Medium Outside Medium Outside Medium Outside Medium Outside Medium Outside Medium Outside Medium Outside Medium Outside Medium Outside Medium Outside Medium Outside Medium Outside Medium Outside Medium Inside Medium Inside Medium Inside Medium Inside Medium Inside Medium Inside High Inside High Inside High Inside High Inside High Inside High Inside High Inside High Inside High Inside High Outside High 101 102 103 102 103 104 105 106 107 108 109 110 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 203364 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 215707 233122 242866 212809 277243 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 Inside Inside Inside Inside Inside 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