Discussion and 2 replies with workbook

 

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.