Blog

As the nationwide customer experience manager, you are curious to know with the full dataset if there is a relationship (association) between store district and overall satisfaction. Answer the following two questions as you select different cell information and interpret the results.   What is the West Region’s overall average satisfaction? 

Is there a statistically significant association between loyalty and bucketed satisfaction with cleanliness? Determine yes or no and what is the p value? 

Excel Use the In-class Amusement Park Excel sheet to answer the following questions:  If you don’t have it already downloaded: Amusement Park Data – Students.xlsx

Create a pivot table to answer the following broad question: How do average wait times vary by area the park where respondents spend most of their time? Rename the worksheet showing the resulting pivot table something like “wait time x area of park”.  Based on the data, what is the average wait time (in minutes) of respondents who spent most of their time in the Kid’s Kingdom?  

What is the range (min – max) of average number of minutes spent waiting in line? 

Of the questionnaire items with numeric responses, which ones would be considered positively skewed? 

Upload your Excel file the with the data, computations, and pivot tables used for this section of the test  

What is the standard deviation for how many rides guests went on during their park visit? 

How many rides, on average, did guests go on during their park visit? 

Calcium homeostasis is an ongoing process to keep the calcium concentration in a normal range by multiple organ systems.  Why do we care about calcium ions in the human body? Select all that apply