library(readxl)
A4Q1 <- read_excel("//apporto.com/dfs/SLU/Users/hannahsmith3_slu/Downloads/A4Q1.xlsx")
table(A4Q1$flavor)

## 
##  Chocolate      Mango Strawberry    Vanilla 
##         87         32         57         74

observed <- table(A4Q1$flavor)
observed

## 
##  Chocolate      Mango Strawberry    Vanilla 
##         87         32         57         74

barplot(observed,
        main="Flavor",
        xlab= "Flavor",
        ylab= "Frequency",
        col= rainbow(length(observed)))

expected <- c(.20, .20, .20, .40)
chi_result <- chisq.test( x = observed, p = expected)
chi_result

## 
##  Chi-squared test for given probabilities
## 
## data:  observed
## X-squared = 41.6, df = 3, p-value = 4.878e-09

w <- sqrt( as.numeric(chi_result$statistic) / sum(observed))
w

## [1] 0.4079216