Excel .xls Template for Attribute Gage R&R with ORDINAL Data needed

[mannygsec]

Hi,

Is there a an Excel Template that handles the Attrbute Gage R&R with ORDINAL Data (i.e. 1,2,3,4). I've searched around but I can only find the an excel template that deals with BINARY Data (i.e. Pass/Fail). I hate to start from scratch if there is already a file floating around. Thanks.

Manny

[Jim Wynne]

Originally Posted by mannygsec

Hi,

Is there a an Excel Template that handles the Attrbute Gage R&R with ORDINAL Data (i.e. 1,2,3,4). I've searched around but I can only find the an excel template that deals with BINARY Data (i.e. Pass/Fail). I hate to start from scratch if there is already a file floating around. Thanks.

Manny

Welcome to the Cove, Manny. When in doubt, do a search--there aren't too many issues that we haven't discussed, and there are a lot of file attachments. For example, have a look at the attachment in this discussion thread: Gage R&R Studies for Attribute Data.

[mannygsec]

Thanks Jim. I pretty much look at all the files in the free directory (http://elsmar.com/pdf_files/) and forums (http://elsmar.com/Forums/fileslist.php) here but to no avail. I guess I just have to customized my own based on one of the posted files which are all based on BINARY data. Again, I need a template for ORDINAL DATA, same concept but I have to redo all the formulas and even the format.


Manny

[Jim Wynne]

Originally Posted by mannygsec

Thanks Jim. I pretty much look at all the files in the free directory (http://elsmar.com/pdf_files/) and forums (http://elsmar.com/Forums/fileslist.php) here but to no avail. I guess I just have to customized my own based on one of the posted files which are all based on BINARY data. Again, I need a template for ORDINAL DATA, same concept but I have to redo all the formulas and even the format.


Manny

Maybe if you could explain a little about what you're trying to do, someone here can help. By definition, "attribute" data is binary--good/bad, pass/fail, etc., so what sort of measurement data are you dealing with?

[Bev D]

you need a KAPPA test. it allows for more 'bins' than just pass or fail. so your ordinal data will work.

I have attached a spreadsheet. you will find it in a couple of other posts I've made if you search for Kappa. you will also find a link to a quality progress article that explains the situation fairly well.

[Bev D]

you need a KAPPA test. it allows for more 'bins' than just pass or fail. so your ordinal data will work.

I have attached a spreadsheet. you will find it in a couple of other posts I've made if you search for Kappa. you will also find a link to a quality progress article that explains the situation fairly well.

the number of categories = the number of ordinal categories...

[Govind]

Originally Posted by Bev D

you need a KAPPA test. it allows for more 'bins' than just pass or fail. so your ordinal data will work.

I have attached a spreadsheet. you will find it in a couple of other posts I've made if you search for Kappa. you will also find a link to a quality progress article that explains the situation fairly well.

the number of categories = the number of ordinal categories...

Thanks Bev D. Very neat. Interpretation Tab in the same work sheet will be a nice addition.

I can see the Comparison between sample Vs categories.
Where do you input individual Judges Scores?

I am attaching a hyperlink to Ordinal data Attribute R & R using Minitab Attribute agreement analysis.
Here is an example with that application
http://www.minitab.com/resources/tut...ntAnalysis.pdf
Regards,
Govind.

[Jim Wynne]

Originally Posted by Bev D

you need a KAPPA test. it allows for more 'bins' than just pass or fail. so your ordinal data will work.

I have attached a spreadsheet. you will find it in a couple of other posts I've made if you search for Kappa. you will also find a link to a quality progress article that explains the situation fairly well.

the number of categories = the number of ordinal categories...

Bev, I linked to a post in which you attached that file, and the OP said it's not what he's looking for, which was why I then asked him to to explain further, because it appeared to me that your Kappa Excel sheet should have been just the ticket.