Minitap
Suhailz
statreview-minitabassignment.docxStat Review-MINITAB Assignment
Enter the Data set (see next page: 50 samples of employee of two offices in Dubai & Abu Dhabi) into MINITAB stat software, run the required analysis, and answer the following questions:
1- What type of sampling technique was used to collect the data?
2- What is the type of Gender data? Present the Gender of Abu Dhabi office employee graphically?
3- What is the type of Age data? Present the Age of Abu Dhabi office employee graphically?
4- If we randomly select an employee from Abu Dhabi office:
a. What is the probability that we will select a male employee?
b. What is the probability that his/her age is above 40 years?
5- Use MINITAB to generate descriptive statistics of “years of Experience” for employee in both Abu Dhabi & Dubai offices.
a. Which office has more years of experience?
b. Which office has more variability in “years of Experience”?
c. Develop a 95% confidence interval for “years of Experience” in both office.
d. What is the shape of distribution for “years of Experience” in Dubai office?
6- For Abu Dhabi office, run a regression analysis for Age & Years of Experience (graph & formula).
a. What kind of correlation exists between the Age and the Years of Experience?
Due date: Saturday November, 5 (Submit to BB).
|
Number |
Gender (Abu Dhabi Office) |
Age (Abu Dhabi Office) |
Years of Experience (Abu Dhabi Office) |
Years of Experience (for another 50 employee in Dubai Office) |
|
1 |
Male |
36 |
10 |
6 |
|
2 |
Female |
25 |
4 |
12 |
|
3 |
Male |
26 |
5 |
6 |
|
4 |
Male |
31 |
7 |
6 |
|
5 |
Male |
37 |
13 |
12 |
|
6 |
Female |
26 |
5 |
24 |
|
7 |
Female |
29 |
9 |
12 |
|
8 |
Male |
36 |
8 |
12 |
|
9 |
Male |
30 |
9 |
12 |
|
10 |
Male |
37 |
14 |
12 |
|
11 |
Female |
25 |
2 |
24 |
|
12 |
Female |
28 |
5 |
24 |
|
13 |
Male |
30 |
9 |
12 |
|
14 |
Female |
21 |
2 |
12 |
|
15 |
Male |
33 |
10 |
12 |
|
16 |
Male |
35 |
9 |
12 |
|
17 |
Female |
32 |
9 |
12 |
|
18 |
Male |
32 |
7 |
6 |
|
19 |
Male |
27 |
3 |
12 |
|
20 |
Female |
22 |
3 |
12 |
|
21 |
Female |
29 |
6 |
12 |
|
22 |
Male |
28 |
4 |
12 |
|
23 |
Male |
28 |
9 |
12 |
|
24 |
Male |
26 |
3 |
6 |
|
25 |
Female |
30 |
9 |
12 |
|
26 |
Female |
26 |
5 |
12 |
|
27 |
Male |
28 |
8 |
6 |
|
28 |
Male |
27 |
4 |
6 |
|
29 |
Female |
26 |
3 |
12 |
|
30 |
Male |
38 |
10 |
6 |
|
31 |
Male |
29 |
5 |
6 |
|
32 |
Male |
30 |
3 |
12 |
|
33 |
Male |
30 |
4 |
12 |
|
34 |
Male |
26 |
5 |
12 |
|
35 |
Male |
27 |
8 |
12 |
|
36 |
Male |
28 |
9 |
12 |
|
37 |
Male |
26 |
3 |
12 |
|
38 |
Male |
26 |
5 |
12 |
|
39 |
Male |
28 |
5 |
12 |
|
40 |
Female |
30 |
5 |
12 |
|
41 |
Male |
31 |
7 |
6 |
|
42 |
Male |
34 |
4 |
6 |
|
43 |
Female |
31 |
9 |
12 |
|
44 |
Male |
22 |
3 |
6 |
|
45 |
Male |
33 |
8 |
12 |
|
46 |
Female |
23 |
2 |
12 |
|
47 |
Male |
25 |
1 |
6 |
|
48 |
Male |
23 |
1 |
12 |
|
49 |
Male |
39 |
14 |
12 |
|
50 |
Male |
30 |
9 |
12 |
