F and T Tests using Excel

[davygryan]

I have to carry out F and T tests on some sample data.
I am not that well versed on Minitab, so is there any may to do this in Excel?

I have two sets of data each with six sample points that I need to compare

 

[doofusboy]

uhhhh, ok, I'll bite........what the H-E-double hockey sticks are "F and T tests"?

 

[xenou]

^^ very well known tests in statistical analysis.

 

[doofusboy]

thanks, weren't 'very well known' to me....learn something new everyday

 

[Paul Barber]

Have you tried the data Analysis tools yet? Both are available there.

 

[mgirvin]

Maybe these videos will help for T test:

Excel Statistics 82: Confidence Interval Sigma Not Known TINV function

http://www.youtube.com/watch?index=2&feature=PlayList&v=sn5_vMaB1YE&list=PLC54F478AEBCE4EE4

Excel Statistics 83: Confidence Interval For Advertising TINV function

http://www.youtube.com/watch?v=Nyg96qnYBg0&feature=watch_response

Excel Statistics 91: TINV & TDIST functions for Critical Value and P-value 6 examples

http://www.youtube.com/watch?index=3&feature=PlayList&v=N_BGWCA5-sQ&list=PL5FA1BCF602A329A1

Excel Statistics 92: Hypothesis Test T Distribution

http://www.youtube.com/watch?v=IQ8U7l1_JJs&feature=watch_response


The link to get the workbooks for the examples in the video is:

http://people.highline.edu/mgirvin/ExcelIsFun.htm

Scroll down to statistics class section.

I have no videos on F distribution.