Question

3. a. Complete the sentence: _____ is an Excel function that returns the student's t-distribution. a....

3.

a.

Complete the sentence: _____ is an Excel function that returns the student's t-distribution.

a.

TINV
b.

TDIST
c.

TTEST
d.

TSTAT

B.

Complete the sentence: _____ is an Excel function that returns the inverse of the student's t-distribution.

a.

TINV
b.

TDIST
c.

TTEST
d.

TSTAT
Math   Statistics-And-Probability   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

A): Option b: TDIST is an excel function which returns the students t distribution.

Basically, TDIST gives us the p value. TDIST(x, df, tails) will give us the p value for the t observed, df = n - 1 and either for a left tailed or a 2 tailed test. If p value is required for a right tailed test, get the left tailed p value, and then (1 - left tailed p value) = Right tailed p value.

___________________________________________________________________

B) Option a: TINV is an excel function which returns the inverse of the students t distribution.

TINV basically is used to give us critical values while doing hypothesis testing or calculing t scores, when the probabilities are known. If the significance level is given, with n - 1 degrees of freedom, then TINV(probability, df), will return the 2 tailed critical value.

TINV(Probability*2,df) returns the left tailed critical value and TINV(ABS(probability*2),df) gives us the right tailed critical value for t.

________________________________________________________________________

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Student's t Distribution CI (PLEASE SHOW EXCEL FUNCTIONS) The manager of The Cheesecake Factory in Boston...
Student's t Distribution CI (PLEASE SHOW EXCEL FUNCTIONS) The manager of The Cheesecake Factory in Boston would like to know the mean number of customers served on weekdays. She believes that the number of customers served follows a Normal distribution. She reports that on six randomly selected weekdays an average of 158.3 customers were served with a sample standard deviation of 52.2. (EXCEL FUNCTIONS) a. Calculate the standard error of the sample mean. (EXCEL FUNCTIONS) b. Find the t-critical value...
The Student's t distribution table gives critical values for the Student's t distribution. Use an appropriate...
The Student's t distribution table gives critical values for the Student's t distribution. Use an appropriate d.f. as the row header. For a right-tailed test, the column header is the value of α found in the one-tail arearow. For a left-tailed test, the column header is the value of α found in the one-tail area row, but you must change the sign of the critical value t to −t. For a two-tailed test, the column header is the value of...
The Student's t distribution table gives critical values for the Student's t distribution. Use an appropriate...
The Student's t distribution table gives critical values for the Student's t distribution. Use an appropriate d.f. as the row header. For a right-tailed test, the column header is the value of α found in the one-tail area row. For a left-tailed test, the column header is the value of α found in the one-tail area row, but you must change the sign of the critical value t to −t. For a two-tailed test, the column header is the value...
(a) Use the Student's t distribution to find tc for a 0.99 confidence level when the...
(a) Use the Student's t distribution to find tc for a 0.99 confidence level when the sample is 17. (Round your answer to three decimal places.) (b) Use the Student's t distribution to find tc for a 0.95 confidence level when the sample is 15. (Round your answer to three decimal places.)
A)Use the Student's t distribution to find tc for a 0.99 confidence level when the sample...
A)Use the Student's t distribution to find tc for a 0.99 confidence level when the sample is 27. (Round your answer to three decimal places.) B)Use the Student's t distribution to find tc for a 0.90 confidence level when the sample is 6. (Round your answer to three decimal places.)
a. Use the Student's t distribution to find tc for a 0.99 confidence level when the...
a. Use the Student's t distribution to find tc for a 0.99 confidence level when the sample is 8. (Round your answer to three decimal places.) b. Use the Student's t distribution to find tc for a 0.90 confidence level when the sample is 8. (Round your answer to three decimal places.) c. Sketch the area under the standard normal curve over the indicated interval and find the specified area. (Round your answer to four decimal places.) The area to...
1. In R, inverse probability distribution functions start with q (no reason why really; it’s just...
1. In R, inverse probability distribution functions start with q (no reason why really; it’s just a convention). To calculate the critical value for a two-tailed t-test with n − k = 100 and α = 0.05, use the inverse t distribution command. For the inverse t function, type qt(1-0.05/2, 100). To find the one-tailed critical value for a t distribution for α = 0.01 and 100 degrees of freedom, type qt(1-0.01, 100). 2. To find the critical value from...
The Student's t distribution table gives critical values for the Student's t distribution. Use an appropriate...
The Student's t distribution table gives critical values for the Student's t distribution. Use an appropriate d.f. as the row header. For a right-tailed test, the column header is the value of α found in the one-tail area row. For a left-tailed test, the column header is the value of α found in the one-tail area row, but you must change the sign of the critical value t to −t. For a two-tailed test, the column header is the value...
11) The Student's t distribution table gives critical values for the Student's t distribution. Use an...
11) The Student's t distribution table gives critical values for the Student's t distribution. Use an appropriate d.f. as the row header. For a right-tailed test, the column header is the value of α found in the one-tail area row. For a left-tailed test, the column header is the value of α found in the one-tail area row, but you must change the sign of the critical value t to −t. For a two-tailed test, the column header is the...
A Poisson distribution has λ = 4.7.   (a )[2] Use the Excel function POISSON.DIST() and 5...
A Poisson distribution has λ = 4.7.   (a )[2] Use the Excel function POISSON.DIST() and 5 decimals to fill in the following table: 4 x 0 1 2 3 4 5 6 7 8 9 10 11 12+ P(x) (b)[2] Use a column chart to visualize the probability distribution above. How is it skewed? (c)[1] Find P(x ≤ 3). [steps & result] (d)[1] Find P(x ≥ 7). [steps & result] (e)[2] Find P(5 < x ≤ 9). [steps & result]...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT