Purchase Solution

Statistics - Normsdist and Tdist

Not what you're looking for?

Ask Custom Question

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".
"t".
1. What is the meaning of the number given in the P column under NORMSDIST?
2) What is the meaning of the number given in the P column under TDIST? ...

[Please see the attached question file.]

Attachments
Purchase this Solution
Solution Summary

The meaning of the number given in the P column under NORMSDIST and under TDIST are computed.

Solution Preview

The solution file is attached.

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".
What is the meaning of the number given in the P column under NORMSDIST?
The values in the P column under NORMSDIST give the areas under the Standard Normal Curve
( = 0,  = 1) from z = - to z = the table z- ...

Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

View More Free Quizzes
Related BrainMass Solutions

  • EXCEL probability functions

    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".

  • Sample Hypothesis Testing

    a. 0 =NORMSDIST(-0.7) b. 0 =TDIST(-0.70,999,1) c. 0 =2*(NORMSDIST(-0.7)) d. 0 =TDIST(0.7,999,2) Objective: Perform a hypothesis test of one population mean using the standard normal distribution. 3.

  • Statistics: Working with Random Samples of Patients

    Excel Tips: The Excel functions =TDIST and =TINV are similar to the functions =NORMSDIST and =NORMSINV and can be used to calculate T critical values.

  • AluminiCorp: Mean Aluminun Content, Promotion Code Stamps, Weight Bearing

    Excel Tips: The Excel functions =TDIST and =TINV are similar to the functions =NORMSDIST and =NORMSINV and can be used to calculate T critical values. See the Excel helpfile for instructions on the syntax for this function.

  • Psychological Statistics

    427115 Psychological Statistics questions 1. If an original set of measurements is made in inches and has a mean of 36 and a variance of 144, what will be the mean, variance, and standard deviation if: a) the unit is changed to feet?

  • statistics question - normal distribution

    (Z value is 0)
    b)>115 - 15.865 percent ( 1-Normsdist(1))
    c) between 100 and 130 = 47.7225% ( area between Z(0) AND Z(2).

  • T-Distributions with Excel Formulas

    .) __________ Solution: Note that the Excel function =TDIST(x,df,1) gives the probability P(t > x) and the function =TDIST(x,df,2) gives the probability P(|t| > x).

  • QMTH 205Lab 3:Probability Distribution & Interval Estimation

    You may start with fx button and select the function NORMSDIST. When you enter addresses, pay attention to Absolute Reference and Relative Reference so you can correctly copy this formula to the rest of the table.

  • Probability distribution

    =NORMSDIST(2.28)-NORMSDIST(-1.16) Ans: 0.8657 2. =1-NORMSDIST(1) Ans: 15.87 3. =NORMSINV(1-0.09) Ans: 1.3408 4. Standard Deviation = 16/sqrt(64) = 2 =1-NORMDIST(91.8,89,2,1) Ans: 0.0808 5.

View More Related Solutions