Comments on: Linear regression analysis in Excel

Run regression analysis in Excel to get the answers to the following questions: Which factors matter and which can be ignored? How closely are these factors related to each other? And how certain can you be about the predictions? Continue reading

Comments page 2. Total comments: 155

  1. Great article!
    Knowledge-filled and hands-on mode enabled.

  2. Thank you so much for this very very helpful Knowledge.

  3. is this valid for non-linear regression

  4. Thank you it's well explained.

  5. Excellet, thanks for sharing!!

  6. Thanks so very much for these knowledge transfer.

  7. Excellent explanation.. Thanks a lot.

  8. Excellent, very useful, so much grateful for this article.

  9. Thank You For Your Well Detailed And Explicit Explanation. God Bless You, Amen.

  10. Outstanding

  11. So cool

  12. very useful, so much grateful for this article.

  13. Thanks a lot. Very useful.

  14. Thank you so much. very useful tutorial...!

  15. Great Lesson!
    I used the SLOPE function, and created a scatter-plot with a trend line, both using the same data set.
    The SLOPE function gives a slightly different result from the equation displayed on the graph by formatting the trendline. Why? Do they use different methods to calculate the slope?

  16. Thank you for great explanation

  17. Any chance to update it for the last version of Windows? Thank you :)

  18. Very useful tutorial

    Just one thing that I can't get my head around. When I calculate slope and coefficient of correlation (and square it or use the =RSQ() to get the coefficient of determination) I do not get exactly the same slope or R-squared as when I use the "add Trendline" in excel. How can that be? And can I get the same result somehow?

    /Martin

    1. Thank you so much. very useful tutorial.

  19. I lie, the slope and intercept functions but a neat thing with the graph regression is being able to hid rows that may have outliers and see the regression line and equation update. The slope and intercept functions use the entire data set regardless of whether rows are hidden or not.

  20. Excellent, Thank you very much for the explanations.

  21. Very useful sir.

  22. Helpful

  23. Very good explanation with the excel formulae.

  24. Hi, why does the R Square value derived by the RSQ function different from what is derived through the the Data Analysis function?

  25. This was very useful and instructive , the example are very explicit and relatable to my current problem . Thanks for the help and i hope you continue your work. Well done

  26. Foud this tutorial so helpful. Need to know how to do multiple regression. Thanks

  27. Very helpful article

  28. This write up was of great help to me. Thank you.

  29. Why does the regression equation change from a + to a - of the intercept?

  30. Well done for this article and thank you for mentioning that XLSTAT is a professional solution for doing linear regression.
    A big thank you from the XLSTAT team! Nicolas

  31. Very good blog,thank so much for your effort in writing the posts.

  32. To whoever that has published this,
    You just saved my life! I can't thank you enough! You'll prosper!!!

  33. Good Job. Thank you very much.

  34. Hmm, you are indeed a great teacher! How can I get this tutorial in PDF?

  35. Thank you very much. I wish you more wins in all your affairs. Regards from Nigeria. ?

  36. You are an absolute beast! Thank you so much. This helped a ton. Excel is so powerful!

  37. very helpful

    Thank you!! Svetlana Cheusheva

  38. Mrs. Svetlana,

    Thank you for this post, it really helped me. Now if you do not mind I would like to ask a further question. If the alpha value of this equation was 0.05, should I accept or reject the null hypothesis? Any help or guidance in this matter would be much appreciated. Thank you for your time.

    Best Regards,
    Justin

  39. Super helpful! Thanks!

  40. Thanks for sharing the ARTICLE. Very helpful

  41. Thnak you for sharing this knowledge with us.

  42. How can you calculate the average monthly rainfall in here ..

  43. Very user friendly resource to understand.

  44. Simple and easy to understand. Well explained. Thank you!

  45. very interesting and precise guide.

  46. Great job on equation types To .be used in régressions.
    However in computing coefficient values, I cannot find the numeric equivalence of ^(1,2) in the formula, say,
    LINEST(C2:C13,B2:B13^(1,2),1).
    In other words, replacing the above two vactors by their row correspondance how does the above formula computes the coefficient values.
    Thank you

  47. Hi
    How can I run the Data Analysis regression and ignore data inputs such as "-" in the middle of the data table?

  48. This is the best clarification I have ever received in recent times. Thank you very much as this has just assisted with my data analysis for my MSc dissertation. I was at a crossroads until I saw this.

    Thanks very much you are a saving grace.

  49. thanks very much, it was very very helpful. it aided me complete my assignment.

  50. thank you so much very helpful!

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)