Purchase Solution

Confidence Interval for z and t test

Not what you're looking for?

Ask Custom Question

Run Excel and answer following questions. You need this problem sheet, answers, and the Excel output tables to take Webtest 3. You can use textbook, course slides as well.Webtest 3 will be open from Sat. 11/23 through Sun 11/24via Hawkes Learning System.

Most computer laptops use a rechargeable lithium-ion battery. However, with brighter computer displays and more powerful chips, batteries are not lasting any longer than they did on older computer laptop models.To determine the average number of hours of use that college student gets on a laptop before the batteries fail, 70students were randomly selected, and values of the variable LaptopBatteryLife were recorded.
Use the data file named Excel Assignment 3 dat..xls. The variable LaptopBatteryLife is defined as the number of hours that a laptop computer will function.

a. The population standard deviation is believed to be 0.8 hours. Now what is the 95% confidence interval for the mean lifetime? Interpret it.
What is the margin of error in this confidence interval? Calculate it using information from the output table

b. The population standard deviation is believed to be 0.8 hours. What is the 80% confidence interval for the mean lifetime? Interpret it.
What is the margin of error in this confidence interval? Calculate it using information from the output table

c. Compare confidence intervals from problem a and b. Which is wider?

d. Determine a 95% confidence interval for the mean battery lifetime assuming the population standard deviation is not known. Interpret it.
What is the margin of error in this confidence interval?

e. Determine a80% confidence interval for the mean battery lifetime assuming the population standard deviation is not known. Interpret it.
What is the margin of error in this confidence interval?

f. Compare confidence intervals from problem d and e. Which is wider?

Excel Instruction
You have done step 1 and 2 for Excel Assignment 1.
1. Download Excel Macro file and save it in your computer or memory stick.
2. Bring Add-ins and Macro in the Excel. (We did it with assignment 1).
(open Assignment 3 data file  click File tab from the top menu select optionsif you forgot details, refer to PowerPoint instruction file...)
If you see Add-Ins tab at the top menu bar of Excel page, it means that step 1 and 2 were successfully done.
3. Download Assignment 3 data file and save it as your own.
4. Excel steps are described in Textbook chapter 8 Appendix (page 325-326) using different example. Or you can refer to lecture slide Excel Macro part in 8.3 and 8.4 sections of chapter 8.
• Confidence Intervals for the Mean with Known Population Standard Deviation
:click Add-Ins tabKPK Data AnalysisOne Population InferenceAt Test for inference on, choose population mean (z statistic); assign input range; check label ; put population standard deviation; put alpha level (you learned this concept in lecture); check confidence interval; assign output range. Click ok.
• Confidence Intervals for the Mean with UnknownPopulation Standard Deviation
: follow same process except selecting population mean withest.std.dev.( t statistic)at Test for inference on:.

Attachments
Purchase this Solution
Solution Summary

This solution is comprised of a detailed explanation of confidence interval using the KPK Data Analysis which is a excel add ins. This solution mainly discussed the 95% and 80% confidence interval using z and t test. A logical answer is given for every situation for better clarity on using the interpretation of confidence interval.

Solution Preview

Run Excel and answer following questions. You need this problem sheet, answers, and the Excel output tables to take Webtest 3. You can use textbook, course slides as well. Webtest 3 will be open from Sat. 11/23 through Sun 11/24 via Hawkes Learning System.

Most computer laptops use a rechargeable lithium-ion battery. However, with brighter computer displays and more powerful chips, batteries are not lasting any longer than they did on older computer laptop models. To determine the average number of hours of use that college student gets on a laptop before the batteries fail, 70 students were randomly selected, and values of the variable LaptopBatteryLife were recorded.
Use the data file named Excel Assignment 3 dat..xls. The variable LaptopBatteryLife is defined as the number of hours that a laptop computer will function.

a. The population standard deviation is believed to be 0.8 hours. Now what is the 95% confidence interval for the mean lifetime? Interpret it.
What is the margin of error in this confidence interval? ...

Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

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.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

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.

View More Free Quizzes
Related BrainMass Solutions

  • Significance Tests and Confidence Intervals

    z test for proportions one-sample z confidence interval for proportions two-sample z test for proportions two-sample z confidence interval for proportions chi-square Please complete at least three significance tests and a confidence interval.

  • Statistics - One Sample t-test

    test for proportions one-sample z confidence interval for proportions two-sample z test for proportions two-sample z confidence interval for proportions Remember to state your question clearly, state Ho and Ha.

  • Hypothesis Test

    The formula for a confidence interval for m when s is estimated is: M - t*s < m < M + t*s where M is the sample mean, and t depends on the degrees of freedom and the level of confidence, usually we apply 95%.

  • Sample Mean

    The formula for a confidence interval for m when s is estimated is:
    M - t*s < m < M + t*s
    where M is the sample mean, and t depends on the degrees of freedom and the 95% level of confidence.

  • Confidence interval, t distribution, sample size, error

    Z corresponding to 95% confidence interval and 2 tailed test is 1.96 We have to see that Z* sp < 3% or sp < 3.

  • Sample Size, Margin of Error, Confidence Level

    test as we are checking the accuracy of plus minus 5% sp=standard error of proportion=square root of (pq/n) confidence interval= 95% Z corresponding to 95% confidence interval and 2 tailed test is

  • Hypothesis Testing & Confidence Interval

    (Note: Since the population standard deviation is given, z-test is more appropriate) If we use z-test, Standard error = = 2.529822128 The test statistic used is = 2.411236716 The 95% confidence interval is given by Confidence Interval Estimate

  • Two sided interval

    346663 T-distribution or CLT: Two sided interval analysis on test score Assume a very large normally distributed population of scores on a test with mean 77 and standard deviation 7. a.

  • Significance Testing Format

    (c) Under small sample assumption and variance (Var X)unknown Under small sample assumption the distribution follows a t-distribution and we should use t test.

  • Compute the mean

    the scores 4 & 7, and t-scores for 1 & 3.

View More Related Solutions