- Louise's play Fever came close to its fundraising goal in a short amount of time. Now, she wants to know how different campaigns fared in relation to their launch dates and their funding goals.
- Using the Kickstarter dataset, I visualize campaign outcomes based on their launch dates and their funding goals, and provide this written report based on my analysis and the visualizations created here.
- We can see that the months of May and June both have a greater success rate.
- The months of May, Jun, Jul, Aug and Oct have similarly high number of failure rate.
- The canceled rate in January is the highest.
- Here is the link to Kickstarter_Challenge.xlsx.
- We can see the higher percentage of success for Goals in less than 1k, 1k-1.5k, 35k-40k, and 40k-45k (75.81%, 72.66%, 66.67%, 66.67%).
- Higher percentage of failed for the Goals in 25k-30k, 45k-50k =, and over 50K (80%, 72.73%, 100%, 87.5%).
- Here is the link to Kickstarter_Challenge.xlsx.
- One challenge is to setup
COUNTIFSformulas in the sheet "Outcomes Based on Goals". By copy and paste the formulas to other columns without using absolute cell reference will require lots of updates in the formula. By adding absolute cell reference (using the shortcut Fn-F4), it makes my life easier!
=COUNTIFS(Kickstarter!D:D,">=5000",Kickstarter!D:D,"<=9999",Kickstarter!F:F,"successful",Kickstarter!R:R,"plays")
=COUNTIFS(Kickstarter!$D:$D,">=5000",Kickstarter!$D:$D,"<=9999",Kickstarter!$F:$F,"successful",Kickstarter!$R:$R,"plays")
- Another challenge is to reduce the Excel file size. The Excel file size is over 45M, and it is mainly due to too large of "used range" in the worksheet "Successful US Kickstarters" and "Failed US Kickstarters". I google the solution and find this https://www.excelefficiency.com/reduce-excel-file-size/#1_Remove_8220blank_space8221_in_your_sheets to describe how to clear the unneccessary "used range". Afterwards, the file size now reduce to under 3M!
- What are two conclusions you can draw about the Outcomes based on Launch Date?
The month that launched the most successful Kickstarter campaigns was May. However, May, June, July, August and October all had roughly the same number of failed campaigns launched.
- What can you conclude about the Outcomes based on Goals?
It is more likely to have successful outcome if the Goal is less than $1000, or between $1000 to $1500.
- What are some limitations of this dataset?
- The latest data was drawn from 2017, which is a little outdated. It is suggested to extract some recent data from the internet, in order to make the results more update-to-date.
- It is assumed that the currency of the amount shown in the "Goals" is the same even the campaigns were took place from different countries. If not, the results would be totally different.
- What are some other possible tables and/or graphs that we could create?
We may further filtering both graphs with the Country like GB or US, depending on where Louise is planning to perform the play, to make the results more country specific and realistic.