Question: This question is based on stocksdb database. You will also need the DBI and RMYSQL packages, as well as the ggplot 2 package in R.

 This question is based on stocksdb database. You will also need

This question is based on stocksdb database. You will also need the DBI and RMYSQL packages, as well as the ggplot 2 package in R. a) Load the "Transaction" table into a data frame tDF in R using the dbReadTable command (similar to what we did in class and assignments). Show the R-Code. (While you need to create the connection string and run it in R, you need not show that code here; it is sufficient to show the R code for dbReadTable). b)Plot the histogram of the Quantity column. Show the R-Code and the Result. c) Plot the histogram of Quantity using the transaction type as the facet. (Hint: Use the facet_wrap feature). Show the R-Code and the Result

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!