a Use Excel functions to calculate the mean and standard
a Use Excel functions to calculate the mean and standard
(a) Use Excel functions to calculate the mean and standard deviation for weekend occupancy rates (percent) in nine resort hotels during the off-season.
(b) What conclusion would a casual observer draw about center and variability, based on your statistics?
(c) Now calculate the median for each sample.
(d) Make a dot plot for each sample.
(e) What did you learn from the medians and dot plots that was not apparent from the means and standard deviations?