R Markdown

This is an R Markdown document. Markdown is a simple formatting syntax for authoring HTML, PDF, and MS Word documents. For more details on using R Markdown see http://rmarkdown.rstudio.com.

When you click the Knit button a document will be generated that includes both content as well as the output of any embedded R code chunks within the document. You can embed an R code chunk like this:

# install.packages("readxl") 
# Load necessary libraries library(readxl) library(dplyr) 
# Read the data from the Excel file bike_orderlines <- readxl::read_excel("bike_orderlines.xlsx") 
# Generate quantity sales and percentage by bikeshop_name result <- your_data %>% group_by(bikeshop_name) %>% summarise( total_quantity = sum(quantity), total_percentage = sum(quantity) / sum(your_data$quantity) * 100 ) 
# Print the result print(result)

Including Plots

You can also embed plots, for example:

Note that the echo = FALSE parameter was added to the code chunk to prevent printing of the R code that generated the plot.