# Question: 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?

(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?

**View Solution:**## Answer to relevant Questions

A random sample of individuals who led their own income taxes were asked how much time (hours) they spent preparing last year's federal income tax forms. (a) Estimate the mean. (b) Estimate the standard deviation. (c) Do you ...(a) Make an Excel scatter plot of X = 1990 assault rate per 100,000 population and Y = 2004 assault rate per 100,000 population for the 50 U.S. states. (b) Use Excel's =CORREL function to find the correlation ...Given P (A) = .70, P (B) = .30, and P (A ∩ B) 5 .00, find (a) P(A ∪ B) and (b) P(A | B). (c) Sketch a Venn diagram. Given P(A) = .40, P(B) = .50, and P(A ∩ B) = .05. (a) Find P(A | B). (b) In this problem, are A and B independent? Explain. The contingency table below summarizes a survey of 1,000 bottled beverage consumers. Find the following probabilities or percentages: a. Probability that a consumer recycles beverage bottles. b. Probability that a consumer ...Post your question