Question: Using Data Analysis ToolPak in Excel, please show how to solve the following problem. The local amusement park was interested in the average wait time

Using Data Analysis ToolPak in Excel, please show how to solve the following problem.

The local amusement park was interested in the average wait time at their most popular roller coaster at the peak park time (2 p.m.). They selected 13 patrons and had them get in line between 2 and 3 p.m. Each was given a stopwatch to record the time they spent in line. The times recorded were as follows (in minutes).

118, 124, 108, 116, 99, 120, 148, 118, 119, 120, 45, 130, 118

What is the 60th percentile?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Q:

Using Data Analysis ToolPak in Excel, please show how to solve the following problem: The average lateness for one of the top airline companies is 10 minutes. The variance of the lateness measure is...

Q:

This is the Table I need to complete These are the files that were provided to solve the problem This is an example of a completed Table All bonds issued by HomeDepot Inc. Project-Part 2 (Total 15...

Q:

Welcome! Please read this page (in particular) very carefully. Instructions You need to understand how to send your assignments (deliverables) to your instructor. The tabs (bottom of each sheet) in...

Q:

Welcome! Please read this page (in particular) very carefully. Instructions You need to understand how to send your assignments (deliverables) to your instructor. The tabs (bottom of each sheet) in...

Q:

Welcome! Please read this page (in particular) very carefully. Instructions You need to understand how to send your assignments (deliverables) to your instructor. The tabs (bottom of each sheet) in...

Q:

Welcome! Please read this page (in particular) very carefully. Instructions You need to understand how to send your assignments (deliverables) to your instructor. The tabs (bottom of each sheet) in...

Q:

MBA622 Syllabus Individual Work: Assignment 5 Resources Needed: \u0001 \u0001 \u0001 \u0001 Textbook: Review Chapters Software: Use Microsoft Excel to compute statistics and create tables, charts,...

Q:

How to submit an Assignment In response to customers like you, we have added a peach-colored box for each deliverable. We have done this to make it clear (and consistent) the areas of the project...

Q:

Welcome! Please read this page (in particular) very carefully. Instructions You need to understand how to send your assignments (deliverables) to your instructor. The tabs (bottom of each sheet) in...

Q:

What could be the "Anticipated Contributions" based on the topic: THE CORRELATION BETWEEN THE AMPLATS SHARE PRICE AND PLATINUM PRICES Abstract Background AMPLATS is a large platinum producing company...

Q:

Is a franchise fee the same thing as a royalty fee? Discuss.

Q:

On Fig. 10.5, what is feature E? Explain its origin.

Q:

6 Weach Diviaion has sotal assets ( net of accumulated depreciation ) of $ 4 6 2 , 0 0 0 at the beginning of year 1 . One of the assets is a machine that hass a net book value of $ 4 2 , 0 0 0 . Now,...

Q:

Irwin, Inc. constructed a machine at a total cost of $51 million Construction was completed at the end of 2017 and the machine was placed in service at the beginning of 2018. The machine was being...