Back Assignment 4.xlsx EMNT509 QUALITY CONTROL - ASSIGNMENT No.: 4 Problems 7-49, 7-50 and 7-51 Submition Deadline: 3 April 2022; 23:59 (GMT+3) 7-49 An investment bank is interested in monitoring the weekly amount (in millions of dollars) invested in volatile stocks so as to maintain a stable rate of return on a selected fund. Table 7-31 shows 25 consecutive weeks of the amount invested ($M) in the fund. Construct appropriate control charts and comment on the stability of invest- ment. Revise the chart, if necessary, assuming special causes for out-of-control points. What is your estimate of the standard deviation of the weekly amount invested? Table 7-31 - Weekly Investment in Volatile Stocks Week Investment ($M) 1 16,2 2 10,8 3 18,9 7-50 Refer to Exercise 7-49 and the revised process. Is this process capable of meeting a goal value of $1.5M for the standard deviation of the weekly amount invested? Construct an appropriate chart and discuss. 4 14,4 5 15,7 6 25,3 7-51 Refer to Exercise 7-49. Construct an exponentially weighted moving-average chart using a weighting constant of 0.2 for the weekly amount invested. Comment on the process. If it is desired to have a goal value of $1.5M for the standard deviation, using the constructed chart, comment on the ability of the process to achieve this goal. 7 20,4 8 22,6 9 17,8 10 12,9 11 28.5. 12 23,3 13 20,2 14 19,3 15 14,8 16 18,7 17 20,4 18 21,7 19 16,3 20 14,2 21 21,5 22 18,6 23 20,9 24 22,4 25 21,8