Programming Homework Help

Hello I have a professional project it should be perfectly done using MINITAB

I will be uploading the Instructions and the data below please go through them deeply and carefully ̅

INSTRUCTIONS:

Please submit ONE MS Word or PDF file which includes all of your solutions to CANVAS. Problem 1. Construct control charts as required using data in file HW1 data 1.xlsxand answerquestions below. (50 points) a)Construct an Individual Control Chart (I Chart). (10 points)b)Construct ̅Control Chart with a subgroup size of two. (10 points) c)Construct ̅Control Chart with a subgroup size of five. (10 points)d)Construct ̅Control Chart with a subgroup size of 10. (10 points)e)Observe the control charts (a) –(d), what is your conclusion about the control charts with the subgroup size increasing? (5points)f)Observe the control charts (a) –(d), Is there anynotableincreasingor decreasingtrend? Brieflydiscussyour understandingof the trends (5points)Problem 2. Construct control charts as required using data in file HW1 data 2(xxx).xlsx. Perform all tests for special cases with the default value of K and answer the questions below. (50 points) a)Construct Chart using data in HW1 data 2 (pchart).xlsxand indicate which test fails. (12 points)b)Construct Chart using data in HW1 data 2 (npchart).xlsxand indicate which tests fail. (14 points)c)Construct Chart using data in HW1 data 2 (uchart).xlsxand indicate which test fails. (12 points)d)Construct Chart using data in HW1 data 2 (cchart).xlsx and indicate which test fails. (12 points)