# Response Surface Design - Repeats - Getting data into Minitab 15

J

#### jaredgalen

I'm using Minitab 15,

I have created a design and now want to enter the response data that has been collected. For each treatment I have over 100 values for the ONE response I am measuring. I see these as repeats, hope I'm right.
So, I have 70 treatments, each with 100 measures of the response.

Code:
``````                  Factor1      Factor2      Reponse(Run1)  Response(Run2)
Treatment1           34          56               6               7
Treatment2           45          67               8               4
..
Treatment70          24          45               4               5``````
My problem is getting them into the model. I can paste them into the worksheet but don't understand how to get it to take them as multiple measure of the same response variable. It keeps taking them as multiple different reponse variables.

#### Tim Folkerts

Trusted Information Resource
Why so many measurements for each setting of the factors? Perhaps you have a large intrinsic variation and want to average out the random variation. But then you might want to work on that challenge before trying to optimize the settings.

As far as I know, Minitab will always treat each column of responses as a separate variable - but only 25 maximum. Minitab help says:

"Enter up to 25 numeric response data columns that are equal in length to the design variables in the worksheet. Each row will contain data corresponding to one run of your experiment. You may enter the response data in any column(s) not occupied by the design data. The number of columns reserved for the design data is dependent on the number of factors in your design. If there is more than one response variable, Minitab fits separate models for each response."

One simple option would be to calculate a few extra columns from the 100 data points - like the average and st dev - perhaps max and min as well, or 10th %tile and 90th %tile. Then you could use these new summary columns in the analysis. You would see how the factors affect the average and how they affect the spread.

Also, 70 different trials seems like a very big design, especially of you really only have two factors. Typically, you are fitting a quadratic curve to the data. It would be overkill to have 70 different values for just two variables and still try to fit just a quadratic surface. 70 trials would be more typical of a design with 5-7 factors.

Tim F

#### Statistical Steven

##### Statistician
Super Moderator
I'm using Minitab 15,

I have created a design and now want to enter the response data that has been collected. For each treatment I have over 100 values for the ONE response I am measuring. I see these as repeats, hope I'm right.
So, I have 70 treatments, each with 100 measures of the response.

Code:
``````                  Factor1      Factor2      Reponse(Run1)  Response(Run2)
Treatment1           34          56               6               7
Treatment2           45          67               8               4
..
Treatment70          24          45               4               5``````
My problem is getting them into the model. I can paste them into the worksheet but don't understand how to get it to take them as multiple measure of the same response variable. It keeps taking them as multiple different reponse variables.
You need to stack the Response from each run into a single variable called response, and then create a new variable called run that would tell you the run that each response is associated with. You then have a factor called run in your model that quantifies the run to run variability (or the variability between the measurements)

S Response Surface Method to create design matrix in Minitab Using Minitab Software 5
T Variation in values of the levels in Factorial/Response surface design Using Minitab Software 1
W Best quadratic subset for analyzing a Response Surface Design with Minitab 15 Using Minitab Software 6
D Showing the Response Surface Experimental Point in MiniTab Using Minitab Software 5
S Need Help with Response Surface Optimization Using Minitab Software 4
R Define Data from Taguchi to Response Surface Methodology in Minitab Using Minitab Software 2
R Multi Response Optimizer - Help with Response Surface Methodologies Using Minitab Software 3
RESPONSE TO NON-CONFORMITIES IATF 16949 - Automotive Quality Systems Standard 6
Streamlining audit response and corrective action processes ISO 13485:2016 - Medical Device Quality Management Systems 9
Help to understand and response to API AAR during the re-certification audit Oil and Gas Industry Standards and Regulations 17
NADCAP Rejection Response to Root Cause Analysis and Corrective Action. Nonconformance and Corrective Action 1
No Customer Response to an SCR Manufacturing and Related Processes 2
One-factor and multiple-response Minitab optimization Using Minitab Software 2
Does the ISO 9001:2015 standard require a disaster recovery plan or emergency response plan ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 16
IEC 60601-2-25; Frequency response test Medical Device and FDA Regulations and Standards News 1
Customer Complaint Response 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 3
Informational ISO COVID-19 response: freely available ISO standards Other ISO and International Standards and European Regulations 1
ISO 13485 - Clause 8.3.3 appropriate actions in response to nonconforming product ISO 13485:2016 - Medical Device Quality Management Systems 2
Corrective Action Response for Missed bumps on brake press Manufacturing and Related Processes 2
"On the job training" as a response to how someone was trained? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 92
How long to wait for Notified Body Response - Potentially significant change to a medical device CE Marking (Conformité Européene) / CB Scheme 6
"We don't have enough resources" as an Audit Non-conformance Response General Auditing Discussions 14
Medical Device News MHRA releases response to consultation on EU exit no-deal legislative proposals Medical Device and FDA Regulations and Standards News 0
Requirements for Interval Measurement test & Frequency Response test clarification IEC 60601 - Medical Electrical Equipment Safety Standards Series 0
O QRQC (quick response quality control) methodology in automotive industry IATF 16949 - Automotive Quality Systems Standard 3
S Formal written response to a corrective action? Nonconformance and Corrective Action 9
A Taguchi Minitab - Continuous Data - What should I choose as response variable? Using Minitab Software 3
Medical Device Malfunction - Customer Complaint - Response vs. Correction Other US Medical Device Regulations 3
W Nonconformance Recurrence Response Help General Auditing Discussions 4
Survey to Customers Regarding Our Complaint Response Time Customer Complaints 7
Customer Complaint - Rapid Response Containment Procedure Customer Complaints 4
Tracking response time with individual label I.D. Statistical Analysis Tools, Techniques and SPC 6
K Fast Response Tracking Board (QSB+) Customer and Company Specific Requirements 6
What are the next steps after providing response to FDA 483 ? US Food and Drug Administration (FDA) 7
Baffled by no response to your job application? Career and Occupation Discussions 6
H FDA Response Time for Amendments? 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 1
S Delegation of Response to Next Level ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 2
How to handle CAR (Corrective Action Request) Scope vs. Timely Response Nonconformance and Corrective Action 9
F Response to ISO 13485 Audit Minor Nonconformances ISO 13485:2016 - Medical Device Quality Management Systems 6
C Optimize One Response with Three Variables Using Minitab Software 8
M Customer Satisfaction Survey - Poor Response ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 11
Response to ISO 17025 Proficiency Test z score ISO 17025 related Discussions 7
R Supplier CAR response scoring Nonconformance and Corrective Action 10
G Setting up a 3 Factor, 2 Level,2 response DOE in Minitab Using Minitab Software 7
A Effects of categorical variables on single response Using Minitab Software 9
About NC (Nonconformance) Type and days for CA (Corrective Action) Response... ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 8
M AS 4706 (Personal Response Systems) & AS 3811 (Patient Alarm Systems) Equivalents? Other ISO and International Standards and European Regulations 4
Closed Customer Complaint Response Form Examples? Customer Complaints 3