Using Minitab's ifelse command

Y

Ying4573

#1
s i time LOWER LIMIT,L UPPER LIMIT,U
1 0 1.764
1 0 2.088
0 0 88.283
1 0 6.154
0 0 87.733
1 0 0.198
1 0 0.3489
0 0 3.660
1 0 7.1284
0 0 2.4592
1 0 1.089
1 0 0.083
1 0 0.4256
1 0 2.535
1 0 9.7014
0 0 6.965
1 0 0.9990
1 0 0.038
1 0 0.3961
0 0 21.301

i need to use s, i and time column to determine my lower and upper limit. The interval used will be (0,4), (4,8), (8,12) and (12, *). When s=0 and i=0, L will be 'time' and U will be ' * '. When s=0 & i=1, L will be 0 and R will be 4 if 0<time<=4 ; L will be 4 and U will be 8 if 4<time<=8; L will be 8 and U will be 12 if 8<time<=12; L will be 12 and R will be ' * ' if time>12. When s=1 and i=0, both L and U will be time. When s=1 and i=1, both L and U will be time as well... To use these conditions to get my L and U column, what are the commands can i use?...
 
Elsmar Forum Sponsor
Thread starter Similar threads Forum Replies Date
J Including Repeats in DoE using Minitab Using Minitab Software 5
B Informational Expanded Gage R&R Analysis using Minitab Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 18
A Capability Analysis for Packaging Seal Strength with spec. >0.1 Kgf using Minitab Using Minitab Software 6
B Measurement Uncertainty using Minitab Measurement Uncertainty (MU) 2
A Using Minitab to do 6 Sigma Studies Six Sigma 4
M How to determine Process Capability using Minitab 17 Capability, Accuracy and Stability - Processes, Machines, etc. 6
B Using Minitab 17's Stepwise Regression to Predict Feature Using Minitab Software 2
C Hardness Testing - Low Cpk's using Minitab Misc. Quality Assurance and Business Systems Related Topics 10
L Automate GR&R using Minitab on complex, multi-measurement assemblies Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 13
F How to Calculate the unbiased Standard Deviation in Excel using Minitab Formula Capability, Accuracy and Stability - Processes, Machines, etc. 6
M Please help to analyze Response Surface Methodology by using Minitab 16 Using Minitab Software 6
K Gage R on a 10 Piece Sample with a CMM using Minitab Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
S D-optimal Designs using Minitab Using Minitab Software 6
A Minitab - Using the INSERT command to copy-paste text from and to a worksheet Using Minitab Software 6
A Copy-Paste in Minitab using Session Commands Using Minitab Software 5
D The correct way to analyze Skewed Data using Minitab Using Minitab Software 3
S Using Minitab for Multinomial Logistic Regression Using Minitab Software 2
M Using Minitab to Compute & Compare the Mean and Standard Deviation Amount Using Minitab Software 7
Proud Liberal Minitab - Organizing a large number of graphs using file details Using Minitab Software 5
E Center Point Residuals on a Factorial Design using Minitab Quality Tools, Improvement and Analysis 3
M Experimental Design at Nested Gage R&R using Minitab 16 Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
A Gage R&R without Operators (using Sensors) using Minitab Using Minitab Software 2
J Taguchi Analysis using MiniTAB Using Minitab Software 1
C Analyzing 3 Factors 3 Levels using Minitab Using Minitab Software 9
V Sample Range for a valid GRR using ANOVA in Minitab Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
B Taguchi DOE (Design of Experiments) example using Minitab Using Minitab Software 3
T Counting the Average Times of Alarms in a Process using Minitab Using Minitab Software 5
Z Using Sum Values for Category Data in Minitab Using Minitab Software 4
V Using Taguchi method in Minitab for Coil Winding Application Using Minitab Software 11
V How to calculate Machine Capability Study using Minitab Using Minitab Software 4
S Pulling Data In Real Time From Excel using Minitab 15 Using Minitab Software 2
M Using the Johnson Transformation in Minitab Six Sigma 1
T 4 Factor Optimization using Minitab Using Minitab Software 7
M Insert Empty Column Using Minitab Macro Using Minitab Software 2
M To find the Optimum Parameter Setting using Minitab (Doing DOEs) Using Minitab Software 18
S Process Capability questions - Calculating Cpu using Minitab Six Sigma 6
B Using Minitab for Chi Square using Weighted Cases Using Minitab Software 2
B Plotting Probability Exceedance using the Probability Plot Graph in Minitab Using Minitab Software 4
A Marketing Survey Analysis of Customer Surveys using Minitab Using Minitab Software 1
P Taguchi's Analysis using Minitab 16 Using Minitab Software 25
P Taguchi method using Minitab - DOE (Design of Experiments) Help Quality Tools, Improvement and Analysis 7
O Sales Forecasting by Using Time Series Decomposition [Minitab] Using Minitab Software 4
B Minitab Gage R&R using Defect Count per Unit Area Using Minitab Software 1
E Gage R&R or Anova two way? Using Minitab Using Minitab Software 1
T Process Capability Analysis Binomial or Normal using Minitab 15 Using Minitab Software 54
K Reproducibility between different lots using minitab Using Minitab Software 1
U How to filter out responses from Minitab - Questionnaire using a 5 point likert scale Using Minitab Software 3
D Control limit calculation (Xbar R charts) using Minitab Statistical Analysis Tools, Techniques and SPC 14
T Using Response Optimizer to find the optimum parameter setting - Minitab Using Minitab Software 4
M Gage R&R (Reproducibility and Repeatability) using Minitab 14 Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
Similar threads


















































Top Bottom