Excel 2013 Statistical Analysis #48: Introduction to Confidence Intervals

preview_player
Показать описание
Topics in this video:
1. (00:35) Remind ourselves of what we did in Chapter 7: Population Mean & Standard Deviation Known and we compared Sample Mean (Xbar) to Sampling Distribution of Xbar.
2. (02:20) What we will do in Chapter 8: Population Mean not known so we create Confidence Intervals from Sample Mean (Xbar) and Margin of Error and estimate the probability that the Population Mean will lie within our Confidence Interval.
3. (03:33) Compare Chapter 8 to Chapter 7 with Printer Cartridge Company Example.
4. (05:48) Look at Visual that shows 100 Confidence Intervals and how most Intervals contains Population Mean, but a small number do not.
5. (07:13) Examples when it is impossible to calculate Population Means and thus we must use Sample Means (Xbar)
6. (08:04) Definition of Confidence Interval and Level of Significance / Alpha (Level of risk that the Interval will not contain the population mean)
7. (09:09) Formulas for building Confidence Intervals
  1. excelisfun
  2. Excel 2013
  3. Statistical Analysis
  4. Excel Statistics
  5. Highline College
  6. Business and Economic Statistical Analysis
Рекомендации по теме
Excel 2013 Statistical 0:14:02

Excel 2013 Statistical Analysis #48: Introduction to Confidence Intervals

Excel 2013 Statistical 0:41:36

Excel 2013 Statistical Analysis #8: Frequency Distributions, Histograms, Skew, Quantitative Variable

Excel 2013 Statistical 0:09:01

Excel 2013 Statistical Analysis #37: Introduction to Continuous Probability Distributions

Excel 2013 Statistical 0:10:03

Excel 2013 Statistical Analysis #47: Central Limit Theorem To Compare Sample Mean To Normal Curve

Excel 2013 Statistical 0:07:22

Excel 2013 Statistical Analysis #13: Scatter Chart & Trendline, X Y Data, 2 Quantitative Variabl...

Excel 2013 Statistical 0:13:05

Excel 2013 Statistical Analysis #14: VLOOKUP to Add New Field To Table & Create Cross Tabulation

Excel 2013 Statistical 0:24:16

Excel 2013 Statistical Analysis #70: Sampling Distribution of Pbar1 – Pbar2, Mean & Standard Err...

Excel 2013 Tutorial#48 0:04:44

Excel 2013 Tutorial#48 Histogram in Excel 2013

Excel 2013 Statistical 0:09:54

Excel 2013 Statistical Analysis #49: Create Confidence Intervals Sigma Known Z-Score (3 Methods)

Excel 2013 Statistical 0:14:29

Excel 2013 Statistical Analysis #62: Calculate Slope and Intercept for Regression Line

Excel 2013 Statistical 2:22:43

Excel 2013 Statistical Analysis #01: Using Excel Efficiently For Statistical Analysis (100 Examples)

Excel 2013 Statistical 0:05:23

Excel 2013 Statistical Analysis #46 Standard Error: Standard Deviation of Xbar Sampling Distribution

Excel 2013 Statistical 0:15:48

Excel 2013 Statistical Analysis #09: Cumulative Frequency Distribution & Chart, PivotTable &...

Excel 2013 Statistical 0:18:37

Excel 2013 Statistical Analysis #12: Cross Tabulation & Charts For Two Variables, Simpson’s Para...

Excel 2013 Statistical 0:07:01

Excel 2013 Statistical Analysis #52: Determine Sample Size for Sample Mean & Sample Proportion

Excel Statistical Analysis 0:11:02

Excel Statistical Analysis 46: Hypothesis Testing with T Distribution, 1 Tail Upper (Right) Test

Office 2013 Class 0:13:18

Office 2013 Class #27: Excel Basics 09: Keeping Data in Excel: Proper Data Set or Excel Table

Excel 2013 Statistical 0:06:30

Excel 2013 Statistical Analysis #29: Create Joint Probability Table from Raw Data & Calc Event P...

Basic Excel Business 0:06:37

Basic Excel Business Analytics #48: Data Analysis Regression feature

Excel 2013 Tutorial 0:07:22

Excel 2013 Tutorial for Beginners #48: Filtering Data

Excel 2013 Statistical 0:09:41

Excel 2013 Statistical Analysis #32: Expected Value Standard & Deviation Discrete Prob. Distribu...

Excel 2013 Statistical 0:20:17

Excel 2013 Statistical Analysis #5 Data Categorical, Quantitative, Nominal, Ordinal, Interval, Ratio

Excel 2013 Statistical 0:20:55

Excel 2013 Statistical Analysis #19: Location: Percentile, Quartile, Rank and Percentile Rank

Excel 2013 Statistical 0:26:57

Excel 2013 Statistical Analysis #43: Simple Random Sampling in Excel: Process & Theory

Комментарии
Автор

Excel 2013 Statistical Analysis #48: Introduction to Confidence Intervals
Topics in this video:
1. (00:35) Remind ourselves of what we did in Chapter 7: Population Mean & Standard Deviation Known and we compared Sample Mean (Xbar) to Sampling Distribution of Xbar.
2. (02:20) What we will do in Chapter 8: Population Mean not known so we create Confidence Intervals from Sample Mean (Xbar) and Margin of Error and estimate the probability that the Population Mean will lie within our Confidence Interval. 
3. (03:33) Compare Chapter 8 to Chapter 7 with Printer Cartridge Company Example.
4. (05:48) Look at Visual that shows 100 Confidence Intervals and how most Intervals contains Population Mean, but a small number do not.
5. (07:13) Examples when it is impossible to calculate Population Means and thus we must use Sample Means (Xbar)
6. (08:04) Definition of Confidence Interval and Level of Significance / Alpha (Level of risk that the Interval will not contain the population mean)
7. (09:09) Formulas for building Confidence Intervals
8.

excelisfun
Автор

Watched twice before fully got the point, may come back and review again in the future, but the way this video to clarify the difference between situation in chapter 7 and chapter 8 is great, especially the examples gives makes it more reasonable why scientist study the complicate formula and theory, great video ~

zhouyinwei