statistics questions
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 |