View the step-by-step solution to:

Observation Salary (AED) Position Experience 1 161814 Inside Medium 2 158082 Inside Medium 3 211545 Outside Low 4 156093 Inside Medium 5 186849

A local chapter of sales professionals in Abu Dhabi conducted a survey of its membership 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 118 observations, is stored in the Excel file SalesSalary.xlsx (please download the excel file).
You should consider the following instructions when answering the case study questions and preparing your report:
I) 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
# 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 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 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 and outside salesman? Use a 0.05 level of significance.
10. Construct a 95% confidence interval of the difference between the proportions for inside and outside salespersons.
11. Test the significance of the relation between salesperson position and experience.
Observation Salary (AED) Position Experience 1 161814 Inside Medium 2 158082 Inside Medium 3 211545 Outside Low 4 156093 Inside Medium 5 186849 Outside Low 6 173154 Inside Low 7 237243 Outside High 8 145863 Inside Low 9 218505 Outside High 10 164304 Inside Medium 11 156846 Inside Medium 12 166896 Inside Low 13 191568 Outside Low 14 155481Inside Medium 15 155844 Inside Low 16 169764 Inside Medium 17 206574 Outside Low 18 190434 Outside Low 19 251538 Outside Medium 20 177759 Inside High 21 160392 Inside Low 22 249528 Outside Medium 23 182847 Inside High 24 158499 Inside Low 25 218742 Outside High 26 249120Outside Medium 27 192864 Outside Low 28 193686 Inside High 29 157932 Inside High 30 167877 Inside Low 31 266190Outside Medium 32 233049 Outside Medium 33 169017 Inside High 34 214035 Outside Low 35 191397 Inside Low 36 234222 Outside High 37 196638 Outside Low 38 177171Inside Medium 39 198072 Outside Low 40 178371Inside High 41 238149 Outside Medium 42 183384 Outside Low 43 162366 Inside Low 44 236130Outside High 45 176442 Inside Low 46 177828 Inside Low 47 227607 Outside Medium 48 172647 Inside Medium 49 230286 Outside Medium 50 182979 Outside Low 51 190086 Inside Medium 52 159693 Inside High 53 186345 Inside High 54 168240Inside Medium 55 160176 Inside Medium 56 183897 Outside Low 57 161682 Inside High 58 248382 Outside Medium 59 170970Inside Low 60 232209 Outside High 61 236808 Outside High 62 162846 Inside Medium 63 236550Outside Medium 64 163776 Inside High 65 169383 Inside Low 66 223167 Outside High 67 148266 Inside Low 68 260076 Outside Medium 69 232068 Outside High 70 174165 Inside Medium 71 233460Outside High 72 233403 Outside High 73 174159 Inside Medium 74 234507 Outside Medium 75 205680Outside Low 76 198960Outside High 77 201711Outside Low 78 186675 Outside Low 79 176598 Inside High 80 231933 Outside High 81 230589 Outside High 82 245250Outside Medium 83 176247 Inside High 84 157914 Inside Medium 85 188025 Inside Medium 86 153081Inside High 87 188643 Outside Low 88 227373 Outside High 89 185040Outside Low 90 179304 Inside High 91 169704 Inside High 92 247866 Outside Medium 93 225978 Outside High 94 173157 Inside High 95 172098 Inside High 96 173010Inside Low 97 156216 Inside Low 98 205707 Outside High 99 244578 Outside Medium 100 246177 Outside Medium 101 223122 Outside High 102 153357 Inside Low 103 242088 Outside Medium 104 169056 Inside Low 105 232866 Outside High 106 207426 Outside Low 107 202809 Outside High 108 181683 Outside Low 109 153738 Inside Medium 110 164673 Inside Low 111 261270Outside Medium 112 166446 Inside High 113 160392 Inside Low 114 175704 Inside Medium 115 174240Inside High 116 236106 Outside Medium 117 249393 Outside Medium 118 173364 Inside High

Observation Salary (AED) Position Experience
1
161814 Inside
Medium
2
158082 Inside
Medium
3
211545 Outside Low
4
156093 Inside
Medium
5
186849 Outside Low
6
173154 Inside
Low
7
237243 Outside...

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
• -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents