Excel Data Question

  • On Sheet 1:
  • Use conditional formatting to fill each cell in the Percent Funded column using a three-color scale. The scale should start at 0 and be a dark shade of red, transitioning to green at 100, and blue at 200.
  • Create a report in Microsoft Word and answer the following questions.
  1. Given the provided data, what are three conclusions we can draw about Kickstarter campaigns?
  2. What are some limitations of this dataset?
  3. What are some other possible tables and/or graphs that we could create?

On Bonus Statistical Analysis Sheet:

  • 1.  Determine  whether the mean or the median summarizes the data more meaningfully.
  •  2. Determine if there is more variability with successful or unsuccessful campaigns. Does this make sense? Why or why not?

Leave a comment

Your email address will not be published. Required fields are marked *