Question

Can I use this to compute confidence interval in Excel =CONFIDENCE.T(alpha,SQRT(Pooled Variance),Observation).

Can I use this to compute confidence interval in Excel

=CONFIDENCE.T(alpha,SQRT(Pooled Variance),Observation).

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Yes,

We can use this function in excel. when we want to find the confidence interval for differences of two population with assume that the two population variances are equal.

Note that,

Observation means Sample Size.

Standard Deviation is Square root of Pooled variance.

Add a comment
Know the answer?
Add Answer to:
Can I use this to compute confidence interval in Excel =CONFIDENCE.T(alpha,SQRT(Pooled Variance),Observation).
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • pie random samples from two popuns. Use the pooled lost and the pooled interval procedure to...

    pie random samples from two popuns. Use the pooled lost and the pooled interval procedure to conducteur est and contre Provided below are summary stics for independent specified confidence interval X - 17,, 4, n, - 19.20, 5, 5, n. 14 a. Loft-aid lost 0.05 b. 90 confidence interval Compute the test statistic - - 1915 (Round to three decimal places as needed.) Determine the P-value P=0.0324 (Round to four decimal places as needed.) Since the P value is equal...

  • Provided below are summary statistics for independent simple random samples from two populations. Use the pooled​...

    Provided below are summary statistics for independent simple random samples from two populations. Use the pooled​ t-test and the pooled​ t-interval procedure to conduct the required hypothesis test and obtain the specified confidence interval. x overbar 1 = 11​, s 1 = 2.4​, n 1=10​, x overbar 2= 14​, s 2= 2.2​, n 2= 10 a.​ Two-tailed test, alpha =0.05 b. 95​% confidence interval (can you please show me how to input it onto calculator) ( I need help finding...

  • 14. (4 points) Given the following information, caleulate Sg, the pooled sample variance that should be...

    14. (4 points) Given the following information, caleulate Sg, the pooled sample variance that should be used in the pooled-variance t test 416 6,25 C.S:-4 D.sg-5.23 А.sg-6 B.sj-5 15. (5 points) If standard deviation σ is unknown, the population is normally distributed, and the sarmple size n is small. What kind of confidence interval should we use for population mean μ?

  • I have misleading data on independent pooled variance std dev 1= 51.95   and std dev 2=...

    I have misleading data on independent pooled variance std dev 1= 51.95   and std dev 2= 61.92 do we use the pooled variance test since the quotient between them is 0.83   between 0.5 and 2. . therefore to use pooled method. However, I received a response telling that we need to use the unpooled method. please clarify.

  • Provided below are summary statistics for independent simple random samples from two populations. Use the pooled​...

    Provided below are summary statistics for independent simple random samples from two populations. Use the pooled​ t-test and the pooled​ t-interval procedure to conduct the required hypothesis test and obtain the specified confidence interval. x1= 13, s1= 2.3, n1= 19, x2= 16, s2= 2.4, n2=19 a. What are the correct hypotheses for a​ left-tailed test? b. Compute the test statistic. c. Determine the​ P-value. d. The 95​% confidence interval is from _____ to _______ ?

  • Provided below are summary statistics for independent simple random samples from two populations. Use the pooled​...

    Provided below are summary statistics for independent simple random samples from two populations. Use the pooled​ t-test and the pooled​ t-interval procedure to conduct the required hypothesis test and obtain the specified confidence interval. x1=22, s1=44​, n1=20, x2=24, s2=55​, n2=16 a. What are the correct hypotheses for a​ left-tailed test? b. Compute the test statistic. c. Determine the​ P-value. d. The 90​% confidence interval is from _____ to _____ ?

  • A (1-alpha)*100% confidence interval for population mean Mu can also be used to test a hypothesis...

    A (1-alpha)*100% confidence interval for population mean Mu can also be used to test a hypothesis about Mu? 1. True 2. False

  • If we are constructing a 90% confidence interval for the variance of a population using a...

    If we are constructing a 90% confidence interval for the variance of a population using a sample of size 16, the two critical values for chi-square from the table that we need to use are  and   (use the three decimal place accuracy that the table gives you) wondering if I have to take 16-1 for this question.

  • Do not use MS Excel or statistics software unless stated otherwise (1 -2) (Confidence Interval) T...

    Do not use MS Excel or statistics software unless stated otherwise (1 -2) (Confidence Interval) The following sample data are measurements of weight of middle school students. 153,148, 151, 163, 114,164, 135, 131,176 (25%) Assume that we do not know the true standard deviation of middle school students Calculate the two-sided 95% confidence intervals on the mean (find both upper and lower limits). I. 2. (25%) Assume now that we know the standard deviation of all middle school students is...

  • Compute the correct quantile for the margin of error of each confidence interval (Use 3 decimal...

    Compute the correct quantile for the margin of error of each confidence interval (Use 3 decimal places.) (a) A 98% confidence interval for  based on n = 11 observations with  known. (b) A 98% confidence interval for  based on n = 11 observations with  unknown. (c) A 90% confidence interval for a population proportion based on n = 11 observations (d) A 92% confidence interval based on n = 14 observations for the slope parameter  

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT