********************************************************* PCLAB #2 (1) Start MINITAB as before. Remember to enable the command language. Also launch WORD or WORDPERFECT so that you can paste any results you want printed to this page. (2) The following data set has 7 columns. It has data on 31 men in an exercise study. Put this data into MINITAB using the copy-paste method. Select the 31 rows by dragging across them and copy them. Go to MINITAB and click in the row1, column1 cell of the spreadsheet. Then use EDIT -> PASTE CELLS. You should see the data inserted. Name the columns in the top spaces. (3) Do a regression study for y = “oxygen” vs x = “time” . Include the plot of the data, descriptive stats, the correlation and the regression equation. Print out these results. (4) Do a regression study for y = “oxygen” vs x = “pulse” . Include the plot of the data, descriptive stats, the correlation and the regression equation. Print out these results. v1 = oxygen consumption in vol/body wt/unit time v2 = age in years v3 = weight in kilograms v4 = time to run 1.5 miles v5 = resting pulse rate v6 = pulse rate at end of run v7 = max pulse rate during run 44.6 44 89.5 11.4 62 178 182 45.3 40 75.1 10.1 62 185 185 54.3 44 85.8 8.7 45 156 168 59.6 42 68.2 8.2 40 166 172 49.9 38 89.0 9.2 55 178 180 44.8 47 77.5 11.6 58 176 176 45.7 40 76.0 12.0 70 176 180 49.1 43 81.2 10.9 64 162 170 39.4 44 81.4 13.1 63 174 176 60.1 38 81.9 8.6 48 170 186 50.5 44 73.0 10.1 45 168 168 37.4 45 87.7 14.0 56 186 192 44.8 45 66.5 11.1 51 176 176 47.3 47 79.2 10.6 47 162 164 51.9 54 83.1 10.3 50 166 170 49.2 49 81.4 9.0 44 180 185 40.8 51 69.6 11.0 57 168 172 46.7 51 77.9 10.0 48 162 168 46.8 48 91.6 10.3 48 162 164 50.4 49 73.4 10.1 76 168 168 39.4 57 73.4 12.6 58 174 176 46.1 54 79.4 11.2 62 156 165 45.4 52 76.3 9.6 48 164 166 54.6 50 70.9 8.9 48 146 155 45.1 51 67.3 11.1 48 172 172 39.2 54 91.6 12.9 44 168 172 46.0 51 73.7 10.5 59 186 188 50.5 57 59.1 9.9 49 148 155 48.7 49 76.3 9.4 56 186 188 47.9 48 61.2 11.5 52 170 176 47.5 52 82.8 10.5 53 170 172 (5) Let's do a simulation study: Consider a box of 5 numbers [0 0 0 0 1] with p = .20 for the proportion of 1's in the box. Note the average of the numbers in the box is also .20 . If we draw 50 times from the box, let X be the number of 1's drawn. X is also the sum of the 50 numbers drawn. X is random and we can't say what it will be exactly before the drawing takes place. To empirically examine what the sum X may be we will repeat the 50 draws 500 times getting an X value each time and explore the results. We will let the computer do all this work for us to save a lot of time. This process is called a simulation study. To simulate this drawing use the session commands: Random 500 C1 ; (Note it ends in a semicolon) binomial 50 .2 . (Note it ends in a period) The column C1 (name it SUM) should contain 500 numbers, the result on the SUM X repeated 500 times. Paste the following results to a WORD page and print from there. ***Get descriptive stats on C1. ***Do a histogram on C1 (you may want to tinker with the cutpoints that set the intervals - find such an option in the histogram menu and try making your own cutpoints.) ***Consider our theory - what is the EV and SE for the SUM X of this example? ***Does your histogram “match” these values in its location and spread? ***Is your histogram approximately Normal in shape?