Question

In: Statistics and Probability

Using, Microsoft Excel, how do you construct a 95% confidence interval for the difference in means?...

Using, Microsoft Excel, how do you construct a 95% confidence interval for the difference in means?

I have two extremely long lists of numbers and need someone to explain the process.

Solutions

Expert Solution


Related Solutions

how do you calculate 95% confidence interval using population variance
how do you calculate 95% confidence interval using population variance
Construct the indicated confidence interval for the difference between the two population means.
Construct the indicated confidence interval for the difference between the two population means. Assume that the two samples are independent simple random samples selected from normally distributed populations. Do not assume that the population standard deviations are equal. Independent samples from two different populations yield the following data. The sample size is 478 for both samples. Find the \(85 \%\) confidence interval for \(\mu_{1}-\mu_{2}\). \(\bar{x}_{1}=958, \bar{x}_{2}=157, s_{1}=77, s_{2}=88\) A. \(800<\mu_{1}-\mu_{2}<802\) B. \(791<\mu_{1}-\mu_{2}<811\) C. \(793<\mu_{1}-\mu_{2}<809\) D. \(781<\mu_{1}-\mu_{2}<821\)
Find a 95% confidence interval for the difference of two means when you have independent samples,...
Find a 95% confidence interval for the difference of two means when you have independent samples, both of size 36, from two populations, in which the variances are not known to be equal. In this case, n1=36, s12=8.2, the first sample mean is equal to 7.9; n2 =36, s22=10.4, the second sample mean is equal to 9.1 Interpret the interval once you find it. Namely, can you conclude one mean is greater than the other mean and if so, which...
Construct the indicated confidence interval for the difference between the two population means. Assume that the...
Construct the indicated confidence interval for the difference between the two population means. Assume that the two samples are independent simple random samples selected from normally distributed populations. Do not assume that the population standard deviations are equal. A paint manufacturer wished to compare the drying times of two different types of paint. Independent simple random samples of 11 cans of type A and 9 cans of type B were selected and applied to similar surfaces. The drying times, in...
Construct the indicated confidence interval for the difference between the two population means. Assume that the...
Construct the indicated confidence interval for the difference between the two population means. Assume that the two samples are independent simple random samples selected from normally distributed populations. Also assume that the population standard deviations are equal (sigma1 = sigma2), so that the standard error of the difference between means is obtained by pooling the sample variances. A paint manufacturer wanted to compare the drying times of two different types of paint. Independent simple random samples of 11 cans of...
In constructing 95% confidence interval estimate for the difference between the means of two populations, where...
In constructing 95% confidence interval estimate for the difference between the means of two populations, where the unknown population variances are assumed not to be equal, summary statistics computed from two independent samples are: ?1=45,?̅1=756,?1=18,?2=40,?̅2=762,?2=15 (using 2-sample T menu) a. Calculate the 95% confidence interval for the true difference of two means. b. Base on the interval in the previous question, can one conclude there is a difference in means of two populations? Justify your answer.
Construct the 95% confidence interval for AOret using its the mean and standard deviation. Construct another...
Construct the 95% confidence interval for AOret using its the mean and standard deviation. Construct another 95% confidence interval for AOret using the mean of AOret and the average AOSD. Explain which one is more reliable. Date AllOrd Aoret AOSD AUDUSD AUDSD TV (m) IR (%) MV PE 2000/4/28 3085.1 0.0703 0.5909 0.0253 5122.6 5.72 634878 22.08 2000/5/31 3040.6 -1.44% 0.0451 0.5735 0.0358 6373.5 5.98 616440 21.36 2000/6/30 3257.6 7.14% 0.0337 0.5986 0.0383 7439.0 6 661306 22.74 2000/7/31 3213.6 -1.35%...
Construct a 95% confidence interval for u1 - u2 using the data presented in the table...
Construct a 95% confidence interval for u1 - u2 using the data presented in the table below: Flight Control 8.59 8.64 7.43 7.21 8.65 6.99 8.40 9.66 6.87 7.89 9.29 6.85 7.62 7.44 8.55 8.70 7.00 8.80 9.30 8.03 7.33 8.58 9.88 9.94 6.39 7.54 7.14 9.14 Let Ho be the null hypothesis that the vote is independent of age (that is there is no age gap in the vote). Test the null hypothesis at the x=0.10 significance level.
(a) Explain what "95% confidence" means in a 95% confidence interval? (b) What type of variable...
(a) Explain what "95% confidence" means in a 95% confidence interval? (b) What type of variable is required to construct a confidence interval for a population proportion? (c) Explain why quadrupling the sample size causes the margin of error to be cut in half?
Calculate the 95% confidence interval for the difference (mu1-mu2) of two population means given the following...
Calculate the 95% confidence interval for the difference (mu1-mu2) of two population means given the following sampling results. Population 1: sample size = 14, sample mean = 12.96, sample standard deviation = 1.38. Population 2: sample size = 12, sample mean = 2.55, sample standard deviation = 1.05.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT