Purchase Solution

Steps on finding confidence intervals using excel

Not what you're looking for?

Ask Custom Question

Suppose that, for a sample size n = -100 measurements, we find that x = 50. Assuming that the standard deviation equals 2, calculate confidence intervals for the population mean with the following confidence levels:

a) 95% b) 99% c) 97% d) 80% e) 99.73% f) 92%

Purchase this Solution
Solution Summary

The solution gives detailed steps on finding confidence intervals using Excel.

Solution Preview

Please see the attachment for the complete solution. Please check relevant cell to formula used.

We are given:

mean: 50
sd: 2
n: 100

a) for a 95% confidence level, the critical value is: ...

Purchase this Solution
Free BrainMass Quizzes
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.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

View More Free Quizzes
Related BrainMass Solutions

  • Finding Correct Z and T Scores for Confidence Intervals

    285945 Statistics: finding correct z and t scores for confidence intervals Finding appropriate z- and t-scores is important when constructing confidence intervals.

  • Statistical Analysis: Confidence Interval Determination

    Thanks for using BrainMass. The solution gives detailed steps on solving 5 statistical problems using normally distributed data such as finding confidence intervals, finding z-score and finding p-value.

  • Confidence Intervals In Excel Worksheet

    653669 Confidence Intervals In Excel Worksheet In this lab we will use Excel to construct a confidence intervals for the true mean mileage per gallon (MPG) for a particular SUV.

  • Regression/Confidence Intervals for Marketing Department

    The solution gives detailed steps on running a simple regression using excel and then analyzing further results such as building confidence intervals and prediction intervals for dependent variable.

  • Confidence Intervals & T-tests

    The solution gives detailed steps on building the confidence interval and performing a one-sample t test for the given data using excel.

  • Hypothesis Testing and Confidence Intervals with Minitab

    -d. as well as the confidence intervals, and including all Minitab output Please find the solutions written in the attachment entitled "Hypothesis Testing and Confidence Intervals" (including graphs), the excel work done in the Excel attachment and the

  • MAT300 M&M project 3

    You can repeat the process using the same steps (described below), it should be a simple matter to find the other confidence intervals. Please see attached files. The expert examines confidence intervals for proportions of M&M's.

  • Confidence Intervals in Excel

    522583 Confidence Intervals in Excel Can you put this on excel for me? I attempted several times and I can't figure out where I'm going wrong.

  • Confidence Interval for z and t test

    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.

View More Related Solutions