Explore BrainMass

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 ≥ 1.75) where t10 has a t distribution with 10 degrees of freedom.

    (b) P (t100 ≥ 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 ≥ 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 ≤ -0.80) where t20 has a t distribution with 20 degrees of freedom.

    (e) P (t3 ≤ -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]

    © BrainMass Inc. brainmass.com June 3, 2020, 10:03 pm ad1c9bdddf
    https://brainmass.com/statistics/degrees-of-freedom/probability-and-degrees-of-freedom-analysis-with-excel-212796

    Attachments

    Solution Preview

    Please see the attached spreadsheet for explanation and formulas.

    using excel functions the follwing probabilities are calculated
    (a) P (t10 ≥ 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

    ADVERTISEMENT