Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Data for Individual Assignments for Week 3 From BIMS2 case, Exhibit D Case data

ID: 408059 • Letter: D

Question

Data for Individual Assignments for Week 3 From BIMS2 case, Exhibit D Case data is attached (Only the first 30 responses are included.) Each student has both qualitative and quantitative data streams to analyze.

Variables (Columns) Q1, A, B

Hint:           1. Treat division (column A) as nominal data.

                   2. Treat gender (column C) as nominal data.

                   3. Treat question answers (column Q1 - Q10) as ordinal.

                   4. Treat months worked (column B) as ratio data.

Week 3 Individual Assignment

Data Summary and Presentation Paper

Describe the data.

For each variable:

Is it qualitative or quantitative?

What is the level of measurement: nominal, ordinal, interval, or ratio?

What is the most appropriate measure of central tendency?

What is the most appropriate measure of dispersion?

What type of chart is most appropriate to represent your data?

Display the data using Excel and MegaStat:

Compute appropriate descriptive statistics for each variable.

Graph your data using the most appropriate presentation type.

Submit as Excel spreadsheet.

Put your name on the spreadsheet and submit as Assignment File.

Exhibit C

BIMS Exit Interview Survey

Using the scale provided, record your answer by circling the number that is closest to your view where 5 is a very positive response (you strongly agree with the statement) and 1 is a very negative choice (you do not agree at all with the statement).

Do Not Agree          Neutral       Strongly Agree

1.You are well trained for your work.

2.The company provided the needed training.

3.You were fairly paid for the work you did.

4.You were given as many hours that you desired.

5.Your supervisor treated you fairly.

6.Your manager treated your division fairly.

7.The company is good at communicating.

8.Your job was secure.

9.You liked working at this location.

10.Getting to and from work was easy.

11.What was the PRIMARY reason that led you to decide to quit? (Select only one.)

A.In which division did you work?

B.How long have you worked for BIMS?

C.What is your gender?

1 2 3 4 5

1 2 3 4 5

1 2 3 4 5

1 2 3 4 5

1 2 3 4 5

1 2 3 4 5

1 2 3 4 5

1 2 3 4 5

1 2 3 4 5

1 2 3 4 5

A.I do not like the work.

B.I do not like my supervisor.

C.I am not satisfied with the pay.

D.I am not satisfied with my shift.

E.Other: ____________________

Food: _ Housekeeping: _ Maintenance: _

Years: _____ Months: _____

Female: _____ Male: _____

Exhibit D

Survey B Data Set

No.    Q1     Q2     Q3     Q4     Q5     Q6     Q7     Q8     Q9     Q10   Q11   A       B       C

1       3       3       5       5       1       3       4       3       2       2       2       3       14      2

2       2       3       4       3       5       2       4       4       2       5       1       1       6       1

3       2       2       2       2       1       3       1       1       1       1       2       2       22      2

4       4       2       1       3       3       5       5       1       3       4       3       2       18      2

5       3       3       3       2       3       4       3       5       2       4       4       2       3       2

6       3       2       3       3       1       2       4       1       2       1       3       1       5       1

7       5       3       1       3       4       5       2       1       4       2       2       1       7       2

8       4       3       4       3       5       4       1       2       2       5       1       2       3       2

9       2       3       5       2       2       2       3       5       3       4       5       3       1       2

10      1       2       2       3       4       3       4       5       5       1       4       1       5       1

11      3       3       4       1       2       2       3       4       3       5       2       2       6       2

12      3       1       2       1       3       5       3       4       3       4       2       1       2       2

13      1       1       3       2       3       2       1       2       3       3       1       1       14      1

14      4       2       3       3       5       4       4       1       2       3       3       2       101    1

15      5       3       5       1       5       5       5       3       3       5       2       3       15      2

16      2       1       5       4       4       5       2       3       4       4       1       2       45      2

17      4       3       3       5       2       4       1       2       1       2       2       1       4       1

18      2       2       3       4       5       2       1       4       2       2       3       2       8       2

19      3       3       1       2       4       1       2       2       5       3       2       1       1       2

20      4       2       2       5       2       3       5       3       4       3       2       2       2       2

21      2       5       5       3       3       4       5       5       1       1       1       1       4       2

22      2       4       1       2       2       3       4       3       5       4       1       3       4       1

23      5       2       1       4       2       4       4       5       2       5       2       2       6       2

24      4       1       2       2       5       2       1       2       2       2       1       2       25      2

25      2       3       5       3       4       3       1       4       4       4       1       3       8       1

26      3       4       5       5       1       2       2       3       2       2       2       1       6       1

27      2       3       4       3       5       5       5       3       3       3       3       2       7       2

28      1       3       4       4       5       5       1       5       3       4       3       2       9       2

29      4       2       2       4       1       2       4       4       2       2       2       1       187    1

30      2       2       3       2       4       4       2       2       1       5       2       1       11      2

1.You are well trained for your work.

2.The company provided the needed training.

3.You were fairly paid for the work you did.

4.You were given as many hours that you desired.

5.Your supervisor treated you fairly.

6.Your manager treated your division fairly.

7.The company is good at communicating.

8.Your job was secure.

9.You liked working at this location.

10.Getting to and from work was easy.

11.What was the PRIMARY reason that led you to decide to quit? (Select only one.)

A.In which division did you work?

B.How long have you worked for BIMS?

C.What is your gender?

1 2 3 4 5

1 2 3 4 5

1 2 3 4 5

1 2 3 4 5

1 2 3 4 5

1 2 3 4 5

1 2 3 4 5

1 2 3 4 5

1 2 3 4 5

1 2 3 4 5

A.I do not like the work.

B.I do not like my supervisor.

C.I am not satisfied with the pay.

D.I am not satisfied with my shift.

E.Other: ____________________

Food: _ Housekeeping: _ Maintenance: _

Years: _____ Months: _____

Female: _____ Male: _____

Explanation / Answer

https://www.dropbox.com/s/a9dkbk3vtafpcz6/excel%20solution%203.xlsx?dl=0