Creating a meaningful statistical data analysis for a dataset

Case Study: You work for a health insurance company that provides medical coverage for their members. You are the Quality Consultant in this healthcare organization. You received a data (data attached) from your manager to analyze and create a report for your senior leadership explaining the data in a way that makes will make sense to them. The data is a list of number of members seen at doctor' office throughout the year. Remember, report must be in a layman's language free of technicalities that it makes sense.

Instructions:

Please evaluate, display, and interpret the attached dataset (tab named "Data").

Your results and discussions should be created and entered on additional worksheets within this Excel file.

Please use descriptive and inferential statistics as well as generally accepted continuous quality improvement (CQI) tools, i.e., charts, tables, and graphs, for evaluation purposes.

Please display and interpret the data using easy to understand format(s)

Please provide a report that the data presents to executive leadership. Report must be very professional and free of grammatical errors.

YOUR GOAL: Is to convert this raw data into useful information for decision making.

Attachment:- Data.rar