topic Re: Percentage for each row in Discussions

Percentage for each row

padhikari — Thu, 04 Oct 2018 21:26:50 GMT

Hello,

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.

Re: Percentage for each row

txnelson — Thu, 04 Oct 2018 21:39:18 GMT

Create a new data table using

Tables==>Split

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

:Pass/(:Pass+:Fail)

to create your % value

Re: Percentage for each row

KarenC — Fri, 05 Oct 2018 11:34:31 GMT

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.

Re: Percentage for each row

padhikari — Wed, 10 Oct 2018 21:17:39 GMT

Thank you so much for your help. It worked great!