Explore BrainMass

# Probability and Degrees of Freedom Analysis with Excel

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

PROBLEM:

Compute the following probabilities using excel:

(a) P (t10 &#8805; 1.75) where t10 has a t distribution with 10 degrees of freedom.

(b) P (t100 &#8805; 1.75) where t100 has a t distribution with 100 degrees of freedom. How do you explain the difference between this result and the one obtained in part (a)?

(c) P (Z &#8805; 1.75) where Z is a standard normal distribution with 10 degrees of freedom. Compare this result to the results obtained in parts (a) and (b). How do you explain the difference in these probabilities?

(d) P (t20 &#8804; -0.80) where t20 has a t distribution with 20 degrees of freedom.

(e) P (t3 &#8804; -0.80) where t3 has a t distribution with 3 degrees of freedom. How do you explain the difference between this result and the one obtained in part (d)?

[PLEASE FIND AN EXCEL SPREAD SHEET WITH THE PROBLEM AND ANY NECESSARY DATA ATTACHED AS AN ATTACHMENT]

https://brainmass.com/statistics/degrees-of-freedom/probability-and-degrees-of-freedom-analysis-with-excel-212796

#### Solution Preview

using excel functions the follwing probabilities are calculated
(a) P (t10 &#8805; 1.75) = 0.055340472
By using TDIST(X, degrees of freedom , ...

#### Solution Summary

Probability and degrees of freedom analysis are analyzed by using excel. A t distribution is used.

\$2.19