Business Statistics Discussion and Assignment

Place all references and citations in and below the appropriate work. Do not place them on the same page. Times New Roman 12 and APA format

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

Assignment- Due Wednesday February 7, 2018

There are significant calculations to be made in doing this assignment. I have attached calculation worksheets to assist in which all of the necessary calculations and charts in those worksheets are done for you. Go through those calculations very carefully, making sure that you understand them completely.  Once you understand those calculations, you should be able to answer the questions without any major difficulty. IN ANSWERING THE QUESTIONS, IT IS ESSENTIAL THAT YOU INCLUDE APPROPRIATE NUMBERS FROM THE WORKSHEETS TO SUPPORT YOUR ANSWERS. 

**The data in the table below lists country code and the order to remittance (OTR) time for hardware / software installations for the last 76 installations (from first to last). OTR is the time it takes from an order being placed until the system is installed and payment is received (remittance). Because this company does business internationally, it also notes the country of installation using a country code. This code is listed in the first column. 

Table: Country Code and OTR Cycle Time for Software Systems Installation

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

Country Code

   

   Cycle Time       Country Code       Cycle Time 

1                                    20                          5                                    29

1                                    24                          6                                    40

1                                    46                          7                                    157

1                                    26                          8                                    19

14                                 38                          5                                    24

1                                    15                          1                                    81

1                                    15                          7                                    53

17                                 23                          7                                    26

1                                    31                          1                                    28

1                                    31                          1                                    34

6                                    64                          1                                    34

5                                    29                          7                                    50

5                                    44                          1                                    52

1                                    32                          1                                    19

1                                    15                          1                                    44

7                                    11                          14                                 150

7                                    14                          7                                    29

1                                    89                          17                                 23

17                                 41                          6                                    79

7                                    41                          17                                 13

1                                    36                          6                                    32

8                                    43                          7                                    61

17                                 21                          8                                    42

8                                    28                          8                                    46

7                                    18                          7                                    88

8                                    47                          14                                 24

6                                    26                          7                                    7

6                                    47                          1                                    33

5                                    9                             5                                    129

7                                    42                          17                                 41

5                                    5                             17                                 43

6                                    27                          14                                 42

6                                    27                          14                                 42

1                                    33                          7                                    53

7                                    44                          7                                    53

1                                    21                          7                                    48

1                                    22                          5                                    21

1                                    50                          1                                    19

Use the date in table above and answer the following questions in the space provided below: 

1. Does the OTR time appear to be stable?  Why or why not? 

2. If you were to use a control chart to evaluate stability, which chart would you use?  Why? 

3. What can you learn about the distribution of the installation process?  

4. Does it appear that the country has an impact on installation time? Why or why not?

Discussion 1 ½ Paragraphs of substance (no copying and pasting) 

Process Improvement and Problem-Solving Tools  

• Use the Internet to research articles on process improvement and problem-solving tools. Select one (1) business project that used one of the tools discussed in the textbook. Evaluate the level of the efficiency and effectiveness of the utilization of the tool within the project that you selected. Justify your response.   

Search the Internet for an article that supports your position and post the link in your thread for everyone to read.

Discussion 1 ½ Paragraphs of substance (no copying and pasting) 

Building Data Models 

• Per the textbook, in order to understand the causal relationship in business process, managers often ask “whys” to drill down the root cause of failures. Select one (1) project from your working or educational environment, and propose at least three (3) “why” questions that you would ask in order to identify the root cause of the problem. Justify your responses.  

Search the Internet for an article that supports your position and post the link in your thread for everyone to read.
Discussion 1 ½ Paragraphs of substance (no copying and pasting) 

Creating Statistical Experiments 

• Select one (1) project from your working or educational environment for which you would apply the DOE technique for the work process. Next, analyze the overall manner in which you would utilize DOE to manage and improve the work process of the project in question. Provide a rationale for your response.

   

2

>Analysis

Country Code

UCL LCL

1

.00

4.

1

.00

.

0.00

2 1

4

84.21 0.00

.

.

.

0.00

3 1

34.00 84.21 0.00 6

5

.01

0.00

4 1

34.00 84.21 0.00 7

.02

9.92

0.00

5 1 15

34.00 84.21 0.00 8

.34

6 1 15 0 34.00 84.21 0.00 14

0.00

7 1 31

34.00 84.21 0.00

.29

0.00

8 1 31 0 34.00 84.21 0.00

9 1

1 34.00 84.21 0.00

1 15 17 34.00 84.21 0.00

11 1

34.00 84.21 0.00

12 1

34.00 84.21 0.00

13 1 33 3 34.00 84.21 0.00
14 1 21 12 34.00 84.21 0.00
15 1 22 1 34.00 84.21 0.00
16 1 50

34.00 84.21 0.00

17 1

31 34.00 84.21 0.00

18 1 28 53 34.00 84.21 0.00
19 1 34 6 34.00 84.21 0.00
20 1 34 0 34.00 84.21 0.00
21 1

18 34.00 84.21 0.00

22 1 19 33 34.00 84.21 0.00

1 44 25 34.00 84.21 0.00

24 1 33 11 34.00 84.21 0.00
25 1 19 14 34.00 84.21 0.00
1 5 29

0.00

2 5 44 15 36.25 149.15 0.00
3 5 9 35 36.25 149.15 0.00
4 5 5 4 36.25 149.15 0.00
5 5 29 24 36.25 149.15 0.00
6 5 24 5 36.25 149.15 0.00
7 5

36.25 149.15 0.00

8 5 21

36.25 149.15 0.00

1 6

0.00

2 6 26

42.75 93.31 0.00

3 6

21 42.75 93.31 0.00

4 6

20 42.75 93.31 0.00

5 6 27 0 42.75 93.31 0.00
6 6

13 42.75 93.31 0.00

7 6

42.75 93.31 0.00

8 6 32 47 42.75 93.31 0.00
1 7 11 46.76

0.00

2 7 14 3 46.76 139.92 0.00
3 7

27 46.76 139.92 0.00

4 7 18 23 46.76 139.92 0.00
5 7 42 24 46.76 139.92 0.00
6 7 44 2 46.76 139.92 0.00
7 7

46.76 139.92 0.00

8 7 53

46.76 139.92 0.00

9 7 26 27 46.76 139.92 0.00
10 7 50 24 46.76 139.92 0.00
11 7 29 21 46.76 139.92 0.00
12 7

32 46.76 139.92 0.00

13 7 88 27 46.76 139.92 0.00
14 7 7 81 46.76 139.92 0.00
15 7 53 46 46.76 139.92 0.00
16 7 53 0 46.76 139.92 0.00
17 7

5 46.76 139.92 0.00

1 8

4.67

2 8 28 15 37.50 70.33 4.67
3 8 47 19 37.50 70.33 4.67
4 8 19 28 37.50 70.33 4.67
5 8 42 23 37.50 70.33 4.67
6 8 46 4 37.50 70.33 4.67
1 14 38 59.20 212.49 0.00
2 14

59.20 212.49 0.00

3 14 24

59.20 212.49 0.00

4 14 42 18 59.20 212.49 0.00
5 14 42 0 59.20 212.49 0.00
1 17 23

63.54 0.00

2 17 41 18 29.29 63.54 0.00
3 17 21 20 29.29 63.54 0.00
4 17 23 2 29.29 63.54 0.00
5 17 13 10 29.29 63.54 0.00
6 17 41 28 29.29 63.54 0.00
7 17 43 2 29.29 63.54 0.00
Counts Country Code Cycle Time Moving Range (MR) Avg. UCL LCL Average Cycle Time Avg. Moving Range
1 2

0 3 4 8 21 0.00 34 18 88 84.21
24 34.00 5 3

6 25 42 44 14 9 15
46 22 42.

7 19 93.

31
26 20 46.76 35 13
11 37.

50 12 70.

33 4.67
59.20 57.63 212.49
16 17 29 12.88 63.54
See Page 214: Chart: Individual and MR
32
10
89 74
36 53
28
81
52
23
36.25 149.15
129 105
108
64 42.75 93.31
38
47
27
40
79 39
139.92
41
157 113
104
61
48
43 37.50 70.33
150 112
126
29.29

Country Code #1

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 20 24 46 26 15 15 31 31 32 15 89 36 33 21 22 50 81 28 34 34 52 19 44 33 19 UCL 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 84.20750000000001 84.20750000000001 84.20750000000001 84.20750000000001 84.20750000000001 84.20750000000001 84.20750000000001 84.20750000000001 84.20750000000001 84.20750000000001 84.20750000000001 84.20750000000001 84.20750000000001 84.20750000000001 84.20750000000001 84.20750000000001 84.20750000000001 84.20750000000001 84.20750000000001 84.20750000000001 84.20750000000001 84.20750000000001 84.20750000000001 84.20750000000001 84.20750000000001 LCL 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Average 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34

Observation number

OTR (minutes)

Country Code #5

1 2 3 4 5 6 7 8 29 44 9 5 29 24 129 21 1 2 3 4 5 6 7 8 36.25 36.25 36.25 36.25 36.25 36.25 36.25 36.25 1 2 3 4 5 6 7 8 149.153493

30

290891 149.15349330290891 149.15349330290891 149.15349330290891 149.15349330290891 149.15349330290891 149.15349330290891 149.15349330290891 1 2 3 4 5 6 7 8 0 0 0 0 0 0 0 0

Observation numbers

OTR (minutes)

Country Code #6

1 2 3 4 5 6 7 8 64 26 47 27 27 40 79 32 1 2 3 4 5 6 7 8 42.75 42.75 42.75 42.75 42.75 42.75 42.75 42.75 1 2 3 4 5 6 7 8 93.306663919474218 93.306663919474218 93.306663919474218 93.306663919474218 93.306663919474218 93.306663919474218 93.306663919474218 93.306663919474218 1 2 3 4 5 6 7 8 0 0 0 0 0 0 0 0

Observation numer

OTR (minutes)

Country Code #7

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 11 14 41 18 42 44 157 53 26 50 29 61 88 7 53 53 48 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 46.764705882352942 46.764705882352942 46.764705882352942 46.764705882352942 46.764705882352942 46.764705882352942 46.764705882352942 46.764705882352942 46.764705882352942 46.764705882352942 46.76470588235294 2 46.764705882352942 46.764705882352942 46.764705882352942 46.764705882352942 46.764705882352942 46.764705882352942 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 139.91789069103248 139.91789069103248 139.91789069103248 139.91789069103248 139.91789069103248 139.91789069103248 139.91789069103248 139.91789069103248 139.91789069103248 139.91789069103248 139.91789069103248 139.91789069103248 139.91789069103248 139.91789069103248 139.91789069103248 139.91789069103248 139.91789069103248 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Observation number
OTR (minutes)

Country Code #8

1 2 3 4 5 6 43 28 47 19 42 46 1 2 3 4 5 6 37.5 37.5 37.5 37.5 37.5 37.5 1 2 3 4 5 6 70.327029716378547 70.327029716378547 70.327029716378547 70.327029716378547 70.327029716378547 70.327029716378547 1 2 3 4 5 6 4.6729702836214599 4.6729702836214599 4.6729702836214599 4.6729702836214599 4.6729702836214599 4.6729702836214599 Observation number
OTR (minutes)

Country Code #14

1 2 3 4 5 38 150 24 42 42 1 2 3 4 5 59.2 59.2 59.2 59.2 59.2 1 2 3 4 5 212.49079424414242 212.49079424414242 212.49079424414242 212.49079424414242 212.49079424414242 1 2 3 4 5 0 0 0 0 0 Observation number
OTR (minutes)

Country Code #17

1 2 3 4 5 6 7 23 41 21 23 13 41 43 1 2 3 4 5 6 7 29.285714285714285 29.285714285714285 29.285714285714285 29.285714285714285 29.285714285714285 29.285714285714285 29.285714285714285 1 2 3 4 5 6 7 63.543650397900997 63.543650397900997 63.543650397900997 63.543650397900997 63.543650397900997 63.543650397900997 63.543650397900997 1 2 3 4 5 6 7 0 0 0 0 0 0 0 Observation number
OTR (minutes)

Histogram

Counts Country Code Cycle Time

bin 1 1 20 0

2 1 24 20

Bin

Frequency

3 1 46 40 0 0
4 1 26

60

20 14
5 1 15

80

40 30
6 1 15

100

60 23
7 1 31

120

80 3
8 1 31

140

100 3
9 1 32

160

120 0
10 1 15 140 1
11 1 89 160 2
12 1 36

More

0
13 1 33
14 1 21
15 1 22
16 1 50
17 1 81
18 1 28
19 1 34
20 1 34
21 1 52
22 1 19
23 1 44
24 1 33
25 1 19
1 5 29
2 5 44
3 5 9
4 5 5
5 5 29
6 5 24
7 5 129
8 5 21
1 6 64
2 6 26
3 6 47
4 6 27
5 6 27
6 6 40
7 6 79
8 6 32
1 7 11
2 7 14
3 7 41
4 7 18
5 7 42
6 7 44
7 7 157
8 7 53
9 7 26
10 7 50
11 7 29
12 7 61
13 7 88
14 7 7
15 7 53
16 7 53
17 7 48
1 8 43
2 8 28
3 8 47
4 8 19
5 8 42
6 8 46
1 14 38
2 14 150
3 14 24
4 14 42
5 14 42
1 17 23
2 17 41
3 17 21
4 17 23
5 17 13
6 17 41
7 17 43

Histogram
Frequency 0 20 40 60 80 100 120 140 160 More 0 14 30 23 3 3 0 1 2 0 Bin
Frequency

Still stressed from student homework?
Get quality assistance from academic writers!

Order your essay today and save 25% with the discount code LAVENDER