Explore BrainMass

Explore BrainMass

    EXCEL probability functions

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

    Here are tables of the Standard Normal and Student's t distributions. The formulas for the first value in each P column are, respectively =NORMSDIST(A3) and =TDIST(C3,20,2), where column A is the one labeled "Z" and column C is labeled "t".

    I need some help in finding the meaning of the number given in the P column under NORMSDIST? and the meaning of the number given in the P column under TDIST?
    and if it is a probability. What probability is it?

    © BrainMass Inc. brainmass.com June 3, 2020, 8:37 pm ad1c9bdddf
    https://brainmass.com/statistics/normal-distribution/probability-functions-excel-145500

    Attachments

    Solution Summary

    This solution explains the use of some of the probability functions in Excel.

    $2.19

    ADVERTISEMENT