+ Reply to Thread
Page 1 of 2 1 2 LastLast
Results 1 to 15 of 16

Thread: What is 'Significance F' and what is its forumula?

  1. #1
    Points: 1,859, Level: 25
    Level completed: 59%, Points required for next Level: 41

    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Arrow What is 'Significance F' and what is its forumula?




    My prof is giving us an ANOVA table to fill in with limited data and he pointed to significance f. I thought it was nothing or could find it on my own. I can't. Any suggestions?

    Also, how can I find confidence intervals without having access to excel?

    This is a summer stats 2 class. Thanks.

  2. #2
    Points: 1,859, Level: 25
    Level completed: 59%, Points required for next Level: 41

    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Anybody? Its not in my book or on the internet.

  3. #3
    Super Moderator
    Points: 19,145, Level: 87
    Level completed: 59%, Points required for next Level: 205
    bugman's Avatar
    Posts
    1,823
    Thanks
    182
    Thanked 221 Times in 175 Posts
    F is the ratio of the MSS between the factor and the residual error.
    The earth is round: P<0.05

  4. #4
    Super Moderator
    Points: 19,145, Level: 87
    Level completed: 59%, Points required for next Level: 205
    bugman's Avatar
    Posts
    1,823
    Thanks
    182
    Thanked 221 Times in 175 Posts
    It would be helpful if you attached your table so we can take a look at it
    The earth is round: P<0.05

  5. #5
    Points: 1,859, Level: 25
    Level completed: 59%, Points required for next Level: 41

    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Significance F ???

    Here it is. Please open the link. I highlighted it but not if it was saved. Thanks.
    Attached Files

  6. #6
    Super Moderator
    Points: 19,145, Level: 87
    Level completed: 59%, Points required for next Level: 205
    bugman's Avatar
    Posts
    1,823
    Thanks
    182
    Thanked 221 Times in 175 Posts
    Ok, so the f-ratio is as I mentioned before.

    The significance F is your P-value (the p-value is the probability of obtaining a test statistic at least as extreme as the one that was actually observed, assuming that the null hypothesis is true) - in the case of regression: Ho: B1= 0
    The earth is round: P<0.05

  7. #7
    Points: 1,859, Level: 25
    Level completed: 59%, Points required for next Level: 41

    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Is there a way I can make the formulas visible in this worksheet? I'd like to get comfortable with how excel is doing the calculations.

    Thanks

  8. #8
    Points: 1,859, Level: 25
    Level completed: 59%, Points required for next Level: 41

    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts
    oh byw, hitting control ~ doesn't do anything.

  9. #9
    Beep
    Points: 60,867, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Awards:
    Discussion EnderPosting AwardCommunity AwardMaster TaggerFrequent Poster
    Dason's Avatar
    Location
    Ames, IA
    Posts
    11,033
    Thanks
    259
    Thanked 2,130 Times in 1,812 Posts
    Now I'm using my mac right now using Numbers 09 as opposed to Excel but it looks like the regression output was hard coded in. The summaries in the data seemed to be from formulas inside the spreadsheet but if the regression output was hard coded I don't think there's a way to recover the formulas that whoever made the spreadsheet used. I mean we could tell you what the formulas are in general (actually we'd probably just point you to a website that has the formulas). Now this might be wrong since I'm not using Excel but Numbers picks up the formulas usually.

  10. #10
    Points: 1,859, Level: 25
    Level completed: 59%, Points required for next Level: 41

    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Yes it came from mystatlab that my prof just loves using. Not really learning much from it b/c he doesn't teach it. Which I guess he should b/c I don't think businesses use the pencil paper method much. I wish minitab was taught.

  11. #11
    Super Moderator
    Points: 9,648, Level: 65
    Level completed: 99%, Points required for next Level: 2
    Dragan's Avatar
    Location
    Illinois, US
    Posts
    1,765
    Thanks
    0
    Thanked 139 Times in 125 Posts
    Quote Originally Posted by bugman View Post
    Ok, so the f-ratio is as I mentioned before.

    The significance F is your P-value (the p-value is the probability of obtaining a test statistic at least as extreme as the one that was actually observed, assuming that the null hypothesis is true) - in the case of regression: Ho: B1= 0
    Hi Bugman : The F-test, in this case, is testing the (null) hypothesis:

    Ho: B1=B2=0.

    The t statistics associated with X1 and X2 are separately testing the unique contribution (i.e. the squared semi-partial correlation) of each independent variable i.e. Ho1: B1=0 and Ho2: B2=0

  12. #12
    Super Moderator
    Points: 19,145, Level: 87
    Level completed: 59%, Points required for next Level: 205
    bugman's Avatar
    Posts
    1,823
    Thanks
    182
    Thanked 221 Times in 175 Posts
    Thanks Dragan - missed that.
    The earth is round: P<0.05

  13. #13
    Points: 1,859, Level: 25
    Level completed: 59%, Points required for next Level: 41

    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Is there a formula to calculate Significance F?

  14. #14
    Beep
    Points: 60,867, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Awards:
    Discussion EnderPosting AwardCommunity AwardMaster TaggerFrequent Poster
    Dason's Avatar
    Location
    Ames, IA
    Posts
    11,033
    Thanks
    259
    Thanked 2,130 Times in 1,812 Posts
    Do you mean is there a formula to calculate a p-value from an F statistic? Do you mean how do you calculate the F statistic? Are you wondering how to calculate the critical value for an F distribution? Can you elaborate on what you mean because what you're asking doesn't really make sense to me.

  15. #15
    Points: 1,859, Level: 25
    Level completed: 59%, Points required for next Level: 41

    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    nevermind.

    its Fcdf(.....)

+ Reply to Thread
Page 1 of 2 1 2 LastLast

           




Similar Threads

  1. ROC significance
    By Tikkuhirvio in forum Statistics
    Replies: 2
    Last Post: 11-05-2010, 03:56 AM
  2. Significance of Demographics
    By erhawkins3 in forum Statistics
    Replies: 5
    Last Post: 07-25-2010, 05:02 PM
  3. Replies: 2
    Last Post: 04-29-2009, 09:57 PM
  4. Help Please..significance
    By astros07 in forum Statistics
    Replies: 1
    Last Post: 12-10-2007, 08:59 AM
  5. Significance
    By rbottner in forum Statistics
    Replies: 2
    Last Post: 01-29-2007, 10:02 PM

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