ISSCM 491 Survey Data Using PhStat

User Generated

frajbg05

Mathematics

ISSCM 491

Description

My Occupational group is Group # 3 Admin Support

Please Use The Program PhStat!!!

there will be a file you can download ( PHStat.xlam PHStat.xlam )if you do not have PhStat, and also another file to show you how to use PhStat to get the answers. ( Ph Stat Handout 2016.pdf )

- everything else should be pretty straight forward in the excel spreadsheet it shows and tells you exactly what to do. - the file for this assignment is hw8.xlsx. Do not do more than is asked please.

Also the Survey Data ISSCM491.xlsx file is attached as (if needed) to look at this for this homework assignment (if it is) mentioned inside hw8.xlsx

Townes.HW1.xlsx will show you the The Correct way on how to answer and submit this assignment, so you could take a look at that to help how to format to answer the questions.

Unformatted Attachment Preview

(Note that this homework has 2 questions) Homework 8 Question 1. The Child Health and Development collected data to study the relationship between the infant weights and several related variables. A sample of 40 observations are given in the next worksheet Model Building - Stepwise Regression (Backward Elimination Method): (a) Follows the process steps described below to obtain a significant regression model. Step 1. Determine the estimated regression equation containing ALL six independent variables (gestation, height, smoke, age, weight, and parity). (a) What is the estimated regression equation with these six independent variables? (b) What percent of the total variation in baby weights is explained by this regression? (c) Which independent variables are NOT significant in this model at a = 0.05? Step 2. Eliminate non-significant variables, one at a time, until you obtain a regression model with all independent variables significant. Process steps: Step 2a. Remove the non-significant independent variable(s), one at a time, starting with the variable that has the highest p-value first. Obtain the new regression model. Step 2b. Check the independent variables for significance at a=0.05.. (i) If all independent variables are significant, stop. This is the significant model. (ii) If some independent variables in the model are not significant, repeat Step 2. (b) These process steps described above will result in a regression model that has significant independent variables only. What is the significant model found after completing the process steps above? (c) Now use the stepwise regression available in PHStat. Run stepwise regression (using backward elimination approach) to obtain a significant regression model. What is the model found by the PHStat stepwise regression? (d) Compare the significant regression models obtained in (b) and (c). Are they different? If they are different, which model is performing better? (e) Using the model you found to be performing better in (d), construct 95 percent confidence interval estimate for the mean baby weights for the newborns with the following values: (i) (i) Baby 1 Baby 2 gestation height smoke age weight parity 283 64 1 22 140 0 gestation height smoke age weight parity 283 64 1 25 160 1 (f) Which confidence interval estimate has a larger interval? Why? When you run stepwise regression in question (c), if you get an error message like the following, that means the PHStat failed. Please copy the data into a NEW FILe and run the stepwise regression from this new file. bwt gestation height smoke age weight parity Variables 128 125 114 130 116 81 124 125 110 125 138 142 115 102 140 133 127 104 119 152 123 143 131 141 129 113 119 109 104 131 110 148 137 117 115 98 136 121 132 93 290 286 290 285 248 256 287 292 262 279 294 284 278 280 294 276 290 274 275 301 284 273 308 319 277 282 292 295 280 282 293 279 283 283 302 250 303 276 285 264 64 64 66 63 66 60 62 65 66 63 64 66 60 55 61 63 66 62 67 65 65 66 65 67 66 59 62 63 68 66 64 71 65 63 67 56 68 71 63 60 0 0 0 1 0 1 1 0 0 1 0 0 1 0 0 0 0 1 0 0 0 0 0 0 1 0 1 1 1 0 1 0 0 0 0 1 0 1 0 1 22 21 30 23 28 30 27 22 25 23 40 39 23 38 25 22 35 20 42 29 20 19 40 20 30 36 33 23 27 21 28 27 20 27 22 35 20 23 25 36 118 139 160 128 135 148 105 122 140 104 125 132 102 140 103 119 165 115 156 150 120 135 160 140 142 140 118 103 146 126 135 189 157 108 135 122 148 152 140 100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 0 0 1 0 0 1 0 1 0 1 1 1 1 0 1 0 1 0 1 1 1 0 Bwt Gestation Height Smoke Age Weight 122.50 15.428911 283.3 64.1 0.4 27.4 0.4 Parity When you run stepwise reg if you get an error message means the PHStat failed. Pl NEW FILe and run the stepwis file. Bwt 180 160 140 120 100 4900.00000 4900.0000 Baby weights in ounces Length of pregnancy in days Mother's height in inches =1 if mother is smoker. = 0 Nonsmoker Mother's age in years Mother's pregnancy weight = 0 if the baby is first born =1 otherwise Bins 90 100 110 120 130 140 150 160 170 180 en you run stepwise regression in question (c), ou get an error message like the following, that ans the PHStat failed. Please copy the data into a W FILe and run the stepwise regression from this new Bwt vs Gestation Bwt 180 160 140 120 100 80 60 40 240 260 280 Gestation 300 320 340 Mid 95 105 115 125 135 145 155 165 175 180 4900.0 4900. bwt gestation height Weight smoke age 128 125 114 130 116 81 124 125 110 125 138 142 115 102 140 133 127 104 119 152 123 143 131 141 129 113 119 109 104 131 110 148 137 117 115 98 136 121 132 93 290 286 290 285 248 256 287 292 262 279 294 284 278 280 294 276 290 274 275 301 284 273 308 319 277 282 292 295 280 282 293 279 283 283 302 250 303 276 285 264 64 64 66 63 66 60 62 65 66 63 64 66 60 55 61 63 66 62 67 65 65 66 65 67 66 59 62 63 68 66 64 71 65 63 67 56 68 71 63 60 118 139 160 128 135 148 105 122 140 104 125 132 102 140 103 119 165 115 156 150 120 135 160 140 142 140 118 103 146 126 135 189 157 108 135 122 148 152 140 100 0 0 0 1 0 1 1 0 0 1 0 0 1 0 0 0 0 1 0 0 0 0 0 0 1 0 1 1 1 0 1 0 0 0 0 1 0 1 0 1 22 21 30 23 28 30 27 22 25 23 40 39 23 38 25 22 35 20 42 29 20 19 40 20 30 36 33 23 27 21 28 27 20 27 22 35 20 23 25 36 122.50 15.428911 283.3 64.1 0.4 27.4 4900.00000 4900.0000 Question 2 (Y) ($1,000) MARKET REAL ESTATE DATA (X1) (X2) (X3) (Sq Feet) AREA ($1,000) (X4) (Yes/No) (Number) ASSESS BASEM BEDRM 128 No 1 101 No 1 (Area) LOCAT Loc 2 Loc 2 1 2 139 172 952 1255 3 4 5 178 180 183 1663 1575 1209 88 110 125 No No No 1 1 1 Loc 1 Loc 3 Loc 3 6 7 8 9 10 183 198 205 205 216 1689 1330 1437 1598 1377 81 147 143 103 123 No Yes Yes Yes Yes 1 1 1 1 1 Loc 1 Loc 1 Loc 2 Loc 1 Loc 1 1607 1225 1610 1157 1262 1426 1185 1580 1215 1444 1808 1925 1577 1010 1365 1342 1460 1573 1425 1629 1589 1855 1769 1768 1505 1824 1888 1607 1848 1792 1881 1936 1832 1873 1769 1691 1855 1824 1957 963 1178 1992 1545 1846 1593 2030 1920 1904 2170 2049 1159 1558 1467 2034 2004 2270 2275 2186 2319 2272 115,707 1,652.96 332.024 123 99 114 132 119 79 125 103 125 156 139 165 139 123 125 123 99 128 121 136 128 132 143 156 103 145 134 178 143 150 167 174 165 125 154 167 183 185 174 125 130 141 143 152 136 176 178 167 165 178 108 112 141 163 169 125 128 165 176 130 9,636 137.66 25.997 Yes No No No No Yes Yes Yes Yes Yes Yes Yes Yes No No No No Yes Yes Yes Yes Yes Yes No Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No No Yes Yes No Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes 1 2 2 2 2 2 2 2 2 2 2 2 2 3 3 2 3 3 2 3 3 2 3 3 2 3 3 2 3 3 2 3 3 2 3 3 2 3 3 3 4 4 3 4 4 3 4 4 3 4 4 4 4 4 4 4 4 4 4 4 185 2.64 Loc 1 Loc 3 Loc 1 Loc 1 Loc 1 Loc 1 Loc 1 Loc 3 Loc 2 Loc 3 Loc 1 Loc 1 Loc 1 Loc 2 Loc 2 Loc 1 Loc 2 Loc 3 Loc 2 Loc 3 Loc 3 Loc 3 Loc 3 Loc 1 Loc 2 Loc 3 Loc 3 Loc 3 Loc 3 Loc 3 Loc 1 Loc 1 Loc 3 Loc 2 Loc 2 Loc 2 Loc 3 Loc 2 Loc 3 Loc 2 Loc 2 Loc 3 Loc 1 Loc 2 Loc 2 Loc 1 Loc 2 Loc 3 Loc 1 Loc 2 Loc 1 Loc 3 Loc 1 Loc 1 Loc 3 Loc 3 Loc 2 Loc 1 Loc 3 Loc 3 11 224 12 161 13 172 14 172 15 180 16 189 17 200 18 200 19 200 20 209 21 222 22 229 23 229 24 145 25 172 26 185 27 191 28 207 29 207 30 209 31 209 32 211 33 211 34 213 35 213 36 222 37 224 38 227 39 231 40 231 41 235 42 235 43 240 44 240 45 240 46 242 47 246 48 268 49 268 50 167 51 189 52 216 53 218 54 222 55 224 56 238 57 246 58 249 59 257 60 266 61 191 62 194 63 196 64 231 65 255 66 255 67 260 68 262 69 266 70 275 SUM 15045 AVG 214.929 St Dev 31.193 Dummy Variables: X3 = Basement X3 = 1 Finished Basement (Yes) X3 = 0 No Finished Basement (No) X5 = Location (Location 2 or not) X5 = 1 if in location 2 X5 = 0 if not in location 2 X6 = Location (Location 3 or not) X6 = 1 if in location 3 X6 = 0 if not in location 3 CORRELATION COEFFICIENTS MARKET AREA ASSESS BASEM BEDRM MARKET AREA ASSESS BASEM BEDRM LOCAT 1 0.8617 1 0.6924 0.5266 1 0.7016 0.5180 0.4405 1 0.4897 0.4787 0.4197 0.2761 1.0000 Question: To answer the regression questions below, you first need to enter numeric values (0 or 1) for BASEMENT column (X3), and 0 or 1 for LOCATION variables (X5 and X6) as defined above. (a) Use stepwise regression to determine the best Regression Model to predict the market value of the houses. Which variables are included in the model determined by stepwise regression? (b) What is the estimated regression equation with these variables? (c) What percentage of the total variations in market VALUEs is explained by this regression model? (d1) Using this regression model, calculate the predicted market VALUE for a house in location 1 with a BASEMENT, AREA=1652 and ASSESS=137. (d2) Using this regression model, calculate the predicted market VALUE for a house in location 2 with a BASEMENT, AREA=1652 and ASSESS=137. (d3) Using this regression model, calculate the predicted market VALUE for a house in location 3 with a BASEMENT, AREA=1652 and ASSESS=137. Page 4 of 4 (Homework 8) Max Min 275 139 Dr. Guder USING EXCEL and PHStat Page 0 MS Excel "Add-Inns": Data Analysis MS Excel "Add-Ins": PHStat Lecture "Add-in" to Use How Class 1 Data Analysis Data --> Data Analysis --> Histogram….. 2 Class 1 PHStat PHStat --> Descriptive Statistics--> Histogram and Polygons 2a Descriptive Statistics (Excel) Descriptive Statistics (PHStat) Class 1 Data Analysis Data --> Data Analysis --> Descriptive Statistics….. 3 150 Class 2 Data Analysis PHStat --> Descriptive Statistics--> Descriptive Summary… 4 150 Normal Distribution (probability Calculation) Class 2 PHStat PHStat --> Probability and Prob Distributions --> Normal … 5, 6 246 Mean (sigma known) Class 2 PHStat PHStat --> Confidence Interval --> Estimate for the Mean, sigma known … 7 302 Mean (sigma unknown) Class 2 PHStat PHStat --> Confidence Interval --> Estimate for the Mean, sigma unknown … 7 302 Proportion Class 2 PHStat PHStat --> Confidence Interval --> Estimate for the Proportion … 8 303 Mean Class 2 PHStat PHStat --> Sample Size --> Determination for the Mean 8 303 Proportion Class 2 PHStat PHStat --> Sample Size --> Determination for the Proportion 8 303 Mean (sigma known) Class 3 PHStat PHStat --> One-Sample Tests --> Z Test for the Mean, sigma known … 9 339 Mean (sigma unknown) Class 3 PHStat PHStat --> One-Sample Tests --> t Test for the Mean, sigma unknown … 10 339 Proportion Class 3 PHStat PHStat --> One-Sample Tests --> Z Test for the Proportion … 10 341 Subject/Task Data - Service Employees Histogram, Frequency Distribution Handout Textbook Page(s) Page(s) 1 95 Interval Estimation for Sample Size for Estimating Hypothesis Testing for One-Sample Tests Two-Sample Tests Differences in Two Means (independent populat Class 3 PHStat PHStat ---> Two-Sample Tests (Summarized Data) --> Pooled Variance t Test for… 11 382 Differences in Two Means (related populations) Class 3 PHStat PHStat --> Two-Sample Tests (Unsummarized) --> Paired t Test … 12 384 Class 4 Data Analysis Analysis of Variance (ANOVA) One-Way ANOVA Tukey-Kramer Procedure Using PHStat Two-Way ANOVA (Excel) PHStat Class 4 Two-Way ANOVA (PHStat) Correlation Data Analysis PHStat Class 6 Data Analysis Data --> Data Analysis --> Anova: Single Factor 13 PHStat --> Multiple-Sample Tests --> One-Way ANOVA (Check Tukey-Kramer Proc) 15 424 Data --> Data Analysis --> Anova: Two Factor 14 426 PHStat --> Multiple-Sample Tests --> Two-Way ANOVA 16 Data --> Data Analysis --> Correlation … 17 Regression Analysis Simple Linear Regression Multiple Regression Class 6 PHStat PHStat --> Regression --> Simple Linear Regression … 18-19 520-523 Classes 7, 8 PHStat PHStat --> Regression --> Multiple Regression … 20-21 564-569 Class 9 Excel Drawing Line Chart (Graph) in Excel 2013 Line Chart Starting PHStat (MS Excel 2003, 2010, and 2013) Step 0. Save the PHStat file (PHStat.xlam) to your desktop. When saved, it will be a shortcut looking an Excel file with the title PHStat2 or PHStat Step 1. Double click on this shortcut. Choose Enable Macros option. This will add another pane called Add-in Step 2. Select Add-in to get to PHStat 22 SERVICE EMPLOYEES (Occup Group = 10) DATA (Explanations on pages 2-3 are based on the data shown below) Page 1 Page 2 USING EXCEL TO OBTAIN HISTOGRAM and FREQUENCY DISTRIBUTION Choose the following: Data ---> Data Analysis ---> Histogram ---> (Fill out the window as shown below) Output/Result: Frequency 0 1 9 12 4 2 1 Histogram Frequency Bins 15.0 25.0 35.0 45.0 55.0 65.0 75.0 15 10 5 0 15.0 25.0 35.0 45.0 55.0 65.0 75.0 Bins USING PHStat TO OBTAIN HISTOGRAM Page 2a Choose the following: PHStat  Descriptive Statistics  Histogram and Polygons You need to provide Cell ranges for three different data:  Variable Cell Range (The area/column that has the INCOME data – D5.D59 in my case. Note D5 has the title/Label)  Bins Cell Range (The area where you entered the interval points as 20, 30, 40, 50, 60, 70, 80, 90)  Midpoints Cell Range (The area where you entered midpoints of the bin values as 25, 35, 45, 55, 65, 75, 85) Suppose the data values are given in column D (D5.D59), where D5 has the column title/label. Bins (interval points) are entered in the range S2.S10 and Midpoints are entered in the range T2.T9 as shown below. You will then enter the ranges in the Histogram & Polygons windows as shown below: The result will be similar to the following: USING EXCEL TO OBTAIN DESCRIPTIVE STATISTICS Page 3 Choose the following: Data ---> Data Analysis ---> Descriptive Statistics... ---> (Fill out the window as shown below) Output/Result: INCOME (000) Mean 31.483 Standard Error 2.300 Median 29.4 Mode #N/A Standard Deviation 12.388 Sample Variance 153.451 Kurtosis -0.112 Skewness 0.855 Range 44 Minimum 15.3 Maximum 59.3 Sum 913 Count 29 Confidence Level (95%) 4.712 WORKed Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count Confidence Level(95%) EDUC 20.690 2.090 21 24 11.254 126.650 0.945 0.816 46 3 49 600 29 4.281 Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count Confidence Level (95% 12.862 0.343 13 14 1.846 3.409 -0.129 -0.478 7 9 16 373 29 0.702 USING PHSTAT TO OBTAIN DESCRIPTIVE STATISTICS (Single Group) PHStat ---> Descriptive Statistics --> Descriptive Summary --> (Select) Single Group Variable --> (Fill out the window as shown below) Descriptive Summary INCOME Mean 31.483 Median 29.4 Mode #N/A Minimum 15.3 Maximum 59.3 Range 44 Variance 153.451 Standard Deviation 12.388 Coeff. of Variation 39.35% Skewness 0.855 Kurtosis -0.112 Count 29 Standard Error 2.300 USING PHSTAT TO OBTAIN DESCRIPTIVE STATISTICS (Multiple Groups) PHStat ---> Descriptive Statistics --> Descriptive Summary --> (Select) Single Group Variable --> (Fill out the window as shown below) Descriptive Summary 0 (Female) Mean Median Mode Minimum Maximum Range Variance Standard Deviation Coeff. of Variation Skewness Kurtosis Count Standard Error 22.991 21.6 #N/A 15.3 33.7 18.4 38.809 6.230 27.10% 0.477 -1.096 11 1.878 1 (Male) 36.672 33.9 #N/A 21.1 59.3 38.2 154.739 12.439 33.92% 0.501 -0.938 18 2.932 Page 4 Page 5 USING PHStat TO OBTAIN PROBABILITY FOR NORMAL DISTRIBUTION Choose the following: PHStat ---> Probability & Prob Distributions ---> Normal… ---> (Fill out the window as shown below) Example 1(a) - Class 2 Example 1(b) - Class 2 Output/Result: Example 1(a) Example 1(b) Common Data Mean Standard Deviation Common Data 68 2 Probability for a Range From X Value 68 To X Value 70 Z Value for 68 0 Z Value for 70 1 P(X Estimate for Proportion... ---> (Fill out the window as shown below) Data Sample Size Number of Successes Confidence Level 600 300 0.99 Intermediate Calculations Sample Proportion Z Value Standard Error of the Proportion Interval Half Width 0.5 -2.576 0.020 0.0526 Confidence Interval Interval Lower Limit Interval Upper Limit 0.447 0.553 USING PHStat TO DETERMINE the SAMPLE SIZE (n) for Mean PHStat ---> Sample Size ---> Determination for the Mean…---> (Fill out the window as shown below) Example 5 Data Population Standard Deviation Sampling Error Confidence Level 4 1 95% Intemediate Calculations Z Value Calculated Sample Size -1.960 61.463 Result Sample Size Needed 62 USING PHStat TO DETERMINE the SAMPLE SIZE (n) for Proportion PHStat ---> Sample Size ---> Determination for the Proportion…---> (Fill out the window as shown below) Example 8 - Class 2 Data Estimate of True Proportion Sampling Error Confidence Level 0.50 0.03 0.99 Intermediate Calculations Z Value Calculated Sample Size -2.58 1843.03 Result Sample Size Needed 1844 USING PHStat FOR HYPOTHESIS TESTING for MEAN Page 9 Choose the following: PHStat ---> One-Sample Tests ---> Z Test for the Mean, sigma known… ---> (Fill out the window as shown below) Example 1 - Class 3 Data = Null Hypothesis Level of Significance Population Standard Deviation Sample Size Sample Mean 64 0.05 0.5 25 63.85 Intermediate Calculations Standard Error of the Mean Z Test Statistic 0.1 -1.50 Two-Tail Test Lower Critical Value Upper Critical Value p-Value -1.960 1.960 0.1336 Do not reject the null hypothesis PHStat ---> One-Sample Tests ---> Z Test for the Mean, sigma known… ---> Example 2 - Class 3 Data Null Hypothesis = Level of Significance Population Standard Deviation Sample Size Sample Mean 700 0.05 75 225 704 Intermediate Calculations Standard Error of the Mean Z Test Statistic 5 0.80 Upper-Tail Test Upper Critical Value p-Value Do not reject the null hypothesis 1.645 0.212 PHStat ---> One-Sample Tests ---> t Test for the Mean, sigma unknown… ---> Page 10 (Fill out the window as shown below) Example 4 - Class 3 Data = Null Hypothesis Level of Significance Sample Size Sample Mean Sample Standard Deviation 700 0.10 64 710 48 Intermediate Calculations Standard Error of the Mean Degrees of Freedom t Test Statistic 6 63.00 1.6667 Upper-Tail Test Ca Lower Critical Value Upper Critical Value p-Value -1.6694 1.2951 0.0503 Reject the null hypothesis PHStat ---> One-Sample Tests ---> Z Test for proportion… ---> (Fill out the window as shown below) Example 6 - Class 3 Null Hypothesis Data = Level of Significance Number of Successes Sample Size 0.40 0.02 170 400 Intermediate Calculations Sample Proportion Standard Error Z Test Statistic 0.4250 0.0245 1.0206 Two-Tail Test Lower Critical Value Upper Critical Value p-Value -2.326 2.326 0.3074 Do not reject the null hypothesis Two-Sample Tests (Independent Populations) Page 11 PHStat ---> Two-Sample Tests (Unsummarized Data) ---> Pooled Variance t Test for… ---> PHStat ---> Two-Sample Tests (Summarized Data) ---> Pooled Variance t Test for… ---> Example 8 ‐ Class 3 (assumes equal population variances) Data Hypothesized Difference Level of Significance Population 1 Sample Sample Size Sample Mean Sample Standard Deviation Population 2 Sample Sample Size Sample Mean Sample Standard Deviation Intermediate Calculations Population 1 Sample Degrees of Freedo Population 2 Sample Degrees of Freedo Total Degrees of Freedom Pooled Variance Standard Error Difference in Sample Means t Test Statistic Upper‐Tail Test Upper Critical Value p‐Value Do not reject the null hypothesis 0 0.05 60 4 1.6 80 3 1 59 79 138 1.6670 0.2205 1.0000 4.5352 1.6560 0.0000 Calcula For one‐t T.DIST.RT 1‐T.DIST. Page 12 Two-Sample Tests (Related Populations - Paired) PHStat ---> Two-Sample Tests (Unsummarized Data) ---> Paired t Test … ---> PHStat ---> Two-Sample Tests (Summarized Data) ---> Paired t Test … ---> (Fill out the window as shown below) Column B Column C Before 199 213 176 160 190 187 194 171 178 210 After 180 190 159 145 168 171 175 156 156 181 Unsummarized Data Example 9 Data Hypothesized Mean Difference Level of significance Intermediate Calculations Sample Size DBar Degrees of Freedom SD Standard Error t Test Statistic 17 0.05 10 19.7000 9 4.3982 1.3908 1.9413 Upper‐Tail Test Upper Critical Value p ‐Value Reject the null hypothesis 1.8331 0.0421 TDIST Calculations T.DIST.RT 0.0421 0.9579 1‐T.DIST.RT Page 13 USING EXCEL FOR ANALYSIS OF VARIANCE (One-Way ANOVA) PHStat ANOVA information given below One-Way Analysis of Variance (ANOVA) Choose the following: Data ---> Data Analysis ---> Anova: Single Factor ---> OK (Fill out the window as shown) Using PHStat Tukey-Kramer Procedure PHStat --> Multiple-Sample Test --> --> One-Way ANOVA --> Check Tukey-Kramer Procedure --> OK PHStat --> Multiple-Sample Test --> --> Tukey-Kramer Procedure (PhStat Version 2.7) USING EXCEL FOR ANALYSIS OF VARIANCE (Two Way ANOVA) Choose the following: Data ---> Data Analysis ---> Anova: Two-Factor with Replication ---> OK (Fill out the window for the data shown above) Two-Way Analysis of Variance (ANOVA) Page 14 USING PHStat FOR ANALYSIS OF VARIANCE (ANOVA) Page 15 One-Way ANOVA PHStat --> Multiple-Sample Test --> One-Way ANOVA Notes: * Do not check Tukey-Kramer Procedure for Two-Samples cases * You can check Tukey-Kramer Procedure for three (or more) sample cases. Q value is to be provided Q Value is to be provided when asked Tukey-Kramer Multiple Comparisons Sample Sample Group Mean Size 1: Hospital A 5 6 2: Hospital B 4 6 3: Hospital C 3 6 Other Data Level of significance 0.05 Numerator d.f. 3 Denominator d.f. 15 MSW 1.0666667 Q Statistic 3.67 Absolute Std. Error Comparison Group 1 to Group 2 Group 1 to Group 3 Group 2 to Group 3 Difference 1 2 1 of DifferenceResults 0.42164 1.547408 Means are not different 0.42164 1.547408 Means are different 0.42164 1.547408 Means are not different Important: PHStat ANOVA procedure sometimes fails to work. If that happens, do the following: (a) Open a new file and copy your data into this new file (b) Repeat PHStat --> Multiple-Sample Test --> One-Way ANOVA (c) If the same problem continues (i) Close and restart your computer (ii) Open a new file and copy your data to this new file (iii) Repeat PHStat --> Multiple-Sample Test --> One-Way ANOVA Two-Way ANOVA PHStat --> Multiple-Sample Test --> Two-Way ANOVA with Replication Important: PHStat ANOVA procedure sometimes fails to work. If that happens, do the following: (a) Open a new file and copy your data to this new file (b) Repeat PHStat --> Multiple-Sample Tests --> One-Way ANOVA (c) If there is still a problem: (i) Close and restart your computer (ii) Open a new file and copy your data to this new file (iii) Repeat PHStat --> Multiple-Sample Test --> One-Way ANOVA Page 16 CORRELATION and REGRESSION Correlation and Regression outputs (on pages 12-15) are based on the Real Estate Data given below. Page 17 USING Excel FOR CORRELATION Data ---> Data Annalysis ---> Correlation Page 18 (Fill out the window as shown below) Correlation Output MARKET AREA ASSESS BASEM MARKET 1 0.8617 0.6924 0.7016 AREA ASSESS BASEM 1 0.5266 0.5180 1 0.4405 1 USING PHStat TO OBTAIN SIMPLE REGRESSION PHStat ---> Regression ---> Simple Linear Regression… ---> (Fill out the window as shown below) These are needed for confidence interval and prediction interval estimates See Regression OUTPUT on next page Regression Statistics Multiple R 0.8617 R Square 0.7425 Adjusted R Square 0.7388 Standard Error 15.9436 Observations 70 Page 19 15 16 14c ANOVA Regression Residual Total Intercept AREA df 1 68 69 SS 49853.25 17285.39 67138.64 Coefficients Stand Error t Stat 81.110 9.744 8.324 0.081 0.006 14.004 11 MS F 49,853.253 196.121 254.197 P-value 0.00000 0.00000 Signif F 0.00000 Lower 95% Upper 95% 61.67 0.07 100.55 0.09 19a 19b Output (Confidence and Prediction Interval Estimates) Data X Value Confidence Level 1,652.96 95% Intermediate Calculations Sample Size 70 Degrees of Freedom 68 t Value 1.9955 XBar, Sample Mean of X 214.9286 Sum of Squared Differences from 7,606,537 Standard Error of the Estimate 15.9436 h Statistic 0.0143 Predicted Y (YHat) 214.929 For Average Y Interval Half Width Confidence Interval Lower Limit Confidence Interval Upper Limit 3.803 211.126 218.731 For Individual Response Y Interval Half Width 32.041 Prediction Interval Lower Limit 182.887 Prediction Interval Upper Limit 246.970 17 18a 18b USING PHSTAT FOR MULTIPLE REGRESSION Choose the following: Page 20 PHStat ---> Regression ---> Multiple Regression… ---> SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations Example 1-2 0.9063 0.8213 0.8160 13.3820 70 25 26 24c ANOVA df 2 67 69 Regression Residual Total Intercept AREA ASSESS Coefficients 53.5824 0.0646 0.3961 21 SS 55,140.48 11,998.17 67,138.64 Stand Error 9.6202 0.0057 0.0729 MS F Significance F 27,570.24 153.9574 0.0000 179.077 t Stat 5.5698 11.3225 5.4337 P-value Lower 99% Upper 99% 0.0000 28.0771 79.0877 0.0000 0.0495 0.0798 0.0000 0.2028 0.5893 29a 29b Page 21 Confidence Interval Estimate and Prediction Interval Example 1-2 Data Confidence Level AREA given value ASSESS given value 0.95 1 1,652.96 137.60 Predicted Y (YHat) 214.906 For Average Predicted Y (YHat) Interval Half Width Confidence Interval Lower Limit Confidence Interval Upper Limit For Individual Response Y Interval Half Width Prediction Interval Lower Limit Prediction Interval Upper Limit 3.193 211.714 218.099 26.901 188.005 241.807 Enter these values 27 28a 28b Drawing (Line) Charts/Graph in Excel 2013 Year 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 Visits 14292 14022 15777 12672 14000 12816 15093 17433 15165 13392 14058 15900 Page 22 Visits 18000 17000 16000 15000 14000 13000 12000 11000 10000 2000 2002 2004 2006 2008 2010 2012 2014 Drawing (Line) Charts/Graph in Excel 2013 Step 1. Step 2. Step 3. Select the cells that contain the data that you want to use for the chart (C7..C19) On the INSERT tab, in the Charts group, click the chart type (select the line chart) The chart will be created after the selection. By default, the chart is placed on the worksheet as an embedded chart. Excel automatically assigns a title (Visits in Excel 2013, Chart 1 in Excel 2010) Visits 20000 15000 10000 5000 0 1 Step 4. 2 3 4 5 6 7 8 9 10 11 12 You can make changes on this default chart by using (a) Select Data to display Year on the X-axis (b) Format axis to change the range of the numbers/visits (10000 to 18000) (c) Format Chart Area to draw lines outside the chart The new chart will look like the following. Visits 18000 16000 14000 12000 10000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 Homework 1 Note that each student will prepare and submit the homework assignments individually. It is important that you complete this first assignment since the remaining assignments will be using the work on this assignment. You will be using MS Excel or PHStat software. It is acceptable, if you prefer to use another software for the study. Please let me know if you need help with the use of Excel. You will be using the survey data given in ISSCM491 file for most of the homework problems. These 800 employees have different occupations. The categorical variables used for occupation are 0. Managerial 1. Professional 2. Production 3. Admin. Support 4. Laborer 5. Finance 6. Corporate 8. Information Systems 9. Technical 10. Service You will be working with the survey data of a specific occupation. The occupational group data that you will be working is provided on the Announcements page of the course web site. For all the questions during this quarter, the term Occupational Group refers to the occupational group that you will be working. The survey data (file ISSCM491.xlsx) can be downloaded from the Assignments page of the course website. The Excel file ISSCM491.xlsx has the following three worksheets Includes the survey information (questions). Has the survey data as observed. Has the same survey data sorted according to the occupational groups. (This sorted data will be helpful to obtain the sample values of your occupational group). Questions Part I: 1. Extract the employees of your group and save them with a meaningful file name such as manag.xls, profe.xls, prod.xls etc. 2. Calculate the Descriptive Statistics for INCOME, Years WORKed and EDUCation for your Group. 3. Find the frequency distribution and Histogram for the INCOME of your Group (See next page for using the Descriptive Statistics and Histogram options of MS Excel). (a) Calculate the Descriptive Statistics for INCOME, Years WORKed and EDUCation for FEMALE employees in your Group. (b) Calculate the Descriptive Statistics for INCOME, Years WORKed and EDUCation for MALE employees in your Group. 5. Select a random sample of 16 employees from this 800 observations. (Note that this sample will be randomly selected from the whole 800 sample survey results, not from the group you are working with). (a) Explain how you have selected your sample to ensure that it is a random sample. (b) What is the average (mean) AGE of the employees in your sample? 4. Questions Part II: (These are general questions that do not use the sample survey data. Your are asked to identify the population and suggest a sample selection for each case). 6. You would like to know, if there is a convincing evidence that newborns from mothers who smoke have a different average birth weight than newborns from mothers who don't smoke? (a) What is the population for this study? (b) How do you select the sample for this study? 7. Suppose a pharmaceutical company had developed a new drug for lowering blood pressure, and they are preparing a clinical trial (experiment) to test the drug's effectiveness. (a) What is the population in this study? (b) How do you proceed with this study? i.e., How do you collect the sample for this study? Submit the file containing your answers to questions (1), (2), (3), (4), (5), (6) and (7) electronically on the course website on Sakai. Please write your name and your Occupational Group number on the first page of your submission. Page 1 of 3 (Homework 1) USING PHStat to calculate DECSRIPTIVE STATISTICS PHStat--> Descritive Statistisc --> Descriptive Summary --> Page 2 Page 2 of 3 (Homework 1) To calculate Descriptive Statistics Using Excel Step 1 Step 2 Select Data pane Click Data Analysis … Page 3 (Data analysis dialog window will open) If Data Analysis… is not available on your tools menu, then the Analysis Toolpack has not been installed in your system. See the FAQ on the course website. Step 3 Choose Descriptive Statistics by clicking it once and then clicking the OK button (The Descriptive Statistics dialog window will open. Provide the necessary information as shown below) Step 4 Click the OK button. A new worksheet will be created with the results. To construct a Histogram and Frequency Distribution Using Excel Step 1 Step 2 Step 3 Select Data pane Click Data Analysis … (Data analysis dialog window will open) Select Histogram option and click the OK button (Next you will get the Histogram window. Provide the necessary information as shown below). Step 4 Click the OK button. A new worksheet will be created with the results. Page 3 of 3 (Homework 1) QUESTION 1 1 2 3 4 5 6 7 8 9 ID_No OCCUP Resp INCOME Years WORKed EDUC GENDER AGE Work HRS No EARN 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 35.2 25.8 34.3 34.1 29.3 31.7 30.6 29.7 37.1 27.8 33.1 29.3 26.7 25.9 35.8 30.0 26.2 44.6 32.7 30.0 29.7 30.5 28.9 23.2 48.7 24.4 23.4 25.3 25.5 72.8 27.8 25.4 25.0 50.7 27.1 27.7 25.3 28.1 15 20 7 33 10 15 20 27 21 20 25 8 20 9 45 15 10 10 13 25 15 20 12 22 8 6 26 17 21 19 10 15 11 24 15 20 3 22 12 14 12 14 13 12 14 12 13 12 16 12 12 12 12 12 12 16 15 13 12 12 12 12 12 16 12 13 14 12 15 14 12 18 13 13 12 13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 33 50 24 50 26 53 52 43 39 40 42 28 37 35 63 42 35 27 29 61 32 55 29 38 32 29 42 38 47 36 27 37 32 44 41 40 20 65 50 40 49 42 40 40 40 40 36 45 36 50 40 43 35 40 40 40 42 40 40 40 32 40 40 40 40 35 60 40 45 40 40 40 40 45 40 40 1 1 2 3 1 1 1 2 3 1 1 1 2 1 1 2 2 2 2 1 2 1 2 2 1 3 1 1 3 1 1 1 2 2 2 3 2 1 2 14 21 31 50 77 94 98 99 100 108 110 112 113 114 126 137 140 150 163 166 176 187 198 200 212 213 218 220 236 249 250 252 269 280 300 307 312 350 359 360 390 400 450 500 550 600 650 700 750 800 19 29 40 58 82 109 115 134 207 222 233 254 315 385 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 32.5 25.0 34.2 31.9 25.5 46.1 28.1 25.6 37.3 24.2 33.2 20.3 26.8 43.1 24.7 25.4 32.5 27.9 36.8 33.9 60.5 26.3 55.8 29.3 62.7 56.6 29.3 Total 2134.90 Average 32.84 25 6 30 21 34 36 4 24 20 20 37 20 27 7 15 16 10 17 18 10 20 24 24 16 31 32 18 12 12 12 12 12 16 14 14 12 17 13 13 12 16 16 12 12 14 13 13 16 12 12 9 14 12 12 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 61 23 55 31 56 56 30 42 38 38 58 57 69 25 35 32 27 27 37 29 37 41 41 33 48 48 35 40 44 50 47 40 40 48 37 40 37 32 32 29 40 40 40 40 40 40 41 50 72 45 56 80 40 40 1 2 2 3 2 1 2 1 4 1 1 2 1 1 2 1 3 2 4 2 2 1 1 1 2 4 2 1216.00 18.71 851.00 13.09 14.00 0.22 2602.00 40.03 2745.00 42.23 113.00 1.74 Marques Townes Occup = 3 10 11 12 13 14 15 16 Fam Inc Job Sat Job Char Get Ahead Traumat Events Employ Years Number Prom 25.2 17.4 27.4 69.6 19.6 35.7 47.3 57.8 31.2 17.8 34.2 19.3 26.5 15.9 38.7 23.0 43.4 69.3 43.1 20.0 38.9 20.5 21.9 16.7 38.7 28.3 29.7 15.3 68.7 63.4 17.8 15.4 25.4 49.2 32.4 31.4 27.1 18.2 1 3 3 2 2 2 2 1 2 1 4 2 2 1 1 1 2 1 2 1 2 2 1 2 2 3 1 1 4 1 1 1 2 3 2 2 1 1 1 1 4 5 3 5 5 5 5 1 5 1 1 5 2 2 1 5 2 1 5 1 5 5 1 1 4 5 5 4 5 1 3 1 5 5 4 5 2 1 2 1 1 2 1 1 1 1 2 1 1 1 3 3 1 1 3 2 1 2 1 1 1 1 1 1 3 1 3 1 1 2 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 1 0 0 0 1 0 0 0 1 0 0 0 0 0 0 4 10 5 3.5 4 12.5 3 9.41 16 0.5 12 3 10 1.5 22 7.08 2.5 5 4.33 18.33 11.58 15 3 1 6 3 1.08 4 1 2.16 2 15 10 22 4 7 1.5 13 3 0 1 1 5 1 1 1 0 0 1 0 0 1 1 0 3 4 0 0 3 2 1 0 0 0 1 1 0 0 0 3 0 0 0 1 0 1 Bins 15.0 25.0 35.0 45.0 55.0 65.0 75.0 22.5 37.3 27.9 40.2 44.5 36.9 41.8 16.4 72.6 49.2 23.2 42.5 16.8 33.1 46.9 15.4 32.5 46.5 34.0 43.0 59.2 16.3 49.4 23.2 56.1 71.0 45.0 1 3 2 1 2 1 2 4 1 2 2 2 1 4 2 1 1 2 3 2 2 1 1 1 4 1 2 5 2 1 1 5 1 1 1 4 5 5 1 5 5 5 1 5 5 4 4 5 5 5 4 1 5 1 3 1 2 1 1 1 2 2 1 1 2 2 1 3 2 2 1 1 1 3 1 3 1 1 3 1 1 0 0 0 0 0 0 1 0 0 0 1 1 0 0 3 0 0 2 0 0 0 1 0 0 0 0 0 17 2.5 30 10 21 30 1 2 10.5 5 5 3 25 1 0.75 0.16 5 0.5 16 3 8.5 18 8 4.5 9 25 8 1 0 3 0 0 3 1 0 4 0 0 0 3 1 2 0 0 0 0 2 2 0 4 0 1 1 0 2284.80 35.15 119.00 1.83 217.00 3.34 99.00 1.52 13.00 0.20 545.38 8.39 64.00 0.98 MidPoints 20 30 40 50 60 70 Question 2 Answer Using Excel --> Data --> Data Analysis --> Descriptive Statistics INCOME Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count Years WORKed 32.84461538 1.299195444 29.3 29.3 10.47444854 109.7140721 3.773770959 1.959863291 52.5 20.3 72.8 2134.9 65 Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count EDUC 18.70769 1.072767 20 20 8.648922 74.80385 0.355163 0.536996 42 3 45 1216 65 Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count 13.09231 0.201822 12 12 1.627144 2.647596 0.951554 0.969298 9 9 18 851 65 Question 3 Answer Using Excel --> Data --> Data Analysis --> Histogram Histogram 40 30 20 10 0 Frequency 15.0 20.0 25.0 30.0 35.0 40.0 45.0 50.0 55.0 60.0 65.0 70.0 75.0 More Frequency Bin Frequency 15.0 0 20.0 0 25.0 6 30.0 31 35.0 13 40.0 5 45.0 2 50.0 2 55.0 1 60.0 2 65.0 2 70.0 0 75.0 1 More 0 Bin Question 4(a) Descriptive Statistics for Female (0) Answer Using Excel --> Data --> Data Analysis --> Descriptive Statistics INCOME Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count Years WORKed 31.17843 1.220168 29.3 29.3 8.713743 75.92933 9.976643 2.70447 52.5 20.3 72.8 1590.1 51 Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count EDUC 18.78431 1.265008 20 20 9.033966 81.61255 0.364075 0.540109 42 3 45 958 51 Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count 13.09804 0.215579 12 12 1.539544 2.370196 1.47951 1.472344 6 12 18 668 51 Question 4(b) Descriptive Statistics for Male (1) Answer Using Excel --> Data --> Data Analysis --> Descriptive Statistics INCOME Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count Years WORKed 38.91429 3.756224 33.2 29.3 14.0545 197.529 -1.17405 0.745903 38 24.7 62.7 544.8 14 Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count EDUC 18.42857 1.968751 17.5 16 7.366392 54.26374 -0.17531 0.465619 25 7 32 258 14 Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count 13.07143 0.528987 12.5 12 1.979288 3.917582 0.184634 0.024092 7 9 16 183 14 QUESTION 5 Sample # 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 Resp Years ID_No OCCUP INCOME WORKed EDUCat GENDER 474 8 29.3 10 13 0 426 6 33.7 25 16 0 1 4 35.7 25 14 0 666 7 41.9 34 16 1 196 11 69.3 30 16 1 128 4 47.3 10 14 1 383 4 32.6 32 10 1 764 6 38.0 26 18 1 96 11 50.8 35 12 1 180 1 50.1 25 15 1 634 9 21.1 4 12 0 18 0 36.6 43 16 1 587 8 28.9 12 12 0 375 4 27.6 8 12 1 663 9 31.4 22 12 1 284 11 30.8 9 14 1 AGE 26 42 64 51 47 27 47 43 52 41 21 59 29 25 41 26 Work HRS 40 40 30 40 50 65 40 56 40 50 55 40 32 63 45 40 5a) To ensure that the chosen samples are random, the ID number of the employees which range from 1 to 800 is generated by using the function RANDBETWEEN(1, 800). Through this, Excel will automatically generate random from 1 to 800 (inclusive).Through this, it can be assured that there is no bias in choosing the samples. In order to changing (random numbers always change), the generated numbers were copied and pasted (Paste Special QUESTION 5(b) Sample # 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 Resp Years ID_No OCCUP INCOME WORKed EDUCat GENDER 474 8 29.3 10 13 0 426 6 33.7 25 16 0 1 4 35.7 25 14 0 666 7 41.9 34 16 1 196 11 69.3 30 16 1 128 4 47.3 10 14 1 383 4 32.6 32 10 1 764 6 38.0 26 18 1 96 11 50.8 35 12 1 180 1 50.1 25 15 1 634 9 21.1 4 12 0 18 0 36.6 43 16 1 587 8 28.9 12 12 0 375 4 27.6 8 12 1 663 9 31.4 22 12 1 284 11 30.8 9 14 1 AGE 26 42 64 51 47 27 47 43 52 41 21 59 29 25 41 26 Work HRS 40 40 30 40 50 65 40 56 40 50 55 40 32 63 45 40 AVERAGE 37.8 5b) The average age of the sample is 40.1 21.9 13.9 0.7 40.1 45.4 No EARN 1 3 2 1 4 2 2 2 2 3 4 1 2 2 1 1 Fam Inc 19.6 51.2 81.9 33.5 89.2 39.7 47.5 36.7 96.2 45.1 35.7 35.4 21.9 30.8 21.4 20.8 Job Sat 2 1 1 2 1 2 1 3 3 2 1 2 1 1 1 1 Job Char 3 1 3 5 5 1 5 1 5 4 5 5 5 1 1 4 Get Ahead 1 1 2 3 1 1 1 1 1 1 1 1 1 1 1 2 Traumat Employ Events Years 0 4 1 5.5 0 11 0 6 0 23.58 1 2 0 10 0 5.5 1 0.08 0 6 0 2 1 1.5 0 3 0 4 0 0.25 0 1.5 Num Prom 5 0 0 1 3 0 1 0 0 2 0 1 1 1 0 1 Job Sat 2 1 1 2 1 2 1 3 3 2 1 2 1 1 1 1 Job Char 3 1 3 5 5 1 5 1 5 4 5 5 5 1 1 4 Get Ahead 1 1 2 3 1 1 1 1 1 1 1 1 1 1 1 2 Traumat Employ Events Years 0 4 1 5.5 0 11 0 6 0 23.58 1 2 0 10 0 5.5 1 0.08 0 6 0 2 1 1.5 0 3 0 4 0 0.25 0 1.5 Num Prom 5 0 0 1 3 0 1 0 0 2 0 1 1 1 0 1 h range from 1 to 800 is ically generate random numbers e samples. In order to stop it from ed (Paste Special -> Values). No EARN 1 3 2 1 4 2 2 2 2 3 4 1 2 2 1 1 Fam Inc 19.6 51.2 81.9 33.5 89.2 39.7 47.5 36.7 96.2 45.1 35.7 35.4 21.9 30.8 21.4 20.8 2.1 44.2 1.6 3.4 1.3 0.3 5.4 1.0 6a) There are two populations of concern in this study. The first population is all the mothers who smoke and the second population is all the mothers who do not smoke. 6b) A good sample of this study is a random sample of mothers who are found in the same area and who are of the same ethnicity. This way, there will be a lesser bias with the weight of the newborn babies since other factors that may affect weight are excluded. weight of 7a) The population of this study would be all patients that have high blood pressure. 7b) In order to proceed with the study, the subjects have to be chosen. The only possible humane way of doing this is through human volunteers. In most cases, there are volunteers who agree to do this because they gain access to new research treatments before these treatments become widely available. Also, these volunteers can actually help others by being able to contribute to medical research. Upon doing this, there is a need to secure a written "informed consent" of these volunteers regarding the risks and benefits of the clinical trial. ble humane way of doing this because they gain Also, these volunteers can here is a need to secure a linical trial. Employee Satisfaction Survey Page A0 Gemini Healthcare (GH) is a not-for-profit, academic health system. GH is affiliated with the Medical School of the local university. The GH system includes three hospitals—American, Badger, and County Hospital. American Hospital with 400 beds is the major hospital of Gemini Healthcare. Badger Hospital is a 150-bed facility. County Hospital with 250 beds has provided high-quality healthcare for more than 30 years. Gemini Healthcare employs 10,000 people in its facilities. As part of its movement to implement a Total Quality Management (TQM) philosophy and to improve the productivity, the management of Gemini Healthcare wants to develop an employee profile that will measure job satisfaction. The company hires L&B Corporation, a management consulting firm, to survey Gemini employees. After careful consideration, the Human Resources department and a statistician from the L&B Corporation determine that a survey will be sufficient to obtain the information. Given below is the list of the 16 questions used in the survey. The Vice-President of the Human Resources and the statistician decided that a sample size of 800 would be sufficient to obtain a confident result. The responses of the 800 full-time employees who have participated in the survey are given on Pages A1-A12. Survey Questions: 1 Identification number 2 What is your occupation? 0. Managerial 1. Professional 2. Production 3. Admin. Support 4. Laborer 5. Finance 6. Corporate 7. Sales 8. Information Systems 9. Technical 10. Service 3 4 5 6 What was your "before tax" income last year? How many years you have worked full time (since you were 16)? How many years of school you have completed? What is your gender? (0=Female, 1=Male) 7 8 9 10 11 What is your age (as of last birthday)? How many hours did you work last week? Among family members, how many were employed last year? What was your "before tax" total family income last year? On the whole, how satisfied are you with your job? (1=Very Satisfied, 2=Moderately Satisfied, 3= A Little Satisfied, 4=Very Dissatisfied) 12 Which one of the following characteristics is most important to you? (1=High Income, 2=No Danger of Being Fired, 3=Flexible Hours, 4=Opportunities for Advancement, 5= Enjoying the Work) 13 Which one of the following is the way most people get ahead on the job? (1=Hard Work, 2=Hard Work and Luck, 3=Luck) 14 How many traumatic events did you experienced last year? 15 How many years altogether you have worked for your present employer? MY OCCUPATION IS #3 ADMI Page A3 Employee Satisfaction Survey Results (SORTED by OCCUPATION) 1 2 3 4 5 6 Resp Years ID_No OCCUP INCOME WORKed EDUCat GENDER 1 4 35.7 25 14 0 2 3 35.2 15 12 0 3 0 88.3 14 20 1 4 0 50.5 12 15 1 5 11 30.2 3 14 1 6 11 45.7 40 14 1 7 11 30.0 10 14 0 8 2 28.0 10 13 0 9 1 70.8 15 18 1 10 0 48.4 15 16 1 11 1 41.0 13 12 0 12 2 86.6 30 13 1 13 11 43.3 12 12 0 14 3 25.8 20 14 0 15 4 37.5 31 4 1 16 11 64.2 23 16 1 17 11 42.0 20 12 0 18 0 36.6 43 16 1 19 3 43.1 7 16 1 20 4 20.5 3 11 1 21 3 34.3 7 12 0 22 2 43.3 17 10 1 23 11 43.8 14 16 1 24 11 45.7 20 13 0 25 5 54.7 13 16 0 26 1 33.7 25 16 0 27 11 66.4 27 13 1 28 2 52.7 18 15 1 29 3 24.7 15 16 1 30 0 41.3 18 12 0 31 3 34.1 33 14 0 32 11 40.3 15 12 0 33 11 55.2 24 13 1 34 1 27.9 9 16 0 35 11 30.4 11 17 0 36 2 36.3 23 13 1 37 1 31.6 12 16 0 38 0 58.7 19 19 1 39 11 28.4 23 15 1 40 3 25.4 16 12 1 41 0 63.7 42 14 1 42 1 27.0 7 16 0 43 4 21.5 1 12 1 44 1 27.7 14 16 0 45 11 21.8 18 9 0 46 0 85.6 23 18 1 47 1 37.6 9 18 1 48 0 42.8 22 17 0 49 11 26.6 3 14 0 50 3 29.3 10 13 0 51 0 60.1 20 17 0 52 1 46.3 7 19 1 53 0 40.3 16 18 1 54 11 51.5 12 12 1 55 1 39.8 23 17 0 56 0 42.2 2 16 1 57 11 50.2 14 16 0 58 3 32.5 10 12 1 59 0 30.1 18 17 1 60 11 31.6 4 9 0 61 0 60.6 36 16 1 62 0 32.5 23 13 0 63 2 66.7 27 14 1 64 0 25.5 5 11 0 65 2 27.0 13 10 0 66 4 26.5 27 12 1 67 0 53.3 18 15 1 7 AGE 64 33 35 33 23 60 37 25 39 35 35 49 34 50 49 39 61 59 25 20 24 33 30 37 26 42 43 35 35 34 50 34 41 44 27 40 33 38 41 32 58 28 18 33 34 39 31 48 21 26 29 33 36 28 40 25 39 27 40 27 53 39 47 27 40 27 35 8 Work HRS 30 50 50 40 40 40 40 40 50 30 32 55 40 40 40 40 40 40 40 50 49 30 55 64 40 40 50 40 40 48 42 50 45 40 40 40 32 50 89 40 48 40 45 40 38 40 40 40 40 40 40 45 32 62 40 40 40 40 40 40 50 46 72 40 40 30 50 9 No EARN 2 1 2 2 1 1 1 3 1 1 1 2 2 1 1 2 1 1 1 2 2 2 1 1 2 3 4 2 2 2 3 4 2 3 2 3 2 2 1 1 2 1 5 1 3 1 1 1 2 1 1 1 2 2 1 2 1 3 2 3 3 2 1 2 2 1 1 10 Fam Inc 81.9 25.2 85.3 85.6 20.2 35.7 15.0 49.5 60.8 38.4 33.5 93.5 55.2 17.4 27.6 67.2 34.6 35.4 33.1 14.3 27.4 42.8 33.8 35.7 65.3 51.2 91.8 51.8 46.9 67.7 69.6 34.2 18.5 34.2 36.2 29.9 46.6 68.0 19.2 15.4 56.5 20.0 55.5 19.3 43.7 91.8 29.4 33.5 60.7 19.6 50.1 37.4 71.3 47.1 44.1 43.2 45.2 32.5 35.1 48.9 75.1 50.3 59.5 30.4 19.3 17.0 43.3 11 Job Sat 1 1 2 2 1 1 2 2 2 2 1 3 2 3 2 1 1 2 4 1 3 3 1 1 1 1 1 1 2 1 2 2 2 1 2 1 1 1 3 1 2 1 3 1 2 1 2 2 2 2 1 2 4 1 4 1 2 1 2 2 2 1 1 4 2 2 1 Page A1 12 13 14 15 16 Job Get TraumatEmploy Num Char Ahead Events Years Prom 3 2 0 11 0 1 2 0 4 3 4 1 0 3 0 3 1 0 9 2 1 1 0 1.5 0 1 1 0 20 0 1 2 0 1.5 0 5 3 1 1.5 0 5 1 0 5 0 1 2 0 3 2 1 1 0 1.5 0 1 1 0 5 0 1 1 0 6 1 1 1 0 10 0 3 2 1 22.08 0 5 1 0 0.5 0 1 1 0 0.75 0 5 1 1 1.5 1 5 3 0 1 1 1 1 0 1 3 4 2 0 5 1 5 1 0 5 0 5 1 0 5 1 5 1 1 3 0 4 1 0 3.5 1 1 1 1 5.5 0 4 1 0 12 2 5 1 0 0.5 0 5 2 3 0.75 2 3 1 0 3 0 5 1 0 3.5 1 3 3 1 8 2 1 1 0 2 0 1 3 0 5.5 0 5 1 0 7 0 1 1 0 10 1 5 3 0 2.58 0 4 1 0 15 4 1 1 0 1 0 1 2 0 0.16 0 4 3 0 36 4 5 1 0 12.33 1 1 1 0 1 0 5 2 0 3 0 1 1 0 1.5 1 5 2 1 3 0 5 1 0 4 0 5 1 0 6 2 5 1 0 0.66 0 3 1 0 4 5 5 1 0 16 0 5 1 0 4 1 5 2 0 4.08 1 4 2 0 5 3 5 3 0 4.5 0 4 1 0 2 0 5 1 0 2 1 5 1 0 5 0 1 1 0 11.83 4 5 1 0 4 0 1 3 0 10 0 5 1 0 1 0 1 1 0 5 0 2 2 1 2 2 5 3 0 4 0 5 1 2 0.5 0 1 1 1 10 0 Page A4 1 2 3 4 5 6 Resp Years ID_No OCCUP INCOME WORKed EDUCat GENDER 68 11 32.0 8 16 1 69 4 20.2 34 9 1 70 1 51.3 13 16 1 71 4 64.2 26 12 1 72 1 29.8 12 14 0 73 2 60.0 32 12 1 74 0 54.7 13 16 0 75 0 26.0 6 16 0 76 9 24.6 20 12 0 77 3 31.7 15 12 0 78 0 33.6 11 16 1 79 2 49.0 30 12 1 80 4 40.9 37 14 1 81 2 42.3 11 13 1 82 3 27.9 17 14 1 83 1 49.8 42 15 1 84 1 47.2 19 16 0 85 1 64.6 30 16 1 86 2 28.8 24 14 0 87 4 49.6 8 17 1 88 11 88.0 23 14 1 89 0 35.2 20 12 0 90 1 74.5 21 20 1 91 0 38.6 21 13 0 92 0 71.7 25 16 0 93 0 45.1 12 16 0 94 3 30.6 20 14 0 95 11 23.7 15 12 0 96 11 50.8 35 12 1 97 2 49.2 8 15 1 98 3 29.7 27 12 0 99 3 37.1 21 13 0 100 3 27.8 20 12 0 101 4 24.6 20 12 0 102 11 38.4 17 14 1 103 11 31.1 8 14 1 104 2 25.0 14 12 1 105 1 39.2 18 18 1 106 11 33.0 15 16 1 107 2 30.0 8 10 1 108 3 33.1 25 16 0 109 3 36.8 18 13 1 110 3 29.3 8 12 0 111 11 20.3 6 16 1 112 3 26.7 20 12 0 113 3 25.9 9 12 0 114 3 35.8 45 12 0 115 3 33.9 10 13 1 116 4 28.9 16 14 1 117 2 46.3 10 12 1 118 1 68.0 34 20 0 119 11 40.7 25 15 0 120 1 61.8 27 17 1 121 11 32.1 7 15 1 122 11 42.5 24 12 1 123 0 34.8 14 16 0 124 12 51.5 26 16 0 125 0 38.5 17 12 0 126 3 30.0 15 12 0 127 11 37.1 8 12 1 128 4 47.3 10 14 1 129 4 26.7 20 12 0 130 11 61.8 49 12 1 131 11 32.7 15 14 0 132 2 52.5 27 8 1 133 1 54.4 28 19 1 134 3 60.5 20 16 1 135 11 91.7 36 16 1 136 11 65.3 20 16 1 137 3 26.2 10 12 0 7 AGE 25 53 35 43 33 48 26 23 49 53 29 53 43 30 27 59 36 52 40 29 40 36 38 64 43 28 52 48 52 29 43 39 40 49 34 25 32 39 32 25 42 37 28 23 37 35 63 29 33 26 50 49 44 25 41 44 48 36 42 26 27 48 65 33 44 48 37 52 38 35 8 Work HRS 40 35 40 48 40 40 40 40 40 40 55 40 40 40 40 35 40 40 50 59 40 45 45 43 55 46 40 30 40 50 40 36 45 40 48 50 42 32 40 40 36 40 50 60 40 43 35 41 50 44 40 40 35 31 40 40 45 60 40 40 65 40 40 40 40 55 50 70 60 40 9 No EARN 3 1 1 2 3 3 2 1 4 1 1 2 1 2 2 2 1 2 2 2 2 1 1 1 2 1 1 2 2 1 2 3 1 4 2 1 1 3 1 1 1 4 1 3 2 1 1 2 2 1 2 3 3 2 1 3 1 3 2 1 2 3 4 2 1 4 2 1 2 2 10 Fam Inc 52.3 15.6 41.3 67.9 62.5 54.1 65.3 16.9 82.5 35.7 34.8 43.9 30.9 39.3 46.5 69.0 38.8 56.7 57.4 46.6 92.9 25.9 65.7 35.2 78.8 38.3 47.3 36.1 96.2 63.6 57.8 31.2 17.8 82.5 33.4 29.9 15.0 62.6 23.5 20.0 34.2 34.0 19.3 38.4 26.5 15.9 38.7 43.0 22.4 36.3 98.7 50.8 61.6 39.8 23.4 48.2 42.1 59.0 23.0 38.2 39.7 46.8 68.0 83.3 49.2 66.8 59.2 81.7 59.0 43.4 11 Job Sat 1 1 2 1 2 2 1 1 2 2 2 2 1 2 2 1 2 4 1 1 1 3 1 1 1 2 2 1 3 1 1 2 1 2 1 2 3 1 2 3 4 3 2 2 2 1 1 2 2 2 2 2 2 1 1 1 1 4 1 1 2 2 1 2 2 2 2 1 1 2 12 13 14 15 16 Job Get TraumatEmploy Num Char Ahead Events Years Prom 5 1 0 2.5 0 5 1 1 5 0 5 1 0 6.41 3 1 1 0 11 2 1 1 1 2 1 4 3 2 21 4 4 1 0 3.5 1 2 1 0 0.75 0 1 1 0 4 0 5 2 0 12.5 1 5 1 0 1 1 5 1 0 0.08 0 5 3 0 2 0 5 1 0 10 2 5 1 2 0.5 0 5 1 0 6 0 4 2 0 12.5 1 5 1 0 21 1 5 3 0 1.5 1 1 2 0 2.83 0 5 1 0 4.33 0 1 1 0 10 1 5 3 0 4 2 4 1 0 7 1 5 1 0 18 2 5 1 0 0.16 0 5 1 0 3 1 5 1 0 1.66 0 5 1 1 0.08 0 4 2 0 1 0 5 1 0 9.41 1 5 1 0 16 0 1 1 0 0.5 0 1 1 0 4 0 5 1 0 10 2 2 1 0 3 0 4 3 0 1 0 3 2 0 2 0 1 1 0 3 3 4 3 0 2 3 5 2 0 12 1 4 1 0 16 0 1 1 0 3 0 1 3 0 1 1 1 1 0 10 0 5 1 0 1.5 1 2 3 0 22 1 4 3 0 3 2 5 2 1 1 0 1 1 0 2.5 0 3 3 0 8 0 5 1 0 3.41 0 5 3 0 22 0 2 1 0 1 1 1 1 0 10.5 1 1 1 0 5 3 4 2 0 4 0 1 1 0 9.5 1 2 3 0 7.08 0 1 3 0 1 0 1 1 1 2 0 5 1 0 9 0 4 1 1 12.41 2 3 3 0 3.75 0 4 3 0 11 1 4 3 0 5.66 0 5 1 0 8.5 2 5 1 0 1 0 5 1 0 2.66 0 1 1 0 2.5 3 Page A5 1 2 3 4 5 6 Resp Years ID_No OCCUP INCOME WORKed EDUCat GENDER 138 0 52.6 12 16 1 139 2 52.3 16 12 1 140 3 44.6 10 16 0 141 4 32.5 6 12 1 142 0 57.1 45 11 1 143 11 49.1 24 13 1 144 4 24.9 9 15 1 145 11 26.0 19 18 0 146 11 43.1 19 16 1 147 0 31.2 20 12 0 148 2 31.7 15 11 1 149 11 35.1 30 10 0 150 3 32.7 13 15 0 151 1 37.0 15 19 0 152 11 26.1 3 10 1 153 2 40.4 14 12 1 154 1 38.6 6 17 1 155 11 35.2 9 14 1 156 11 40.6 15 17 1 157 2 40.9 33 12 1 158 4 45.1 31 12 1 159 4 23.9 10 14 0 160 11 27.1 20 10 0 161 11 51.5 26 16 0 162 4 36.7 19 16 1 163 3 30.0 25 13 0 164 11 32.7 21 14 1 165 11 48.2 23 12 1 166 3 29.7 15 12 0 167 4 55.3 14 12 1 168 4 44.0 12 12 1 169 1 67.8 22 20 1 170 0 43.3 20 20 0 171 4 55.3 30 16 1 172 11 48.1 32 14 1 173 0 24.7 7 16 1 174 11 34.7 27 13 0 175 11 23.6 5 13 0 176 3 30.5 20 12 0 177 1 45.5 13 12 1 178 1 58.6 15 20 1 179 2 54.8 18 13 1 180 1 50.1 25 15 1 181 1 61.4 29 18 1 182 1 39.9 38 18 1 183 4 33.7 40 8 1 184 1 36.4 40 10 1 185 2 40.8 25 13 1 186 11 55.7 15 16 1 187 3 28.9 12 12 0 188 1 47.9 30 18 0 189 0 57.7 15 12 1 190 11 49.0 27 16 1 191 0 42.4 11 20 1 192 4 41.2 21 14 1 193 0 36.7 26 12 0 194 4 26.4 13 12 1 195 4 36.1 13 10 1 196 11 69.3 30 16 1 197 0 52.3 18 16 1 198 3 23.2 22 12 0 199 4 21.9 35 14 0 200 3 48.7 8 12 0 201 11 43.7 24 14 0 202 11 36.9 11 16 1 203 0 33.0 16 12 0 204 11 27.3 16 14 0 205 11 48.3 24 12 1 206 0 69.3 18 12 1 207 3 26.3 24 12 1 7 AGE 34 34 27 23 62 41 26 36 37 39 33 61 29 47 20 31 28 22 36 51 48 30 40 48 35 61 38 40 32 32 33 39 58 47 50 24 44 30 55 30 31 37 41 46 57 61 58 49 32 29 47 32 44 34 38 42 30 29 47 40 38 55 32 43 37 32 31 44 39 41 8 Work HRS 43 52 40 46 50 76 38 42 40 40 40 40 42 41 54 60 50 40 40 67 44 37 40 45 48 40 38 40 40 52 40 60 45 52 40 50 50 40 40 40 60 60 50 55 49 32 40 40 40 32 40 60 40 55 60 60 42 40 50 70 40 40 40 40 40 55 40 89 50 72 9 No EARN 1 1 2 2 1 2 2 2 4 1 1 1 2 1 2 1 2 1 1 3 2 2 2 1 2 1 3 2 2 1 2 2 2 1 2 2 4 2 1 1 2 1 3 2 3 2 1 2 1 2 1 2 2 1 2 3 1 2 4 1 2 2 1 2 1 2 2 2 2 1 10 Fam Inc 42.6 42.3 69.3 25.3 47.1 46.1 39.1 71.2 51.2 21.2 39.2 25.5 43.1 36.3 22.5 32.4 31.1 25.2 30.6 47.4 63.2 43.4 15.0 42.1 46.6 20.0 49.5 66.2 38.9 45.3 46.4 78.6 35.5 46.0 50.5 25.3 56.6 21.9 20.5 35.5 51.2 45.5 45.1 90.4 34.6 26.6 26.4 58.7 45.7 21.9 37.9 69.7 69.6 32.4 50.0 38.2 17.3 28.6 89.2 42.3 16.7 24.0 38.7 21.3 26.9 32.2 27.6 46.1 74.0 16.3 11 Job Sat 1 2 1 2 1 1 1 4 2 2 2 1 2 4 2 2 2 2 1 1 2 2 1 1 2 1 2 1 2 1 3 1 1 2 3 2 1 4 2 1 1 2 2 1 2 2 1 4 2 1 3 2 1 1 2 2 3 2 1 1 2 1 2 1 1 2 1 1 1 1 12 13 14 15 16 Job Get TraumatEmploy Num Char Ahead Events Years Prom 5 3 0 5.5 1 5 1 0 13 2 5 1 0 5 4 5 1 1 1.41 0 1 2 0 52.25 4 5 1 0 27.16 4 5 1 5 0.5 1 5 1 1 1 0 5 1 2 19 4 5 1 0 10 0 5 1 0 1 2 5 2 0 13 3 2 3 0 4.33 0 1 1 0 1 0 4 2 0 3 0 5 2 0 12.5 3 5 1 0 4.58 2 5 2 0 1 0 5 1 0 7 3 4 3 1 32.33 0 2 3 0 24.75 2 5 1 0 4 0 1 1 0 17 0 4 2 0 4 0 1 1 0 12 1 1 2 0 18.33 0 2 1 0 2.66 2 2 1 0 3 1 5 1 1 11.58 3 5 1 0 13 3 5 1 1 11 0 5 1 0 17 2 4 2 0 12 0 5 3 0 8 0 5 2 0 22.5 2 5 2 0 1 0 1 1 0 10 0 5 2 0 2 0 1 2 0 15 2 1 1 0 1.5 0 5 1 0 3 1 5 2 0 3 0 4 1 0 6 2 5 2 0 7 4 5 1 0 34 0 5 1 1 40 0 1 2 0 3.91 0 5 2 0 6 0 5 1 0 7 1 5 1 0 3 1 3 1 0 2 0 1 1 0 12 5 4 1 0 22 4 5 1 0 4 1 5 1 0 15 2 5 1 2 22 3 5 2 1 1.5 0 2 3 0 0.25 0 5 1 0 23.58 3 5 1 0 2 0 5 1 1 1 0 5 1 1 29.5 1 1 1 0 6 0 1 2 0 22.25 1 5 1 0 5 2 5 1 0 11 1 1 1 0 10 2 4 1 0 0.66 0 5 2 0 11 2 5 3 1 18 0 Page A6 1 2 3 4 5 6 Resp Years ID_No OCCUP INCOME WORKed EDUCat GENDER 208 11 44.4 13 14 1 209 4 41.4 41 8 1 210 1 63.8 38 18 1 211 2 36.4 54 12 1 212 3 24.4 6 16 0 213 3 23.4 26 12 0 214 11 33.1 12 16 1 215 4 22.0 19 14 1 216 2 32.8 7 12 1 217 0 40.7 22 16 1 218 3 25.3 17 13 0 219 1 37.9 20 16 0 220 3 25.5 21 14 0 221 9 21.9 35 14 0 222 3 55.8 24 12 1 223 4 39.5 21 15 1 224 1 30.4 4 16 0 225 1 47.7 24 20 0 226 11 33.4 11 14 0 227 4 35.9 11 12 1 228 2 36.8 20 12 1 229 0 51.2 11 15 1 230 11 36.0 8 16 1 231 11 45.2 42 11 1 232 4 23.1 20 12 1 233 3 29.3 16 9 1 234 4 21.1 4 12 0 235 11 28.7 20 9 0 236 3 72.8 19 12 0 237 0 35.2 22 16 0 238 1 31.1 10 13 1 239 11 46.6 25 17 1 240 1 39.3 11 12 1 241 4 29.3 30 8 1 242 1 42.2 14 18 0 243 2 53.6 22 15 1 244 1 38.1 20 16 0 245 11 25.3 13 14 0 246 11 35.0 16 17 0 247 2 25.3 34 13 1 248 11 42.6 14 14 1 249 3 27.8 10 15 0 250 3 25.4 15 14 0 251 0 35.9 19 14 0 252 3 25.0 11 12 0 253 4 40.3 25 13 1 254 3 62.7 31 14 1 255 0 55.7 17 16 1 256 1 38.6 14 20 0 257 0 26.2 20 16 1 258 0 54.7 45 15 1 259 2 28.1 5 12 0 260 0 65.0 45 14 1 261 11 37.5 17 12 1 262 4 35.2 16 11 1 263 4 31.4 22 12 1 264 1 35.5 21 16 0 265 4 26.1 33 10 1 266 2 41.9 34 16 1 267 0 60.4 35 14 1 268 2 26.2 13 13 1 269 3 50.7 24 18 0 270 0 64.9 20 16 1 271 1 28.1 24 18 0 272 1 60.9 14 12 1 273 2 36.1 22 14 1 274 8 25.4 15 14 0 275 0 37.6 28 12 0 276 0 33.9 26 19 0 277 11 68.0 48 12 1 7 AGE 30 58 55 60 29 42 41 35 24 39 38 37 47 55 41 38 26 41 31 29 38 33 25 62 42 33 21 50 36 41 27 42 28 46 32 40 39 30 33 56 30 27 37 36 32 44 48 39 31 39 62 21 62 34 35 41 45 54 51 52 29 44 40 41 31 40 37 43 41 64 8 Work HRS 40 65 75 68 40 40 38 48 50 45 35 35 60 40 45 60 45 35 40 45 40 40 60 45 40 56 55 40 40 50 57 47 60 40 40 46 40 43 45 40 40 45 40 65 40 50 80 40 45 60 40 72 40 45 40 45 50 40 40 40 60 40 50 40 45 40 40 46 40 48 9 No EARN 2 3 2 1 3 1 1 2 2 1 1 1 3 2 1 2 1 2 2 2 2 1 1 2 2 1 4 2 1 1 2 1 2 4 1 1 2 2 1 1 2 1 1 1 2 2 2 2 1 1 2 4 3 3 1 1 2 3 1 1 2 2 2 2 1 1 1 1 2 2 10 Fam Inc 38.3 42.3 74.3 35.4 28.3 29.7 26.9 15.8 34.5 34.1 15.3 35.2 68.7 24.0 49.4 49.7 53.9 61.6 45.6 33.5 34.1 41.2 39.9 34.2 25.8 23.2 35.7 24.8 63.4 26.9 28.3 39.2 44.0 24.0 32.2 51.4 68.7 28.9 26.3 15.3 32.4 17.8 15.4 26.6 25.4 37.7 56.1 68.5 28.6 16.8 49.4 77.9 85.4 45.2 28.4 21.4 70.4 26.4 33.5 53.7 41.2 49.2 82.7 47.1 55.1 26.1 15.4 27.6 55.3 98.6 11 Job Sat 2 2 3 1 3 1 2 2 2 3 1 2 4 1 1 1 2 1 1 2 2 2 2 2 1 1 1 2 1 1 2 1 3 2 1 1 2 1 2 1 2 1 1 1 2 2 4 2 2 1 1 1 1 1 2 1 2 1 2 1 1 3 3 1 1 2 1 2 2 1 12 13 14 15 16 Job Get TraumatEmploy Num Char Ahead Events Years Prom 1 1 0 11 3 2 1 0 3 0 4 3 4 29 2 1 1 0 10 4 1 1 0 3 0 4 1 0 1.08 1 4 1 0 12 0 2 1 0 7 1 5 1 0 3 0 4 3 0 9 2 5 1 1 4 1 1 1 0 14 0 5 3 0 1 0 5 1 1 29.5 1 5 1 0 8 4 1 3 0 4 1 1 1 0 4 0 3 2 0 17 0 5 2 0 5.5 0 1 1 0 3 0 5 2 0 7 0 5 3 0 10 0 4 1 0 3 0 5 1 0 23 0 1 1 0 12.83 0 4 1 0 4.5 0 5 1 0 2 0 1 1 0 10 0 4 1 0 2.16 0 5 1 0 2.33 0 5 1 0 0.33 1 2 2 2 5 0 5 1 0 5.5 5 1 1 1 2 0 5 1 0 5 0 5 1 0 18 6 3 1 1 5 1 5 3 3 0.25 1 5 1 0 1 0 5 1 0 1.83 0 5 2 0 6 0 5 3 0 2 0 1 1 1 15 3 5 3 0 6 0 3 1 0 10 0 1 1 1 15 0 1 3 0 9 1 4 3 0 16 1 5 2 0 1 0 1 1 2 3.25 0 2 1 0 27 2 1 1 0 1.08 0 1 1 0 1.91 2 4 2 0 2.08 1 1 3 0 13 0 1 1 0 0.25 0 1 1 0 20 3 2 2 0 33 2 5 3 0 6 1 2 2 0 31.91 3 1 3 0 5 1 1 2 0 22 0 5 1 0 6 1 5 1 0 0.25 0 1 1 0 0.66 0 5 2 0 15 1 1 1 1 15 3 5 3 0 14 1 5 1 0 4 0 5 1 1 29 3 Page A7 1 2 3 4 5 6 Resp Years ID_No OCCUP INCOME WORKed EDUCat GENDER 278 1 37.0 23 13 0 279 4 43.0 35 8 1 280 3 27.1 15 13 0 281 2 36.6 20 12 1 282 8 25.5 34 12 0 283 1 36.0 10 18 0 284 11 30.8 9 14 1 285 0 31.3 28 12 1 286 1 33.4 9 16 0 287 0 51.2 16 14 1 288 11 35.8 19 12 0 289 2 49.2 20 14 1 290 11 61.6 12 16 1 291 0 38.1 25 13 0 292 4 37.5 29 12 1 293 11 34.0 16 14 0 294 0 49.6 30 13 0 295 0 40.2 6 16 0 296 8 27.7 20 13 0 297 2 61.2 37 14 1 298 0 86.4 38 12 1 299 1 29.5 27 18 1 300 3 27.7 20 13 0 301 0 39.4 25 16 0 302 4 52.8 38 14 1 303 0 24.7 26 13 1 304 4 30.5 27 16 0 305 1 30.4 27 16 1 306 4 28.2 45 11 0 307 3 25.3 3 12 0 308 1 53.4 25 19 0 309 1 48.5 18 14 1 310 2 46.6 21 14 1 311 11 41.2 20 15 1 312 3 28.1 22 13 0 313 1 40.4 33 18 1 314 1 43.4 14 16 0 315 3 56.6 32 12 1 316 1 77.0 35 19 1 317 1 43.7 32 16 0 318 1 49.4 19 14 1 319 11 41.3 9 16 0 320 1 101.9 35 16 1 321 0 43.7 25 16 0 322 0 26.6 5 15 0 323 2 53.6 27 12 1 324 4 32.5 12 12 1 325 11 27.6 10 12 0 326 4 41.8 45 8 1 327 1 37.9 27 18 1 328 11 39.4 23 12 0 329 2 35.0 35 12 1 330 4 46.9 21 12 1 331 2 52.7 35 12 1 332 1 47.7 26 15 1 333 0 62.6 8 14 1 334 4 35.7 11 11 0 335 2 42.5 42 12 1 336 4 31.6 12 16 0 337 2 57.2 16 14 1 338 11 46.9 23 12 1 339 11 27.4 34 12 0 340 4 24.7 8 12 0 341 1 32.7 12 16 0 342 2 23.2 10 14 1 343 2 32.5 35 11 0 344 4 33.3 22 12 1 345 1 35.4 19 18 0 346 11 27.8 17 16 1 347 11 48.4 24 12 0 7 AGE 40 52 41 38 56 26 26 45 26 33 38 36 36 45 45 34 51 38 40 54 57 43 40 45 54 43 48 44 57 20 49 39 41 37 65 50 57 48 53 52 38 33 63 51 43 44 30 42 62 38 54 52 38 55 43 25 36 53 28 32 40 57 27 38 28 52 39 36 38 41 8 Work HRS 51 40 40 40 40 40 40 40 40 55 32 40 60 36 50 40 40 40 45 50 32 54 45 40 50 40 35 40 40 40 28 40 40 40 40 40 34 40 50 60 52 40 45 40 38 40 50 40 40 60 40 40 48 44 60 73 48 40 60 40 60 42 32 40 75 50 50 60 60 40 9 No EARN 2 1 2 2 2 1 1 1 1 1 2 1 1 2 2 1 2 2 3 2 2 1 3 4 1 2 1 1 2 2 1 1 1 1 1 1 4 4 4 2 1 1 4 2 4 2 1 2 1 1 2 2 2 3 2 1 2 4 2 2 1 1 2 1 1 1 1 4 2 2 10 Fam Inc 29.7 33.2 32.4 29.6 44.5 26.0 20.8 44.1 29.0 48.8 59.4 39.8 51.6 60.3 47.6 19.5 85.9 90.5 31.4 66.7 94.2 24.6 31.4 53.3 42.8 23.3 20.9 20.4 30.1 27.1 45.3 38.5 39.4 31.2 18.2 30.4 88.0 71.0 70.1 51.4 59.9 31.3 98.3 66.1 67.6 61.2 22.5 22.7 32.0 42.7 21.3 34.6 51.7 46.9 70.8 54.4 47.5 46.5 40.0 49.3 37.5 18.7 22.0 22.7 14.5 22.5 23.3 51.2 50.6 76.4 11 Job Sat 1 4 2 1 2 1 1 2 1 2 1 1 1 2 1 1 1 1 2 1 1 2 2 1 2 1 2 1 2 1 1 1 2 1 1 1 2 1 2 1 1 1 1 2 4 1 3 1 1 2 1 1 2 2 2 1 2 1 1 2 1 2 2 1 2 1 2 2 1 4 12 13 14 15 16 Job Get TraumatEmploy Num Char Ahead Events Years Prom 5 1 0 17 0 3 1 1 20 2 5 1 0 4 0 1 1 0 11 3 5 1 0 21 0 5 1 0 1 0 4 2 0 1.5 1 5 3 1 0.58 1 5 1 0 8 3 1 2 1 7 4 5 1 0 3.5 1 2 1 0 18 2 3 2 0 5 0 5 1 0 21 4 1 1 0 17 2 5 1 2 4 1 5 2 0 24 4 1 3 0 6 4 5 1 0 7 1 5 1 0 5 0 1 1 1 34 0 2 3 1 13 2 5 1 0 7 1 5 2 0 4 0 5 1 0 27 2 5 1 0 26 0 5 3 0 3 0 5 1 0 2 0 1 1 0 15 2 4 1 0 1.5 0 5 1 0 1 3 5 1 1 10 1 5 2 0 11 1 5 1 0 5 0 5 1 0 13 1 3 2 0 23 3 3 1 0 11 0 5 1 0 25 1 5 1 0 11 0 4 1 0 18 0 5 1 0 1.5 1 1 2 0 1 0 5 2 0 32 0 5 2 0 23 1 5 1 0 3 0 3 1 0 20 4 5 1 0 8 2 5 1 2 6 1 5 2 0 17 0 5 1 0 12 0 5 1 0 23 0 5 1 0 27 0 4 1 1 18 1 5 1 0 14 0 1 1 0 17 0 5 1 0 2.5 0 5 2 0 10 0 5 2 0 22 0 5 1 0 7 0 5 1 0 1 0 5 1 1 11.25 0 5 1 0 29.25 0 4 1 0 5 1 4 1 0 10 1 4 1 0 3 0 5 1 0 19.16 0 5 3 0 3.41 2 5 1 0 10 0 5 1 0 2 0 5 1 4 11 0 Page A8 1 2 3 4 5 6 Resp Years ID_No OCCUP INCOME WORKed EDUCat GENDER 348 4 41.1 4 14 1 349 11 26.5 15 10 1 350 3 32.5 25 12 0 351 2 31.8 44 12 1 352 2 56.9 25 12 1 353 4 23.7 10 13 1 354 1 36.6 9 16 0 355 4 61.9 16 12 0 356 4 28.7 20 14 0 357 4 20.8 10 12 0 358 11 58.4 18 16 1 359 3 25.0 6 12 0 360 3 34.2 30 12 0 361 0 27.5 27 16 1 362 4 24.9 27 12 1 363 0 29.9 14 16 0 364 1 38.0 26 18 1 365 11 31.9 32 17 1 366 1 51.1 45 20 1 367 2 41.2 16 12 1 368 11 26.4 16 12 0 369 2 32.0 4 12 0 370 11 40.2 46 10 1 371 2 22.6 18 14 1 372 2 25.2 10 12 1 373 2 25.8 27 14 1 374 2 31.3 24 11 1 375 4 27.6 8 12 1 376 1 39.7 7 17 0 377 0 48.5 6 12 1 378 0 45.7 17 12 0 379 2 25.3 4 12 0 380 2 43.9 28 12 1 381 1 33.9 28 19 0 382 4 25.4 6 12 0 383 4 32.6 32 10 1 384 4 41.4 24 11 1 385 3 29.3 18 12 1 386 4 21.8 25 12 0 387 1 33.6 16 16 0 388 4 23.3 16 12 1 389 4 20.1 13 12 0 390 3 31.9 21 12 0 391 9 28.7 20 14 0 392 4 58.4 15 14 1 393 11 32.5 24 13 1 394 11 38.9 10 14 0 395 2 62.8 15 12 1 396 1 27.9 10 19 0 397 2 51.1 26 12 1 398 0 24.5 2 13 1 399 4 46.3 16 12 1 400 3 25.5 34 12 0 401 9 35.7 25 14 0 402 8 35.2 15 12 0 403 5 88.3 14 20 1 404 5 50.5 12 15 1 405 12 30.2 3 14 1 406 12 45.7 40 14 1 407 10 30.0 10 14 0 408 7 28.0 10 13 0 409 6 70.8 15 18 1 410 5 48.4 15 16 1 411 6 41.0 13 12 0 412 7 86.6 30 13 1 413 12 43.3 12 12 0 414 8 25.8 20 14 0 415 9 37.5 31 4 1 416 10 64.2 23 16 1 417 12 42.0 20 12 0 7 AGE 27 32 61 51 42 30 24 33 39 37 39 23 55 43 43 50 43 49 63 33 35 21 63 36 28 43 44 25 27 22 33 25 47 44 26 47 41 35 41 32 34 31 31 39 32 44 29 35 28 42 22 35 56 64 33 35 33 23 60 37 25 39 35 35 49 34 50 49 39 61 8 Work HRS 50 80 40 60 50 40 56 48 40 40 35 44 50 55 56 38 56 50 50 84 40 40 42 50 70 40 34 63 50 65 36 48 40 40 40 40 65 40 40 40 40 40 47 40 80 50 37 60 40 45 40 40 40 30 50 50 40 40 40 40 40 50 30 32 55 40 40 40 40 40 9 No EARN 1 2 1 2 2 1 2 2 2 2 2 2 2 3 2 3 2 1 2 1 2 2 1 2 1 1 1 2 2 2 1 1 2 2 2 2 3 2 4 2 1 2 3 2 2 3 2 1 1 2 3 2 2 2 1 2 2 1 1 1 3 1 1 1 2 2 1 1 2 1 10 Fam Inc 31.1 36.3 22.5 35.1 50.9 14.6 39.2 58.3 38.3 24.1 61.8 37.3 27.9 55.7 18.0 54.1 36.7 21.9 60.7 31.2 46.8 35.6 29.0 19.8 15.2 15.9 21.3 30.8 61.6 41.4 35.7 15.3 41.1 42.0 39.9 47.5 48.8 45.0 28.2 43.9 14.5 59.7 40.2 38.3 67.9 26.1 72.6 52.8 17.9 44.6 31.1 43.1 44.5 81.9 25.2 85.3 85.6 20.2 35.7 15.0 49.5 60.8 38.4 33.5 93.5 55.2 17.4 27.6 67.2 34.6 11 Job Sat 2 1 1 3 1 2 2 2 2 3 1 3 2 2 2 1 3 2 1 1 2 2 2 2 1 2 2 1 1 1 1 2 2 1 2 1 2 2 2 1 2 2 1 2 1 1 1 3 1 2 2 2 2 1 1 2 2 1 1 2 2 2 2 1 3 2 3 2 1 1 12 13 14 15 16 Job Get TraumatEmploy Num Char Ahead Events Years Prom 5 3 0 3 0 2 1 0 1.5 0 5 3 0 17 1 5 1 0 8 0 5 2 0 14 0 5 3 0 8 0 4 1 1 2 0 5 3 0 14 1 1 1 0 20 2 1 2 0 2.66 0 5 2 0 9 0 2 1 0 2.5 0 1 2 0 30 3 3 1 0 5 2 5 1 0 0.25 0 5 1 0 1 0 1 1 0 5.5 0 4 1 3 1.5 0 5 2 1 25 2 1 2 0 13.91 3 2 2 0 10 0 1 2 0 1.25 3 4 1 0 9.41 7 2 2 0 9.66 5 1 2 0 9.66 2 5 3 0 18.16 7 4 2 0 4 0 1 1 0 4 1 5 1 3 1 0 5 1 2 1 1 5 1 0 11 0 4 1 1 2 0 1 1 0 19 1 5 1 0 3.58 0 1 1 0 5 1 5 1 0 10 1 1 3 0 5 1 1 1 0 8 0 4 1 0 16 0 4 1 0 3 0 1 2 0 13 0 1 1 0 2.5 0 1 1 0 10 0 1 1 0 20 2 5 1 0 6 2 5 2 0 24 0 5 1 0 2 0 1 3 0 3 2 5 1 0 2 1 5 3 0 19.25 0 2 1 0 1.25 1 4 3 0 16 4 5 1 0 21 0 3 2 0 11 0 1 2 0 4 3 4 1 0 3 0 3 1 0 9 2 1 1 0 1.5 0 1 1 0 20 0 1 2 0 1.5 0 5 3 1 1.5 0 5 1 0 5 0 1 2 0 3 2 1 1 0 1.5 0 1 1 0 5 0 1 1 0 6 1 1 1 0 10 0 3 2 1 22.08 0 5 1 0 0.5 0 1 1 0 0.75 0 Page A9 1 2 3 4 5 6 Resp Years ID_No OCCUP INCOME WORKed EDUCat GENDER 418 5 36.6 43 16 1 419 8 43.1 7 16 1 420 9 20.5 3 11 1 421 8 34.3 7 12 0 422 7 43.3 17 10 1 423 12 43.8 14 16 1 424 12 45.7 20 13 0 425 8 46.1 36 16 0 426 6 33.7 25 16 0 427 10 66.4 27 13 1 428 7 52.7 18 15 1 429 8 24.7 15 16 1 430 5 41.3 18 12 0 431 8 34.1 33 14 0 432 12 40.3 15 12 0 433 10 55.2 24 13 1 434 6 27.9 9 16 0 435 12 30.4 11 17 0 436 7 36.3 23 13 1 437 6 31.6 12 16 0 438 5 58.7 19 19 1 439 12 28.4 23 15 1 440 8 25.4 16 12 1 441 5 63.7 42 14 1 442 6 27.0 7 16 0 443 9 21.5 1 12 1 444 6 27.7 14 16 0 445 12 21.8 18 9 0 446 5 85.6 23 18 1 447 6 37.6 9 18 1 448 5 42.8 22 17 0 449 10 26.6 3 14 0 450 3 46.1 36 16 0 451 5 60.1 20 17 0 452 6 46.3 7 19 1 453 5 40.3 16 18 1 454 10 51.5 12 12 1 455 6 39.8 23 17 0 456 5 42.2 2 16 1 457 12 50.2 14 16 0 458 8 32.5 10 12 1 459 5 30.1 18 17 1 460 10 31.6 4 9 0 461 5 60.6 36 16 1 462 5 32.5 23 13 0 463 7 66.7 27 14 1 464 5 25.5 5 11 0 465 7 27.0 13 10 0 466 9 26.5 27 12 1 467 5 53.3 18 15 1 468 12 32.0 8 16 1 469 9 20.2 34 9 1 470 6 51.3 13 16 1 471 9 64.2 26 12 1 472 6 29.8 12 14 0 473 7 60.0 32 12 1 474 8 29.3 10 13 0 475 5 26.0 6 16 0 476 8 28.1 4 14 0 477 8 31.7 15 12 0 478 5 33.6 11 16 1 479 7 49.0 30 12 1 480 9 40.9 37 14 1 481 7 42.3 11 13 1 482 8 27.9 17 14 1 483 6 49.8 42 15 1 484 6 47.2 19 16 0 485 6 64.6 30 16 1 486 7 28.8 24 14 0 487 9 49.6 8 17 1 7 AGE 59 25 20 24 33 30 37 56 42 43 35 35 34 50 34 41 44 27 40 33 38 41 32 58 28 18 33 34 39 31 48 21 56 29 33 36 28 40 25 39 27 40 27 53 39 47 27 40 27 35 25 53 35 43 33 48 26 23 30 53 29 53 43 30 27 59 36 52 40 29 8 Work HRS 40 40 50 49 30 55 64 40 40 50 40 40 48 42 50 45 40 40 40 32 50 89 40 48 40 45 40 38 40 40 40 40 40 40 45 32 62 40 40 40 40 40 40 50 46 72 40 40 30 50 40 35 40 48 40 40 40 40 48 40 55 40 40 40 40 35 40 40 50 59 9 No EARN 1 1 2 2 2 1 1 1 3 4 2 2 2 3 4 2 3 2 3 2 2 1 1 2 1 5 1 3 1 1 1 2 1 1 1 2 2 1 2 1 3 2 3 3 2 1 2 2 1 1 3 1 1 2 3 3 1 1 2 1 1 2 1 2 2 2 1 2 2 2 10 Fam Inc 35.4 33.1 14.3 27.4 42.8 33.8 35.7 36.9 51.2 91.8 51.8 46.9 67.7 69.6 34.2 18.5 34.2 36.2 29.9 46.6 68.0 19.2 15.4 56.5 20.0 55.5 19.3 43.7 91.8 29.4 33.5 60.7 36.9 50.1 37.4 71.3 47.1 44.1 43.2 45.2 32.5 35.1 48.9 75.1 50.3 59.5 30.4 19.3 17.0 43.3 52.3 15.6 41.3 67.9 62.5 54.1 19.6 16.9 41.8 35.7 34.8 43.9 30.9 39.3 46.5 69.0 38.8 56.7 57.4 46.6 11 Job Sat 2 4 1 3 3 1 1 1 1 1 1 2 1 2 2 2 1 2 1 1 1 3 1 2 1 3 1 2 1 2 2 2 1 1 2 4 1 4 1 2 1 2 2 2 1 1 4 2 2 1 1 1 2 1 2 2 2 1 2 2 2 2 1 2 2 1 2 4 1 1 12 13 14 15 16 Job Get TraumatEmploy Num Char Ahead Events Years Prom 5 1 1 1.5 1 5 3 0 1 1 1 1 0 1 3 4 2 0 5 1 5 1 0 5 0 5 1 0 5 1 5 1 1 3 0 1 1 0 30 3 1 1 1 5.5 0 4 1 0 12 2 5 1 0 0.5 0 5 2 3 0.75 2 3 1 0 3 0 5 1 0 3.5 1 3 3 1 8 2 1 1 0 2 0 1 3 0 5.5 0 5 1 0 7 0 1 1 0 10 1 5 3 0 2.58 0 4 1 0 15 4 1 1 0 1 0 1 2 0 0.16 0 4 3 0 36 4 5 1 0 12.33 1 1 1 0 1 0 5 2 0 3 0 1 1 0 1.5 1 5 2 1 3 0 5 1 0 4 0 5 1 0 6 2 5 1 0 0.66 0 1 1 0 30 3 5 1 0 16 0 5 1 0 4 1 5 2 0 4.08 1 4 2 0 5 3 5 3 0 4.5 0 4 1 0 2 0 5 1 0 2 1 5 1 0 5 0 1 1 0 11.83 4 5 1 0 4 0 1 3 0 10 0 5 1 0 1 0 1 1 0 5 0 2 2 1 2 2 5 3 0 4 0 5 1 2 0.5 0 1 1 1 10 0 5 1 0 2.5 0 5 1 1 5 0 5 1 0 6.41 3 1 1 0 11 2 1 1 1 2 1 4 3 2 21 4 3 1 0 4 5 2 1 0 0.75 0 1 2 1 1 1 5 2 0 12.5 1 5 1 0 1 1 5 1 0 0.08 0 5 3 0 2 0 5 1 0 10 2 5 1 2 0.5 0 5 1 0 6 0 4 2 0 12.5 1 5 1 0 21 1 5 3 0 1.5 1 1 2 0 2.83 0 Page A10 1 2 3 4 5 6 Resp Years ID_No OCCUP INCOME WORKed EDUCat GENDER 488 12 88.0 23 14 1 489 5 35.2 20 12 0 490 6 74.5 21 20 1 491 5 38.6 21 13 0 492 5 71.7 25 16 0 493 5 45.1 12 16 0 494 8 30.6 20 14 0 495 12 23.7 15 12 0 496 12 50.8 35 12 1 497 7 49.2 8 15 1 498 8 29.7 27 12 0 499 8 37.1 21 13 0 500 3 28.1 4 14 0 501 8 27.8 20 12 0 502 10 38.4 17 14 1 503 10 31.1 8 14 1 504 7 25.0 14 12 1 505 6 39.2 18 18 1 506 12 33.0 15 16 1 507 7 30.0 8 10 1 508 8 33.1 25 16 0 509 8 36.8 18 13 1 510 8 29.3 8 12 0 511 12 20.3 6 16 1 512 8 26.7 20 12 0 513 8 25.9 9 12 0 514 8 35.8 45 12 0 515 8 33.9 10 13 1 516 9 28.9 16 14 1 517 7 46.3 10 12 1 518 6 68.0 34 20 0 519 10 40.7 25 15 0 520 6 61.8 27 17 1 521 10 32.1 7 15 1 522 10 42.5 24 12 1 523 5 34.8 14 16 0 524 8 25.6 24 14 0 525 5 38.5 17 12 0 526 8 30.0 15 12 0 527 10 37.1 8 12 1 528 9 47.3 10 14 1 529 9 26.7 20 12 0 530 10 61.8 49 12 1 531 12 32.7 15 14 0 532 7 52.5 27 8 1 533 6 54.4 28 19 1 534 8 60.5 20 16 1 535 12 91.7 36 16 1 536 12 65.3 20 16 1 537 8 26.2 10 12 0 538 5 52.6 12 16 1 539 7 52.3 16 12 1 540 8 44.6 10 16 0 541 9 32.5 6 12 1 542 5 57.1 45 11 1 543 10 49.1 24 13 1 544 9 24.9 9 15 1 545 12 26.0 19 18 0 546 12 43.1 19 16 1 547 5 31.2 20 12 0 548 7 31.7 15 11 1 549 12 35.1 30 10 0 550 3 25.6 24 14 0 551 6 37.0 15 19 0 552 12 26.1 3 10 1 553 7 40.4 14 12 1 554 6 38.6 6 17 1 555 12 35.2 9 14 1 556 12 40.6 15 17 1 557 7 40.9 33 12 1 7 AGE 40 36 38 64 43 28 52 48 52 29 43 39 30 40 34 25 32 39 32 25 42 37 28 23 37 35 63 29 33 26 50 49 44 25 41 44 42 36 42 26 27 48 65 33 44 48 37 52 38 35 34 34 27 23 62 41 26 36 37 39 33 61 42 47 20 31 28 22 36 51 8 Work HRS 40 45 45 43 55 46 40 30 40 50 40 36 48 45 48 50 42 32 40 40 36 40 50 60 40 43 35 41 50 44 40 40 35 31 40 40 37 60 40 40 65 40 40 40 40 55 50 70 60 40 43 52 40 46 50 76 38 42 40 40 40 40 37 41 54 60 50 40 40 67 9 No EARN 2 1 1 1 2 1 1 2 2 1 2 3 2 1 2 1 1 3 1 1 1 4 1 3 2 1 1 2 2 1 2 3 3 2 1 3 1 3 2 1 2 3 4 2 1 4 2 1 2 2 1 1 2 2 1 2 2 2 4 1 1 1 1 1 2 1 2 1 1 3 10 Fam Inc 92.9 25.9 65.7 35.2 78.8 38.3 47.3 36.1 96.2 63.6 57.8 31.2 41.8 17.8 33.4 29.9 15.0 62.6 23.5 20.0 34.2 34.0 19.3 38.4 26.5 15.9 38.7 43.0 22.4 36.3 98.7 50.8 61.6 39.8 23.4 48.2 16.4 59.0 23.0 38.2 39.7 46.8 68.0 83.3 49.2 66.8 59.2 81.7 59.0 43.4 42.6 42.3 69.3 25.3 47.1 46.1 39.1 71.2 51.2 21.2 39.2 25.5 16.4 36.3 22.5 32.4 31.1 25.2 30.6 47.4 11 Job Sat 1 3 1 1 1 2 2 1 3 1 1 2 2 1 1 2 3 1 2 3 4 3 2 2 2 1 1 2 2 2 2 2 2 1 1 1 4 4 1 1 2 2 1 2 2 2 2 1 1 2 1 2 1 2 1 1 1 4 2 2 2 1 4 4 2 2 2 2 1 1 12 13 14 15 16 Job Get TraumatEmploy Num Char Ahead Events Years Prom 5 1 0 4.33 0 1 1 0 10 1 5 3 0 4 2 4 1 0 7 1 5 1 0 18 2 5 1 0 0.16 0 5 1 0 3 1 5 1 0 1.66 0 5 1 1 0.08 0 4 2 0 1 0 5 1 0 9.41 1 5 1 0 16 0 1 2 1 1 1 1 1 0 0.5 0 5 1 0 10 2 2 1 0 3 0 4 3 0 1 0 3 2 0 2 0 1 1 0 3 3 4 3 0 2 3 5 2 0 12 1 4 1 0 16 0 1 1 0 3 0 1 3 0 1 1 1 1 0 10 0 5 1 0 1.5 1 2 3 0 22 1 4 3 0 3 2 5 2 1 1 0 1 1 0 2.5 0 3 3 0 8 0 5 1 0 3.41 0 5 3 0 22 0 2 1 0 1 1 1 1 0 10.5 1 1 1 0 5 3 1 2 0 2 0 1 1 0 9.5 1 2 3 0 7.08 0 1 3 0 1 0 1 1 1 2 0 5 1 0 9 0 4 1 1 12.41 2 3 3 0 3.75 0 4 3 0 11 1 4 3 0 5.66 0 5 1 0 8.5 2 5 1 0 1 0 5 1 0 2.66 0 1 1 0 2.5 3 5 3 0 5.5 1 5 1 0 13 2 5 1 0 5 4 5 1 1 1.41 0 1 2 0 52.25 4 5 1 0 27.16 4 5 1 5 0.5 1 5 1 1 1 0 5 1 2 19 4 5 1 0 10 0 5 1 0 1 2 5 2 0 13 3 1 2 0 2 0 1 1 0 1 0 4 2 0 3 0 5 2 0 12.5 3 5 1 0 4.58 2 5 2 0 1 0 5 1 0 7 3 4 3 1 32.33 0 Page A11 1 2 3 4 5 6 Resp Years ID_No OCCUP INCOME WORKed EDUCat GENDER 558 9 45.1 31 12 1 559 9 23.9 10 14 0 560 10 27.1 20 10 0 561 8 32.7 13 15 0 562 9 36.7 19 16 1 563 8 30.0 25 13 0 564 10 32.7 21 14 1 565 10 48.2 23 12 1 566 8 29.7 15 12 0 567 9 55.3 14 12 1 568 9 44.0 12 12 1 569 6 67.8 22 20 1 570 5 43.3 20 20 0 571 9 55.3 30 16 1 572 12 48.1 32 14 1 573 5 24.7 7 16 1 574 12 34.7 27 13 0 575 12 23.6 5 13 0 576 8 30.5 20 12 0 577 6 45.5 13 12 1 578 6 58.6 15 20 1 579 7 54.8 18 13 1 580 6 50.1 25 15 1 581 6 61.4 29 18 1 582 6 39.9 38 18 1 583 9 33.7 40 8 1 584 6 36.4 40 10 1 585 7 40.8 25 13 1 586 12 55.7 15 16 1 587 8 28.9 12 12 0 588 6 47.9 30 18 0 589 5 57.7 15 12 1 590 12 49.0 27 16 1 591 5 42.4 11 20 1 592 9 41.2 21 14 1 593 5 36.7 26 12 0 594 9 26.4 13 12 1 595 9 36.1 13 10 1 596 10 69.3 30 16 1 597 5 52.3 18 16 1 598 8 23.2 22 12 0 599 8 48.7 8 12 0 600 3 37.3 20 12 0 601 10 43.7 24 14 0 602 12 36.9 11 16 1 603 5 33.0 16 12 0 604 12 27.3 16 14 0 605 12 48.3 24 12 1 606 5 69.3 18 12 1 607 8 26.3 24 12 1 608 12 44.4 13 14 1 609 9 41.4 41 8 1 610 6 63.8 38 18 1 611 7 36.4 54 12 1 612 8 24.4 6 16 0 613 8 23.4 26 12 0 614 12 33.1 12 16 1 615 9 22.0 19 14 1 616 7 32.8 7 12 1 617 5 40.7 22 16 1 618 8 25.3 17 13 0 619 6 37.9 20 16 0 620 8 25.5 21 14 0 621 8 37.3 20 12 0 622 8 55.8 24 12 1 623 9 39.5 21 15 1 624 6 30.4 4 16 0 625 6 47.7 24 20 0 626 12 33.4 11 14 0 627 9 35.9 11 12 1 7 AGE 48 30 40 29 35 61 38 40 32 32 33 39 58 47 50 24 44 30 55 30 31 37 41 46 57 61 58 49 32 29 47 32 44 34 38 42 30 29 47 40 38 32 38 43 37 32 31 44 39 41 30 58 55 60 29 42 41 35 24 39 38 37 47 38 41 38 26 41 31 29 8 Work HRS 44 37 40 42 48 40 38 40 40 52 40 60 45 52 40 50 50 40 40 40 60 60 50 55 49 32 40 40 40 32 40 60 40 55 60 60 42 40 50 70 40 40 40 40 40 55 40 89 50 72 40 65 75 68 40 40 38 48 50 45 35 35 60 40 45 60 45 35 40 45 9 No EARN 2 2 2 2 2 1 3 2 2 1 2 2 2 1 2 2 4 2 1 1 2 1 3 2 3 2 1 2 1 2 1 2 2 1 2 3 1 2 4 1 2 1 4 2 1 2 2 2 2 1 2 3 2 1 3 1 1 2 2 1 1 1 3 4 1 2 1 2 2 2 10 Fam Inc 63.2 43.4 15.0 43.1 46.6 20.0 49.5 66.2 38.9 45.3 46.4 78.6 35.5 46.0 50.5 25.3 56.6 21.9 20.5 35.5 51.2 45.5 45.1 90.4 34.6 26.6 26.4 58.7 45.7 21.9 37.9 69.7 69.6 32.4 50.0 38.2 17.3 28.6 89.2 42.3 16.7 38.7 72.6 21.3 26.9 32.2 27.6 46.1 74.0 16.3 38.3 42.3 74.3 35.4 28.3 29.7 26.9 15.8 34.5 34.1 15.3 35.2 68.7 72.6 49.4 49.7 53.9 61.6 45.6 33.5 11 Job Sat 2 2 1 2 2 1 2 1 2 1 3 1 1 2 3 2 1 4 2 1 1 2 2 1 2 2 1 4 2 1 3 2 1 1 2 2 3 2 1 1 2 2 1 1 1 2 1 1 1 1 2 2 3 1 3 1 2 2 2 3 1 2 4 1 1 1 2 1 1 2 12 13 14 15 16 Job Get TraumatEmploy Num Char Ahead Events Years Prom 2 3 0 24.75 2 5 1 0 4 0 1 1 0 17 0 2 3 0 4.33 0 1 1 0 12 1 1 2 0 18.33 0 2 1 0 2.66 2 2 1 0 3 1 5 1 1 11.58 3 5 1 0 13 3 5 1 1 11 0 5 1 0 17 2 4 2 0 12 0 5 3 0 8 0 5 2 0 22.5 2 5 2 0 1 0 1 1 0 10 0 5 2 0 2 0 1 2 0 15 2 1 1 0 1.5 0 5 1 0 3 1 5 2 0 3 0 4 1 0 6 2 5 2 0 7 4 5 1 0 34 0 5 1 1 40 0 1 2 0 3.91 0 5 2 0 6 0 5 1 0 7 1 5 1 0 3 1 3 1 0 2 0 1 1 0 12 5 4 1 0 22 4 5 1 0 4 1 5 1 0 15 2 5 1 2 22 3 5 2 1 1.5 0 2 3 0 0.25 0 5 1 0 23.58 3 5 1 0 2 0 5 1 1 1 0 1 1 0 6 0 4 1 0 10.5 4 1 2 0 22.25 1 5 1 0 5 2 5 1 0 11 1 1 1 0 10 2 4 1 0 0.66 0 5 2 0 11 2 5 3 1 18 0 1 1 0 11 3 2 1 0 3 0 4 3 4 29 2 1 1 0 10 4 1 1 0 3 0 4 1 0 1.08 1 4 1 0 12 0 2 1 0 7 1 5 1 0 3 0 4 3 0 9 2 5 1 1 4 1 1 1 0 14 0 5 3 0 1 0 4 1 0 10.5 4 5 1 0 8 4 1 3 0 4 1 1 1 0 4 0 3 2 0 17 0 5 2 0 5.5 0 1 1 0 3 0 Page A12 1 2 3 4 5 6 Resp Years ID_No OCCUP INCOME WORKed EDUCat GENDER 628 7 36.8 20 12 1 629 5 51.2 11 15 1 630 12 36.0 8 16 1 631 10 45.2 42 11 1 632 9 23.1 20 12 1 633 8 29.3 16 9 1 634 9 21.1 4 12 0 635 10 28.7 20 9 0 636 8 72.8 19 12 0 637 5 35.2 22 16 0 638 6 31.1 10 13 1 639 12 46.6 25 17 1 640 6 39.3 11 12 1 641 9 29.3 30 8 1 642 6 42.2 14 18 0 643 7 53.6 22 15 1 644 6 38.1 20 16 0 645 10 25.3 13 14 0 646 12 35.0 16 17 0 647 7 25.3 34 13 1 648 10 42.6 14 14 1 649 8 27.8 10 15 0 650 3 24.2 20 17 0 651 5 35.9 19 14 0 652 8 25.0 11 12 0 653 9 40.3 25 13 1 654 8 62.7 31 14 1 655 5 55.7 17 16 1 656 6 38.6 14 20 0 657 5 26.2 20 16 1 658 5 54.7 45 15 1 659 7 28.1 5 12 0 660 5 65.0 45 14 1 661 12 37.5 17 12 1 662 9 35.2 16 11 1 663 9 31.4 22 12 1 664 6 35.5 21 16 0 665 9 26.1 33 10 1 666 7 41.9 34 16 1 667 5 60.4 35 14 1 668 7 26.2 13 13 1 669 8 50.7 24 18 0 670 5 64.9 20 16 1 671 6 28.1 24 18 0 672 6 60.9 14 12 1 673 7 36.1 22 14 1 674 8 24.2 20 17 0 675 5 37.6 28 12 0 676 5 33.9 26 19 0 677 12 68.0 48 12 1 678 6 37.0 23 13 0 679 9 43.0 35 8 1 680 8 27.1 15 13 0 681 7 36.6 20 12 1 682 8 26.8 27 12 0 683 6 36.0 10 18 0 684 12 30.8 9 14 1 685 5 31.3 28 12 1 686 6 33.4 9 16 0 687 5 51.2 16 14 1 688 10 35.8 19 12 0 689 7 49.2 20 14 1 690 12 61.6 12 16 1 691 5 38.1 25 13 0 692 9 37.5 29 12 1 693 10 34.0 16 14 0 694 5 49.6 30 13 0 695 5 40.2 6 16 0 696 8 33.2 37 13 0 697 7 61.2 37 14 1 7 AGE 38 33 25 62 42 33 21 50 36 41 27 42 28 46 32 40 39 30 33 56 30 27 38 36 32 44 48 39 31 39 62 21 62 34 35 41 45 54 51 52 29 44 40 41 31 40 38 43 41 64 40 52 41 38 69 26 26 45 26 33 38 36 36 45 45 34 51 38 58 54 8 Work HRS 40 40 60 45 40 56 55 40 40 50 57 47 60 40 40 46 40 43 45 40 40 45 37 65 40 50 80 40 45 60 40 72 40 45 40 45 50 40 40 40 60 40 50 40 45 40 37 46 40 48 51 40 40 40 29 40 40 40 40 55 32 40 60 36 50 40 40 40 32 50 9 No EARN 2 1 1 2 2 1 4 2 1 1 2 1 2 4 1 1 2 2 1 1 2 1 1 1 2 2 2 2 1 1 2 4 3 3 1 1 2 3 1 1 2 2 2 2 1 1 1 1 2 2 2 1 2 2 1 1 1 1 1 1 2 1 1 2 2 1 2 2 1 2 10 Fam Inc 34.1 41.2 39.9 34.2 25.8 23.2 35.7 24.8 63.4 26.9 28.3 39.2 44.0 24.0 32.2 51.4 68.7 28.9 26.3 15.3 32.4 17.8 49.2 26.6 25.4 37.7 56.1 68.5 28.6 16.8 49.4 77.9 85.4 45.2 28.4 21.4 70.4 26.4 33.5 53.7 41.2 49.2 82.7 47.1 55.1 26.1 49.2 27.6 55.3 98.6 29.7 33.2 32.4 29.6 16.8 26.0 20.8 44.1 29.0 48.8 59.4 39.8 51.6 60.3 47.6 19.5 85.9 90.5 23.2 66.7 11 Job Sat 2 2 2 2 1 1 1 2 1 1 2 1 3 2 1 1 2 1 2 1 2 1 2 1 2 2 4 2 2 1 1 1 1 1 2 1 2 1 2 1 1 3 3 1 1 2 2 2 2 1 1 4 2 1 1 1 1 2 1 2 1 1 1 2 1 1 1 1 2 1 12 13 14 15 16 Job Get TraumatEmploy Num Char Ahead Events Years Prom 5 2 0 7 0 5 3 0 10 0 4 1 0 3 0 5 1 0 23 0 1 1 0 12.83 0 4 1 0 4.5 0 5 1 0 2 0 1 1 0 10 0 4 1 0 2.16 0 5 1 0 2.33 0 5 1 0 0.33 1 2 2 2 5 0 5 1 0 5.5 5 1 1 1 2 0 5 1 0 5 0 5 1 0 18 6 3 1 1 5 1 5 3 3 0.25 1 5 1 0 1 0 5 1 0 1.83 0 5 2 0 6 0 5 3 0 2 0 5 1 0 5 0 5 3 0 6 0 3 1 0 10 0 1 1 1 15 0 1 3 0 9 1 4 3 0 16 1 5 2 0 1 0 1 1 2 3.25 0 2 1 0 27 2 1 1 0 1.08 0 1 1 0 1.91 2 4 2 0 2.08 1 1 3 0 13 0 1 1 0 0.25 0 1 1 0 20 3 2 2 0 33 2 5 3 0 6 1 2 2 0 31.91 3 1 3 0 5 1 1 2 0 22 0 5 1 0 6 1 5 1 0 0.25 0 1 1 0 0.66 0 5 2 0 15 1 5 1 0 5 0 5 3 0 14 1 5 1 0 4 0 5 1 1 29 3 5 1 0 17 0 3 1 1 20 2 5 1 0 4 0 1 1 0 11 3 5 1 0 25 3 5 1 0 1 0 4 2 0 1.5 1 5 3 1 0.58 1 5 1 0 8 3 1 2 1 7 4 5 1 0 3.5 1 2 1 0 18 2 3 2 0 5 0 5 1 0 21 4 1 1 0 17 2 5 1 2 4 1 5 2 0 24 4 1 3 0 6 4 5 2 1 5 0 5 1 0 5 0 Page A13 1 2 3 4 5 6 Resp Years ID_No OCCUP INCOME WORKed EDUCat GENDER 698 5 86.4 38 12 1 699 6 29.5 27 18 1 700 3 33.2 37 13 0 701 5 39.4 25 16 0 702 9 52.8 38 14 1 703 5 24.7 26 13 1 704 9 30.5 27 16 0 705 6 30.4 27 16 1 706 9 28.2 45 11 0 707 8 25.3 3 12 0 708 6 53.4 25 19 0 709 6 48.5 18 14 1 710 7 46.6 21 14 1 711 12 41.2 20 15 1 712 8 28.1 22 13 0 713 6 40.4 33 18 1 714 6 43.4 14 16 0 715 8 56.6 32 12 1 716 6 77.0 35 19 1 717 6 43.7 32 16 0 718 6 49.4 19 14 1 719 12 41.3 9 16 0 720 6 101.9 35 16 1 721 5 43.7 25 16 0 722 5 26.6 5 15 0 723 7 53.6 27 12 1 724 9 32.5 12 12 1 725 12 27.6 10 12 0 726 9 41.8 45 8 1 727 6 37.9 27 18 1 728 10 39.4 23 12 0 729 7 35.0 35 12 1 730 9 46.9 21 12 1 731 7 52.7 35 12 1 732 6 47.7 26 15 1 733 5 62.6 8 14 1 734 9 35.7 11 11 0 735 7 42.5 42 12 1 736 9 31.6 12 16 0 737 7 57.2 16 14 1 738 12 46.9 23 12 1 739 12 27.4 34 12 0 740 9 24.7 8 12 0 741 6 32.7 12 16 0 742 7 23.2 10 14 1 743 7 32.5 35 11 0 744 9 33.3 22 12 1 745 6 35.4 19 18 0 746 12 27.8 17 16 1 747 12 48.4 24 12 0 748 9 41.1 4 14 1 749 12 26.5 15 10 1 750 3 20.3 20 13 0 751 7 31.8 44 12 1 752 7 56.9 25 12 1 753 9 23.7 10 13 1 754 6 36.6 9 16 0 755 9 61.9 16 12 0 756 8 32.5 25 12 0 757 9 20.8 10 12 0 758 12 58.4 18 16 1 759 8 25.0 6 12 0 760 8 34.2 30 12 0 761 5 27.5 27 16 1 762 9 24.9 27 12 1 763 5 29.9 14 16 0 764 6 38.0 26 18 1 765 12 31.9 32 17 1 766 6 51.1 45 20 1 767 7 41.2 16 12 1 7 AGE 57 43 58 45 54 43 48 44 57 20 49 39 41 37 65 50 57 48 53 52 38 33 63 51 43 44 30 42 62 38 54 52 38 55 43 25 36 53 28 32 40 57 27 38 28 52 39 36 38 41 27 32 57 51 42 30 24 33 61 37 39 23 55 43 43 50 43 49 63 33 8 Work HRS 32 54 32 40 50 40 35 40 40 40 28 40 40 40 40 40 34 40 50 60 52 40 45 40 38 40 50 40 40 60 40 40 48 44 60 73 48 40 60 40 60 42 32 40 75 50 50 60 60 40 50 80 32 60 50 40 56 48 40 40 35 44 50 55 56 38 56 50 50 84 9 No EARN 2 1 1 4 1 2 1 1 2 2 1 1 1 1 1 1 4 4 4 2 1 1 4 2 4 2 1 2 1 1 2 2 2 3 2 1 2 4 2 2 1 1 2 1 1 1 1 4 2 2 1 2 2 2 2 1 2 2 1 2 2 2 2 3 2 3 2 1 2 1 10 Fam Inc 94.2 24.6 23.2 53.3 42.8 23.3 20.9 20.4 30.1 27.1 45.3 38.5 39.4 31.2 18.2 30.4 88.0 71.0 70.1 51.4 59.9 31.3 98.3 66.1 67.6 61.2 22.5 22.7 32.0 42.7 21.3 34.6 51.7 46.9 70.8 54.4 47.5 46.5 40.0 49.3 37.5 18.7 22.0 22.7 14.5 22.5 23.3 51.2 50.6 76.4 31.1 36.3 42.5 35.1 50.9 14.6 39.2 58.3 22.5 24.1 61.8 37.3 27.9 55.7 18.0 54.1 36.7 21.9 60.7 31.2 11 Job Sat 1 2 2 1 2 1 2 1 2 1 1 1 2 1 1 1 2 1 2 1 1 1 1 2 4 1 3 1 1 2 1 1 2 2 2 1 2 1 1 2 1 2 2 1 2 1 2 2 1 4 2 1 2 3 1 2 2 2 1 3 1 3 2 2 2 1 3 2 1 1 12 13 14 15 16 Job Get TraumatEmploy Num Char Ahead Events Years Prom 1 1 1 34 0 2 3 1 13 2 5 2 1 5 0 5 2 0 4 0 5 1 0 27 2 5 1 0 26 0 5 3 0 3 0 5 1 0 2 0 1 1 0 15 2 4 1 0 1.5 0 5 1 0 1 3 5 1 1 10 1 5 2 0 11 1 5 1 0 5 0 5 1 0 13 1 3 2 0 23 3 3 1 0 11 0 5 1 0 25 1 5 1 0 11 0 4 1 0 18 0 5 1 0 1.5 1 1 2 0 1 0 5 2 0 32 0 5 2 0 23 1 5 1 0 3 0 3 1 0 20 4 5 1 0 8 2 5 1 2 6 1 5 2 0 17 0 5 1 0 12 0 5 1 0 23 0 5 1 0 27 0 4 1 1 18 1 5 1 0 14 0 1 1 0 17 0 5 1 0 2.5 0 5 2 0 10 0 5 2 0 22 0 5 1 0 7 0 5 1 0 1 0 5 1 1 11.25 0 5 1 0 29.25 0 4 1 0 5 1 4 1 0 10 1 4 1 0 3 0 5 1 0 19.16 0 5 3 0 3.41 2 5 1 0 10 0 5 1 0 2 0 5 1 4 11 0 5 3 0 3 0 2 1 0 1.5 0 1 2 1 3 0 5 1 0 8 0 5 2 0 14 0 5 3 0 8 0 4 1 1 2 0 5 3 0 14 1 5 3 0 17 1 1 2 0 2.66 0 5 2 0 9 0 2 1 0 2.5 0 1 2 0 30 3 3 1 0 5 2 5 1 0 0.25 0 5 1 0 1 0 1 1 0 5.5 0 4 1 3 1.5 0 5 2 1 25 2 1 2 0 13.91 3 Page A14 1 3 4 5 6 Resp Years ID_No OCCUP INCOME WORKed EDUCat GENDER 768 12 26.4 16 12 0 769 7 32.0 4 12 0 770 10 40.2 46 10 1 771 7 22.6 18 14 1 772 7 25.2 10 12 1 773 7 25.8 27 14 1 774 7 31.3 24 11 1 775 9 27.6 8 12 1 776 6 39.7 7 17 0 777 5 48.5 6 12 1 778 5 45.7 17 12 0 779 7 25.3 4 12 0 780 7 43.9 28 12 1 781 6 33.9 28 19 0 782 9 25.4 6 12 0 783 9 32.6 32 10 1 784 9 41.4 24 11 1 785 8 29.3 18 12 1 786 9 21.8 25 12 0 787 6 33.6 16 16 0 788 9 23.3 16 12 1 789 9 20.1 13 12 0 790 8 31.9 21 12 0 791 8 20.3 20 13 0 792 9 58.4 15 14 1 793 10 32.5 24 13 1 794 12 38.9 10 14 0 795 7 62.8 15 12 1 796 6 27.9 10 19 0 797 7 51.1 26 12 1 798 5 24.5 2 13 1 799 9 46.3 16 12 1 800 3 26.8 27 12 0 Total Average ID_No 2 32004.0 40.005 15974.0 19.968 11116.0 13.895 458.0 INCOME WORKed EDUCat GENDER 7 AGE 35 21 63 36 28 43 44 25 27 22 33 25 47 44 26 47 41 35 41 32 34 31 31 57 32 44 29 35 28 42 22 35 69 8 Work HRS 40 40 42 50 70 40 34 63 50 65 36 48 40 40 40 40 65 40 40 40 40 40 47 32 80 50 37 60 40 45 40 40 29 9 No EARN 2 2 1 2 1 1 1 2 2 2 1 1 2 2 2 2 3 2 4 2 1 2 3 2 2 3 2 1 1 2 3 2 1 10 Fam Inc 46.8 35.6 29.0 19.8 15.2 15.9 21.3 30.8 61.6 41.4 35.7 15.3 41.1 42.0 39.9 47.5 48.8 45.0 28.2 43.9 14.5 59.7 40.2 42.5 67.9 26.1 72.6 52.8 17.9 44.6 31.1 43.1 16.8 11 Job Sat 2 2 2 2 1 2 2 1 1 1 1 2 2 1 2 1 2 2 2 1 2 2 1 2 1 1 1 3 1 2 2 2 1 12 13 14 15 16 Job Get TraumatEmploy Num Char Ahead Events Years Prom 2 2 0 10 0 1 2 0 1.25 3 4 1 0 9.41 7 2 2 0 9.66 5 1 2 0 9.66 2 5 3 0 18.16 7 4 2 0 4 0 1 1 0 4 1 5 1 3 1 0 5 1 2 1 1 5 1 0 11 0 4 1 1 2 0 1 1 0 19 1 5 1 0 3.58 0 1 1 0 5 1 5 1 0 10 1 1 3 0 5 1 1 1 0 8 0 4 1 0 16 0 4 1 0 3 0 1 2 0 13 0 1 1 0 2.5 0 1 1 0 10 0 1 2 1 3 0 5 1 0 6 2 5 2 0 24 0 5 1 0 2 0 1 3 0 3 2 5 1 0 2 1 5 3 0 19.25 0 2 1 0 1.25 1 4 3 0 16 4 5 1 0 25 3 31528.0 36346.0 1448.0 33993.2 1352.0 2854.0 1200.0 180.0 6932.6 39.410 45.433 1.810 42.492 1.690 3.568 1.500 0.225 8.666 AGE HRS EARN Inc Sat Char Ahead Events Years 760.0 0.950 Prom Page A15 Employee Satisfaction Survey Results (SORTED by OCCUPATION) 1 2 3 4 5 6 Resp Years Count ID_No OCCUP INCOME WORKed EDUCat GENDER 1 3 0 88.3 14 20 1 2 4 0 50.5 12 15 1 3 10 0 48.4 15 16 1 4 18 0 36.6 43 16 1 5 30 0 41.3 18 12 0 6 38 0 58.7 19 19 1 7 41 0 63.7 42 14 1 8 46 0 85.6 23 18 1 9 48 0 42.8 22 17 0 10 51 0 60.1 20 17 0 11 53 0 40.3 16 18 1 12 56 0 42.2 2 16 1 13 59 0 30.1 18 17 1 14 61 0 60.6 36 16 1 15 62 0 32.5 23 13 0 16 64 0 25.5 5 11 0 17 67 0 53.3 18 15 1 18 74 0 54.7 13 16 0 19 75 0 26.0 6 16 0 20 78 0 33.6 11 16 1 21 89 0 35.2 20 12 0 22 91 0 38.6 21 13 0 23 92 0 71.7 25 16 0 24 93 0 45.1 12 16 0 25 123 0 34.8 14 16 0 26 125 0 38.5 17 12 0 27 138 0 52.6 12 16 1 28 142 0 57.1 45 11 1 29 147 0 31.2 20 12 0 30 170 0 43.3 20 20 0 31 173 0 24.7 7 16 1 32 189 0 57.7 15 12 1 33 191 0 42.4 11 20 1 34 193 0 36.7 26 12 0 35 197 0 52.3 18 16 1 36 203 0 33.0 16 12 0 37 206 0 69.3 18 12 1 38 217 0 40.7 22 16 1 39 229 0 51.2 11 15 1 40 237 0 35.2 22 16 0 41 251 0 35.9 19 14 0 42 255 0 55.7 17 16 1 43 257 0 26.2 20 16 1 44 258 0 54.7 45 15 1 45 260 0 65.0 45 14 1 46 267 0 60.4 35 14 1 47 270 0 64.9 20 16 1 48 275 0 37.6 28 12 0 49 276 0 33.9 26 19 0 50 285 0 31.3 28 12 1 51 287 0 51.2 16 14 1 52 291 0 38.1 25 13 0 53 294 0 49.6 30 13 0 54 295 0 40.2 6 16 0 55 298 0 86.4 38 12 1 56 301 0 39.4 25 16 0 57 303 0 24.7 26 13 1 58 321 0 43.7 25 16 0 59 322 0 26.6 5 15 0 60 333 0 62.6 8 14 1 61 361 0 27.5 27 16 1 62 363 0 29.9 14 16 0 63 377 0 48.5 6 12 1 64 378 0 45.7 17 12 0 65 398 0 24.5 2 13 1 66 9 1 70.8 15 18 1 67 11 1 41.0 13 12 0 7 AGE 35 33 35 59 34 38 58 39 48 29 36 25 40 53 39 27 35 26 23 29 36 64 43 28 44 36 34 62 39 58 24 32 34 42 40 32 39 39 33 41 36 39 39 62 62 52 40 43 41 45 33 45 51 38 57 45 43 51 43 25 43 50 22 33 22 39 35 8 Work HRS 50 40 30 40 48 50 48 40 40 40 32 40 40 50 46 40 50 40 40 55 45 43 55 46 40 60 43 50 40 45 50 60 55 60 70 55 50 45 40 50 65 40 60 40 40 40 50 46 40 40 55 36 40 40 32 40 40 40 38 73 55 38 65 36 40 50 32 9 No EARN 2 2 1 1 2 2 2 1 1 1 2 2 2 3 2 2 1 2 1 1 1 1 2 1 3 3 1 1 1 2 2 2 1 3 1 2 2 1 1 1 1 2 1 2 3 1 2 1 2 1 1 2 2 2 2 4 2 2 4 1 3 3 2 1 3 1 1 10 Fam Inc 85.3 85.6 38.4 35.4 67.7 68.0 56.5 91.8 33.5 50.1 71.3 43.2 35.1 75.1 50.3 30.4 43.3 65.3 16.9 34.8 25.9 35.2 78.8 38.3 48.2 59.0 42.6 47.1 21.2 35.5 25.3 69.7 32.4 38.2 42.3 32.2 74.0 34.1 41.2 26.9 26.6 68.5 16.8 49.4 85.4 53.7 82.7 27.6 55.3 44.1 48.8 60.3 85.9 90.5 94.2 53.3 23.3 66.1 67.6 54.4 55.7 54.1 41.4 35.7 31.1 60.8 33.5 11 Job Sat 2 2 2 2 1 1 2 1 2 1 4 1 2 2 1 4 1 1 1 2 3 1 1 2 1 4 1 1 2 1 2 2 1 2 1 2 1 3 2 1 1 2 1 1 1 1 3 2 2 2 2 2 1 1 1 1 1 2 4 1 2 1 1 1 2 2 1 12 13 14 15 16 Job Get TraumatEmploy Num Char Ahead Events Years Prom 4 1 0 3 0 3 1 0 9 2 1 2 0 3 2 5 1 1 1.5 1 3 1 0 3 0 4 1 0 15 4 4 3 0 36 4 5 2 1 3 0 5 1 0 6 2 5 1 0 16 0 5 2 0 4.08 1 4 1 0 2 0 1 1 0 11.83 4 1 3 0 10 0 5 1 0 1 0 2 2 1 2 2 1 1 1 10 0 4 1 0 3.5 1 2 1 0 0.75 0 5 1 0 1 1 1 1 0 10 1 4 1 0 7 1 5 1 0 18 2 5 1 0 0.16 0 1 1 0 5 3 1 1 0 9.5 1 5 3 0 5.5 1 1 2 0 52.25 4 5 1 0 10 0 4 2 0 12 0 5 2 0 1 0 1 1 0 12 5 5 1 0 4 1 5 1 2 22 3 5 1 0 2 0 5 1 0 11 1 5 2 0 11 2 4 3 0 9 2 5 3 0 10 0 5 1 0 2.33 0 5 3 0 6 0 4 3 0 16 1 1 1 2 3.25 0 2 1 0 27 2 1 1 0 1.91 2 2 2 0 31.91 3 5 1 0 6 1 5 3 0 14 1 5 1 0 4 0 5 3 1 0.58 1 1 2 1 7 4 5 1 0 21 4 5 2 0 24 4 1 3 0 6 4 1 1 1 34 0 5 2 0 4 0 5 1 0 26 0 5 2 0 23 1 5 1 0 3 0 5 1 0 2.5 0 3 1 0 5 2 5 1 0 1 0 5 1 2 1 1 5 1 0 11 0 2 1 0 1.25 1 5 1 0 5 0 1 1 0 1.5 0 Page A16 1 2 3 4 5 6 Resp Years Count ID_No OCCUP INCOME WORKed EDUCat GENDER 68 26 1 33.7 25 16 0 69 34 1 27.9 9 16 0 70 37 1 31.6 12 16 0 71 42 1 27.0 7 16 0 72 44 1 27.7 14 16 0 73 47 1 37.6 9 18 1 74 52 1 46.3 7 19 1 75 55 1 39.8 23 17 0 76 70 1 51.3 13 16 1 77 72 1 29.8 12 14 0 78 83 1 49.8 42 15 1 79 84 1 47.2 19 16 0 80 85 1 64.6 30 16 1 81 90 1 74.5 21 20 1 82 105 1 39.2 18 18 1 83 118 1 68.0 34 20 0 84 120 1 61.8 27 17 1 85 133 1 54.4 28 19 1 86 151 1 37.0 15 19 0 87 154 1 38.6 6 17 1 88 169 1 67.8 22 20 1 89 177 1 45.5 13 12 1 90 178 1 58.6 15 20 1 91 180 1 50.1 25 15 1 92 181 1 61.4 29 18 1 93 182 1 39.9 38 18 1 94 184 1 36.4 40 10 1 95 188 1 47.9 30 18 0 96 210 1 63.8 38 18 1 97 219 1 37.9 20 16 0 98 224 1 30.4 4 16 0 99 225 1 47.7 24 20 0 100 238 1 31.1 10 13 1 101 240 1 39.3 11 12 1 102 242 1 42.2 14 18 0 103 244 1 38.1 20 16 0 104 256 1 38.6 14 20 0 105 264 1 35.5 21 16 0 106 271 1 28.1 24 18 0 107 272 1 60.9 14 12 1 108 278 1 37.0 23 13 0 109 283 1 36.0 10 18 0 110 286 1 33.4 9 16 0 111 299 1 29.5 27 18 1 112 305 1 30.4 27 16 1 113 308 1 53.4 25 19 0 114 309 1 48.5 18 14 1 115 313 1 40.4 33 18 1 116 314 1 43.4 14 16 0 117 316 1 77.0 35 19 1 118 317 1 43.7 32 16 0 119 318 1 49.4 19 14 1 120 320 1 101.9 35 16 1 121 327 1 37.9 27 18 1 122 332 1 47.7 26 15 1 123 341 1 32.7 12 16 0 124 345 1 35.4 19 18 0 125 354 1 36.6 9 16 0 126 364 1 38.0 26 18 1 127 366 1 51.1 45 20 1 128 376 1 39.7 7 17 0 129 381 1 33.9 28 19 0 130 387 1 33.6 16 16 0 131 396 1 27.9 10 19 0 132 8 2 28.0 10 13 0 133 12 2 86.6 30 13 1 134 22 2 43.3 17 10 1 135 28 2 52.7 18 15 1 136 36 2 36.3 23 13 1 137 63 2 66.7 27 14 1 7 AGE 42 44 33 28 33 31 33 40 35 33 59 36 52 38 39 50 44 48 47 28 39 30 31 41 46 57 58 47 55 37 26 41 27 28 32 39 31 45 41 31 40 26 26 43 44 49 39 50 57 53 52 38 63 38 43 38 36 24 43 63 27 44 32 28 25 49 33 35 40 47 8 Work HRS 40 40 32 40 40 40 45 40 40 40 35 40 40 45 32 40 35 55 41 50 60 40 60 50 55 49 40 40 75 35 45 35 57 60 40 40 45 50 40 45 51 40 40 54 40 28 40 40 34 50 60 52 45 60 60 40 60 56 56 50 50 40 40 40 40 55 30 40 40 72 9 No EARN 3 3 2 1 1 1 1 1 1 3 2 1 2 1 3 2 3 4 1 2 2 1 2 3 2 3 1 1 2 1 1 2 2 2 1 2 1 2 2 1 2 1 1 1 1 1 1 1 4 4 2 1 4 1 2 1 4 2 2 2 2 2 2 1 3 2 2 2 3 1 10 Fam Inc 51.2 34.2 46.6 20.0 19.3 29.4 37.4 44.1 41.3 62.5 69.0 38.8 56.7 65.7 62.6 98.7 61.6 66.8 36.3 31.1 78.6 35.5 51.2 45.1 90.4 34.6 26.4 37.9 74.3 35.2 53.9 61.6 28.3 44.0 32.2 68.7 28.6 70.4 47.1 55.1 29.7 26.0 29.0 24.6 20.4 45.3 38.5 30.4 88.0 70.1 51.4 59.9 98.3 42.7 70.8 22.7 51.2 39.2 36.7 60.7 61.6 42.0 43.9 17.9 49.5 93.5 42.8 51.8 29.9 59.5 11 Job Sat 1 1 1 1 1 2 2 4 2 2 1 2 4 1 1 2 2 2 4 2 1 1 1 2 1 2 1 3 3 2 2 1 2 3 1 2 2 2 1 1 1 1 1 2 1 1 1 1 2 2 1 1 1 2 2 1 2 2 3 1 1 1 1 1 2 3 3 1 1 1 12 13 14 15 16 Job Get TraumatEmploy Num Char Ahead Events Years Prom 1 1 1 5.5 0 1 3 0 5.5 0 5 3 0 2.58 0 5 1 0 12.33 1 5 2 0 3 0 5 1 0 4 0 5 1 0 4 1 5 3 0 4.5 0 5 1 0 6.41 3 1 1 1 2 1 5 1 0 6 0 4 2 0 12.5 1 5 1 0 21 1 5 3 0 4 2 3 2 0 2 0 3 3 0 8 0 5 3 0 22 0 4 3 0 5.66 0 1 1 0 1 0 5 1 0 4.58 2 5 1 0 17 2 1 1 0 1.5 0 5 1 0 3 1 4 1 0 6 2 5 2 0 7 4 5 1 0 34 0 1 2 0 3.91 0 3 1 0 2 0 4 3 4 29 2 1 1 0 14 0 1 1 0 4 0 3 2 0 17 0 5 1 0 0.33 1 5 1 0 5.5 5 5 1 0 5 0 3 1 1 5 1 5 2 0 1 0 1 1 0 20 3 5 1 0 0.25 0 1 1 0 0.66 0 5 1 0 17 0 5 1 0 1 0 5 1 0 8 3 2 3 1 13 2 5 1 0 2 0 5 1 0 1 3 5 1 1 10 1 3 2 0 23 3 3 1 0 11 0 5 1 0 11 0 4 1 0 18 0 5 1 0 1.5 1 5 2 0 32 0 5 1 0 12 0 1 1 0 17 0 4 1 0 10 1 5 1 0 10 0 4 1 1 2 0 1 1 0 5.5 0 5 2 1 25 2 5 1 3 1 0 5 1 0 3.58 0 4 1 0 3 0 5 1 0 2 1 5 3 1 1.5 0 1 1 0 5 0 5 1 0 5 0 5 1 0 0.5 0 1 1 0 10 1 1 1 0 5 0 Page A17 1 2 3 4 5 6 Resp Years Count ID_No OCCUP INCOME WORKed EDUCat GENDER 138 65 2 27.0 13 10 0 139 73 2 60.0 32 12 1 140 79 2 49.0 30 12 1 141 81 2 42.3 11 13 1 142 86 2 28.8 24 14 0 143 97 2 49.2 8 15 1 144 104 2 25.0 14 12 1 145 107 2 30.0 8 10 1 146 117 2 46.3 10 12 1 147 132 2 52.5 27 8 1 148 139 2 52.3 16 12 1 149 148 2 31.7 15 11 1 150 153 2 40.4 14 12 1 151 157 2 40.9 33 12 1 152 179 2 54.8 18 13 1 153 185 2 40.8 25 13 1 154 211 2 36.4 54 12 1 155 216 2 32.8 7 12 1 156 228 2 36.8 20 12 1 157 243 2 53.6 22 15 1 158 247 2 25.3 34 13 1 159 259 2 28.1 5 12 0 160 266 2 41.9 34 16 1 161 268 2 26.2 13 13 1 162 273 2 36.1 22 14 1 163 281 2 36.6 20 12 1 164 289 2 49.2 20 14 1 165 297 2 61.2 37 14 1 166 310 2 46.6 21 14 1 167 323 2 53.6 27 12 1 168 329 2 35.0 35 12 1 169 331 2 52.7 35 12 1 170 335 2 42.5 42 12 1 171 337 2 57.2 16 14 1 172 342 2 23.2 10 14 1 173 343 2 32.5 35 11 0 174 351 2 31.8 44 12 1 175 352 2 56.9 25 12 1 176 367 2 41.2 16 12 1 177 369 2 32.0 4 12 0 178 371 2 22.6 18 14 1 179 372 2 25.2 10 12 1 180 373 2 25.8 27 14 1 181 374 2 31.3 24 11 1 182 379 2 25.3 4 12 0 183 380 2 43.9 28 12 1 184 395 2 62.8 15 12 1 185 397 2 51.1 26 12 1 186 2 3 35.2 15 12 0 187 14 3 25.8 20 14 0 188 19 3 43.1 7 16 1 189 21 3 34.3 7 12 0 190 29 3 24.7 15 16 1 191 31 3 34.1 33 14 0 192 40 3 25.4 16 12 1 193 50 3 29.3 10 13 0 194 58 3 32.5 10 12 1 195 77 3 31.7 15 12 0 196 82 3 27.9 17 14 1 197 94 3 30.6 20 14 0 198 98 3 29.7 27 12 0 199 99 3 37.1 21 13 0 200 100 3 27.8 20 12 0 201 108 3 33.1 25 16 0 202 109 3 36.8 18 13 1 203 110 3 29.3 8 12 0 204 112 3 26.7 20 12 0 205 113 3 25.9 9 12 0 206 114 3 35.8 45 12 0 207 115 3 33.9 10 13 1 7 AGE 40 48 53 30 40 29 32 25 26 44 34 33 31 51 37 49 60 24 38 40 56 21 51 29 40 38 36 54 41 44 52 55 53 32 28 52 51 42 33 21 36 28 43 44 25 47 35 42 33 50 25 24 35 50 32 26 27 53 27 52 43 39 40 42 37 28 37 35 63 29 8 Work HRS 40 40 40 40 50 50 42 40 44 40 52 40 60 67 60 40 68 50 40 46 40 72 40 60 40 40 40 50 40 40 40 44 40 40 75 50 60 50 84 40 50 70 40 34 48 40 60 45 50 40 40 49 40 42 40 40 40 40 40 40 40 36 45 36 40 50 40 43 35 41 9 No EARN 2 3 2 2 2 1 1 1 1 1 1 1 1 3 1 2 1 2 2 1 1 4 1 2 1 2 1 2 1 2 2 3 4 2 1 1 2 2 1 2 2 1 1 1 1 2 1 2 1 1 1 2 2 3 1 1 3 1 2 1 2 3 1 1 4 1 2 1 1 2 10 Fam Inc 19.3 54.1 43.9 39.3 57.4 63.6 15.0 20.0 36.3 49.2 42.3 39.2 32.4 47.4 45.5 58.7 35.4 34.5 34.1 51.4 15.3 77.9 33.5 41.2 26.1 29.6 39.8 66.7 39.4 61.2 34.6 46.9 46.5 49.3 14.5 22.5 35.1 50.9 31.2 35.6 19.8 15.2 15.9 21.3 15.3 41.1 52.8 44.6 25.2 17.4 33.1 27.4 46.9 69.6 15.4 19.6 32.5 35.7 46.5 47.3 57.8 31.2 17.8 34.2 34.0 19.3 26.5 15.9 38.7 43.0 11 Job Sat 2 2 2 2 1 1 3 3 2 2 2 2 2 1 2 4 1 2 2 1 1 1 2 1 2 1 1 1 2 1 1 2 1 2 2 1 3 1 1 2 2 1 2 2 2 2 3 2 1 3 4 3 2 2 1 2 1 2 2 2 1 2 1 4 3 2 2 1 1 2 12 13 14 15 16 Job Get TraumatEmploy Num Char Ahead Events Years Prom 5 3 0 4 0 4 3 2 21 4 5 1 0 0.08 0 5 1 0 10 2 5 3 0 1.5 1 4 2 0 1 0 4 3 0 1 0 4 3 0 2 3 1 1 0 2.5 0 4 3 0 11 1 5 1 0 13 2 5 1 0 1 2 5 2 0 12.5 3 4 3 1 32.33 0 5 2 0 3 0 5 2 0 6 0 1 1 0 10 4 5 1 0 3 0 5 2 0 7 0 5 1 0 18 6 5 1 0 1.83 0 1 1 0 1.08 0 5 3 0 6 1 1 3 0 5 1 5 2 0 15 1 1 1 0 11 3 2 1 0 18 2 5 1 0 5 0 5 2 0 11 1 3 1 0 20 4 5 1 0 27 0 5 1 0 14 0 5 2 0 22 0 5 1 0 1 0 4 1 0 3 0 5 1 0 19.16 0 5 1 0 8 0 5 2 0 14 0 1 2 0 13.91 3 1 2 0 1.25 3 2 2 0 9.66 5 1 2 0 9.66 2 5 3 0 18.16 7 4 2 0 4 0 4 1 1 2 0 1 1 0 19 1 1 3 0 3 2 5 3 0 19.25 0 1 2 0 4 3 1 1 0 10 0 5 3 0 1 1 4 2 0 5 1 5 2 3 0.75 2 5 1 0 3.5 1 1 2 0 0.16 0 3 1 0 4 5 5 1 0 5 0 5 2 0 12.5 1 5 1 2 0.5 0 5 1 0 3 1 5 1 0 9.41 1 5 1 0 16 0 1 1 0 0.5 0 5 2 0 12 1 4 1 0 16 0 1 1 0 3 0 1 1 0 10 0 5 1 0 1.5 1 2 3 0 22 1 4 3 0 3 2 Page A18 1 2 3 4 5 6 Resp Years Count ID_No OCCUP INCOME WORKed EDUCat GENDER 208 126 3 30.0 15 12 0 209 134 3 60.5 20 16 1 210 137 3 26.2 10 12 0 211 140 3 44.6 10 16 0 212 150 3 32.7 13 15 0 213 163 3 30.0 25 13 0 214 166 3 29.7 15 12 0 215 176 3 30.5 20 12 0 216 187 3 28.9 12 12 0 217 198 3 23.2 22 12 0 218 200 3 48.7 8 12 0 219 207 3 26.3 24 12 1 220 212 3 24.4 6 16 0 221 213 3 23.4 26 12 0 222 218 3 25.3 17 13 0 223 220 3 25.5 21 14 0 224 222 3 55.8 24 12 1 225 233 3 29.3 16 9 1 226 236 3 72.8 19 12 0 227 249 3 27.8 10 15 0 228 250 3 25.4 15 14 0 229 252 3 25.0 11 12 0 230 254 3 62.7 31 14 1 231 269 3 50.7 24 18 0 232 280 3 27.1 15 13 0 233 300 3 27.7 20 13 0 234 307 3 25.3 3 12 0 235 312 3 28.1 22 13 0 236 315 3 56.6 32 12 1 237 350 3 32.5 25 12 0 238 359 3 25.0 6 12 0 239 360 3 34.2 30 12 0 240 385 3 29.3 18 12 1 241 390 3 31.9 21 12 0 242 400 3 25.5 34 12 0 243 450 3 46.1 36 16 0 244 500 3 28.1 4 14 0 245 550 3 25.6 24 14 0 246 600 3 37.3 20 12 0 247 650 3 24.2 20 17 0 248 700 3 33.2 37 13 0 249 750 3 20.3 20 13 0 250 800 3 26.8 27 12 0 251 1 4 35.7 25 14 0 252 15 4 37.5 31 4 1 253 20 4 20.5 3 11 1 254 43 4 21.5 1 12 1 255 66 4 26.5 27 12 1 256 69 4 20.2 34 9 1 257 71 4 64.2 26 12 1 258 80 4 40.9 37 14 1 259 87 4 49.6 8 17 1 260 101 4 24.6 20 12 0 261 116 4 28.9 16 14 1 262 128 4 47.3 10 14 1 263 129 4 26.7 20 12 0 264 141 4 32.5 6 12 1 265 144 4 24.9 9 15 1 266 158 4 45.1 31 12 1 267 159 4 23.9 10 14 0 268 162 4 36.7 19 16 1 269 167 4 55.3 14 12 1 270 168 4 44.0 12 12 1 271 171 4 55.3 30 16 1 272 183 4 33.7 40 8 1 273 192 4 41.2 21 14 1 274 194 4 26.4 13 12 1 275 195 4 36.1 13 10 1 276 199 4 21.9 35 14 0 277 209 4 41.4 41 8 1 7 AGE 42 37 35 27 29 61 32 55 29 38 32 41 29 42 38 47 41 33 36 27 37 32 48 44 41 40 20 65 48 61 23 55 35 31 56 56 30 42 38 38 58 57 69 64 49 20 18 27 53 43 43 29 49 33 27 48 23 26 48 30 35 32 33 47 61 38 30 29 55 58 8 Work HRS 40 50 40 40 42 40 40 40 32 40 40 72 40 40 35 60 45 56 40 45 40 40 80 40 40 45 40 40 40 40 44 50 40 47 40 40 48 37 40 37 32 32 29 30 40 50 45 30 35 48 40 59 40 50 65 40 46 38 44 37 48 52 40 52 32 60 42 40 40 65 9 No EARN 2 2 2 2 2 1 2 1 2 2 1 1 3 1 1 3 1 1 1 1 1 2 2 2 2 3 2 1 4 1 2 2 2 3 2 1 2 1 4 1 1 2 1 2 1 2 5 1 1 2 1 2 4 2 2 3 2 2 2 2 2 1 2 1 2 2 1 2 2 3 10 Fam Inc 23.0 59.2 43.4 69.3 43.1 20.0 38.9 20.5 21.9 16.7 38.7 16.3 28.3 29.7 15.3 68.7 49.4 23.2 63.4 17.8 15.4 25.4 56.1 49.2 32.4 31.4 27.1 18.2 71.0 22.5 37.3 27.9 45.0 40.2 44.5 36.9 41.8 16.4 72.6 49.2 23.2 42.5 16.8 81.9 27.6 14.3 55.5 17.0 15.6 67.9 30.9 46.6 82.5 22.4 39.7 46.8 25.3 39.1 63.2 43.4 46.6 45.3 46.4 46.0 26.6 50.0 17.3 28.6 24.0 42.3 11 Job Sat 1 2 2 1 2 1 2 2 1 2 2 1 3 1 1 4 1 1 1 1 1 2 4 3 2 2 1 1 1 1 3 2 2 1 2 1 2 4 1 2 2 2 1 1 2 1 3 2 1 1 1 1 2 2 2 2 2 1 2 2 2 1 3 2 2 2 3 2 1 2 12 13 14 15 16 Job Get TraumatEmploy Num Char Ahead Events Years Prom 2 3 0 7.08 0 5 1 0 8.5 2 1 1 0 2.5 3 5 1 0 5 4 2 3 0 4.33 0 1 2 0 18.33 0 5 1 1 11.58 3 1 2 0 15 2 5 1 0 3 1 5 1 1 1 0 1 1 0 6 0 5 3 1 18 0 1 1 0 3 0 4 1 0 1.08 1 5 1 1 4 1 5 3 0 1 0 5 1 0 8 4 4 1 0 4.5 0 4 1 0 2.16 0 5 3 0 2 0 1 1 1 15 3 3 1 0 10 0 1 3 0 9 1 1 2 0 22 0 5 1 0 4 0 5 1 0 7 1 4 1 0 1.5 0 5 1 0 13 1 5 1 0 25 1 5 3 0 17 1 2 1 0 2.5 0 1 2 0 30 3 1 1 0 8 0 1 1 0 10 0 5 1 0 21 0 1 1 0 30 3 1 2 1 1 1 1 2 0 2 0 4 1 0 10.5 4 5 1 0 5 0 5 2 1 5 0 1 2 1 3 0 5 1 0 25 3 3 2 0 11 0 3 2 1 22.08 0 1 1 0 1 3 1 1 0 1 0 5 1 2 0.5 0 5 1 1 5 0 1 1 0 11 2 5 3 0 2 0 1 2 0 2.83 0 1 1 0 4 0 5 2 1 1 0 1 1 1 2 0 5 1 0 9 0 5 1 1 1.41 0 5 1 5 0.5 1 2 3 0 24.75 2 5 1 0 4 0 1 1 0 12 1 5 1 0 13 3 5 1 1 11 0 5 3 0 8 0 5 1 1 40 0 5 1 0 15 2 5 2 1 1.5 0 2 3 0 0.25 0 5 1 1 29.5 1 2 1 0 3 0 Page A19 1 2 3 4 5 6 Resp Years Count ID_No OCCUP INCOME WORKed EDUCat GENDER 278 215 4 22.0 19 14 1 279 223 4 39.5 21 15 1 280 227 4 35.9 11 12 1 281 232 4 23.1 20 12 1 282 234 4 21.1 4 12 0 283 241 4 29.3 30 8 1 284 253 4 40.3 25 13 1 285 262 4 35.2 16 11 1 286 263 4 31.4 22 12 1 287 265 4 26.1 33 10 1 288 279 4 43.0 35 8 1 289 292 4 37.5 29 12 1 290 302 4 52.8 38 14 1 291 304 4 30.5 27 16 0 292 306 4 28.2 45 11 0 293 324 4 32.5 12 12 1 294 326 4 41.8 45 8 1 295 330 4 46.9 21 12 1 296 334 4 35.7 11 11 0 297 336 4 31.6 12 16 0 298 340 4 24.7 8 12 0 299 344 4 33.3 22 12 1 300 348 4 41.1 4 14 1 301 353 4 23.7 10 13 1 302 355 4 61.9 16 12 0 303 356 4 28.7 20 14 0 304 357 4 20.8 10 12 0 305 362 4 24.9 27 12 1 306 375 4 27.6 8 12 1 307 382 4 25.4 6 12 0 308 383 4 32.6 32 10 1 309 384 4 41.4 24 11 1 310 386 4 21.8 25 12 0 311 388 4 23.3 16 12 1 312 389 4 20.1 13 12 0 313 392 4 58.4 15 14 1 314 399 4 46.3 16 12 1 315 25 5 54.7 13 16 0 316 403 5 88.3 14 20 1 317 404 5 50.5 12 15 1 318 410 5 48.4 15 16 1 319 418 5 36.6 43 16 1 320 430 5 41.3 18 12 0 321 438 5 58.7 19 19 1 322 441 5 63.7 42 14 1 323 446 5 85.6 23 18 1 324 448 5 42.8 22 17 0 325 451 5 60.1 20 17 0 326 453 5 40.3 16 18 1 327 456 5 42.2 2 16 1 328 459 5 30.1 18 17 1 329 461 5 60.6 36 16 1 330 462 5 32.5 23 13 0 331 464 5 25.5 5 11 0 332 467 5 53.3 18 15 1 333 475 5 26.0 6 16 0 334 478 5 33.6 11 16 1 335 489 5 35.2 20 12 0 ...
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

The hw8.xlsx file contains the solution.The Analysis_hw8.xlsx file contains steps/analyses that were used in arriving at the result in hw8.xlsx.

(Note that this homework has 2 questions)

Homework 8

Question 1.
The Child Health and Development collected data to study the relationship between the infant weights
and several related variables.
A sample of 40 observations are given in the next worksheet
Model Building - Stepwise Regression (Backward Elimination Method):
(a) Follows the process steps described below to obtain a significant regression model.
Step 1. Determine the estimated regression equation containing ALL six independent variables
(gestation, height, smoke, age, weight, and parity).
(a) What is the estimated regression equation with these six independent variables?
(b) What percent of the total variation in baby weights is explained by this regression?
(c) Which independent variables are NOT significant in this model at a = 0.05?
Step 2. Eliminate non-significant variables, one at a time, until you obtain a regression model
with all independent variables significant.
Process steps:
Step 2a. Remove the non-significant independent variable(s), one at a time, starting
with the variable that has the highest p-value first. Obtain the new
regression model.
Step 2b. Check the independent variables for significance at a=0.05..
(i) If all independent variables are significant, stop. This is the significant model.
(ii) If some independent variables in the model are not significant, repeat Step 2.
(b) These process steps described above will result in a regression model that has significant
independent variables only. What is the significant model found after completing the process
steps above?
(c) Now use the stepwise regression available in PHStat. Run stepwise regression (using
backward elimination approach) to obtain a significant regression model.
What is the model found by the PHStat stepwise regression?
(d) Compare the significant regression models obtained in (b) and (c). Are they different? If
they are different, which model is performing better?
(e) Using the model you found to be performing better in (d), construct 95 percent confidence
interval estimate for the mean baby weights for the newborns with the following values:
(i)
(i)

Baby 1
Baby 2

gestation

height

smoke

age

weight

parity

283

64

1

22

140

0

gestation

height

smoke

age

weight

parity

283

64

1

25

160

1

(f) Which confidence interval estimate has a larger interval? Why?

When you run stepwise regression in question (c),
if you get an error message like the following, that
means the PHStat failed. Please copy the data into a
NEW FILe and run the stepwise regression from this new
file.

Question 2
(Y)
($1,000)
MARKET

REAL ESTATE DATA
(X1)
(X2)
(X3)
(Sq Feet)
AREA

($1,000)

(X4)

(Yes/No) (Number)

ASSESS BASEM BEDRM
128
No
1
101
No
1

(Area)

LOCAT
Loc 2
Loc 2

1
2

139
172

952
1255

3
4
5

178
180
183

1663
1575
1209

88
110
125

No
No
No

1
1
1

Loc 1
Loc 3
Loc 3

6
7
8
9
10

183
198
205
205
216

1689
1330
1437
1598
1377

81
147
143
103
123

No
Yes
Yes
Yes
Yes

1
1
1
1
1

Loc 1
Loc 1
Loc 2
Loc 1
Loc 1

1607
1225
1610
1157
1262
1426
1185
1580
1215
1444
1808
1925
1577
1010
1365
1342
1460
1573
1425
1629
1589
1855
1769
1768
1505
1824
1888
1607
1848
1792
1881
1936
1832
1873
1769
1691
1855
1824
1957
963
1178
1992
1545
1846
1593
2030
1920
1904
2170
2049
1159
1558
1467
2034
2004
2270
2275
2186
2319
2272
115,707
1,652.96
332.024

123
99
114
132
119
79
125
103
125
156
139
165
139
123
125
123
99
128
121
136
128
132
143
156
103
145
134
178
143
150
167
174
165
125
154
167
183
185
174
125
130
141
143
152
136
176
178
167
165
178
108
112
141
163
169
...


Anonymous
I use Studypool every time I need help studying, and it never disappoints.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags