Please do in Excell so I can understand formulas

Brand valuations are critical to CEOs, financial and marketing executives, security analysts, institutional investors, and others who depend on well-researched, reliable information needed for assessments, and comparisons in decision making. Millward Brown Optimor has developed the BrandZ Top 100 Most Valuable Global Brands for WPP, the world's largest communications services group. Unlike other studies, the BrandZ Top 100 Most Valuable Global Brands fuses consumer measures of

brand equity with financial measures to place a financial value on brands. The file BrandZTechFin contains the brand values for two sectors in the BrandZ Top 100 Most Valuable Global Brands for 2014: the technology sector and the financial institutions sector. (Data extracted from bit.ly/18OL5Mu.)

a. Assuming that the population variances are equal, is there evidence of a difference between the technology sector and the financial institutions sector with respect to mean brand value?(Use a = .05.)

b. Repeat (a), assuming that the population variances are not equal.

c. Compare the results of (a) and (b).

Financial Institutions 79197 54262 42101 42101 39497 34430 27051 25008 22620 21001 19950 19072 18235 17341 14926 14177 12637 12356 11743 11663 11351 11060 10149 9771 9683

Technology 158843 147880 107541 90185 53615 36390 35740 29768 25892 20913 19469 18105 16800 14174 13837 13710 12407 11667