Discussion and 2 replies with workbook




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.

Calculate your paper price
Pages (550 words)
Approximate price: -

Why Choose Us

Quality Papers

We value our clients. For this reason, we ensure that each paper is written carefully as per the instructions provided by the client. Our editing team also checks all the papers to ensure that they have been completed as per the expectations.

Professional Academic Writers

Over the years, our Acme Homework has managed to secure the most qualified, reliable and experienced team of writers. The company has also ensured continued training and development of the team members to ensure that it keep up with the rising Academic Trends.

Affordable Prices

Our prices are fairly priced in such a way that ensures affordability. Additionally, you can get a free price quotation by clicking on the "Place Order" button.

On-Time delivery

We pay strict attention on deadlines. For this reason, we ensure that all papers are submitted earlier, even before the deadline indicated by the customer. For this reason, the client can go through the work and review everything.

100% Originality

At Essay USA, all papers are plagiarism-free as they are written from scratch. We have taken strict measures to ensure that there is no similarity on all papers and that citations are included as per the standards set.

Customer Support 24/7

Our support team is readily available to provide any guidance/help on our platform at any time of the day/night. Feel free to contact us via the Chat window or support email: support@acmehomework.com.

Try it now!

Calculate the price of your order

We'll send you the first draft for approval by at
Total price:

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

Essay USA has stood as the world’s leading custom essay writing services providers. Once you enter all the details in the order form under the place order button, the rest is up to us.


Essay Writing Services

At Essay USA, we prioritize on all aspects that bring about a good grade such as impeccable grammar, proper structure, zero-plagiarism and conformance to guidelines. Our experienced team of writers will help you completed your essays and other assignments.


Admission and Business Papers

Be assured that you’ll definitely get accepted to the Master’s level program at any university once you enter all the details in the order form. We won’t leave you here; we will also help you secure a good position in your aspired workplace by creating an outstanding resume or portfolio once you place an order.


Editing and Proofreading

Our skilled editing and writing team will help you restructure you paper, paraphrase, correct grammar and replace plagiarized sections on your paper just on time. The service is geared toward eliminating any mistakes and rather enhancing better quality.


Technical papers

We have writers in almost all fields including the most technical fields. You don’t have to worry about the complexity of your paper. Simply enter as much details as possible in the place order section.