![]() Now, we’ll see how in excel, we can fit a regression equation on a scatterplot itself. #2 – Regression Analysis Using Scatterplot with Trendline in Excel Weight = 0.6746*Height – 38.45508 (Slope value for Height is 0.6746… and Intercept is -38.45508…)ĭid you get what you have defined? You have defined a function in which you now just have to put the value of Height, and you’ll get the Weight value. Now our, regression equation for prediction becomes: It gives values of coefficients that can be used to build the model for future predictions. The other important part of the entire output is a table of coefficients. Or in another language, information about the Y variable is explained 95.47% by the X variable. In this case, the R Square value is 0.9547, which interprets that the model has a 95.47% accuracy (good fit). One important part of this entire output is R Square/ Adjusted R Square under the SUMMARY OUTPUT table, which provides information, how good our model is fit. However, interpreting this output and make valuable insights from it is a tricky task. Till here, it was easy and not that logical.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |