Question

Assuming you have the data from the Acme superstore (provided in the tableau exercise) loaded into your R Project as a data frame called "AcmeSales". Show the R code necessary to: A. Calculate the total annual sales and total annual profit from the sales of each category of product sold in Texas and New York. B. Plot the annual profits from A. above to visualize the difference between each category's annual profits from sales in Texas and New York. The plot must have appropriately formatted titles, axes and "geoms" that show differences within and between groups for full points.

Answer 1

To analyze the AcmeSales data for Texas and New York sales and profits by category, the R language can be used to filter and aggregate the data, then ggplot2 can be utilized to create a bar chart visualizing the annual profits compared across categories and states.

Step-by-step explanation:

To calculate the total annual sales and total annual profit from each category of product sold in Texas and New York, you will first need to filter the data in your AcmeSales data frame. Then, you'll aggregate the sales and profit data for each category. Here's how to do it in R:

# Filter for Texas and New York
sales_tx_ny <- AcmeSales[AcmeSales$State %in% c("Texas", "New York"),]
# Aggregate sales and profits by category
annual_sales_profits <- aggregate(cbind(Sales, Profit) ~ Category + State, data = sales_tx_ny, sum)

To plot the annual profits for each category in Texas and New York, we can use ggplot2:

library(ggplot2)
# Create a plot of annual profits
profit_plot <- ggplot(annual_sales_profits, aes(x = Category, y = Profit, fill = State)) +
geom_bar(stat = "identity", position = "dodge") +
labs(title = "Annual Profits by Category in Texas and New York", x = "Category", y = "Annual Profit") +
theme_minimal()
# Display the plot
print(profit_plot)

The code geom_bar with position dodge is used to create a bar plot that allows us to easily compare the profits between categories and between states.