Hi,

I just need to mean and the STD to finish this table. thanks so much!

Hi, this is the data I got for B which is pfizer. There is data online as well. I did not turn the decimals into percents because that is what I got online.

4. Find and compare last ten year ROA's (Net Income/[(Beginning Total assets + Ending total assets)/2] of two firms. Calculate their means and standard deviations (STD) in Excel. Fiscal Firm A's Net Income (NI) (Smillions) Firm A's ROA (%) year end Firm B's Net Income (Smillions) Firm B's ROA (%) date 1 2008 $4052 NA NA NA 2 2009 $4605 23.24% NA NA 3 2010 $5545 25.50% $8,257 $1.01" 4 2011 $4312 17.64% $10,009 $1.31 5 2012 $5577 120.54% $14,570 $1.95 6 2013 $5081 15.36% $22,003 $3.07 7 2014 S5158 14.97% $9,135 $1.34 8 2015 $6939 19.42% $6960 $1.04 9 2016 $7722 19.89% $7215 $1.06 10 2017 $1979 4.95% $21,308 $3.10 11 2018 $8394 25.27% $11,153 $1.68 Mean $5397 19.00% STD $1712.86 5.74%