Design of Experiments is a useful methodology for process improvement. The purpose is to find a relationship between process variables we can control and key process outputs in order to increase process capability.
You can use Excel statistical analysis tools, Solver, Pivot charts, etc. to plan and analyse the results of these experiments.
The first approach is to look for a linear relationship as shown in: Excel DOE
But in some cases this relationship may not be linear, in which case we will try a quadratic model with Response Surface DOE.
We will use an example in this Excel file ResponseSurface.xlsm you can download from OneDrive to your PC:
https://1drv.ms/x/c/7771149fcda84607/QQdGqM2fFHEggHfQCwAAAAAAwP1FHZM6jFgiug
You can see this article in:
https://polyhedrika.blogspot.com/2020/12/response-surface-doe-with-excel-design.html