Describe the data on vehicle year driver age years lived in

Reference no: EM13473841

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

Reference no: EM13473841

Questions Cloud

Mr randolph finds that the supply and demand for gasoline : mr. randolph finds that the supply and demand for gasoline at his station are generally given be the following

The mean speed of a given airplane on its usual route is : the mean speed of a given airplane on its usual route is 525 mph. due to an excessive headwind the plane only travels

Find solution by solving system of equations in b using : a person collects coins nickels dimes and quarters in a jar. at the end of the year they emptied the jar and found that

Although controversial art is not a topic exclusive to the : although controversial art is not a topic exclusive to the 20th century the distribution of information regarding

Describe the data on vehicle year driver age years lived in : case study 1managerial statisticsthe state department of transportation dot recently conducted a study of motorists in

The workplace can be an especially stressful environment : the workplace can be an especially stressful environment. personal conflicts between coworkers fear of layoffs and

Harry decided to save money for new born sons college cost : harry decided to save money for his new born sons college cost right now. he wants to have 120000 in 18 years. bank of

For the research paper assignment you will choose a piece : for the research paper assignment you will choose a piece of literature from our reading list as the focus of your

An application of the findings in this graph for example : maple rockers. ozark furniture company can obtain at most 3000 board feet of maple lumber for making its classic and

User Account

All Pages