In: Statistics and Probability
If X has a t-distribution with df = 14, find P(X < -1.42).
NEED STEP BY STEP ON HOW TO SOLVE IN EXCEL
Solution:
Given: X has a t-distribution with df = 14
We have to find P( X < -1.42 ) by using EXCEL.
In Excel 2010 or more version, use following Excel command:
=T.DIST(x , df , cumulative)
=T.DIST(-1.42,14,TRUE)
=0.08874606
=0.0887
Thus P( X < -1.42 ) = 0.0887
In older version like Excel 2007, use following command:
=TDIST( absolute t, df , tails)
=TDIST(1.42,14,1)