+ Reply to Thread
Results 1 to 2 of 2

Thread: Excel - is this a reliable data

  1. #1
    Points: 37, Level: 1
    Level completed: 74%, Points required for next Level: 13

    Thanked 0 Times in 0 Posts

    Excel - is this a reliable data


    I have got a data set that i am using the regression tool on and I just cant clarify to my self if this data if good enough or not.
    Nr. 1 : R Square , here I only get 46% fit which is not so good
    Nr. 2 : Significance F is very low, and what I have read if it is below 0.05 the results are reliable
    Nr. 3 : The P values are all below 0.05 so thats all good

    The main problem is that I am doing a presentation and I want to be able to fully justify what I am doing and why this data set is reliable enough.
    Can you give me some hints on how you would do that?

    Best regards
    Attached Images  

  2. #2
    TS Contributor
    Points: 14,811, Level: 78
    Level completed: 91%, Points required for next Level: 39
    Miner's Avatar
    Greater Milwaukee area
    Thanked 405 Times in 363 Posts

    Re: Excel - is this a reliable data

    These measures each tell you something different about your analysis.

    Working backwards on your questions:

    #3 This tells you whether a particular term should remain in your model. In this case the low p-values indicate that both the intercept and the term should stay in the model.
    #2 This tells you whether the regression model as a whole is significant. In this case it is.
    #1 This tells you whether the significant regression is any good at explaining the amount of variation observed. In this case, it's not very good. There may be a number of reasons why your R^2 is so low. The first suspect is the measurement variation. Others include missing variables, nonlinear relationships, missing covariates, noise factors, etc.

  3. The Following User Says Thank You to Miner For This Useful Post:

    hlynur11 (05-16-2017)

+ Reply to Thread


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Advertise on Talk Stats