STAT 385: Class Examples

Examples

Chapter 10 Examples:
Exercise 26
Exercise 28

Stratified Example: This is an Excel Spreadsheet of Example 8.3 covered in class on Friday, February 24th. It illustrates how to get a stratified sample with proportional sample sizes.

Systematic Sample This is an Excel Spreadsheet of Problem 14 in chapter 8 covered in class on Wednesday, February 22nd. It illustrates how to get a systematic sample.

Simple Random Sample This is an Excel Spreadsheet of Example 8.1 covered in class on Monday, February 21st. It illustrates how to get a simple random sample.

Invest Example: This is an Excel Spreadsheet of the Market Data example covered in class on Friday, February 3rd. It illustrates how to calculate the expected value, variance, and standard deviation of weighted sum of random variables.

Products Demand Example: This is an Excel Spreadsheet of the Invest example covered in class on Wednesday, February 1st. It illustrates the how to directly calculate the marginal and conditional distributions using the joint probability distribution function.

GM Gold Example: This is an Excel Spreadsheet of the Invest example covered in class on Monday, January 30th. It illustrates the how to assess the joint probability using different scenarios.

Market Data Example: This is an Excel Spreadsheet of the Market Data example covered in class on Friday, January 27th. It illustrates the use of the =SUMPRODUCT, =RAND, =VLOOKUP functions to calculate the expected value, variance, and standard deviation of a probability distribution and simulate a discrete probablity distribution.