Howard Atkins
20th February 2006, 10:06 AM
I have been trying to find a way of making excel chart scatter plots as per page 106 of MSA.
Can anyone help?
Can anyone help?
|
*Please be aware that SOME RECENT forum threads may not yet be indexed by Google. |
|
View Full Version : Scatter plots - A way of making Excel chart scatter plots to page 106 of MSA manual Al Rosen 20th February 2006, 11:58 AM I have been trying to find a way of making excel chart scatter plots as per page 106 of MSA. Can anyone help?Howard, if you use "Insert"->Chart, then chart type, 5 items down the list is a scatter diagram. Sleepless 20th February 2006, 02:45 PM FYI - I don't believe that the Excel chart will give you the Correlation Coefficient. If that's important to you, you may want to look at other products. In a previous life, I worked on a product that provided Active X controls for various statistical analysis such as basic trends, various regression types, spc, and multivariate analysis. You can take these Active X controls and insert them into an Excel spread sheet. If you have an interest, I can provide a link to the product. (BTW - I have no affiliation with the product, company, or any stock in the company - just a little pride in the product I once worked on, I guess). Howard Atkins 20th February 2006, 03:12 PM Thanks for the help but I think that the chart as shown in the MSA book is different. I will post a picture tommorrow. Tim Folkerts 20th February 2006, 03:53 PM FYI - I don't believe that the Excel chart will give you the Correlation Coefficient. The CORREL function in Excel returns the correlation coefficient, "r". Also, if you fit a linear "trendline" (i.e. least squares linear fit), you can add the equation and the value of R^2 to the graph by just selecting the appropriate option within the "trendline" menu. Tim F nickh 20th February 2006, 04:24 PM After you create the scatterplot, right-click on the data series and select add Trendline from the context menu. Choose the trend type (linear, exponential, etc) then select the Options tab. Under Options you can choose to set the y-intercept, display the formula, and show the R-squared value. Whether this matches the output required per the MSA manual (??) - I don't know since I don't have a copy. Rob Nix 20th February 2006, 04:41 PM I do scatter plots in Excel much the way Tim describes it. Page 106 of the MSA book calls it a scatter plot, but I do not believe that it really is one. It appears to be more of a graphed ANOVA or a multi-vari chart than a scatter diagram. It shows values in the Y-axis, but part numbers and appraiser designations in the X-axis, not a second set of data. You can make a chart like they show in Excel, but you have to do a "Line Chart" and play with the settings, putting a space between the groups of data you want linked, or connected with lines. Caster 20th February 2006, 05:47 PM I have been trying to find a way of making excel chart scatter plots as per page 106 of MSA. Can anyone help? Howard Here is an Excel worksheet I made that has "all the charts". It is very much home built, lots of quirks in it. User beware - it only does 5x3 MSA. You also have to update the chart ranges manually.. Please check all the math yourself.... I mostly did this as a learning experience, it helped me understand the math behind the charts. We use Minitab now. I hope someone can make use of this, a small give back for all that I have taken. Howard Atkins 21st February 2006, 02:52 AM I do scatter plots in Excel much the way Tim describes it. Page 106 of the MSA book calls it a scatter plot, but I do not believe that it really is one. It appears to be more of a graphed ANOVA or a multi-vari chart than a scatter diagram. It shows values in the Y-axis, but part numbers and appraiser designations in the X-axis, not a second set of data. You can make a chart like they show in Excel, but you have to do a "Line Chart" and play with the settings, putting a space between the groups of data you want linked, or connected with lines. You are right and after hearing what is being said I am becominmg more proficent Howard Here is an Excel worksheet I made that has "all the charts". It is very much home built, lots of quirks in it. User beware - it only does 5x3 MSA. You also have to update the chart ranges manually.. Please check all the math yourself.... I mostly did this as a learning experience, it helped me understand the math behind the charts. We use Minitab now. I hope someone can make use of this, a small give back for all that I have taken. Thanks you have worked hard on this and it has given me some ideas. But--it has the 2nd edition method and constants. Attached the plots I was talking about (sorry for the quality of the scan) Thanks to everyone Tim Folkerts 21st February 2006, 07:56 AM Here, try this. I don't have time to discuss all possible details, but tou can try "reverese engineering" it and ask questions about specific concerns. Tim F Tim Folkerts 21st February 2006, 07:59 AM oops :o I hit reply before I was quite ready. It's not fancy, but it get the job done. You can tweek the appearance to make it look a little nicer, if you want. Tim Howard Atkins 21st February 2006, 08:14 AM oops :o I hit reply before I was quite ready. It's not fancy, but it get the job done. You can tweek the appearance to make it look a little nicer, if you want. Tim Thanks a lot :applause: :applause: |
|