Hello I need assistance in the following using military promotions as my topic. I have attached my flow chart if that helps.

Complete the following in Excel:

Calculate the defined process metrics including variation and process capability.

Develop and display a control chart for the process.

Evaluate the control chart and process metrics using Statistical Process Control (SPC) methods. Determine whether the process could benefit from the use of Six Sigma, Lean, or other tools. (Include all calculation and charts.)