There are so many numbers, but you really only need to know the parts in yellow in the image above for business, at least. Let’s see the results of a Simple Regression Analysis in Excel with the same data first. In practice, you can complete your job with only the Scatter Plot, many times, but performing a Single Regression Analysis will give you more significant information. We obtained a Simple Regression Equation of Y = 0.4738 X + 35.519 and a Coefficient of Determination of 0.9727. Here are the results from the previous Scatter Plot. ⇒ “Simple Regression Analysis by Scatter Plot in Excel” We learned about the basics of Regression Analysis and how to get a Single Regression Equation from the Scatter Plot in the previous post. Hi, this is Mike Negami, Lean Sigma Black Belt. Making a Simple Regression Equation with the Simple Regression Analysis using the Excel Analysis Tool.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |