QUESTION 4: Use Excel and derive (come up with a sampling plan) an item-by-item sequential-sampling plan for which p = 0.04, a = 0.05, p2 = 0.12, and = 0.05 (30pts) (Note: Assume that the single sampling plan for the given data is n = 40, c = 2. Therefore, the item-by-item sequential- sampling plan would be truncated after the inspection of a certain number of unit) SUBMISSION TYPE: EXCEL + VIDEO (no time limit). Note: Record (screen recording) yourself solving the question. Teach us as if you are an instructor. Upload your video to onedrive or youtube (or another platform as long as your link works) and provide me a link in the submission.

i dont need the video part im trying to figure out where to start.

QUESTION 4: Use Excel and derive (come up with a sampling plan) an item-by-item sequential-sampling plan for which p1=0.04,=0.05,p2=0.12, and =0.05 (30pts) (Note: Assume that the single sampling plan for the given data is n=40,c=2. Therefore, the item-by-item sequential- sampling plan would be truncated after the inspection of a certain number of unit) SUBMISSION TYPE: EXCEL + VIDEO (no time limit). Note: Record (screen recording) yourself solving the question. Teach us as if you are an instructor. Upload your video to onedrive or youtube (or another platform as long as your link works) and provide me a link in the submission