The Excel Worksheet named "Question " contains data on a sample of 30 hotel guests that were asked to rate the quality of their accommodations as being excellent, average, or poor.The responses were divided by gender (male, female) { Show how to solve this question in excel. For accuracy, retain all four decimal places during intermediate calculations and round the final answers to two decimal places.}

a. Prepare pivot table summarizing the two variables of quality rating and gender.

Transfer the information below.

Quality Rating

Female

Male

Totals

Excellent

Average

Poor

Totals

b.What is the probability that a randomly selected female guest rates the quality of accommodation as excellent?

c.You know that the guest rated the quality of accommodation as poor.What is the probability that the guest is male?

d.Quality Rating is measured on which scale (level ) of measurement? Answer:___________________

Quality Rating:- Excellent Poor Average Excellent Average Excellent Average Excellent Poor Excellent Excellent Average Poor Excellent Excellent Average Excellent Excellent Average Poor Excellent Poor Excellent Excellent Excellent Excellent Poor Excellent Poor Average

Gender:- Male Female Male Male Male Female Female Female Male Male Female Male Male Female Female Male Female Male Male Female Female Male Male Female Male Male Female Female Female Female