Over $2 billion has been raised using the massively successful crowdfunding service, Kickstarter, but not every project has found success. Of the more than 300,000 projects launched on Kickstarter, only a third have made it through the funding process with a positive outcome.
Getting funded on Kickstarter requires meeting or exceeding the project's initial goal, so many organizations spend months looking through past projects in an attempt to discover some trick for finding success. For this week's homework, you will organize and analyze a database of 4,000 past projects in order to uncover any hidden trends.
Analyze the data of 4,000 past Kickstarter projects to uncover some market trends.
- Conditional formatting to fill each cell in the 'state' column with different color, depending on whether the associated campaign was successful, failed, or canceled, or is currently live.
- Formula to calculate 'Percent Funded' to uncover how much money a campaign made to reach its initial goal.
- Formula to calculate 'Average Donation' to uncover how much each backer for the project paid on average.
- Utilize 'Text to Columns' Wizard to split 'Category and Sub-Category' column to 'Category' amd 'Sub-Category'.
- Pivot table that will analyze worksheet to count how many campaigns were successful, failed, canceled, or are currently live per 'category'.
- Create stacked column pivot chart that can be filtered by country based on the table you have created.
- Pivot table that will analyze initial sheet to count how many campaigns were successful, failed, or canceled, or are currently live per 'sub-category'.
- Create a stacked column pivot chart that can be filtered by country and parent-category based on the table created.
- Convert Unit timestamps to Excel's date format.
- Pivot table to analyze count of 'state' by date (Month and Year) . Create line graph to visualize the data.
- Count Ifs formula to count how many successful, failed, and canceled projects were created with goals within the ranges listed above. Populate the 'Number Successful', 'Number Failed', and 'Number Canceled' columns with this data.