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 3. Total comments: 155

  1. Very useful sir.

  2. Helpful

  3. Very good explanation with the excel formulae.

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

  5. 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

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

  7. Very helpful article

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

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

  10. 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

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

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

  13. Good Job. Thank you very much.

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

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

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

  17. very helpful

    Thank you!! Svetlana Cheusheva

  18. 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

  19. Super helpful! Thanks!

  20. Thanks for sharing the ARTICLE. Very helpful

  21. Thnak you for sharing this knowledge with us.

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

  23. Very user friendly resource to understand.

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

  25. very interesting and precise guide.

  26. 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

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

  28. 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.

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

  30. thank you so much very helpful!

  31. Thanks Ms, great introduction specially for excel regression model

  32. well presented ,made so simple to get complete idea!

  33. 1.True or false: In simple regression analysis, if the intercept is negative, then there is a negative
    correlation between the dependent variable and the independent variable .

    2. True or false: The range of values that indicates that there is a significant difference between the
    value of the sample statistic and the proposed parameter value is called the rejection
    region.

  34. Very nice explanation. I have data in row wise instead of column wise. I am unable to run the regression. Please can you help me out in performing regression with row wise data

  35. Hello,

    I would like to know the mathematical formulas that Excel uses to calculate the linear regression coefficients. Can you help me?

    Umar

  36. Thank you so much for this very clear and helpful tutorial! It was really excellent.

  37. This was an amazing explanation, thank you very much ! :)

  38. required to chart a linear regression line, but it makes creating statistics tables simpler. To verify if installed, select Data from the toolbar. If Data Analysis is an option, the feature is installed and ready to use. If not installed, you can request this option by clicking on the Office button and selecting Excel options .

  39. I just want to say thank you for this well descriptive explanation of how to add in the data analysis, as well as explaining what to type in for the x and y ranges and what I could learn from the analysis once it was completed. This has helped me tremendously. Thank you!!!!

  40. Thanks a lot....best explanation ever.

  41. Thank you very much. The best explanation I've found. Wonderful!!!

  42. Hi Svetlana. I never place my comments but your tutorial is worth it! All other pages either just show how its done or explain it very "statistically". But you explained it like teaching to a child. Thank you again for this!

  43. Best explanation of regression ever. Very simple, clear and easy to understand. Thank you so much and will keep a tab on your tutorials.

  44. thanks a lot. really helped.

  45. Very well explained! Thanks.

  46. Hi!
    Also for me it was really helpful!
    Unfortunately I cannot produce a graph for a multiple linear regression. Is Excel not able to show it or do you have a tutorial about it, which could help me?
    Thanks!

  47. This write-up has really helped me, but I'm left with one other question:
    If I am using linear regression on a standard curve (say response over concentration) to obtain an equation that I can use to determine the concentration of unknown samples, how do I determine the uncertainty of the concentration value that this equation yields?

    Thank you for this tutorial, it was a lifesaver!

  48. I agree with Andre above. this is the clearest tutorial ever. So easy to follow.
    Further question, how do you deal with blank spaces in the data? If I chart it, I can still get a trend line and equation but if I try to work directly from the data it balks.
    Thank you very much

  49. Wow, first excel tutorial I read that is clear from A to Z...nice!

  50. Hi Svetlana,
    I really like your explanations for linear regression, but I am confused about your explanation on Significance F value. In the example you provided, you explained that If Significance F is less than 0.05 (5%), your model is OK. If it is greater than 0.05, you'd probably better choose another independent variable.
    But When responding to Ali's question whose Significance F value is 6.07596E-31, you said " in your case, Significance F is far less than 5%, so your results are statistically significant." So between (0.05) and (6.07), which one is greater than the other one?
    I have run my regression and my Significance F value is 0.005590647. Is this value (0.005) greater or less than (0.05)?
    Please, I am confused.

    1. Hi!

      6.07 is of course greater than 0.05. However, 6.07596E-31 is not 6.07, it is 0.000000000000000000000000000000607596! 6.07596E-31 is a special format (Scientific notation) used by Excel to display very large and very small numbers in a compact way. When responding to Ali's question I briefly explained about the Scientific format, you can find more info here: Scientific notation format in Excel.

      In your case, Significance F (0.005590647) is also less than 0.05 - the more zeros after the decimal point the smaller the number.

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 :)