Purchase Solution

Statistics: Confidence Intervals and Confidence Levels

Not what you're looking for?

Ask Custom Question

See the attached spreadsheet with data on the "number of children" of a sample. Compute the 95% and 99% confidence intervals using Excel's descriptive statistics function: Run Data Analysis, Descriptive stats, highlight the data, check "summary statistics" as normal. Click on "Confidence Level for Man" and type in the level desired. 95% is the default.

The descriptive stats output now will include a "confidence level" number at the bottom. This is the +/- number (sometimes called the "margin of error") of the confidence interval on the mean formula.

Compare the output to that from using the "confidence interval calculator" I posted.

What does the confidence interval mean?

Attachments
Purchase this Solution

Solution Summary

This solution shows calculations in an Excel file to determine the 99% and 95% confidence level and compare the values with the values in the 'confidence interval calculator'.

Solution Preview

I have attached the solution.

Column1

Mean 5.26
Standard ...

Purchase this Solution


Free BrainMass Quizzes
Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

Lean your Process

This quiz will help you understand the basic concepts of Lean.

Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.