Chat with us, powered by LiveChat As part of a study on transportation safety, the U.S. Department of Transportation collected data on the number of fatal accidents per 1000 | Wridemy

As part of a study on transportation safety, the U.S. Department of Transportation collected data on the number of fatal accidents per 1000

 

Discussion

 

As part of a study on transportation safety, the U.S. Department of Transportation collected data on the number of fatal accidents per 1000 licenses and the percentage of licensed drivers under the age of 21 in a sample of 42 cities. Data collected over a one-year period follow. These data are contained in the file Safety.

 

Managerial Report

  1. Develop numerical and graphical summaries of the data.
  2. Use regression analysis to investigate the relationship between the number of fatal accidents and the percentage of drivers under the age of 21. Discuss your findings.
  3. What conclusion and recommendations can you derive from your analysis?

Initial post prompt: Your Managerial Report serves as your initial post to the discussion forum. After responding to the requirements posed by the Managerial Report, also provide an example in your career in which you believe one of the lessons learned from the Case has been/could be applicable. Alternatively, if you don’t have/foresee direct experience relevant to your current position, what type of scenario can you anticipate occurring where you can utilize one of the lessons learned from examining this case?

Response post prompt: Consider Managerial Reports posted by two of your peers. One or both of your responses may be to Managerial Reports for a case problem different from your own. Think critically and ask open-ended questions. If you agree, consider their position and expand upon their ideas. Provide an additional perspective. If you disagree, provide your reasoning. Always be professional and courteous in your responses.

Post by classmate 1

 

In question 1 I created a scatter plot and a regression data analysis chart to summarize the data found by the US department of transportation safety. As we can see from the scatter plot there is a positive linear relationship between the number of fatal accidents per 1000 licenses and percent of drivers under 21. I also included a dotted line to further show the positive regression between the two. In my regression data analysis chart we find important values R squared and the intercept and x variable. All values are also displayed on the plot and provide us more information of the relationship between X and Y. 

Question 2 asks us to discuss our findings. Using our intercept and x variable value displayed in my regression analysis we then find our estimated regression equation. Our equation is written as y = 0.2871x – 1.5974 or y = -1.5974 + 0.2871x. The regression equation tells us when the percentage value of drivers under the age of 21 increases, the fatal accident per 1000 licenses increases by 0.2871. Now we consider R squared to determine how well the equation fits the data and if it accurately depicts the changes in the dependent variable. From my regression analysis chart I found a R squared or coefficient of determination value of +0.7046. Our textbook explains that a positive value indicates that in a linear regression, variables x and y have a strong relationship because the value is positive. Furthermore, a R squared value can be written as a percentage and in this case is 70.5%. This means the scatter plot values around the regression line are small in difference and more significant in fitting the linear regression. 

The most important conclusion that can be made is there is a significant relationship between the number of fatal accidents and the percentage of drivers under the age of 21 in the 42 cities observed. Our estimated regression equation even tells us that when the percentage of drivers under the age of 21 increases, fatal accidents per 1000 licenses also increases by 0.2871. While that number might not seem significant our R squared percentage of 70.5% tells us the dependent variable variation to the linear model is strong and significant. Recommendations for the US department of Transportation may include additional testing to receive a license for individuals under the age of 21 to prevent fatal accidents from occurring.  

Anderson, D. R., Sweeney, D. J., Williams, T. A., Camm, J. D., Cochran, J. J., (2021). Modern Business Statistics with Microsoft Office Excel (7th ed.) Cengage.

Post by classmate 2

 

Hello Everyone,

This week’s case study was about the U.S Department of Transportation. The data that was collected was on the number of fatal accidents per 1000 licenses and the percentage of licensed drivers under the age of 21 in a sample of 42 cities total.

In my analysis, I used the regression method which show a positive impact between the two data sets. Within the regression data, the R square was proven to be an important value. Shown in my scattered plot I was able to provide more information between X = percent under 21 and Y = Fatal Accidents per 1000 which equal the R square. Using this method, I was able to learn that the regression analysis is very reliable when I comes to identifying which variable have a impact on specific interest. Based on the chart that I provided, the slope Y = 0.2871x – 1.5674 = 0.7046 which is R Squared. When looking at my scatter plot, there was a positive correlation between the two data samples. As a result, I am seeing that the percentage of licensed underage of 21 increased and the fatal accidents per 1000 licenses has increased by 0.2871.

Lastly, I would recommend that there should be a mandatory driving test after driving school in order to get their licenses. After reviewing this data, I believe that the U.S Department of Transportation should implement this to ensure that everyone is having the proper training on how to operate a vehicle. Furthermore, I believe that having someone coach you to be prepared to look out for other people while driving is very important, and it can keep you safe. I believe that the regression method is very useful in for this research which allowed us to see a change in each variable. I believe that another great example for this would possible be on the electrical market to see what customer are satisfied with their service.

Data

Percent Under 21 Fatal Accidents per 1000
13 2.962
12 0.708
8 0.885
12 1.652
11 2.091
17 2.627
18 3.83
8 0.368
13 1.142
8 0.645
9 1.028
16 2.801
12 1.405
9 1.433
10 0.039
9 0.338
11 1.849
12 2.246
14 2.855
14 2.352
11 1.294
17 4.1
8 2.19
16 3.623
15 2.623
9 0.835
8 0.82
14 2.89
8 1.267
15 3.224
10 1.014
10 0.493
14 1.443
18 3.614
10 1.926
14 1.643
16 2.943
12 1.913
15 2.814
13 2.634
9 0.926
17 3.256

Sheet2

Sheet3

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.

Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.

Do you need an answer to this or any other questions?

About Wridemy

We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.

How It Works

To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. 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.

Are there Discounts?

All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.

Hire a tutor today CLICK HERE to make your first order

Related Tags

Academic APA Writing College Course Discussion Management English Finance General Graduate History Information Justify Literature MLA