Quantitative Business Analysis help

profileRahrah80
excel_template.xlsx
Home>Business & Finance homework help>Management homework help>Quantitative Business Analysis help

Sheet1

ROE (2001) ROE (2003) difference= ROE(2001)- ROE (2003)
Bank of America 14.1 22 -7.9
Bank 2 0
Bank 3 0
Bank 4 0
Bank 5 0
Bank 6 0
Bank 7 0
Bank 8 0
Bank 9 0
Bank 10 0
Bank 11 0
Bank 12 0
Bank 13 0
Bank 14 0
Bank 15 0
Bank 16 0
Bank 17 0
Bank 18 0
Bank 19 0
Bank 20 0
mean (d)= -0.395
standard deviation (d)= 1.7664937022
n (no. of banks)=
SE(md)=std. dev/n where n= sample size ERROR:#DIV/0!
Find value below from Table- "APPENDIX D STUDENT'S t CRITICAL VALUES" in Text book. Use the one tailed test and choose 3 different signifcance levels. To read the table, look at degree of freedom d(f)=n-1 on y axes of table. On the x axes of tabke pick the significance level from the table and find the corresponding value in the table. So for example if n=12 and significance level=0.05, then t value from table is 1.796
t (test statistic)= where t=mean/std. deviation ERROR:#DIV/0! Significance value (p or α) 0.05 or 5% 0.025 or 2.5% 0.01 or 1%
T (critical)

For your convenience, i have attached the t table to this excel file. Please see tab titled "t table"

For your convenience, i have picked 3 different significance levels. You can pick other levels from the t table as per your like. So for example you can pick 0.1, 0.001, etc.

Sheet2

t table