[removed]       World’s Biggest Public CompaniesStart with the Exc

[removed]       World’s Biggest Public CompaniesStart with the Excel workbook (spreadsheet) World’s Biggest Public Companies– start.xlsx.Thisdatashowsinformationproducedby Forbesin termsof theWorld’sLargestPublicCompanies.In columnB, thecompany’snameis displayed;in columnC, thecountry;incolumnD, thecompany’s2013sales;in columnE, thecompany’s2013profits;in columnF,thecompany’s2013assets;in columnG, thecompany’s2013marketvalue.In therangeI1:M5,youwillseethefirstmatrixthatyouwillneedto summarize,wherethegoalis to determinethemedianvalueof sales,profits,assetsandmarketvaluerespectiveto thecorrespondingcountry.However,to date,Exceldoesnotfeaturea MEDIANIFSfunction.Thus,youwillhaveto usean arrayformulasimilarto ourlearningactivity.Executingthisstatementcorrectlywillproducea medianof thedesiredvaluesin thedatasetforthegivencountryof interest.In therangeI7:M11,youwillseethesecondmatrixthatyouwillneedto summarize,wherethegoalis to determinetheminvalueof sales,profits,assetsandmarketvaluerespectiveto thecorrespondingcountry.However,to date,Exceldoesnotfeaturea MINIFSfunction.Thus,youwillhaveto usean arrayformulasimilarto ourlearningactivity.Executingthisstatementcorrectlywillproducea minof thedesiredvaluesin thedatasetforthegivencountryof interest.In therangeI13:M17,youwillseethethirdmatrixthatyouwillneedto summarize,wherethegoalis to determinethemaxvalueof sales,profits,assetsandmarketvaluerespectiveto thecorrespondingcountry.However,to date,Exceldoesnotfeaturea MAXIFSfunction.Thus,youwillhaveto usean arrayformulasimilarto ourlearningactivity.Executingthisstatementcorrectlywillproducea maxof thedesiredvaluesin thedatasetforthegivencountryof interest.In therangeI19:M23,youwillseethethirdmatrixthatyouwillneedto summarize,wherethegoalis to determinethestandarddeviationvalueof sales,profits,assetsandmarketvaluerespectiveto thecorrespondingcountry.However,to date,ExceldoesnotfeatureaSTDEV.S.IFSfunction.Thus,youwillhaveto usean arrayformulasimilarto ourlearningactivity.Executingthisstatementcorrectlywillproducea maxof thedesiredvaluesin thedatasetforthegivencountryof interest.Pleasenotethatthe“dotS” portionof theSTDEVfunctionindicatesthatwearetakingthestandarddeviationof a sample.Thisis a samplesincewedo nothaveinformationfromallcompanies(i.e.population).Finally,ensurethatallvaluesin yoursummarytablesareformattedwithan Accountingstylewithtwodecimalsshowing(i.e.$52.21)HINT:Beverycarefulaboutwhatcellreferencesareabsoluteandwhicharemixed(therowor columnabsoluteandtheotherrelative).Also, remember that you must use aCtrl+Shift+Enter keystroke in order to implement an array formula in Excel.