Search found 8 matches
- Tue Nov 29, 2022 2:17 pm
- Forum: Fall 2022
- Topic: wk10 - 11.29.22 Final Project
- Replies: 4
- Views: 14314
Re: wk10 - 11.29.22 Final Project
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...
- Mon Nov 21, 2022 9:37 pm
- Forum: Fall 2022
- Topic: wk9 - 11.22.22 Random Sampling
- Replies: 4
- Views: 4094
Re: wk9 - 11.22.22 Random Sampling
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...
- Tue Nov 15, 2022 3:03 pm
- Forum: Fall 2022
- Topic: wk8 - 11.15.22 Outliers
- Replies: 4
- Views: 4949
Re: wk8 - 11.15.22 Outliers
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...
- Mon Nov 07, 2022 10:55 pm
- Forum: Fall 2022
- Topic: wk7 - 11.8.22 4 MySQL commands new to you
- Replies: 4
- Views: 4798
Re: wk7 - 11.8.22 4 MySQL commands new to you
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()
- Tue Nov 01, 2022 2:23 pm
- Forum: Fall 2022
- Topic: wk6 - 11.01.22 MidTerm Presentation
- Replies: 4
- Views: 4787
Re: wk6 - 11.01.22 MidTerm Presentation
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 ...
- Tue Oct 18, 2022 11:18 am
- Forum: Fall 2022
- Topic: wk4 - 10.18.22 Discover Patterns with MySQL
- Replies: 4
- Views: 4571
Re: wk4 - 10.18.22 Discover Patterns with MySQL
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...
- Tue Oct 11, 2022 1:58 pm
- Forum: Fall 2022
- Topic: wk3 - 10.11 .22 2nd Project in MySQL
- Replies: 4
- Views: 4924
Re: wk3 - 10.06 .22 MySQL queries studies
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.
- Tue Oct 04, 2022 11:22 am
- Forum: Fall 2022
- Topic: wk2 - 09.29.22 1st Project in MySQL
- Replies: 4
- Views: 4345
Re: wk2 - 09.29.22 MySQL queries studies
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?
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?