Description
The administrators of Dino Fun World, a local amusement park, have asked you, one of their data
analysts, to perform three data analysis tasks for their park. These tasks will involve understanding,
analyzing, and graphing attendance data that the park has provided for you to use. They have
provided the data in the form of a database, described below.
Provided Database
The database provided by the park administration is formatted to be readable by any SQL database
library. The course staff recommends the sqlite3 library. The database contains three tables, named
‘checkins’, ‘attractions’, and ‘sequences’. The information contained in each of these tables is listed
below:
`checkin`:
Description: checkin data for all visitors for the day in the park. The data includes two types of
checkins, inferred and actual checkins.
Fields: visitorID, timestamp, attraction, duration, type
`attraction`:
The attractions in the park by their corresponding AttractionID, Name, Region, Category, and type.
Regions are from the VAST Challenge map such as Coaster Alley, Tundra Land, etc. Categories
include Thrill rides, Kiddie Rides, etc. Type is broken into Outdoor Coaster, Other Ride, Carussel,
etc.
Fields: AttractionID, Name, Region, Category, type
`sequences`:
The checkin sequences of visitors. These sequences list the position of each visitor to the park
every five minutes. If the visitor has not entered the part yet, the sequence has a value of 0 for that
time interval. If the visitor is in the park, the sequence lists the attraction they have most recently
checked in to until they check in to a new one or leave the park.
Fields: visitorID, sequence
The database is named ‘dinofunworld.db’ and is available in the readonly directory of the Jupyter
Notebook environment (i.e. readonly/dinofunworld.db).
1
Assignment
1: The park’s administrators are worried about the attendance at the ride ‘Atmosfear’ in the data
window. To assuage their fears, they have asked you to create a control chart of the total attendance
at this ride. Using the data provided, create a control chart displaying the attendance, the mean, and
the standard deviation bands at one and two standard deviations.
2: Some of the park’s administrators are having trouble interpreting the control chart graph of
‘Atmosfear’ attendance, so they ask you to also provide a moving average chart of the attendance in
addition to the control chart created in the previous question. In this case, they request that you use
50 samples for the size of the moving average window.
3: In order to have options concerning the graphs presented, the park’s administrators also ask you
to provide a 50sample moving average window with the average computed with exponential
weighting (i.e. an exponentiallyweight moving average) over the same ‘Atmosfear’ attendance data.
Administrative Notes
This assignment will be graded by Coursera’s grading system. In order for your answers to be
correctly registered in the system, you must place the code for your answers in the cell indicated for
each question. In addition, you should submit the assignment with the output of the code in the cell’s
display area. The display area should contain only your answer to the question with no extraneous
information, or else the answer may not be picked up correctly. Each cell that is going to be graded
has a set of comment lines at the beginning of the cell. These lines are extremely important and
must not be modified or removed.
A correct submission would result in feedback as:”Correct!”
An incorrect submission would look like: “ Incorrect Response! ”
2