Scatter plots - A way of making Excel chart scatter plots to page 106 of MSA manual

[Howard Atkins]

I have been trying to find a way of making excel chart scatter plots as per page 106 of MSA.
Can anyone help?

[Al Rosen]

Originally Posted by Howard Atkins

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]

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]

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]

Originally Posted by Sleepless

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]

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]

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]

Originally Posted by Howard Atkins

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.