Generate summary statistics for 2007 and 2013 using descriptive statistics of Excel Data Analysis.

$10.00

The dataset posted in the blackboard list the total assets of 30 largest U.S. banks for 2007 and 2013.

 

 

SKU: Stat090123

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 –

  1.  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).
  2.  Generate summary statistics for 2007 and 2013 using descriptive statistics of Excel Data Analysis.
  3.  Use an appropriate measure of central tendency obtained from summary statistics (question 2) to construct a bar graph.
  4.  Answer of the question posted on the top paragraph –  are the large U.S. banks larger than pre-recession level.

 

 

Download the Dataset

Reviews

There are no reviews yet.

Be the first to review “Generate summary statistics for 2007 and 2013 using descriptive statistics of Excel Data Analysis.”

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

Sorry no more offers available