The Excel file named IN1.xls shows the amount billed to a health insurance company in 2019 by 27 individuals. On the first worksheet, for each individual, you have their age, gender, whether or they are a smoker, and the amount billed to the insurance company. The variable definitions are given on the second worksheet. a. Using Excel’s Histogram function, develop frequency and relative frequency distribution tables for the variable "Charges". Choose an appropriate number of buckets.
b. Using the relative frequency table, draw a bar chart to represent this distribution. Be sure to label the axes appropriately.
c. Using a basic understanding of the kinds of illnesses for which health insurance charges are submitted, write no more than five sentences explaining why the bar chart for "Charges" is not symmetric? {You do not have to be a health industry expert to answer this question}
age= age of the insured
sex= gender of the policy holder
smoker= whether or not policy holder smokes
charges= medical costs billed to health insurance in 2019