QI Macros Add-in for Excel can create a scatter plot in seconds and will calculate the slope and R² for you. However, you have to find the right chart to get a trend line and Excel will not calculate the R² for you. Scatter Plots can be made manually or in Excel. NOTE: Our Scatter Plot Diagram does NOT calculate the Equivalence Point for you - it can be identified by the end user where the graph is the steepest.Īlso, if you have identified the Equivalence Point, simply hover over it - Excel will provide you with the value. Select your data and then select the "Scatter" macro from the "Box, Dot & Scatter Plot" drop-down menu: Most statistics books imply that this means that you have a strong correlation.Ĭan I create a Titration Curve in Excel using QI Macros?Ĭertainly! Make sure that you have a column of Volume data that represents your X-Axis, along with a column of pH data that represents your Y-Axis. If R², the correlation of determination (square of the correlation coefficient), is greater than 0.8, then 80% of the variability in the data is accounted for by the equation. Free Agile Lean Six Sigma Trainer TrainingĬalculating the Correlation of Determination. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |