This paper concentrates on the primary theme of Generate summary statistics for 2007 and 2013 using descriptive statistics of Excel Data Analysis in which you have to explain and evaluate its intricate aspects in detail. In addition to this, this paper has been reviewed and purchased by most of the students hence; it has been rated 4.8 points on the scale of 5 points. Besides, the price of this paper starts from £ 40. For more details and full access to the paper, please refer to the site.
The dataset posted in the blackboard list the total assets of 30 largest U.S. banks for 2007 and 2013. Five years after the peak of the financial crisis, has Washington solved the problem of banks “too big to fail”? Are the large U.S. banks larger than pre-recession level? Write a report based on your analysis of these data. Report must include –
- A separate histogram for 2007 and 2013. (Hint: for 2007 total assets, construct a histogram using 6 classes. Use class intervals 0 to up to 400, 400 to up to 800, …, 2000 to up to 2400. Create a separate column for upper-class limits of each class intervals – this column is the bin range in Excel. Do the same for 2013).
- Generate summary statistics for 2007 and 2013 using descriptive statistics of Excel Data Analysis.
- Use an appropriate measure of central tendency obtained from summary statistics (question 2) to construct a bar graph.
- Answer of the question posted on the top paragraph – are the large U.S. banks larger than pre-recession level.