Instructions: For this assignment, submit one Word file. Do not submit Excel file. Copy and paste all graphs, table if any, and descriptive statistics to a Microsoft Word file.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?P.S.
Israel: A Blessing to All Nations
“I will make of you a great nation? And you shall be a blessing? And all the families of the earth shall bless themselves by you” (Gen. 12:2-3). Israel is a blessing to the other nations. As long as Israel succeeds in informing other peoples and proving that Yahweh is God, it will be understood […]
