Open the file "dati_piastre.xls" and save it in .csv format.
The dataset reports the results of a study in which the concentration of a certain protein extracted from cells in 16 culture plates (HTC122 cell line) was evaluated.
The incubation conditions of the plates vary by temperature and concentration of a certain vitamin.
Open the .csv file in R and calculate the absolute frequency, relative frequency, percentage relative frequency, and cumulative relative frequency for all variables.
SOLUTIONS:
Change the working directory
setwd("insert the Path of the Folder where you saved the file")2. Import the file
es_riass1 = read.csv("dati_piastre.csv", header = TRUE, sep = ";", dec = ".")
View(es_riass1); str(es_riass1)
attach(es_riass1)
dim(es_riass1); colnames(es_riass1); head(es_riass1)3. Frequency distributions for the variable Temperature
table(Temperatura) ## absolute frequency
table(Temperatura)/length(Temperatura) # relative frequency
table(Temperatura)/length(Temperatura)*100 # percentage relative frequency cumsum(table(Temperatura)/length(Temperatura)) # cumulative relative frequency4. Frequency distributions for the variable Protein
table(Proteina) ## absolute frequency
table(Proteina)/length(Proteina) # relative frequency
table(Proteina)/length(Proteina)*100 # percentage relative frequency
cumsum(table(Proteina)/length(Proteina)) # cumulative relative frequency5. Frequency distributions for the variable Vitamin
table(Vitamina) ## absolute frequency
table(Vitamina)/length(Vitamina) # relative frequency
table(Vitamina)/length(Vitamina)*100 # percentage relative frequency
cumsum(table(Vitamina)/length(Vitamina)) # cumulative relative frequency