library(readr) df<-read.csv("mod4peerrev_data.csv") library(tidyverse) library(ggplot2) library(dplyr) library(ggeasy) library(patchwork) library(stringr)

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

summary(df$Price) summary(df$Quantity)

3. Display the count of NA values in each columns.

colSums(is.na(df))

4. Display a bar chart for Category columns. The bar should display the frequency of each category.

library(ggplot2) ggplot(df, aes(x=Category))+ geom_bar()+ labs(title = 'Frequency Count by Category')

5. Display a bar chart for Category columns. Order the bars in a meaningful way.

df1 <- df%>% dplyr::groupby(Category)%>% dplyr::mutate(Category = strto_title(Category))%>% tally()

ggplot(data = df1, aes(x = Category, y = n,fill = Category))+ geom_bar(stat = "identity") + labs(subtitle = "Order Category Made by Mark Recio")

ggplot(data = df1, aes(x= reorder(Category, -n), y = n, fill = n))+ geombar(stat = "identity") + geomtext(aes(label = n), size = 2, vjust = -0.3) + themeclassic() + theme(legend.position = "none") + labs(x = "Category", y = "Number of Category") + ggeasy::easyalltextcolor(color = "blue") + labs(subtitle = "Order Category Meaningful Way Made by Mark Recio")

6. Create a Histogram and box and whisker plot of the price and Quantity columns.

a. box plot of the price column

library(ggplot2) ggplot(df, aes(x=Price)) + geomboxplot() + coordcartesian(ylim =c(-1,1.0))+ labs(title = 'Box Plot Price')

b. a histogram of the price column

ggplot(df, aes(x=Price)) + geomhistogram(binwidth = .75) + coordcartesian(xlim = c(-50, 50), ylim = c(0, 10000))+ labs(title = 'Histogram of Price')

c. a box plot of the quantity column

library(ggplot2) ggplot(df, aes(x=Quantity)) + geomboxplot() + coordcartesian(ylim =c(-1,1.0))+ labs(title = 'Box Plot Price')

d. a histogram of the quantity column

ggplot(df, aes(x=Quantity)) + geomhistogram(binwidth = 1.0) + coordcartesian(xlim = c(0, 25), ylim = c(0, 3000))+ labs(title = 'Histogram of Quantity')

7. Write a a short essay (150-200 words) to compare the strengths and weaknesses of (1) Power Bi (2) Alteryx with that of R, # for this kind of analysis.

I find Alteryx to be a good tool to use for data analysis and visualization; however, I prefer to use Microsoft Power BI to be best source for me in my career. Microsoft Power BI allows me to easily to use DAX function for calculations, put into charts into visualization, and get the insights and summary information. Microsoft Power BI offers lots of features to make rich data visualization and dashboards. Microsoft Power BI is the tool for Business Analyst. Microsoft Power BI has the platforms supported for Windows, Mac, Android, and Chromebook, while Alteryx only supports Windows. Microsoft Power BI ranked as the #2 among all Business Intelligence Tools. Microsoft Power BI is much more affordable to use and worth the money than using Alteryx. Alteryx is the tool to use for fast reporting with no programming needed and less learning curve than