Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Statistics and Probability Expert

This assignment needs a considerable amount of computer work and written comment. You might need to seek guidance from your tutor along the way. Do not leave things until too late. Each and every problem carefully describes what you are required to do, so please follow the instructions carefully. Your answer to each and every problem must begin with the number of the problem.

In this assignment you will observe statistical data consisting of records of car accidents on Victorian roads and freeways in 2012. The Victorian department of transportation, Police and VIC Roads are interested in determining the major factors affecting car accidents in Victoria. They will utilize this information to develop strategies aimed at decreasing the number of fatalities on Victorian roads.

Alcohol is a main factor in road deaths in Victoria. Each year, about one quarter of drivers killed in road crashes had a blood alcohol concentration (BAC) of .05 or greater.

The Victorian road rules associating to the use of alcohol and drugs by drivers might be briefly summarized as follows:

Blood alcohol concentration:

Professional drivers such as truck, bus or taxi drivers should have a blood alcohol concentration (BAC) under 0.02; P-platers and learner drivers, as well as visitors from interstate or overseas, must have a zero blood alcohol concentration (BAC). All other drivers should stay under .05 BAC. You should be under .05 BAC while supervising a learner driver. This rule applies to public roads and as well private property.

Drug impairment:

This is illegal to drive while impaired by any drug whether that drug is legal or illegal. You should not be affected by illegal drugs while accompanying a learner driver. This rule applies to public roads and as well private property. (VIC Roads, 2012).

Data was collected and is contained in a file called and the columns of the file contain the given information:

349_random samples.jpg

Students must use their own random sample of 180recordsto answer the problems the random samples are in the file “find your name random samples for assignment.xlsx”.

Assignment Tasks:

For each task below, you should answer all the problems in sequential order and submit all of the required printouts, graphs, tables and summaries needed.

NB: Each graph and table must have a heading and each axis should have a label!!

problem: Introduction and Variable List: Give a short introduction to your report. describe the nature of the data. Read problems below and briefly describe the specific data and relationships which will be examined here.

problem: Data: Provide a printout of the data in your sample, sorted in ascending order based on Driver ID number.

problem: Give a short comment about what you what would happen to the answers to your assignment if you had a different randomly selected sample of size 180.

problem: Produce a histogram exhibiting the age distribution of the drivers involved in car accidents. Give your comments on the graph shape, and the most appropriate measures of centre and spread for this data.

problem: Pivot Tables: There is a general feeling that male drivers commit more driving offences causing more accidents and more fatalities compared to female drivers. For each of the following prepare a contingency table (cross-classification table), by using the

Pivot Table option in Excel. Make sure to comment on similarities or differences and any conclusions you can draw in each case.

a) The average car speed in an accident for the cause of accident split on gender.
b) The average driver blood alcohol level in a road accident for each license type split on gender.
c) The number of road accident fatalities for each license type split on gender.

problem: T-Test and CI: The Victorian police believe that the average speed of vehicles included in accidents on Victorian highways is significantly higher than 100 km/hr.

a) Obtain suitable descriptive statistics and so compute a 95% confidence interval for the mean car speed in accidents on Victorian highways.

b) Conduct a statistical test to find out if the average car speed in accidents on Victorian highways is considerably higher than 100 km/hr. Mention any suppositions, comprise relevant hypotheses and report the outcomes and conclusion in the conventional way.               
problem: Stratified scatter plot with trend lines: Obtain a stratified scatter-plot comparing the relationship between driver age and car speed (km/hr) in accidents for each gender. Think carefully regarding which variable must go on the vertical axis. Keep in mind; it is the independent variable which goes on the horizontal axis (that is, the x-axis). Comprise trend lines, their equations and R-squared values on the graph. Make sure you label axes appropriately and that your graph has a suitable title.

Briefly compare the nature of the relationship between these two variables, the driver Age (years) and Speed (km/hr), for males and females.

problem: Make a table of correlation coefficients for the following variables: Age, Number of Fatalities, Car Speed and Blood Alcohol Level. Discuss your results and state which pairs of variables have the maximum and the lowest correlation coefficients.

problem: Use Excel to carry out a regression analysis on the two variables: driver age (years) (independent variable) and car speed (km/hr) (dependent variable).

a) Copy the output into your assignment and use it to find out the answers to the given problems.

b) prepare down the regression equation.

c) State the R-squared value and the standard error and elucidate what they mean with respect to the data.

d) prepare down the value of the gradient of the regression line and describe what it means for this data.

e) Are the values for the constant and the gradient (slope) significant (that is, significantly different from zero) in this case? Validate your answer.

f) Do you think this regression model is a good model? Justify your answer by using the regression output.

problem: By using the information obtained for your analyses prepare a brief conclusion regarding what you found from the study above.

Statistics and Probability, Statistics

  • Category:- Statistics and Probability
  • Reference No.:- M9287

Have any Question? 


Related Questions in Statistics and Probability

Penney wishes to borrow 75000 today for the purchase of

Penney wishes to borrow $75,000 today for the purchase of bakery equipment. She have an agreement with their commercial banker that she can borrow money at an annual rate of 7.75%. How much will she owe if she repay the ...

Interested in learning more about its fans the marketing

Interested in learning more about its fans, the marketing office of the Arena Football League (AFL) conducted a survey at one of its games. The survey had 952 respondents, 679 males and 273 females. Out of the 952 total ...

An egg farmer wanted to determine if increasing the amount

An egg farmer wanted to determine if increasing the amount of time the lights were on in his hand house would increase egg production. For example of 8 chickens he determined the production before and after increasing th ...

A company making refrigerators strives for the internal

A company making refrigerators strives for the internal temperature to have a mean of 37.5 degrees with a standard deviation of 0.6 degrees, based on samples of 100. A sample of 100 refrigerators have an average temperat ...

You want to retire in 35 years to fund the retirement you

You want to retire in 35 years. To fund the retirement, you deposit $25,000 into an account now, and you deposit $20,000 five years from now. You also plan to save an equal amount each year between now and 35 years from ...

You are considering an investment in a 40-year security the

You are considering an investment in a 40-year security. The security will pay $25 a year at the end of each of the first three years. The security will then pay $30 a year at the end of each of the next 20 years. The no ...

54 of public high school students are provided a computer

54% of public high school students are provided a computer by their school district. 40 students are selected at random. The random variable represents the number of students who have been provided a computer by their sc ...

Let x be a random variable with range rx -1 0 1 and let px

Let X be a random variable with range RX = {-1, 0, 1} and let P(X = 1) = P(X = -1) = p/2 for some p ∈ [0, 1]. a) Compute P(X = 0). b) Compute the expectation E[X] and variance Var(X) of X as a function of p, and determin ...

The number of people arriving for treatment at an emergency

The number of people arriving for treatment at an emergency room can be modeled by a Poisson process with a mean of 7 people per hour. How many people do you expect to arrive during a 55-minute period?

On average the parts from a supplier have a mean of 975

On average, the parts from a supplier have a mean of 97.5 inches and a standard deviation of 6.1 inches. Find the probability that a randomly selected part from this supplier will have a value between 85.3 and 109.7 inch ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As