Files To Download for Chapter 07:
Zipped Raw Data Files For Whole Textbook: HomeworkRawDataFiles.zip
Excel file: Busn210ch07.xlsm
PDF file: Busn210Ch07.pdf
PowerPoint file: MBS4ch07.pptx There is some good information about sampling techniques in these that was not covered in videos.
Videos To Watch:
Excel 2010 Statistics 65: Sample Mean Xbar and Probability, Not X values
Excel 2010 Statistics 66: Simple Random Sample Using RAND Function, Sort and
Copy Paste
Excel 2010 Statistics 67: Formula To Extract Simple Random Sample
Excel 2010 Statistics 68: Construct Sampling Distribution Of Samples Means
(Xbar)
Excel 2010 Statistics 68.5: Sparklines to Compare Population and Sampling
Distributions
Excel 2010 Statistics 69: Probability That Sample Mean Occur w/ Given Margin Of
Error (3 Examples)
Excel 2010 Statistics 70: Standard Error and Correction Factor For Finite
Populations
Excel 2010 Statistics 71: Sampling Distrib. Of X Bar As Sample Size Increase Probability Increase
Excel 2010 Statistics 72: Sampling Distribution of Sample Proportion