Good day Louise. The following report will identify key findings of the attached spreadsheet titled "Kickstarter_Challenge". In this spreadsheet, the data has been cleaned up and and filtered to allow you to see the most importand information to you as soon as you open it, that being how other plays similar to your sfaired in their kickstarter campaigns. At any time, you are able to clear the filters created and see all of the kickstarter data.
Data Results
As for creating the provided spreadsheet, there weren't to many complications. The spreadsheet was already structured in a way that was easily readable and filterable. I did have to add some columns(P-T) in order to provide more fidelity on the kicstarter campaigns which I think you'll appreciate. Of specifc importance were the 'Date Created' and 'Date Ended Conversion' which allowed me to provide the table below:
What this line graph shows are campaigns that started in the early summer did better than those that started at any other time of the year. It also showed that during the winter months, less people were inclined to donate to kickstarters. This makes since given the holiday season and most people are spending extra on gifts for the holidays.
The other line graph I wanted to highlight was one I created based on percentages of succesfful and filed campaigns based on their kickstarter goals(graph below). There is a very high correlation of failed campaigns as the goal amount increases. There does seem to be an anomaly between $35-$45,000 dollars where the percentage of successful and failed campaigns flips. There is a chance this could be related to the time of year, as I already discussed above, or this could be due to the year in which these plays were fund raising. I will have to work with the data a little more but I wanted to provide you with an update on my findings sooner rather than later.
Final Thoughts
I believe that the data set that was provided can be very useful to support business decisions. However, I caution you to rely solely on this spreadsheet alone. What we have yet to do is determine what genre of plays were successful in their fundraising and those that failed. This could be of much more use to you than when fundraisers were most successful. Also, this dataset covers almost a decade. Different societal factors could have influenced whether a play was successful or not. Do any of these plays conflict with social norms? Are there perceived racial prejudices with any of these plays? A lot has happened in the world in a decade and is not reflected in this spreadsheet nor has an analysis been done on those factors. Remember to always include multiple data sources when needing to make decisions that can impact your business.
This is just the beginning. Continued analysis of the prodvided data could provide more strategic business solutions. If you should have any questions or insights, please don't hesitate to reach out.