Excel to Solve Probabilities -Distributions -Degrees of Freedom

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]

... below (note that we need excel's built in ... on decision theory involving optimal solution, conditional probability and ... kill a human with probabilities 0.02, 0.03 ...

... with n = 10 and p = .3, use the formula to find the following probabilities. ... These problems can be solved manually, using the Excel spreadsheets you ...

... This solution provides work and answers in plain text regarding a ...Excel formulas are used and provided for calculations. ... 5. Find the following probabilities. ...

Probability and Statistics. ... Solution: -H0: σ<=5 -H1: σ>5 - Test statistic -X2=7.3^2/5^2=2.132 (how did you get the Xsquared=). ... (In the excel, we could use ...

... Model and use both the graphical method and Excel to find the optimal solution. ... 10,000 50,000 40,000 Order High -10,000 40,000 80,000 Probability 0.3 0.3 ...

... This solution is provided in a .doc and .xls file ... Use excel, we get the following ANOVA table. ... a uniform distribution, namely, each occurs with probability 1/30 ...

... [Please refer to the EXCEL attachment for ... Solution: No, it won't be appropriate to use the model ... p- value = 0.0000 This is the probability of failing to reject ...

... Characteristics of People who Excel at Critical ... truth of premises, sound Probability: certainty Reasoning ... problem you are trying to solve All ideas ...

... Characteristics of People who Excel at Critical Thinking. ... 10 Probability: certainty Reasoning from diverse facts ... you are trying to solve All ideas should ...

... As this probability is smaller than alpha=0.02, we should reject H0. Chapter 12. ... Use Excel, we get the following(see sheet 8). SUMMARY OUTPUT. ... Solution. ...