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 there any significant difference of the mean salary due to position? Use a 0.05 level of significance?Give point estimates for the proportion of salespersons according to their positions.Is there a difference between the proportions of inside salesperson between Low and High experience? Use a 0.05 level of significance.Construct a 95% confidence interval of the difference in proportion of inside salespersons between Low and High experience.Is the salesperson position dependent (related to) on the salesperson experience? Use a 0.05 level of significance.ObservationSalary (AED)PositionExperience1173154InsideLow2145863InsideLow3166896InsideLow4155844InsideLow5160392InsideLow6158499InsideLow7167877InsideLow8191397InsideLow9162366InsideLow10176442InsideLow11177828InsideLow12170970InsideLow13169383InsideLow14148266InsideLow15173010InsideLow16156216InsideLow17153357InsideLow18169056InsideLow19164673InsideLow20160392InsideLow21211545OutsideLow22186849OutsideLow23191568OutsideLow24206574OutsideLow25190434OutsideLow26192864OutsideLow27214035OutsideLow28196638OutsideLow29198072OutsideLow30183384OutsideLow31182979OutsideLow32183897OutsideLow33205680OutsideLow34201711OutsideLow35186675OutsideLow36188643OutsideLow37185040OutsideLow38207426OutsideLow39181683InsideLow40180777InsideLow41193384InsideLow42192979InsideLow43193897InsideLow44215680OutsideLow45211711OutsideLow46196675OutsideLow47198643OutsideLow48195040OutsideLow49217426OutsideLow50191683OutsideLow51190777OutsideLow52207864InsideMedium53221574InsideMedium54175392InsideMedium55211638InsideMedium56206397InsideMedium57181896InsideMedium58177366InsideMedium59238545InsideMedium60213072InsideMedium61170844InsideMedium62196683OutsideMedium63222426OutsideMedium64168357OutsideMedium65195777OutsideMedium66198897OutsideMedium67220680OutsideMedium68192828OutsideMedium69197979OutsideMedium70171216OutsideMedium71163266OutsideMedium72179673OutsideMedium73185970OutsideMedium74203643OutsideMedium75188010OutsideMedium76201675OutsideMedium77200040OutsideMedium78216711OutsideMedium79175392OutsideMedium80184383OutsideMedium81184056OutsideMedium82173266OutsideMedium83189673OutsideMedium84195970OutsideMedium85213643OutsideMedium86198010OutsideMedium87211675OutsideMedium88210040InsideMedium89226711InsideMedium90185392InsideMedium91194383InsideMedium92194056InsideMedium93206598InsideHigh94206247InsideHigh95183081InsideHigh96209304InsideHigh97199704InsideHigh98203157InsideHigh99202098InsideHigh100196446InsideHigh101204240InsideHigh102203364InsideHigh103218505OutsideHigh104218742OutsideHigh105234222OutsideHigh106236130OutsideHigh107232209OutsideHigh108236808OutsideHigh109223167OutsideHigh110232068OutsideHigh111233460OutsideHigh112233403OutsideHigh113198960OutsideHigh114231933OutsideHigh115230589OutsideHigh116227373OutsideHigh117225978OutsideHigh118205707OutsideHigh119223122OutsideHigh120232866OutsideHigh121202809OutsideHigh122267243OutsideHigh123243403OutsideHigh124208960OutsideHigh125241933OutsideHigh126240589OutsideHigh127237373OutsideHigh128235978OutsideHigh129215707InsideHigh130233122InsideHigh131242866InsideHigh132212809InsideHigh133277243InsideHigh

Question

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 there any significant difference of the mean salary due to position? Use a 0.05 level of significance?Give point estimates for the proportion of salespersons according to their positions.Is there a difference between the proportions of inside salesperson between Low and High experience? Use a 0.05 level of significance.Construct a 95% confidence interval of the difference in proportion of inside salespersons between Low and High experience.Is the salesperson position dependent (related to) on the salesperson experience? Use a 0.05 level of significance.ObservationSalary (AED)PositionExperience1173154InsideLow2145863InsideLow3166896InsideLow4155844InsideLow5160392InsideLow6158499InsideLow7167877InsideLow8191397InsideLow9162366InsideLow10176442InsideLow11177828InsideLow12170970InsideLow13169383InsideLow14148266InsideLow15173010InsideLow16156216InsideLow17153357InsideLow18169056InsideLow19164673InsideLow20160392InsideLow21211545OutsideLow22186849OutsideLow23191568OutsideLow24206574OutsideLow25190434OutsideLow26192864OutsideLow27214035OutsideLow28196638OutsideLow29198072OutsideLow30183384OutsideLow31182979OutsideLow32183897OutsideLow33205680OutsideLow34201711OutsideLow35186675OutsideLow36188643OutsideLow37185040OutsideLow38207426OutsideLow39181683InsideLow40180777InsideLow41193384InsideLow42192979InsideLow43193897InsideLow44215680OutsideLow45211711OutsideLow46196675OutsideLow47198643OutsideLow48195040OutsideLow49217426OutsideLow50191683OutsideLow51190777OutsideLow52207864InsideMedium53221574InsideMedium54175392InsideMedium55211638InsideMedium56206397InsideMedium57181896InsideMedium58177366InsideMedium59238545InsideMedium60213072InsideMedium61170844InsideMedium62196683OutsideMedium63222426OutsideMedium64168357OutsideMedium65195777OutsideMedium66198897OutsideMedium67220680OutsideMedium68192828OutsideMedium69197979OutsideMedium70171216OutsideMedium71163266OutsideMedium72179673OutsideMedium73185970OutsideMedium74203643OutsideMedium75188010OutsideMedium76201675OutsideMedium77200040OutsideMedium78216711OutsideMedium79175392OutsideMedium80184383OutsideMedium81184056OutsideMedium82173266OutsideMedium83189673OutsideMedium84195970OutsideMedium85213643OutsideMedium86198010OutsideMedium87211675OutsideMedium88210040InsideMedium89226711InsideMedium90185392InsideMedium91194383InsideMedium92194056InsideMedium93206598InsideHigh94206247InsideHigh95183081InsideHigh96209304InsideHigh97199704InsideHigh98203157InsideHigh99202098InsideHigh100196446InsideHigh101204240InsideHigh102203364InsideHigh103218505OutsideHigh104218742OutsideHigh105234222OutsideHigh106236130OutsideHigh107232209OutsideHigh108236808OutsideHigh109223167OutsideHigh110232068OutsideHigh111233460OutsideHigh112233403OutsideHigh113198960OutsideHigh114231933OutsideHigh115230589OutsideHigh116227373OutsideHigh117225978OutsideHigh118205707OutsideHigh119223122OutsideHigh120232866OutsideHigh121202809OutsideHigh122267243OutsideHigh123243403OutsideHigh124208960OutsideHigh125241933OutsideHigh126240589OutsideHigh127237373OutsideHigh128235978OutsideHigh129215707InsideHigh130233122InsideHigh131242866InsideHigh132212809InsideHigh133277243InsideHigh

Accepted Answer

Hello. Since your question has multiple sub-parts, we will solve first three sub-parts for you. If…

Observation	Salary (AED)	Position	Experience
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	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	Low
44	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	207864	Inside	Medium
53	221574	Inside	Medium
54	175392	Inside	Medium
55	211638	Inside	Medium
56	206397	Inside	Medium
57	181896	Inside	Medium
58	177366	Inside	Medium
59	238545	Inside	Medium
60	213072	Inside	Medium
61	170844	Inside	Medium
62	196683	Outside	Medium
63	222426	Outside	Medium
64	168357	Outside	Medium
65	195777	Outside	Medium
66	198897	Outside	Medium
67	220680	Outside	Medium
68	192828	Outside	Medium
69	197979	Outside	Medium
70	171216	Outside	Medium
71	163266	Outside	Medium
72	179673	Outside	Medium
73	185970	Outside	Medium
74	203643	Outside	Medium
75	188010	Outside	Medium
76	201675	Outside	Medium
77	200040	Outside	Medium
78	216711	Outside	Medium
79	175392	Outside	Medium
80	184383	Outside	Medium
81	184056	Outside	Medium
82	173266	Outside	Medium
83	189673	Outside	Medium
84	195970	Outside	Medium
85	213643	Outside	Medium
86	198010	Outside	Medium
87	211675	Outside	Medium
88	210040	Inside	Medium
89	226711	Inside	Medium
90	185392	Inside	Medium
91	194383	Inside	Medium
92	194056	Inside	Medium
93	206598	Inside	High
94	206247	Inside	High
95	183081	Inside	High
96	209304	Inside	High
97	199704	Inside	High
98	203157	Inside	High
99	202098	Inside	High
100	196446	Inside	High
101	204240	Inside	High
102	203364	Inside	High
103	218505	Outside	High
104	218742	Outside	High
105	234222	Outside	High
106	236130	Outside	High
107	232209	Outside	High
108	236808	Outside	High
109	223167	Outside	High
110	232068	Outside	High
111	233460	Outside	High
112	233403	Outside	High
113	198960	Outside	High
114	231933	Outside	High
115	230589	Outside	High
116	227373	Outside	High
117	225978	Outside	High
118	205707	Outside	High
119	223122	Outside	High
120	232866	Outside	High
121	202809	Outside	High
122	267243	Outside	High
123	243403	Outside	High
124	208960	Outside	High
125	241933	Outside	High
126	240589	Outside	High
127	237373	Outside	High
128	235978	Outside	High
129	215707	Inside	High
130	233122	Inside	High
131	242866	Inside	High
132	212809	Inside	High
133	277243	Inside	High