Blog

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 

For this feedback loop scenario, fill in the completion of the loop and the type of feedback loop (positive or negative). Background: Land desertification is a process by which fertile land becomes desert, typically because of hotter and drier conditions. This results in greater amounts of windblown dust entering the atmosphere, which reflects sunlight back into space rather than it reaching the Earth’s surface. Beginning of Loop: Rising atmospheric carbon dioxide concentrations results in longer periods of drought and extreme heat. Completion of loop:   Type of feedback loop:  

Create a pivot table to examine data to answer the following broad question: “Does the likelihood to return differ by season of visit and does this relationship vary by type of group visited with?” Rename the worksheet showing the resulting pivot table something like “return x season x group.” Respond to the following 3 questions based on adjusting the pivot table to show what you need.  Based on % of row totals, what season has the highest percent of respondents reporting they are “definitely” planning to return to the park?