Mula Education Society’s
Shri Dnyaneshwar Mahavidyalaya Newasa
Department of B. Sc. (CS)
Practical No: 07 Date: / / 2025
Practical Title: Computation of probability values for t distribution and
F distribution using MS-Excel command.
----------------------------------------------------------------------------------------------------
Q.1) If 𝑡𝑛 follows Student t- distribution with n d.f. find-
a) P( 𝑡15 > 1.341 )
b) P( 𝑡10 > 3.9 )
c) P( 𝑡12 < 6 )
Q.2) Suppose X is r.v. assumed to follow student t- distribution with 12 d.f. Find the constant
C such that P ( X ≤ C ) = 0.10.
Q.3) If 𝑡𝑛 follows Student t- distribution with n d.f. find-
a) P( |𝑡8 | ≤ 2.306 )
b) P( |𝑡10 | > 1.812 )
c) a such that P ( 𝑡15 ≤ a ) = 0.1
Q.4) Find:
a) P ( 𝐹24,20 > 2.08 )
b) P ( 𝐹7,6 > 4 )
c) k such that P ( 𝐹8,12 ≥ k ) = 0.8
Q.5) Let X have Snedecor’s F distribution with 2 and 8 d.f. If P ( X ≤ a ) = 0.01 and
P ( X ≥ b ) = 0.99, find –
a) a and b
b) P ( X ≤ a ) + P ( X ≥ b )