workshop12 - CHEN 3010 Applied Data Analysis Fall 2003...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
CHEN 3010 Applied Data Analysis Fall 2003 Names: __________________________ Workshop # 12 Inferences on the Mean: Variance Known Case The objectives of this workshop are to learn how to evaluate hypothesis tests, confidence intervals, and operating characteristic curves for the variance-known case of estimating the mean from a sample. Excel can be used conveniently for all these tests. 1. Group Member 1: Log on to a labstation computer and download the file Workshop12.xls from the course web site. 2. Launch Excel and open the Workshop12.xls workbook file. You will see a fairly large data set there. You will consider that to be a large enough set that it is representative of the entire population. Enter your group number and member names at the top of the worksheet. 3. Select all the data and name it viscdata (using the Name Box ). Enter a 1 in cell A3 and a 2 in cell A4 . Select both cells A3 and A4 and double-click on the fill handle. That should extend an index column alongside the data. How many data are there? ______ Enter the label mu in cell D3 and the formula =average(viscdata) in cell C3 . Name the C3 cell mu . Enter the label sigma in cell D4 and the formula =stdevp(viscdata) in cell C4 . Name the C4 cell sigma . You will take these values to be the true values of the mean ( μ ) and standard deviation ( σ ), even though these usually aren’t known. However, it is common to get good estimates for σ from long data histories. 4. In cell C6 , enter the formula =int(rand()*( <the total number of data> -25)) and enter the label location in cell D6 .
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 5

workshop12 - CHEN 3010 Applied Data Analysis Fall 2003...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online