Media Arts and Technology

In this report, I try to model the amount of time that passes between check-out and return using several variables that I constructed and a sample of 2813 observations. The linear regression showed that adult items, CDs, and DVDs tend to be returned faster. However, the regression method with my dat...

In this report, I repeatedly draw samples of increasing size to demonstrate that higher sample size results in a more representative sample. I use all checkouts in 2018 as my population and use item type distribution as the main parameter to evaluate how well samples represent original data. I was a...

In this report, I focus on entries with incorrectly classified check-in times (earlier than check-out times). I explore overall yearly trends in those anomalies, use cross tabs to classify them by both check-in and check-out, identify the most extreme cases with the largest discrepancies, and invest...

In this report, I explore new MySQL functions. Specifically, I try string manipulation, extracting day of the week, getting variance and standard deviation, and manually replacing null values using coalesce()

In this report, I dive deeper into the exploration of seasonal trends in the SPL, this time using daily Data from March 2015. I explore variables such as total checkouts, checkouts by type, diversity of titles, diversity of types, and the weight of a top performing item each day against temperature ...

For this report, I wanted to explore seasonal patterns in SPL book checkouts. Specifically, I am interested in (1) whether or not seasonal patterns exist; (2) whether or not there is some association with weather conditions (temperature and precipitation); and (3) whether there are seasonal trends f...

For this assignment, I analyzed several other (disconnected) questions. Specifically: (1) the aftermath of J.K. Rowling’s Twitter scandal; (2) items that were not returned to the library and associated check-in issues; and (3) general information regarding the busiest day in the SPL to date.

Just a few exploratory queries out of general interest:
1. Interest in data science books over time
2. Interest in math books over time
3. Did people boycott J.K. Rowling's books following her Twitter scandal?
4. Does interest in political science books rise during election years?