Working on the “Dataset NHAMCS—National Ambulatory and Medical Care Survey” spreadsheet provided below in order to complete the following exercises. It is a national sample of visits to emergency departments (EDs) in non-institutional general and short-stay hospitals, exclusive of federal, military, and Veterans Administration hospitals, located in the 50 United States and the District of Columbia. Save the dataset on your thumb drive because we will also be using this in the future.

The actual sample comprised over 19,000 ED visits. In this assignment, you are provided with a subset of the survey data (300 ED visits) for the year 2016. Data are obtained on patient characteristics such as age, sex, race, and ethnicity, and visit characteristics such as the patient’s reason for the visit.

For this assignment you are required to complete the following:

Sort and filter data
Create a frequency distribution table using the COUNTIF function
Use of the F4 function
Using the Data Analysis Toolpak to provide descriptive statistics: mean, median, and mode.

Complete the assignment in Excel and submit the Excel file.