A survey conducted by CBS News asked 829 respondents which of the following events will happen first. The responses are summarized in the following table:
Cure for cancer found ..... 40%
End of dependence on oil ..... 27%
Signs of life in outer space ... 12%
Peace in Middle East ...... 8%
Other ............ 6%
None will happen ....... 7%

a. Use Excel to construct a pie chart and a bar chart for these data.
b. How many people think that a cure for cancer will be found first?