Description of this paper





Question;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 DATAState Department of Transportation Insurance Division Data BaseFile: Liabins.xlsVariable Definitions:Column A: Total convictions for driving-related citations within the past 3 yearsColumn B: Vehicle yearColumn C: Sex of the owner/drivercoded 1 if male, 2 if femaleColumn D: Age of the owner/driverColumn E: Driver's seat belt statuscoded 1 = Yes, was wearing seat belt2 = No, was not wearing seat beltColumn F: Knowledge of the state's mandatory liability insurance lawcoded 1 = Yes, aware of law 2 = No, not aware of law3 = Uncertain about the lawColumn G: Employment statuscoded1 = Yes, is employed 2 = No, unemployed3 = Other (retired)Column H: Number of years lived in this stateColumn I: Number of vehicles registered in this stateColumn J: Number of years of formal educationColumn K: Insurance certificate statuscoded 1 = Yes, certificate in vehicle, 2 = No, insurance certificate not in vehicleColumn L: Insurance StatusCoded 0 = Uninsured 1 = Insured


Paper#57148 | Written in 18-Jul-2015

Price : $30