Create a histogram and box and whisker plot of the Price and Quantity columns.

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

Perform the following tasks using R/RStudio and submit .html file

Read the data

1. Transform columns so that datatypes are appropriate. Specifically ensure that the CustomerCode variable is formatted as character, any other categorical variable is set as factor, and date column is set as a date type (Date/POSIXIt/POSIXct). 3 points

2. Display and interpret the summaries for the Quantity and Price columns. 4 points

3. Display the count of NA values in each column. 1 point

4. Display a bar chart for Category column. 2 points

5. Display the Departments and their revenue using a bar chart. Order the bars in a meaningful way. 4 points. (Hint: You will need to create a new column Revenue by multiplying Price and Quantity.)

6. Create a histogram and box and whisker plot of the Price and Quantity columns. 4 points

7. Write a short essay (150-200 words) to compare the strengths and weaknesses of (1) Power BI and (2) Alteryx with that of R, for this kind of analysis. You may discuss how each of these fare in terms of replicability, ease of use, cost, ability to share results with others, scalability, etc. 7 points

Attachments:

Expert's Answer

946 Times Downloaded

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