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?
Membership TRY NOW
  • Access to 800,000+ Textbook Solutions
  • Ask any question from 24/7 available
    Tutors
  • Live Video Consultation with Tutors
  • 50,000+ Answers by Tutors
OR
Relevant Tutors available to help