Question CASE STUDY 1 MANAGERIAL STATISTICS

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.

1. 1. 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.
   2. 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.
   3. 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.
   4. 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?
   5. Construct and interpret the 95% confidence interval for the proportion of drivers that had their insurance cards in the vehicle with them.
   6. 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.
   7. Explore the relationship between the number of citations and the driver’s age. Use whatever method(s) you think is(are) appropriate.
   8. Explore the relationship between the number of citations and the driver’s education level. Use whatever method(s) you think is(are) appropriate.
2. LIABINS CASE DATA
3. 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

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.