Question

1. Using VehicleFailureData' available on the course website, answer the following: a) Classify each variable as nominal, ordinal, interval or ratio. b) Identify qualitative and quantitative variables c) How many vehicles failed in month-9? d) What was the minimum and maximum labor cost? e) What was the total failure cost (material+ labor) for the data available? A seven-year medical research study reported that women whose mothers took the drug DES during pregnancy were twice as likely to develop tissue abnormalities that might lead to cancer as were women whose mothers did not take the drug. a) This study involved the comparison of two populations. What were the populations? b) Do you suppose the data were obtained in a survey or an experiment? c) For the population of women whose mothers took the drug DES during pregnancy, a sample of 3980 women showed 63 developed tissue abnormalities that might lead to cancer. Provide a descriptive statistic that could be used to estimate the number of women out of 1000 in this population who have tissue abnormalities e population of women whose mothers did not take the drug DES during gnancy, what is the estimate of the number of women out of 1000 who would be expected to have tissue abnormalities? ) Medical studies often use a relatively large sample (in this case, 3980). Why? ACNielsen conducts weekly surveys of television viewing throughout the United States. The AC Nielsen statistical rating indicates the size of the viewing audience for each major network television program. Rankings of the television program and of the viewing audience market share for each network are published each weck a) What is AC Nielsen attempting to measure b) What is the population c) Why would a sample be used in this situation? isions or actions are based on the ACNielsen studies" summarizs the data for faitures in top 10 states by constructing Using Vehiclel alureData, a) Relative and percent frequeney distributions b) Bar chart x-/ fil Labor Cost Material Cost $119.66 $153.16 $119.66 $119 66 $119.66 $128.21 $188.00 $119.66 $17.76 $175 46 $119.66 $119.66 $146.25 $123 69 $651.81 $119.66 $192.89 $407 00 $119.66 $132 86 $126.51 $119.66 $2.046.03 State Labor Cost $176.06 $385.77 $155.40 $136.69 $141.76 S421.29 $189.90 $85.33 $220.82 $44.69 $281.40 $9.45 $261.57 $49.10 982.19 S340.71 $695.09 $205.14 $356.69 $273.54 $55.78 $78.11 $3,234.41 $185.08 $318.10 $306 53 $129.04 1 Vehicle Number Failure Month Mileage at Failure Labor Hours 11,229 14,233 14,155 1598 1599 1600 1601 NJ 75,587 1603 1604 1605 35,645 16,481 30,104 19 1607 1027,328 56,013 7.131 1608 NJ 1610 1611 32,894 17,432 15,085 31,720 6,740 47.314 13,073 29.786 13 12 1613 1617 12 15,565 $371.59 $152.05 $119.66 1622 1623 1624 17,195 NJ 28 125 33 011

Answer 1

1. a) Vehicle Number is a nominal variable

Failure month – Ordinal variable

Mileage at Failure – Ratio

Labor Hours – Ratio

Labor Cost – Ratio

Material Cost – Ratio

State – Nominal

b) Qualitative variables here are Vehicle Number and State. Rest of them are quantitative variables

c) Number of vehicles failed in month – 9 = 3
(Count the number of rows where the second column has the value 9)

d) Minimum labor cost = $9.45

Maximum labor cost = $3234.41

E) Total Failure cost is simply the sum of the total labor cost + total material cost. You can sum the values in the column ‘Labor Cost’ and ‘Material Cost’ by SUM function and add both the values. This will be the total failure cost. (I haven’t computed it as I don’t have the excel file, sorry.)

2. a) The two populations are women whose mothers who took the drug DES during pregnancy and women whose mothers who did not take the drug.

b) The data seems to be taken in a survey

c) Number of women out of 1000 in the population who have tissue abnormalities = (63/3980) * 1000 = 16

d) As the women whose mothers who took the drug were twice as likely to develop the abnormalities as were women whose mothers didn’t, hence the estimate is 16/2 = 8 women

e) They use a large sample size so that their study is statistically significant & it doesn’t occur by chance. The results of the study are very important and hence they have to make accurate findings.