I need help in setting up and solving the problem given below. The problem with necessary data is fully set up in the attached excel document.

INSTRUCTION: Include a "summary statement" for each CI.
Use the data for which is given in columns A:C.

FACTS / PROBLEM:

USE EXCEL AND EXCEL FUNCTIONS TO SOLVE:

(A) Give a 84% CI for the mean of Brand 1 minus mean lifetime (in hours) of Brand 2, using the formula for equal population variances.

(B) Repeat, but using the general formula for any relationship between the population variances.

Use excel to do this. Excel formulas will automatically give the output for both formulas. All you have to do is figure out where the answer is for each part and clearly indicate which cell has the answer.

The book gives guidance on which of the two CI outputs should be used. The one in (B) is always correct (unless the sample sizes are small and at least one population is not normally distributed). The one in (A) is sometimes correct as well. If the number in cell is "large" then the (A) result is also correct. People differ about what "large" would mean here. Anything larger than 0.25 would satisfy about everyone. Anything larger than 0.05 would be the rule for a substantial number of analysts. A few people would use 0.01 as the lower limit for "large". We can use 0.05 for this problem.

...Using Excel, construct a 90% confidence interval for the ... Answer 90% confidence interval: __4.21875__ +/- _0.811524971__. ... is fairly large, we can use the normal ...

... Would the decision be different if you used α = .01? ... (a) Construct a 95 ... By Using Excel Add ins Megastat confidence interval/sample size Summary. ...

... Then use excel to find the sample mean and sample ... B) Construct a 95% confidence interval estimate of the mean ... tα / 2 = 2.100922037 (Please see the excel sheet ...

... 3 Please solve the exercise below using Excel and show ...Construct a 99 percent confidence interval around the mean ... sample is fairly large, we can use the normal ...

... in simple steps in document file (no excel used) how to ... Please show all steps, no excel or any other ...Use the following information to construct the confidence...

... A3 and in cell B3, I typed the Excel function =NORM ... P(-0.73 < Z < 2.27) Again using the same method in cell ... sizes are all large (greater than 30), we use the Z ...

... this lab (described below) you will use a population ...Intervals worksheet in our Lab 6 Excel file (linked ... 1. Using Excel, find the z-score that corresponds to ...

... NOTE: Please use an Excel spreadsheet for response. ... Mean Volume 2. Procedure for Excel confidence interval for µ ...Using the mean for this sample, and assuming ...

...Construct the 99% confidence interval for the ... Statistics exercise 4 Please solve the exercise below using Excel and show your work (incl. formulas). ...