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

#### sweetheart

##### New Member
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.:wave:

#### sweetheart

##### New Member
Anybody? Its not in my book or on the internet.

#### bugman

##### Super Moderator
F is the ratio of the MSS between the factor and the residual error.

#### bugman

##### Super Moderator
It would be helpful if you attached your table so we can take a look at it

#### sweetheart

##### New Member
Significance F ???

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

#### bugman

##### Super Moderator
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

#### sweetheart

##### New Member
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

#### sweetheart

##### New Member
oh byw, hitting control ~ doesn't do anything.

#### Dason

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.

#### sweetheart

##### New Member
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.

#### Dragan

##### Super Moderator
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

#### sweetheart

##### New Member
Is there a formula to calculate Significance F?

#### Dason

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.

nevermind.

its Fcdf(.....)