The Elsmar Cove Forum and Site Map The Elsmar Cove Wiki More Free Files The Elsmar Cove Forums Discussion Thread Index Post Attachments Listing Failure Modes Services and Solutions to Problems Elsmar cove Forums Main Page Elsmar Cove Home Page

Go Back   The Elsmar Cove Forum > Common Quality Assurance Processes and Tools > Quality Tools, Improvement and Analysis > Quality Assurance and Compliance Software Tools / Solutions > Excel .xls Spreadsheet Templates and Tools


The Elsmar Cove Forum SideBar!
Monitor the Forum
Monitor New Forum Posts
New Threads Feeds
RSS FeedRSS Feed
Sponsor Link










$ Contributor Forum Access
Courtesy Quick Links

Links that Elsmar Cove visitors will find useful in your quest for knowledge:


Howard's International Quality Services

Atul's Symphony Technologies

Dave Scott's Scott Quality Solutions

Praxiom Research Group


NIST's Engineering Statistics Handbook

IRCA - International Register of Certified Auditors

SAE - Society of Automotive Engineers

Quality Digest Portal

IEST - Institute of Environmental Sciences and Technology

ASQ - American Society for Quality


All the Important Standards and Related Web Sites in the World
Reply
 
Thread Tools Search this Thread Rating: Thread Rating: 1 votes, 4.00 average. Display Modes
  #1  
Old 26th August 2005, 02:04 AM
veness veness is offline
Inactive Registered Visitor

Registration Date: Aug 2005
Location: Malaysia
 
Posts: 7
Thanks Given to Others: 0
Thanked 0 Times in 0 Posts
Karma Power: 18
Karma: 10
veness has less than 100 Karma points so far.
Let Me Help You To formulate an Excel .xls worksheet for MSA on attribute data using Kappa Analysis

Hi, everyone

Im an undergraduate student in University Science of Malaysia, major in Applied Statistics.
I need to do my final year project and the title is:

To formulate an Excel worksheet for Measurement System Analysis on attribute data using Kappa Analysis.I dont know how to do it. Thus, I hope that you can help me and provide me some information or idea how to do it. Thanks!

thanks a lot!!

veness
Reply With Quote

Sponsored Links
  #2  
Old 26th August 2005, 01:09 PM
Miner's Avatar
Miner Miner is offline
Forum Moderator

Registration Date: Apr 2002
Location: Wisconsin
 
Posts: 1,840
Thanks Given to Others: 166
Thanked 670 Times in 457 Posts
Blog Entries: 9
Karma Power: 251
Karma: 9207
Miner is appreciated, and has over 1700 Karma points.Miner is appreciated, and has over 1700 Karma points.Miner is appreciated, and has over 1700 Karma points.
Miner is appreciated, and has over 1700 Karma points.Miner is appreciated, and has over 1700 Karma points.Miner is appreciated, and has over 1700 Karma points.
Default

There is a good article on KAPPA analysis in Quality Progress, May 1995.
Reply With Quote
Sponsored Links

  #3  
Old 28th August 2005, 12:11 PM
veness veness is offline
Inactive Registered Visitor

Registration Date: Aug 2005
Location: Malaysia
 
Posts: 7
Thanks Given to Others: 0
Thanked 0 Times in 0 Posts
Karma Power: 18
Karma: 10
veness has less than 100 Karma points so far.
Default

hi Miner,

Quality Progress?? is tat a book??who is the editor of tis book??

veness
Reply With Quote
  #4  
Old 28th August 2005, 12:21 PM
Barbara B's Avatar
Barbara B Barbara B is offline
Involved - Posts

Registration Date: May 2005
Location: Germany
 
Posts: 43
Thanks Given to Others: 0
Thanked 0 Times in 0 Posts
Karma Power: 19
Karma: 12
Barbara B has less than 100 Karma points so far.
Default

Hi veness,

are you familiar with the calculation of the kappa statistic? It's a measurement for the agreement among variables, so for a MSA-study it could be used to find significant differences between appraiser decisions.

You could find the formulas and a description e. g. in Joaquim P. Marques de Sá [2003]: "Applied Statistics using SPSS, STATISTICA and MATLAB", Springer, ISBN 3540011560, p. 61 ff. (Although it deals with statistic-software, there are formulas for all methods and thus you could make your own excel-version).

Hope this helps,

Barbara
Reply With Quote
  #5  
Old 28th August 2005, 06:43 PM
Miner's Avatar
Miner Miner is offline
Forum Moderator

Registration Date: Apr 2002
Location: Wisconsin
 
Posts: 1,840
Thanks Given to Others: 166
Thanked 670 Times in 457 Posts
Blog Entries: 9
Karma Power: 251
Karma: 9207
Miner is appreciated, and has over 1700 Karma points.Miner is appreciated, and has over 1700 Karma points.Miner is appreciated, and has over 1700 Karma points.
Miner is appreciated, and has over 1700 Karma points.Miner is appreciated, and has over 1700 Karma points.Miner is appreciated, and has over 1700 Karma points.
Default

Quote:
Originally Posted by veness

hi Miner,

Quality Progress?? is tat a book??who is the editor of tis book??

veness
Quality Progress is a publication of ASQ (American Society for Quality) at www.asq.org. You should be able to obtain a reprint of the article, which covers KAPPA and ICC (Intra-Correlation Analysis). Use KAPPA for attribute studies that are Good/Bad, and ICC for attribute studies that have a scale or range of possible values from worst to best.

The full name of the article is "When Quality is a Matter of Taste, Use Reliabilty Indexes" by David Futrell, in Quality Progress, May 1995, pp 81-86.

Last edited by Miner; 28th August 2005 at 06:57 PM.
Reply With Quote
  #6  
Old 1st September 2005, 02:28 AM
veness veness is offline
Inactive Registered Visitor

Registration Date: Aug 2005
Location: Malaysia
 
Posts: 7
Thanks Given to Others: 0
Thanked 0 Times in 0 Posts
Karma Power: 18
Karma: 10
veness has less than 100 Karma points so far.
Default

hi, Miner

can you send me the article "When Quality is a Matter of Taste, Use Reliabilty Indexes" by David Futrell, in Quality Progress, May 1995, pp 81-86 as a attachment because im not a member of ASQ?
thanks for your help!!

veness
Reply With Quote
  #7  
Old 1st September 2005, 07:33 AM
Bill Ryan's Avatar
Bill Ryan Bill Ryan is offline
Dogs rule

Registration Date: Jul 2002
Location: Madison, WI
Age: 56
 
Posts: 980
Thanks Given to Others: 15
Thanked 23 Times in 16 Posts
Karma Power: 69
Karma: 1002
Bill Ryan is appreciated, and has over 900 Karma points.Bill Ryan is appreciated, and has over 900 Karma points.Bill Ryan is appreciated, and has over 900 Karma points.Bill Ryan is appreciated, and has over 900 Karma points.Bill Ryan is appreciated, and has over 900 Karma points.Bill Ryan is appreciated, and has over 900 Karma points.Bill Ryan is appreciated, and has over 900 Karma points.Bill Ryan is appreciated, and has over 900 Karma points.
Default

Try this site out. It has been recommended many times here for statistical questions.


http://www.itl.nist.gov/div898/handbook/index.htm
__________________
There is no psychiatrist in the world like a puppy licking your face. - Ben Williams
Reply With Quote
  #8  
Old 1st September 2005, 01:10 PM
Miner's Avatar
Miner Miner is offline
Forum Moderator

Registration Date: Apr 2002
Location: Wisconsin
 
Posts: 1,840
Thanks Given to Others: 166
Thanked 670 Times in 457 Posts
Blog Entries: 9
Karma Power: 251
Karma: 9207
Miner is appreciated, and has over 1700 Karma points.Miner is appreciated, and has over 1700 Karma points.Miner is appreciated, and has over 1700 Karma points.
Miner is appreciated, and has over 1700 Karma points.Miner is appreciated, and has over 1700 Karma points.Miner is appreciated, and has over 1700 Karma points.
Default

Quote:
Originally Posted by veness

hi, Miner

can you send me the article "When Quality is a Matter of Taste, Use Reliabilty Indexes" by David Futrell, in Quality Progress, May 1995, pp 81-86 as a attachment because im not a member of ASQ?
thanks for your help!!

veness
Sorry. I do not want to run afoul of copyright laws by making it publicly available. The article can be downloaded free from ASQ by ASQ members. Some professors are ASQ members, and use for educational purposes should not infringe copyright protection.

Try these publicly available sites. The information that you need should be here. However, the ASQ article presents in a clearer fashion.

http://www.statsdirect.com/help/chi_...ests/kappa.htm

http://faculty.vassar.edu/lowry/kappa.html
Reply With Quote
Reply

Lower Navigation Bar
Go Back   The Elsmar Cove Forum > Common Quality Assurance Processes and Tools > Quality Tools, Improvement and Analysis > Quality Assurance and Compliance Software Tools / Solutions > Excel .xls Spreadsheet Templates and Tools

Bookmarks


Visitors Currently Viewing this Thread: 1 (0 Registered Visitors and 1 Unregistered Guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Forum Search
Display Modes Rate Thread Content
Rate Thread Content:

Posting Settings
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Discussion Threads
Discussion Thread Title Thread Starter Forum Replies Last Post or Poll Vote
ISO/TS 16949 Gap Analysis Excel .xls Worksheet Roto_Manic Excel .xls Spreadsheet Templates and Tools 8 13th November 2009 10:35 AM
Attribute MSA Study using Kappa - Why Kappa value is low Chua Kwan Teng Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 12 22nd January 2009 08:30 AM
MSA Excel .xls worksheet that includes GR&R, Bias, Linearity, etc. HDR Excel .xls Spreadsheet Templates and Tools 10 19th May 2006 10:31 AM
Graphing a defect chart in Excel .xls using attribute data statman78 Excel .xls Spreadsheet Templates and Tools 4 16th March 2006 06:21 PM
CMM Uncertainty Level analysis - Seeking EXCEL .xls template or worksheet apurk45 Excel .xls Spreadsheet Templates and Tools 2 18th October 2004 11:27 PM



The time now is 11:01 PM. All times are GMT -4.
The time zone can be changed in your UserCP --> Options.



   

All Y'All Come Back Now, Y' Hear?

Made With A Mac! FreeBSD OS Powered by Apache!
Using php4 Forums provided and maintained by Marc Smith Database by MySQL

FAIR USE and CORRECTNESS NOTICE: This site contains copyrighted material the use of which has not always been specifically authorized by the copyright owner. We are making such material available in our efforts to advance understanding of environmental, political, human rights, economic, democracy, scientific, and social justice issues, etc. We believe herein constitutes a 'fair use' of any such copyrighted material as provided for in section 107 of the US Copyright Law. In accordance with Title 17 U.S.C. Section 107, the material on this site is distributed without profit to those who have expressed a prior interest in receiving the included information for research and educational purposes. For more information go to: http://www.law.cornell.edu/uscode/17/ If you wish to use copyrighted material from this site for purposes of your own that go beyond 'fair use', you must obtain permission from the copyright owner. In addition, I do not guarantee the correctness of the content. The risk of using content from the Elsmar Cove web site and forums remains with the user/visitor.

Responsibility Statement: Each person is responsible for anything they post in the Elsmar Cove forum. Neither I, Marc Timothy Smith, nor any of the forum Moderators, are responsible for the content of posts people make. Liability for post content resides with the poster as does interpretation and/or acceptance and/or use of advice by the reader.

Complaints: If you have a complaint with a post in a forum discussion thread, including Content in general, fighting, flaming, copyright infringement, defamation and/or 'slander', please use the 'Report This Post Report This Post Button button which appears at the top of every post in every thread.

Site courtesy of:
Marc Timothy Smith - Cayman Business Systems, 8466 Lesourdsville-West Chester Road, West Chester, Ohio 45069-1929 - USA
(513) 341-6272

To contact me, click the Google Voice link below, enter Your Name and Your Phone Number and Google will ring your phone and connect you for free!

The Elsmar Cove Web Site is *CopyFree*
no new posts