> For the complete documentation index, see [llms.txt](https://chankyungpak.gitbook.io/ebis3003-2021/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://chankyungpak.gitbook.io/ebis3003-2021/assignments/homework-assignment-1.md).

# Homework Assignment 1

Analytics of donorschoose.org Data (DUE: April 4th)

In Week 3, we analyzed `projects` table on donorschoose.org to gain some insights we can use to improve the platform. As a homework assignment, you are analyzing `donations` and `donors` for the same purpose. Throughout your answers, use the techniques you have learned so far, and submit your code and the results **as one file**. Remember, in this assignment, correctness of your codes and results will be graded. You do not have to write only one set of code to answer one question.

## 1. Donations

* What is the average total amount (in $) of donations made to **each project**? If two donations that amount to $10 and $20 respectively were made to project A, the total donation to project A is $30.
* How many did **unique** projects receive a donation at least once according to `donations` table? 
* Some donations 'complete' projects, meaning that those **last** donations made to projects enabled the projects to achieve the monetary goal they set up front. Whether a donation completes a project is recorded in the column `completion`. Are donations that complete projects substantially larger/smaller than other donations?

## 2. Donors

* Count the numbers of donors from each `state`.
* Does average amount of donation (`avg_total`) differ between one-time donor (`num_projeccts=1`) v. more-than-once donor (`num_projects>1`)?