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

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

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

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

  4. that was really really helpful.

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

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

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

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

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

  10. Very good notes

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

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

  13. very useful guide.thanks

  14. thank you ms. for your help

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

  16. The article is very nice keep posting

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

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

  19. Thanks! Good easy to follow guide.

  20. So helpful!! Thank you!

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