Purchase Solution

Probability and Degrees of Freedom Analysis with Excel

Not what you're looking for?

Ask Custom Question

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]

Attachments
Purchase this Solution
Solution Summary

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

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

Purchase this Solution
Free BrainMass Quizzes
Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

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.

Measures of Central Tendency

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

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.

View More Free Quizzes
Related BrainMass Solutions

  • Excel to Solve Probabilities -Distributions -Degrees of Freedom

    to x and y The expert uses excel to solve probability, distribution and degrees of freedom.

  • Statistical relationship & cross tabulation

    Therefore, we get that the degrees of freedom are 2*3 = 6. The p-value is the probability in a chi-square distribution with 6 df to the right of 30.59. I calculated this in Excel, finding that the p-value is 0.00003.

  • T-Distributions with Excel Formulas

    465664 T-Distributions with Excel Formulas Please help with the following problem. For a t distribution with 16 degrees of freedom, find the area, or probability, in each region. a.) To the right of 2.120.

  • Analysis of variance

    76217 Analysis of variance..

  • Chi square distribution: probability statements.

    For example for a Chi-square distribution with 5 degrees of freedom, if you want to find the value of A such that , you simply type in any cell and hit .

  • Analyze Anova for Test Scores

    Areas to calculate: ANOVA Analysis Of Variance Correction for the Mean df degrees of freedom F F statistic used to compare with the F-table value ('critical value') MS Mean Square SS Sum of Squares So what

  • Testing of hypothesis problems

    What is the chi-square critical value with 12 degrees of freedom for a 0.05 probability? What is the exact probability of a value that fits a chi-square distribution with 17 degrees of freedom being higher than 30.995?

  • P Value

    The degrees of freedom for the numerator are the degrees of freedom for the between group (k-1) and the degrees of freedom for the denominator are the degrees of freedom for the within group (N-k).

  • ANOVA table F test

    The p-value, found either by using a table or a calculator with an F function is the probability that a randomly selected observation from an F distribution with 2 numerator degrees of freedom and 72 denominator degrees of freedom is greater than the

View More Related Solutions