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

  1. Thanks for this.
    Any link for Logistic Regression?

  2. Thank you very much for the information . My assignment became very easy and understandable through the information provided here. It gave me the conceptual clarity.
    Heaps of thanks!

  3. Hi Mam,
    I find it extremely helpful for my M.Tech project where i have to perform regression analysis. But can you please tell me if we can use this LINEST function can be implemented for lognormal equations as ln(y)=a+bln(x)....

  4. Thank you so much @ Svetlana. It's been really helpful

  5. The tutorial was easy to understand and was also helpful. I am no longer a novice as far as regression analysis is concern. Thanks.

  6. Hi Svetlana,
    Thanks for your detailed and well-written article on regression in the Analysis Toolpak and also for mentioning RegressIt as a professional-grade alternative. I'd like your readers to know that RegressIt is free (unlike XLSTAT) and has many features that are designed to help users learn and apply best practices of regression modeling. Variables are selected from a list of names (rather than by entering coordinates of cell ranges), and there are tools for testing model assumptions, comparing models side by side, and sharing results with others in presentation quality format. The graphs and tables that it produces are far superior to what you get with the Analysis Toolpak, both in terms of design and in terms of the set of options that are available. RegressIt also includes very detailed built-in teaching notes that can be embedded in the model worksheets, and it has features that help instructors to grade and verify the originality of work submitted by students. Also, unlike the Analysis Toolpak, it has the capability to forecast from a regression model (including an option for interactive confidence limits on forecast charts), which addresses the question raised by one of your respondents (Syed, post #34). And one more thing: it includes a user-friendly interface with R that allows users to run both linear and logistic regression models in R without writing any code. This feature allows more sophisticated model testing to be carried out and provides a gentle introduction to the R environment for those without programming experience. I encourage you to mention some of these features to your readers, either in this list of comments or a separate post.
    Cheers,
    --Bob

  7. Thanks a lot ma'am

  8. Hi Svetlana,

    Your post is amazing; it must have helped millions including me.
    One simple confusion; now i can i forecast using this regression concept. So if have to predict future, i can use this concept.can you take one example.
    Many thanks in advance.

  9. So helpful. Thanks!

  10. THIS IS EXCELLENT, IT HAS HELP ME DOING MY PROJECT.

  11. This was so useful.. Thanks a ton

  12. I have two variables say time and one predictor variable. However, the predictor variable is classified into regions. Is there a possibility of having that captured in a regression output as a grouping variable in excel?

  13. Very helpful. Detailed and clear explanation.

  14. Thank you so much

    Please also send the link. How to do multiple regression, non-linear regression

    With your best Regards
    Tanveer

  15. Great explanation, much appreciated Excel Functions there!

  16. Thanks a lot.

  17. Mrs. Svetlana,
    Congratulations for great work on this topic.
    You made it easy to understand in short time.
    BRAVO

  18. Really helpful and easy to understand. Thanks.

  19. Thanks a lot! It`s very interesting and useful!

  20. Thanks a lot, it was too useful!

  21. my Significance F value is 6.07596E-31
    what does it mean?

    1. Hi Ali,
      It is a scientific notation that replaces part of the number with E+n, where E (exponent) multiplies the preceding number by 10 to the nth power. That is, 6.07596E-31 equals 6.07596x10^-31 (6.07596 times 10 to the -31st power).

      The Significance F value measures the reliability of the results. If it is less than 0.05 (5%), your model is OK. In your case, Significance F is far less than 5%, so your results are statistically significant.

      1. Hey! Can you also provide this data?

        1. Hey Mona, what data hey ! You send data 15000.

        2. Around 500 enteries if you have! please upload that too

  22. Very clear, helped me a ton. Thank you so much :)

  23. Am definitely getting an A with the explanation of these awesome work. Thank you

  24. that was really really helpful.

  25. Highly informative. I love that. God blesses you.

  26. Hi Svetlana,
    Your article is very nice and its self explanatory for beginners like me.

  27. so helpful! will be using this site more often

  28. do you have any post about what is difference between standardized versus non-standardized coefficient? i don't get it

  29. Why does # of observations equal # data points minus 1? It is not immediately apparent in your example because you include the title rows in your input ranges.
    Besides this one issue the article is great and extremely informative

    1. Hi Braden,
      It's a very good question.
      I included the header row in the input ranges to make it easier to interpret the regression analysis output, based on the column headers. The number of observations equals the number of data points (24 observations, rows 2-25); the header row is not counted because the Labels box was selected.

  30. Very good notes

  31. Wow! Thank you. I had to learn this for my statistics homework.

  32. So I completed the regression analysis for my assignment. So how do I figure out what actually goes on the graph? I tried two different sets of data, one produced two points on the graph and the other did not produce anything close to what your examples were. SOS

  33. very useful guide.thanks

  34. thank you ms. for your help

  35. hi! the article is very helpful, just a quick question, why is it that i cannot add a trendline? :( pls help

  36. The article is very nice keep posting

  37. Thanks Ms.Svetlana for the quick response. Your tutorial was very easy to understand as it went step by step, hand holding a novice..which is very important..! I really appreciate your effort in making complex issues simple. Do you have similar tutorial on Multiple regression, Pricing optimization ,Price bundling etc( in Excel), Decision tree Analysis etc.
    Would appreciate your advise.
    Regards
    Shankar

  38. For the regression analysis..where do I down load the date for the 'Ranfall-Umbrella" example..? Please advise..Thanks

  39. Thanks! Good easy to follow guide.

  40. So helpful!! Thank you!

  41. this was so helpful. hoping to learn more from this site

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