Rstudio1

library(readxl)
file_path <- "/Users/limjiyun/Desktop/F1/tips.xlsx"
tips <- read_xlsx(file_path)

df <-read_xlsx(file_path)

male_tip <- df$total_bill[df$gender == 'Male']
female_tip <- df$total_bill[df$gender =='Female']



#t.test(male_tip, female_tip, alternative = 'greater', var.equal = TRUE)

t.test(male_tip, female_tip)

## 
##  Welch Two Sample t-test
## 
## data:  male_tip and female_tip
## t = 2.3734, df = 199.85, p-value = 0.01857
## alternative hypothesis: true difference in means is not equal to 0
## 95 percent confidence interval:
##  0.454573 4.919787
## sample estimates:
## mean of x mean of y 
##  20.74408  18.05690

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.