Purchase Solution

Excel to Solve Probabilities -Distributions -Degrees of Freedom

Not what you're looking for?

Ask Custom Question

I'm having a problem Using Excel to Solve Probabilities - Distributions - Degrees of Freedom.

The question is listed below and the question with any relevant data is attached as an excel spread sheet.

PROBLEM:

Determine the following quantities using Excel:

(a) Find the value of x such that P (t10x ? X) = 0.75, where t10 has a t distribution with 10 degrees of freedom.

(b) Find the value of y such that P (t100x ? X) = 0.75, where t100 has a t distribution with 100 degrees of freedom. How do you explain the difference between this result and the result obtained in part a?

(c) Find the value of z such that z P (Z ? z) = 0.75, where Z is a standard normal random variable. Compare the results with the results obtained in part a and b. How do you explain the difference in the values of x, y, and z?

[PLEASE FIND THE EXCEL SPREAD SHEET WITH THE QUESTION AND ANY RELEVANT DATA ATTACHED]

Attachments
Purchase this Solution
Solution Summary

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

Solution Preview

Please see the attached for explanation and formulas.

a) P (t10x ? X) = 0.75

By using TINV(probability, degrees of freedom) we can get the value of x
TINV(0.75,10) is 0.327558265

b) P (t100x ? ...

Purchase this Solution
Free BrainMass Quizzes
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.

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.

View More Free Quizzes
Related BrainMass Solutions

  • Chi-square distribution: Probabilities and percentiles

    14901 How to find probabilities and percentiles of a chi-square distribution using EXCEL functions. Use a calculator to solve the following problems: Suppose that X follows a chi-square distribution with 28 degrees of freedom.

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

  • Probability and Degrees of Freedom Analysis with Excel

    212796 Probability and Degrees of Freedom Analysis with Excel PROBLEM: Compute the following probabilities using excel: (a) P (t10 ≥ 1.75) where t10 has a t distribution with 10 degrees of freedom.

  • Joint Probabilities

    11946 Joint Probabilities Variables Let Z be a standard normal random variable and let V have a chi-square distribution with n-degrees of freedom.

  • Multicollinearity / chi-square distributions

    Therefore, out of the two distributions on the same chart, one with 12 degrees of freedom would tend to approach a normal distribution. Answer two multiple choice questions on Multicollinearity and chi-square distributions

  • Goodness fit for Binomial distribution

    (c) The X^2 distribution lies between chi-square distributions with what degrees of freedom ? (d) Test the goodness of fit by finding the two critical values of part (c). What can you say about the p-value for the goodness-of-fit test?

  • Probability calculation using the Z score

    Consider an F distribution with numerator degrees of freedom and denominator degrees of freedom. Compute . Round your answer to at least three decimal places. ?

  • Chi square distribution: probability statements.

    The cell displays the value 1.610 (A is the 10th percentile of the chi-square distribution with 5 degrees of freedom). I did this for the probabilities in questions a. - e. and put them in the table below.

  • Hypothesis Testing of Mean..

    B. enter the appropriate degrees of freedom to use. Note: Use excel and explain why you used a certain method to solve this problem Please see the attachments.

View More Related Solutions