Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Paste in excel doucement Make a Control Chart of Percentage of employees out due to work injury. This should include the three months prior to

Paste in excel doucement

Make a Control Chart of Percentage of employees out due to work injury. This should include the three months prior to the changes (Oct-Dec) and the two months after the changes (Jan-Feb).

Date Month Employees that worked Employees out due to work injury Percent
2-Jan Jan 507 5 1%
3-Jan Jan 480 1 0%
4-Jan Jan 505 7 1%
5-Jan Jan 495 15 3%
8-Jan Jan 490 14 3%
9-Jan Jan 523 9 2%
10-Jan Jan 499 9 2%
11-Jan Jan 530 0 0%
12-Jan Jan 519 8 2%
15-Jan Jan 499 10 2%
16-Jan Jan 521 17 3%
17-Jan Jan 495 13 3%
18-Jan Jan 489 20 4%
19-Jan Jan 510 9 2%
22-Jan Jan 507 9 2%
23-Jan Jan 512 7 1%
24-Jan Jan 502 2 0%
25-Jan Jan 504 8 2%
26-Jan Jan 489 2 0%
29-Jan Jan 511 14 3%
30-Jan Jan 485 4 1%
31-Jan Jan 498 8 2%
1-Feb Feb 497 6 1%
2-Feb Feb 525 2 0%
5-Feb Feb 520 6 1%
6-Feb Feb 487 13 3%
7-Feb Feb 484 15 3%
8-Feb Feb 523 20 4%
9-Feb Feb 490 3 1%
12-Feb Feb 525 9 2%
13-Feb Feb 506 7 1%
14-Feb Feb 491 14 3%
15-Feb Feb 493 19 4%
16-Feb Feb 524 12 2%
19-Feb Feb 489 19 4%
20-Feb Feb 506 0 0%
21-Feb Feb 513 11 2%
22-Feb Feb 481 20 4%
23-Feb Feb 483 14 3%
26-Feb Feb 497 2 0%
27-Feb Feb 512 10 2%
28-Feb Feb 501 15 3%
1-Mar Mar 520 17 3%
2-Mar Mar 521 3 1%
5-Mar Mar 522 0 0%
6-Mar Mar 494 11 2%
7-Mar Mar 488 9 2%
8-Mar Mar 481 14 3%
9-Mar Mar 502 14 3%
12-Mar Mar 521 8 2%
13-Mar Mar 504 18 4%
14-Mar Mar 494 14 3%
15-Mar Mar 491 5 1%
16-Mar Mar 498 14 3%
19-Mar Mar 520 8 2%
20-Mar Mar 513 9 2%
21-Mar Mar 510 18 4%
22-Mar Mar 528 4 1%
23-Mar Mar 520 11 2%
26-Mar Mar 489 8 2%
27-Mar Mar 508 16 3%
28-Mar Mar 488 16 3%
29-Mar Mar 497 0 0%
30-Mar Mar 494 7 1%
2-Apr Apr 499 15 3%
3-Apr Apr 493 7 1%
4-Apr Apr 529 14 3%
5-Apr Apr 508 15 3%
6-Apr Apr 517 3 1%
9-Apr Apr 512 1 0%
10-Apr Apr 515 15 3%
11-Apr Apr 514 18 4%
12-Apr Apr 505 17 3%
13-Apr Apr 480 13 3%
16-Apr Apr 505 20 4%
17-Apr Apr 488 20 4%
18-Apr Apr 495 12 2%
19-Apr Apr 523 18 3%
20-Apr Apr 510 9 2%
23-Apr Apr 502 16 3%
24-Apr Apr 514 13 3%
25-Apr Apr 526 9 2%
26-Apr Apr 495 17 3%
27-Apr Apr 510 18 4%
30-Apr Apr 522 15 3%
1-May May 503 19 4%
2-May May 501 14 3%
3-May May 508 7 1%
4-May May 524 11 2%
7-May May 507 18 4%
8-May May 526 6 1%
9-May May 503 16 3%
10-May May 522 8 2%
11-May May 481 16 3%
14-May May 498 20 4%
15-May May 530 11 2%
16-May May 511 13 3%
17-May May 513 8 2%
18-May May 511 10 2%
21-May May 482 1 0%
22-May May 499 2 0%
23-May May 486 7 1%
24-May May 502 11 2%
25-May May 524 0 0%
28-May May 498 19 4%
29-May May 529 10 2%
30-May May 516 8 2%
31-May May 511 19 4%
1-Jun Jun 527 15 3%
4-Jun Jun 439 12 3%
5-Jun Jun 438 11 3%
6-Jun Jun 447 19 4%
7-Jun Jun 440 16 4%
8-Jun Jun 471 8 2%
11-Jun Jun 477 11 2%
12-Jun Jun 439 3 1%
13-Jun Jun 436 14 3%
14-Jun Jun 449 10 2%
15-Jun Jun 450 7 2%
18-Jun Jun 452 13 3%
19-Jun Jun 448 10 2%
20-Jun Jun 465 18 4%
21-Jun Jun 471 13 3%
22-Jun Jun 445 14 3%
25-Jun Jun 441 14 3%
26-Jun Jun 444 3 1%
27-Jun Jun 432 17 4%
28-Jun Jun 435 13 3%
29-Jun Jun 475 3 1%
2-Jul Jul 433 21 5%
3-Jul Jul 440 12 3%
5-Jul Jul 450 10 2%
6-Jul Jul 455 11 2%
9-Jul Jul 465 10 2%
10-Jul Jul 456 6 1%
11-Jul Jul 455 15 3%
12-Jul Jul 477 11 2%
13-Jul Jul 464 11 2%
16-Jul Jul 455 8 2%
17-Jul Jul 464 10 2%
18-Jul Jul 438 21 5%
19-Jul Jul 434 20 5%
20-Jul Jul 446 12 3%
23-Jul Jul 455 12 3%
24-Jul Jul 469 19 4%
25-Jul Jul 442 10 2%
26-Jul Jul 455 17 4%
27-Jul Jul 470 14 3%
30-Jul Jul 476 8 2%
31-Jul Jul 451 7 2%
1-Aug Aug 437 5 1%
2-Aug Aug 464 2 0%
3-Aug Aug 447 19 4%
6-Aug Aug 442 12 3%
7-Aug Aug 473 7 1%
8-Aug Aug 469 22 5%
9-Aug Aug 476 4 1%
10-Aug Aug 476 21 4%
13-Aug Aug 445 19 4%
14-Aug Aug 446 22 5%
15-Aug Aug 432 16 4%
16-Aug Aug 455 22 5%
17-Aug Aug 475 5 1%
20-Aug Aug 455 9 2%
21-Aug Aug 468 20 4%
22-Aug Aug 456 6 1%
23-Aug Aug 461 2 0%
24-Aug Aug 448 10 2%
27-Aug Aug 441 14 3%
28-Aug Aug 461 13 3%
29-Aug Aug 441 20 5%
30-Aug Aug 437 14 3%
31-Aug Aug 446 18 4%
3-Sep Sep 506 17 3%
4-Sep Sep 521 10 2%
5-Sep Sep 498 16 3%
6-Sep Sep 483 13 3%
7-Sep Sep 493 13 3%
10-Sep Sep 486 13 3%
11-Sep Sep 508 19 4%
12-Sep Sep 485 14 3%
13-Sep Sep 494 21 4%
14-Sep Sep 486 17 3%
17-Sep Sep 507 10 2%
18-Sep Sep 483 8 2%
19-Sep Sep 502 14 3%
20-Sep Sep 490 15 3%
21-Sep Sep 530 25 5%
24-Sep Sep 495 18 4%
25-Sep Sep 488 23 5%
26-Sep Sep 510 8 2%
27-Sep Sep 503 16 3%
28-Sep Sep 497 17 3%
1-Oct Oct 502 10 2%
2-Oct Oct 486 16 3%
3-Oct Oct 527 18 3%
4-Oct Oct 486 13 3%
5-Oct Oct 501 5 1%
8-Oct Oct 529 8 2%
9-Oct Oct 500 14 3%
10-Oct Oct 494 25 5%
11-Oct Oct 482 9 2%
12-Oct Oct 489 24 5%
15-Oct Oct 500 10 2%
16-Oct Oct 496 25 5%
17-Oct Oct 521 16 3%
18-Oct Oct 480 15 3%
19-Oct Oct 491 19 4%
22-Oct Oct 524 9 2%
23-Oct Oct 506 16 3%
24-Oct Oct 487 21 4%
25-Oct Oct 509 16 3%
26-Oct Oct 489 11 2%
29-Oct Oct 505 8 2%
30-Oct Oct 511 14 3%
31-Oct Oct 511 8 2%
1-Nov Nov 508 21 4%
2-Nov Nov 488 17 3%
5-Nov Nov 493 15 3%
6-Nov Nov 528 12 2%
7-Nov Nov 484 20 4%
8-Nov Nov 530 21 4%
9-Nov Nov 491 17 3%
12-Nov Nov 488 24 5%
13-Nov Nov 495 14 3%
14-Nov Nov 515 9 2%
15-Nov Nov 499 21 4%
16-Nov Nov 523 25 5%
19-Nov Nov 492 11 2%
20-Nov Nov 485 21 4%
21-Nov Nov 523 22 4%
23-Nov Nov 502 13 3%
26-Nov Nov 507 13 3%
27-Nov Nov 524 22 4%
28-Nov Nov 516 23 4%
29-Nov Nov 501 10 2%
30-Nov Nov 515 17 3%
3-Dec Dec 485 15 3%
4-Dec Dec 493 28 6%
5-Dec Dec 492 18 4%
6-Dec Dec 508 28 6%
7-Dec Dec 496 19 4%
10-Dec Dec 504 12 2%
11-Dec Dec 511 28 5%
12-Dec Dec 513 24 5%
13-Dec Dec 484 13 3%
14-Dec Dec 526 30 6%
17-Dec Dec 510 12 2%
18-Dec Dec 517 11 2%
19-Dec Dec 520 21 4%
20-Dec Dec 526 17 3%
21-Dec Dec 500 17 3%
24-Dec Dec 521 29 6%
25-Dec Dec 488 11 2%
26-Dec Dec 501 13 3%
27-Dec Dec 526 24 5%
28-Dec Dec 489 15 3%

Process changes were implemented on Jan 2nd

After process changes

Date Month Employees that worked Employees out due to work injury Percent
2-Jan Jan 517 4 1%
3-Jan Jan 477 1 0%
4-Jan Jan 511 8 2%
5-Jan Jan 499 6 1%
6-Jan Jan 474 8 2%
9-Jan Jan 511 4 1%
10-Jan Jan 519 1 0%
11-Jan Jan 519 9 2%
12-Jan Jan 530 4 1%
13-Jan Jan 486 1 0%
16-Jan Jan 522 4 1%
17-Jan Jan 513 9 2%
18-Jan Jan 474 0 0%
19-Jan Jan 517 1 0%
20-Jan Jan 515 0 0%
23-Jan Jan 494 6 1%
24-Jan Jan 516 6 1%
25-Jan Jan 488 2 0%
26-Jan Jan 493 0 0%
27-Jan Jan 527 2 0%
30-Jan Jan 483 5 1%
31-Jan Jan 504 2 0%
1-Feb Feb 501 4 1%
2-Feb Feb 510 3 1%
3-Feb Feb 528 3 1%
6-Feb Feb 504 2 0%
7-Feb Feb 475 4 1%
8-Feb Feb 508 3 1%
9-Feb Feb 509 4 1%
10-Feb Feb 539 3 1%
13-Feb Feb 520 3 1%
14-Feb Feb 487 5 1%
15-Feb Feb 493 3 1%
16-Feb Feb 504 0 0%
17-Feb Feb 499 1 0%
20-Feb Feb 495 0 0%
21-Feb Feb 493 4 1%
22-Feb Feb 486 1 0%
23-Feb Feb 485 0 0%
24-Feb Feb 481 4 1%
27-Feb Feb 496 4 1%
28-Feb Feb 494 0 0%

ake a Control Chart of Percentage of employees out due to work injury. This should include the three months prior to the changes (Oct-Dec) and the two months after the changes (Jan-Feb).

Date Month Employees that worked Employees out due to work injury Percent
2-Jan Jan 507 5 1%
3-Jan Jan 480 1 0%
4-Jan Jan 505 7 1%
5-Jan Jan 495 15 3%
8-Jan Jan 490 14 3%
9-Jan Jan 523 9 2%
10-Jan Jan 499 9 2%
11-Jan Jan 530 0 0%
12-Jan Jan 519 8 2%
15-Jan Jan 499 10 2%
16-Jan Jan 521 17 3%
17-Jan Jan 495 13 3%
18-Jan Jan 489 20 4%
19-Jan Jan 510 9 2%
22-Jan Jan 507 9 2%
23-Jan Jan 512 7 1%
24-Jan Jan 502 2 0%
25-Jan Jan 504 8 2%
26-Jan Jan 489 2 0%
29-Jan Jan 511 14 3%
30-Jan Jan 485 4 1%
31-Jan Jan 498 8 2%
1-Feb Feb 497 6 1%
2-Feb Feb 525 2 0%
5-Feb Feb 520 6 1%
6-Feb Feb 487 13 3%
7-Feb Feb 484 15 3%
8-Feb Feb 523 20 4%
9-Feb Feb 490 3 1%
12-Feb Feb 525 9 2%
13-Feb Feb 506 7 1%
14-Feb Feb 491 14 3%
15-Feb Feb 493 19 4%
16-Feb Feb 524 12 2%
19-Feb Feb 489 19 4%
20-Feb Feb 506 0 0%
21-Feb Feb 513 11 2%
22-Feb Feb 481 20 4%
23-Feb Feb 483 14 3%
26-Feb Feb 497 2 0%
27-Feb Feb 512 10 2%
28-Feb Feb 501 15 3%
1-Mar Mar 520 17 3%
2-Mar Mar 521 3 1%
5-Mar Mar 522 0 0%
6-Mar Mar 494 11 2%
7-Mar Mar 488 9 2%
8-Mar Mar 481 14 3%
9-Mar Mar 502 14 3%
12-Mar Mar 521 8 2%
13-Mar Mar 504 18 4%
14-Mar Mar 494 14 3%
15-Mar Mar 491 5 1%
16-Mar Mar 498 14 3%
19-Mar Mar 520 8 2%
20-Mar Mar 513 9 2%
21-Mar Mar 510 18 4%
22-Mar Mar 528 4 1%
23-Mar Mar 520 11 2%
26-Mar Mar 489 8 2%
27-Mar Mar 508 16 3%
28-Mar Mar 488 16 3%
29-Mar Mar 497 0 0%
30-Mar Mar 494 7 1%
2-Apr Apr 499 15 3%
3-Apr Apr 493 7 1%
4-Apr Apr 529 14 3%
5-Apr Apr 508 15 3%
6-Apr Apr 517 3 1%
9-Apr Apr 512 1 0%
10-Apr Apr 515 15 3%
11-Apr Apr 514 18 4%
12-Apr Apr 505 17 3%
13-Apr Apr 480 13 3%
16-Apr Apr 505 20 4%
17-Apr Apr 488 20 4%
18-Apr Apr 495 12 2%
19-Apr Apr 523 18 3%
20-Apr Apr 510 9 2%
23-Apr Apr 502 16 3%
24-Apr Apr 514 13 3%
25-Apr Apr 526 9 2%
26-Apr Apr 495 17 3%
27-Apr Apr 510 18 4%
30-Apr Apr 522 15 3%
1-May May 503 19 4%
2-May May 501 14 3%
3-May May 508 7 1%
4-May May 524 11 2%
7-May May 507 18 4%
8-May May 526 6 1%
9-May May 503 16 3%
10-May May 522 8 2%
11-May May 481 16 3%
14-May May 498 20 4%
15-May May 530 11 2%
16-May May 511 13 3%
17-May May 513 8 2%
18-May May 511 10 2%
21-May May 482 1 0%
22-May May 499 2 0%
23-May May 486 7 1%
24-May May 502 11 2%
25-May May 524 0 0%
28-May May 498 19 4%
29-May May 529 10 2%
30-May May 516 8 2%
31-May May 511 19 4%
1-Jun Jun 527 15 3%
4-Jun Jun 439 12 3%
5-Jun Jun 438 11 3%
6-Jun Jun 447 19 4%
7-Jun Jun 440 16 4%
8-Jun Jun 471 8 2%
11-Jun Jun 477 11 2%
12-Jun Jun 439 3 1%
13-Jun Jun 436 14 3%
14-Jun Jun 449 10 2%
15-Jun Jun 450 7 2%
18-Jun Jun 452 13 3%
19-Jun Jun 448 10 2%
20-Jun Jun 465 18 4%
21-Jun Jun 471 13 3%
22-Jun Jun 445 14 3%
25-Jun Jun 441 14 3%
26-Jun Jun 444 3 1%
27-Jun Jun 432 17 4%
28-Jun Jun 435 13 3%
29-Jun Jun 475 3 1%
2-Jul Jul 433 21 5%
3-Jul Jul 440 12 3%
5-Jul Jul 450 10 2%
6-Jul Jul 455 11 2%
9-Jul Jul 465 10 2%
10-Jul Jul 456 6 1%
11-Jul Jul 455 15 3%
12-Jul Jul 477 11 2%
13-Jul Jul 464 11 2%
16-Jul Jul 455 8 2%
17-Jul Jul 464 10 2%
18-Jul Jul 438 21 5%
19-Jul Jul 434 20 5%
20-Jul Jul 446 12 3%
23-Jul Jul 455 12 3%
24-Jul Jul 469 19 4%
25-Jul Jul 442 10 2%
26-Jul Jul 455 17 4%
27-Jul Jul 470 14 3%
30-Jul Jul 476 8 2%
31-Jul Jul 451 7 2%
1-Aug Aug 437 5 1%
2-Aug Aug 464 2 0%
3-Aug Aug 447 19 4%
6-Aug Aug 442 12 3%
7-Aug Aug 473 7 1%
8-Aug Aug 469 22 5%
9-Aug Aug 476 4 1%
10-Aug Aug 476 21 4%
13-Aug Aug 445 19 4%
14-Aug Aug 446 22 5%
15-Aug Aug 432 16 4%
16-Aug Aug 455 22 5%
17-Aug Aug 475 5 1%
20-Aug Aug 455 9 2%
21-Aug Aug 468 20 4%
22-Aug Aug 456 6 1%
23-Aug Aug 461 2 0%
24-Aug Aug 448 10 2%
27-Aug Aug 441 14 3%
28-Aug Aug 461 13 3%
29-Aug Aug 441 20 5%
30-Aug Aug 437 14 3%
31-Aug Aug 446 18 4%
3-Sep Sep 506 17 3%
4-Sep Sep 521 10 2%
5-Sep Sep 498 16 3%
6-Sep Sep 483 13 3%
7-Sep Sep 493 13 3%
10-Sep Sep 486 13 3%
11-Sep Sep 508 19 4%
12-Sep Sep 485 14 3%
13-Sep Sep 494 21 4%
14-Sep Sep 486 17 3%
17-Sep Sep 507 10 2%
18-Sep Sep 483 8 2%
19-Sep Sep 502 14 3%
20-Sep Sep 490 15 3%
21-Sep Sep 530 25 5%
24-Sep Sep 495 18 4%
25-Sep Sep 488 23 5%
26-Sep Sep 510 8 2%
27-Sep Sep 503 16 3%
28-Sep Sep 497 17 3%
1-Oct Oct 502 10 2%
2-Oct Oct 486 16 3%
3-Oct Oct 527 18 3%
4-Oct Oct 486 13 3%
5-Oct Oct 501 5 1%
8-Oct Oct 529 8 2%
9-Oct Oct 500 14 3%
10-Oct Oct 494 25 5%
11-Oct Oct 482 9 2%
12-Oct Oct 489 24 5%
15-Oct Oct 500 10 2%
16-Oct Oct 496 25 5%
17-Oct Oct 521 16 3%
18-Oct Oct 480 15 3%
19-Oct Oct 491 19 4%
22-Oct Oct 524 9 2%
23-Oct Oct 506 16 3%
24-Oct Oct 487 21 4%
25-Oct Oct 509 16 3%
26-Oct Oct 489 11 2%
29-Oct Oct 505 8 2%
30-Oct Oct 511 14 3%
31-Oct Oct 511 8 2%
1-Nov Nov 508 21 4%
2-Nov Nov 488 17 3%
5-Nov Nov 493 15 3%
6-Nov Nov 528 12 2%
7-Nov Nov 484 20 4%
8-Nov Nov 530 21 4%
9-Nov Nov 491 17 3%
12-Nov Nov 488 24 5%
13-Nov Nov 495 14 3%
14-Nov Nov 515 9 2%
15-Nov Nov 499 21 4%
16-Nov Nov 523 25 5%
19-Nov Nov 492 11 2%
20-Nov Nov 485 21 4%
21-Nov Nov 523 22 4%
23-Nov Nov 502 13 3%
26-Nov Nov 507 13 3%
27-Nov Nov 524 22 4%
28-Nov Nov 516 23 4%
29-Nov Nov 501 10 2%
30-Nov Nov 515 17 3%
3-Dec Dec 485 15 3%
4-Dec Dec 493 28 6%
5-Dec Dec 492 18 4%
6-Dec Dec 508 28 6%
7-Dec Dec 496 19 4%
10-Dec Dec 504 12 2%
11-Dec Dec 511 28 5%
12-Dec Dec 513 24 5%
13-Dec Dec 484 13 3%
14-Dec Dec 526 30 6%
17-Dec Dec 510 12 2%
18-Dec Dec 517 11 2%
19-Dec Dec 520 21 4%
20-Dec Dec 526 17 3%
21-Dec Dec 500 17 3%
24-Dec Dec 521 29 6%
25-Dec Dec 488 11 2%
26-Dec Dec 501 13 3%
27-Dec Dec 526 24 5%
28-Dec Dec 489 15 3%

Process changes were implemented on Jan 2nd

After process changes

Date Month Employees that worked Employees out due to work injury Percent
2-Jan Jan 517 4 1%
3-Jan Jan 477 1 0%
4-Jan Jan 511 8 2%
5-Jan Jan 499 6 1%
6-Jan Jan 474 8 2%
9-Jan Jan 511 4 1%
10-Jan Jan 519 1 0%
11-Jan Jan 519 9 2%
12-Jan Jan 530 4 1%
13-Jan Jan 486 1 0%
16-Jan Jan 522 4 1%
17-Jan Jan 513 9 2%
18-Jan Jan 474 0 0%
19-Jan Jan 517 1 0%
20-Jan Jan 515 0 0%
23-Jan Jan 494 6 1%
24-Jan Jan 516 6 1%
25-Jan Jan 488 2 0%
26-Jan Jan 493 0 0%
27-Jan Jan 527 2 0%
30-Jan Jan 483 5 1%
31-Jan Jan 504 2 0%
1-Feb Feb 501 4 1%
2-Feb Feb 510 3 1%
3-Feb Feb 528 3 1%
6-Feb Feb 504 2 0%
7-Feb Feb 475 4 1%
8-Feb Feb 508 3 1%
9-Feb Feb 509 4 1%
10-Feb Feb 539 3 1%
13-Feb Feb 520 3 1%
14-Feb Feb 487 5 1%
15-Feb Feb 493 3 1%
16-Feb Feb 504 0 0%
17-Feb Feb 499 1 0%
20-Feb Feb 495 0 0%
21-Feb Feb 493 4 1%
22-Feb Feb 486 1 0%
23-Feb Feb 485 0 0%
24-Feb Feb 481 4 1%
27-Feb Feb 496 4 1%
28-Feb Feb 494 0 0%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Services Management The New Paradigm In Hospitality

Authors: Jay Kandampully

1st Edition

0131916548, 9780131916548

More Books

Students also viewed these General Management questions