-------------------------------------------------
(SUBJECT CODE: STA1114)
-------------------------------------------------
Instructions to Students:
1. Assignment questions consist of: * Question One - 25% * Question Two - 25%
2. Assignment question must be combined into ONE (1) booklet, attached with “Assignment Submission Form” as the front cover, enclosed with the “Marking Criteria.” typed with double spacing using Times New Roman font type (Size 12). Submitted booklet must be stapled.
3. Students are to submit their assignment booklet ON or BEFORE 8.00pm, 9th NOVEMBER (WEDNESDAY).
All assignments are to be submitted to CCE (Centre for Continuing Education). NO EXTENSION WILL BE GRANTED. Any assignments submitted after the dateline will be penalized 5 marks per day.
4. Group discussions are encouraged but answers must not give the Examiners reasons to believe that copying of each other’s works has occurred. Copying is a serious offence and could result in a FAIL grade. Originality will be one of the key factors in the awarding of points and grades.
-------------------------------------------------
Question One [25 Marks]
Answer the questions based on the data below.
PRODUCTIVITY BONUS PAYMENT
The production of each manufacturing department of your company is monitored weekly to establish productivity bonuses paid to the members of that department. At least 380 items have to be produced each week before a bonus will be paid. The production in one department over a forty week period is shown below:-
382 | 364 | 454 | 398 | 355 | 354 | 359 | 371 | 457 | 371 | 361 | 382 | 357 | 372 | 437 | 469 | 459 | 396 | 364 | 445 | 367 | 365 | 460 | 365 | 347 | 359 | 360 | 370 | 406 | 364 | 380 | 394 | 362 | 451 | 446 |
1. Data Presentation a. Use Microsoft Excel to complete the table below: Production | Midpoint |