The number of passengers passing through a large airport is normally distributed with a mean of 110,000 persons per day and a standard deviation of 20,200 persons. If you select a random sample of 16 days. How do I calculate the lower and upper values at 60%? Preferably using Excel.
Equation
- Thread starter Steve123
- Start date
mmm4444bot
Super Moderator
- Joined
- Oct 6, 2005
- Messages
- 10,902
Posting Guidelines (Summary)
Welcome to our tutoring boards! :) This page summarizes the main points from our posting guidelines. As our name implies, we provide math help (primarily to students with homework). We do not generally post immediate answers or step-by-step solutions. We don't do your homework. We prefer to...
www.freemathhelp.com
[imath]\;[/imath]
Dr.Peterson
Elite Member
- Joined
- Nov 12, 2017
- Messages
- 16,087
Have you tried searching for "confidence interval in Excel"? Here are two results:
CONFIDENCE function - Microsoft Support
This article describes the formula syntax and usage of the CONFIDENCE function, which returns the confidence interval for a population mean, using a normal distribution.
support.microsoft.com
How to Calculate Confidence Interval in Excel? - QuickExcel
In this tutorial, we'll learn how to calculate Confidence Interval in Excel. But before that, let's begin by understanding what it exactly is and how the
quickexcel.com
(Don't miss the distinction between CONFIDENCE.NORM and CONFIDENCE.T. Do you know how to tell which is appropriate?)