Import the given dataset in MySQL workbench. Inspect the table(s), columns, and determine the data types.

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

1. With the given dataset execute the following steps mentioned below. Variable description file contains necessary descriptions of variables. Provide necessary screenshots for each steps, SQL queries, R codes, graphs in Tableau.

(a) Import the given dataset in MySQL workbench. Inspect the table(s), columns, and determine the data types.

(b) Using R code read the data stored in MySQL into RStudio. Provide R code to summarize the data. What is your observations?

(c) Using RStudio find out the following characteristics –

(i) “Florida is the most accident-prone state in USA”-True or False? With the information in the dataset, justify your answer.

(ii) Speeding is often considered as one of the major reasons for road accident. What patterns do you observe in the dataset pertaining to this statement?

(ii) Find the top-3 accident prone state in the data. Write a function in R to find top-k accident prone state given k as input.

(d) Depict the above findings by creating a dashboard in Tableau for proper visualization.

2. Formulate a suitable research question of your choice which is distinct from question 1 and can be addressed using the given dataset. Justify briefly your choice of the research question. Provide the solution details using MySQL/R/Tableau.

Attachments:

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme