hw01

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:

summary(cars)

##      speed           dist       
##  Min.   : 4.0   Min.   :  2.00  
##  1st Qu.:12.0   1st Qu.: 26.00  
##  Median :15.0   Median : 36.00  
##  Mean   :15.4   Mean   : 42.98  
##  3rd Qu.:19.0   3rd Qu.: 56.00  
##  Max.   :25.0   Max.   :120.00

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.

install.packages(“tidyverse”) install.packages(“lubridate”) install.packages(“tidyquant”) install.packages(“readxl”) install.packages(“writexl”)

library(tidyverse)
library(lubridate)
library(tidyquant)
library(readxl)
library(writexl)

read_excel(“C:\Users\Pham Vu Phuong Chinh\Downloads\bikes.xlsx”)

library(dplyr)

Read the Excel file

data <- read_excel(“C:\Users\Pham Vu Phuong Chinh\Downloads\bikes.xlsx”)

Select only the “model” and “price” columns, and arrange by “price” descending

result <- data %>% select(model, price) %>% arrange(desc(price))

View the resulting data frame

print(result)

Calculate the mean of the “price” column

mean_price <- mean(data$price)

Select only the “model” and “price” columns, filtering by price greater than the mean

result <- data %>% select(model, price) %>% filter(price > mean_price)

View the resulting data frame

print(result)