this is a business statistics hw need to be answered in excel

PRESENTING STATISTICAL DATAThe purpose of these case studies is to demonstrate your ability to develop relatively routinepresentation graphics for analytical studies. You may refer to Chapter 2-R as needed, or to anyother source. Prepare these as if you were an entry level analytics analyst for an organization, andare going to present these to a staff meeting of middle managers.Case Study 2.1The US government National Center for Education Statistics publishes a ?Digest of EducationStatistics? which shows the number of adults 18 years of age and older having attained each level ofacademic degree. Find the appropriate website, and produce a pie chart showing the number ofadults age 18 and older in the United States having the following as their highest level of educationattained.Ph.D.Master?s DegreeBachelor?s DegreeAssociate?s DegreeSome College, No DegreeHigh School DegreeNo DegreeYou are free to build the chart in a way convenient for you as long as the following standards aremet. Upload the spreadsheet and chart to Canvas by the time frame required.Case Study 2.2Choose a US-based industry having many competitors. For example, the fast food industry has many competitors, the auto industry has many competitors, as with the tire industry. Build a histogram showing last year?s sales of each of the top five sales leaders in that industry to include the amount of sales for each company. You are free to build the chart in a way convenient for you as long as the following standards are met. Upload the spreadsheet and chart to Canvas by the time frame required.