Use Excel to Construct Confidence Intervals
Not what you're looking for?
See the attached file.
Please 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.
Purchase this Solution
Solution Summary
The solution uses Excel to construct confidence intervals.
Purchase this Solution
Free BrainMass Quizzes
Terms and Definitions for Statistics
This quiz covers basic terms and definitions of statistics.
Measures of Central Tendency
This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.
Know Your Statistical Concepts
Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.
Measures of Central Tendency
Tests knowledge of the three main measures of central tendency, including some simple calculation questions.