You used the market cap data for Statistical Analysis Project 1. The data includes the market cap and the stock price (USD) of 100 companies. The market cap represents the total dollar market value of a company's outstanding shares. a) Use Excel to create a histogram of the stock prices of the 100 companies. Describe the distribution. Are there any suspicious outliers? If so, identify their stock price and the company name [3 marks] b) Compare the mean and median of the stock prices. What does this suggest about the distribution? [2 marks]| c) Find the five-number summary for the stock prices of US-based companies. Use the QUARTILE.EXC in Excel to determine the quartiles. [2 marks] d) Find the five-number summary for the stock price of non-US-based companies. Use the QUARTILE.EXC in Excel to determine the quartiles. [2 marks] e) Manually create a comparative boxplot to compare the stock prices of US-based and non- US-based companies. Identify any outliers, and include all steps of your work. [4 marks] f) Comment on the differences and similarities in stock prices between US-based and non-US- based companies. [2 marks] Uutstanding shares are all those 1ssued and sold by a company. Using the data, you can calculate the outstanding shares of the 100 companies by dividing their market cap by their stock price. Ensure that the outstanding shares for Apple and Unilever are 15,334,099,725 and 2,533,380,202, respectively. Page 1 of 3 g) Test for a linear, exponential, or power-law relationship between stock price and the outstanding shares for the 100 companies. Determine which relationship fits best, and provide supporting evidence. [10 marks] h) Provide the equation for the best-fitting relationship. If the best fit is exponential or power law function, be sure to reverse the logarithm as needed. [3 marks]