statistics questions

profilestrength
LSSGB_exl.xlsx

Q1.1 ProjectCharterTemplate

Project Name
Prepared by
Date
Problem Statement
Business Case
Goal(s) of the Project
Team Members
Project Scope
Milestones

Q1.8

Complaint Type Frequency
Solving Time 61
Information Provided 35
Received Treatment 50
Too Many Formalities 34
Timetable 65
Waiting Time 41
Personal Skill 18
Others 15
Forms Missing 42

Q1.9

Failure Mode Failure Effects Severity Potential Causes Occurrence Current Controls Detection RPN Actions Recommended
Too many staff nurses to give a report to None
Report is given based on staff nurse preference Potential to off-put off going/ ongoing nurse
Timing of charge nurse in report None
Doesn’t directly measure report time Don’t utilize the report
Relationship development versus actual report Potential to off-put off going nurse

Q1.11

Number of Received Complaints per Month Improved Nursing Shift Change Duration (minutes) Number of Arrival Patients per Week
57 28.3 347
29 29.9 303
27 27.6 306
55 27.9 331
52 28.7 342
33 26.7 328
21 28 331
42 30 323
50 28.9 331
21 27.3 337
4 29.9 341
18 28.9 330
53 26.6 310
21 27.7 307
53 30.3 310
49 26.8 317
23 29.6 329
38 29.6 350
48 30.5 345
42 30.9 326
54 28.5 315
7 28.3 311
41 28.4 305
30 29.3 311
27 28.8 345
2 27.8 321
26 29.8 327
22 29.9 340
12 28.7 314
45 27.9 345
14 28.3 302
24 31 315
6 30.6 301
34 26.8 332
9 30.9 307
60 27.7 329
46 29.5 333
55 27.9 304
41 28.6 309
7 31 322
51 27.8 334
14 30.4 343
48 28.3 336
29 26.6 322
17 30.8 302
37 28.7 300
14 27 332
39 26.6 300
4 27.2 346

Q1.13

Pre Shift Change Time Post Shift Change Time
45.1 34.2
41.8 25.4
43 32.9
45.7 30.2
45.4 34.8
41.5 34.3
43.7 29.2
42.8 25.1
33.2 32.8
42.4 29
44.2 31.3
40.4 34.2
46.1 32.7
43.7 25.2
47.1 31.6
45 26.2
43.5 26.4
40.1 32.4
41.6 27
44.4 34.7
39.7 31.7
45.6 33
40.4 34.7
43.4 33.8
40 28.7
35.2 34.5
46.3 25
43.3 32.3
40.2 29.1
46.2 34
43.2 26.6
41.2 28
41.4 26.8
43.4 28.5
40.4 30.4
39.5 30.6
41.3 28.6
41.2 34.4
36.7 34.7
44.9 30.6
45.4 28.4
32.6 34.9
40.3 29.5
46.4 32.1
45.8 26
40.1 32.2
40.8 31.8
47.1 31.9
45 26
47.1 34.9

Q2

Sample Operator 1 Operator 2
R1 R2 R1 R2
1 12.37 12.36 12.35 12.34
2 12.33 12.29 12.35 12.32
3 12.32 12.31 12.29 12.3
4 12.3 12.3 12.32 12.31
5 12.31 12.31 12.31 12.28
6 12.34 12.35 12.34 12.33
7 12.35 12.34 12.35 12.35
8 12.32 12.31 12.29 12.3
9 12.31 12.33 12.29 12.32
10 12.35 12.34 12.32 12.32

Gauge R&R Template

GAGE REPEATABILITY AND REPRODUCIBILITY DATA SHEET
No. of trials per item by each operator:
No. of operators used in study:
No. of parts:
item
Trial 1 1 2 3 4 5 6 7 8 9 10 Average
Operator: 1 1 ERROR:#DIV/0!
2 ERROR:#DIV/0!
3 ERROR:#DIV/0!
Average ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Range 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ERROR:#DIV/0!
Trial 2 item
Operator: 2 1 ERROR:#DIV/0!
2 ERROR:#DIV/0!
3 ERROR:#DIV/0!
Average ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Range 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ERROR:#DIV/0!
Trial 3 item
Operator: 3 1 ERROR:#DIV/0!
2 ERROR:#DIV/0!
3 ERROR:#DIV/0!
Average ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Range 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000
ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
ERROR:#DIV/0!
ERROR:#DIV/0!
ERROR:#DIV/0! XDiff
Repeatability: Trials K1
Equipment Variation(EV): ERROR:#DIV/0! %EV= 100*(EV/TV)= ERROR:#DIV/0! ERROR:#DIV/0! 2 0.8862
%AV=100*(AV/TV)= ERROR:#DIV/0! ERROR:#DIV/0! 3 0.5908
Reproducibility: %R&R=100*(R&R/TV)= ERROR:#VALUE! ERROR:#VALUE!
Appraiser Variation(AV): ERROR:#DIV/0! %PV=100*(PV/TV)= ERROR:#VALUE! ERROR:#VALUE!
Operators K2
R & R: 2 0.7071
R&R : ERR 3 0.5231
Part variation: Total variation: items K3
PV: TV: ERROR:#VALUE! 2 0.7071
3 0.5231
4 0.4467
5 0.403
6 0.3742
7 0.3534
8 0.3375
9 0.3249
10 0.3146

𝑷𝒂𝒓𝒕 𝑹𝒂𝒏𝒈𝒆 (𝑿𝒑)

(𝐑𝟏) ̅

(𝐑𝟐) ̅

(𝐗𝟏) ̅

(𝐗𝟐) ̅

(𝐑𝐩) ̅

𝐑 ̿

𝐗 ̿

(𝐑𝟑) ̅

(𝐗𝟑) ̅

Q4

Observations (Turnaround time in hours)
Day 1 2 3 4 5 6 7 8 9 10
1 11 12 21 18 35 16 18 22 11 23
2 13 19 20 18 16 6 21 5 15 5
3 8 1 16 8 16 23 12 5 7 22
4 7 9 19 9 11 10 21 17 19 6
5 1 14 9 18 18 22 20 8 11 16
6 13 4 17 5 6 22 17 5 18 26
7 15 15 9 6 21 23 16 7 3 9
8 17 3 5 13 23 3 11 22 15 5
9 5 2 12 17 8 14 21 21 20 19
10 17 19 7 8 22 17 7 14 14 21
11 20 20 18 23 15 11 23 8 15 33
12 10 6 23 22 3 6 17 19 12 9
13 1 23 24 7 8 3 20 11 22 1
14 12 25 23 13 16 8 21 13 12 4
15 7 17 4 13 2 17 4 4 15 6
16 4 14 20 5 1 10 21 14 21 13
17 3 11 13 14 6 11 15 23 23 20
18 20 1 13 11 10 19 19 21 21 16
19 19 3 5 12 22 9 15 2 22 7
20 13 11 5 17 21 20 18 11 17 8
21 14 23 8 12 18 8 19 9 30 6
22 12 22 11 17 20 3 2 1 23 3
23 11 12 21 18 35 16 18 22 11 23
24 7 1 11 20 8 28 20 15 11 14
25 13 30 12 2 3 6 9 6 7 17
26 13 6 8 16 11 23 21 2 13 21
27 2 12 19 14 15 22 7 11 8 15
28 14 14 10 16 15 19 20 12 4 15
29 9 12 4 18 17 1 3 15 13 6
30 14 1 9 9 4 23 11 15 16 5

Q5

Observation x1 x2 x3 x4 y
1 18.69 15.65 45.01 58.21 947
2 19.43 23.51 39.69 46.31 1407
3 19.24 24.23 43.16 46.63 1452
4 22.64 22.2 35.67 45.85 1553
5 16.54 23.56 41.2 55.14 989
6 21.44 23.65 35.56 54.24 1162
7 19.53 24.45 40.18 47.2 1466
8 23.97 19.39 44.11 43.82 1656
9 21.45 23.84 35.41 51.01 1254
10 20.34 26.5 34.21 49.06 1336
11 17.03 23.46 32.45 53.23 1097
12 21.03 26.99 38.19 51.78 1266
13 20.49 19.87 41.35 46.69 1401
14 20.45 23.03 43.59 53.57 1223
15 18.81 22.62 42.2 52.98 1216

Q6

Inspector Caliper 1 Caliper 2
1 0.473 0.518
2 0.512 0.552
3 0.518 0.545
4 0.492 0.521
5 0.484 0.511
6 0.512 0.492
7 0.513 0.558
8 0.536 0.545
9 0.481 0.5
10 0.533 0.575
11 0.536 0.554
12 0.538 0.515
13 0.539 0.577
14 0.523 0.55
15 0.535 0.566
16 0.513 0.562
17 0.553 0.505
18 0.544 0.527
19 0.585 0.479
20 0.527 0.484

Q8

Sample Number Low light with black background Higher light level with white background
1 25.85 18.23
2 28.84 20.84
3 32.05 22.96
4 25.74 19.68
5 20.89 19.5
6 41.05 24.98
7 25.01 16.61
8 24.96 16.07
9 27.47 24.59

Q9

Machine 1 Machine 2
16.03 16.02
16.04 15.97
16.05 15.96
16.05 16.01
16.02 15.99
16.01 16.03
15.96 16.04
15.98 16.02
16.02 16.01
15.99 16