The file below called banks EMA provides selected financial data for a sample of $404$ banks in the UK$,$ Switzerland, and France. The table below lists the first $10$ banks from the file where each row represents an individual firm. Column ID assigns a unique identification number to each bank. Column Country codes the countries: FR $($France$),$ GB $($Great Britain$),$ and CH $($Switzerland$).$ The next two columns show the banks$$ total assets, measured in $ in $2021$ and $2020$ correspondingly.

The first $10$ rows in banks EMA.

ID Company name Country Total assets $($$$)2021$ Total assets $($$$)2020$

$1$ BNP PARIBAS FR $2,983,772,0843,053,625,563$

$2$ CREDIT AGRICOLE SA FR $2,348,962,0712,406,417,806$

$3$ SOCIETE GENERALE FR $1,658,635,3881,772,427,136$

$4$ BARCLAYS BANK PLC GB $1,426,392,4401,422,159,894$

$5$ CREDIT MUTUEL $($COMBINED $-$ IFRS$)$ FR $1,223,764,4391,253,616,915$

$6$ GOLDMAN SACHS INTERNATIONAL GB $1,143,420,0001,267,858,000$

$7$ UBS AG CH $1,116,145,0001,125,327,000$

$8$ BPCE SA FR $1,045,376,4931,041,734,906$

$9$ LA BANQUE POSTALE FR $874,718,543904,588,153$

$10$ CREDIT SUISSE AG CH $831,833,058933,761,924$

Use the file banks EMA above to answer the following questions:

$$ Add a new column titled $$Change in Assets$$ to the spreadsheet. In the newly created column, calculate the annual percentage change in total assets for each bank using the formula:

o Change in Assets $=($Total Assets in $2021$ Total Assets in $2020)*100/($Total Assets in $2020)$

Make sure that each row in the $$Change in Assets$$ column is filled with the calculated value for each bank in the sample. Next, calculate the average percentage change in total assets for the entire sample. Finally, calculate the average percentage change in total assets across the banks$$ locations $($Great Britain, Switzerland and France$).$

$$ Using the sample data provided, calculate the $95\%$ confidence interval for the average change in total assets of British banks in $2021.$ Then, interpret the results. What conditions must be satisfied for the validity of the confidence interval?

$$ Using the data provided, evaluate whether there is a statistically significant difference between the mean average change in total assets of British banks and French banks in $2021.$