CASE STUDY 1
MANAGERIAL STATISTICS
The state Department of Transportation (DOT) recently conducted a study of motorists in Idaho. The data they collected can be found in the file calledLiabins.The worksheet named DATA DESCRIPTIONS includes definitions of variables for the sample of 100 motorists. The data itself is on worksheet DATA.
In analyzing this data, you need to provide the following analyses and prepare a written report discussing ALL your findings, incorporating your statistical analysis done in Excel into your written report in Word. Print out of your report to turn in in class.Your report should be written as if you have been hired as a consultant to the Idaho DOT and not mere answers to parts a though h.
Describe the data on vehicle year, driver age, years lived in state and years of education for this sample of motorists using a combination of frequency distributions and descriptive statistics. Discuss in terms of central tendency and dispersion.
One state trooper was heard saying that those with citations were typically young drivers under 30 years old. For those observations with at least one citation, test the hypothesis made by the trooper about the average age of the driver. Can you reject the null hypothesis at any acceptable level of significance.
Test the hypothesis that the average number of citations is the same for female drivers and male drivers. Can you reject the null hypothesis at any acceptable level of significance.
Construct and interpret the 95% confidence interval for the average number of years a driver has lived in the state using the whole sample and do the same for those drivers that were unaware or uncertain about the law requiring liability insurance. Do these 2 confidence intervals tell you anything useful? If so, what?
Construct and interpret the 95% confidence interval for the proportion of drivers that had their insurance cards in the vehicle with them.
Test the hypothesis that the proportion of people insured is greater than 95%. Can you reject the null hypothesis at any acceptable level of significance.
Explore the relationship between the number of citations and the driver's age. Use whatever method(s) you think is(are) appropriate.
Explore the relationship between the number of citations and the driver's education level.Use whatever method(s) you think is(are) appropriate.
LIABINS CASE DATA
State Department of Transportation Insurance Division Data Base
File: Liabins.xls
Variable Definitions:
Column A: Total convictions for driving-related citations within the past 3 years
Column B: Vehicle year
Column C: Sex of the owner/driver
coded 1 if male, 2 if female
Column D: Age of the owner/driver
Column E: Driver's seat belt status
coded 1 = Yes, was wearing seat belt
2 = No, was not wearing seat belt
Column F: Knowledge of the state's mandatory liability insurance law
coded 1 = Yes, aware of law 2 = No, not aware of law
3 = Uncertain about the law
Column G: Employment status
coded1 = Yes, is employed 2 = No, unemployed
3 = Other (retired)
Column H: Number of years lived in this state
Column I: Number of vehicles registered in this state
Column J: Number of years of formal education
Column K: Insurance certificate status
coded 1 = Yes, certificate in vehicle, 2 = No, insurance certificate not in vehicle
Column L: Insurance Status
Coded 0 = Uninsured 1 = Insured