I am trying to find the percentage of fail for each membrane lot base on the count of fail to pass for each number of rows for the specific membrane lot number.
Go to Solution
Create a new data table using
Selecting ODStatus as the Split variable and
Selecting N Rows as the Split Columns
You should also Select MembraneLot of Just ........ as the Group column
In the new data table you will now have a Fail and a Pass column, which you can then create a New column and using a formula of
to create your % value
View solution in original post
Two other options:
1. Tabulate: drag lot to the rows zone, status to the column zone, N to the Freq, and Row % to the cells.
2. Analyze > Consumer Research > Categorical then Responses = OD Status, X,Grouping = Lot, and Freq = N.
Thank you so much for your help. It worked great!
There are no labels assigned to this post.