business statics

i have a project for business i have the date in the attachment i need to follow the 10 steps to creat this project . 1. Compute the mean, median, mode for the stock price in the past year. Based on these three measures, indicate whether the stock price distribution is left-skewed, right-skewed, or symmetric and clearly explain your answer. 2. Compute the range, interquartile range, variance, and standard deviation for the stock price data in Question 1. 3. Develop a frequency distribution and frequency histogram of stock price. Group the prices into classes starting near the 52-week low and ending near the 52-week high. Label the graph appropriately using green as the primary graph color. Indicate whether the graph supports your conclusion regarding skewness in Question 1. 4. Add the S&P 500 in Security/Study and calculate the coefficient of variation with respect to your company and the S&P 500. What do the results indicate? 5. Create a line chart that displays your company’s stock price and the S&P 500 with respect to time. Graph in two different colors and label appropriately. What is the relationship? 6. Go into company earnings and determine the average estimated sales for 2015-2017. How does this compare to previous years? 7. Graph the 2014 Actual and 2015-2017 Estimated sales in a vertical bar chart. Format the 2014 actual as a different color than the estimated sales. 8. Go into Relative Valuation and report the market capitalization for your company as well as the peer group median and average. Create a graph that displays these three variables. What does this graph imply? 9. Within ESG Ratios, determine the Actual Net Income per Employee for the past five years (use less if there is limited data). Graph these using a bar chart. Interpret the graph. 10. Suppose that your selected company has been accused of discrimination against females on the basis of executive promotion. Based on the data in the ESG Governance tab, determine the percentage of women executives and women on board for the most recent year reported. Create a Pie chart to depict these results. Does it appear that there might be a gender equity problem in your selected company at the executive level? D