Use the data from Table 1 below to answer Questions 1 - 8 of the exam. Table 1 shows data of 20 people surveyed about their current credit card balances. The data set includes variables regarding an individual's gender, ethnicity, age, current credit care balance and the number of credit cards they currently have open.

\f2. Use the descriptive statistics run for Age in Part A of Question 1 (Column D) to answer the following questions. A. 1What are the minimum and maximum ages of the participants? B. 1What is the range and standard deviation of age variable? C. Given the range and standard deviation, would you consider there to be large or small variability in the ages of the participants? Why? 3. From the data from Table 1, we can look at the gender variable. A. Use the data from Table 1 to complete the frequency table of gender (Column 13} for the 20 participants. You can use the =countif ((321321, "Maleil function in Excel. MATT-I309 lVIidterm Exam 3 Frequency 4. Using the gender frequency table, create a pie chart for Gender of the Survey Participants. Make sure to include a title and each slice is clearly labeled. Paste your Pie Chart below. (See video link on page 7 if needed) 5. Use the data from Table 1 to complete the frequency table of Ethnicity (Column C) for the 20 participants. You can use the =co1mtif (132321, "Caucasian"} function in Excel. A. Complete the frequency table of Ethnicity below. Ethnicity Frequency Caucasian B. Using the ethnicity table, create a bar chart of Ethnicity of the Survey Participants. Make sure to include a title and that each axis is clearly labeled. Paste your Bar Chart below. 6. Complete the Frequency Dishibution table below for the variable Credit Card Balance (Colunm E). Use a bin width of 300. (See video link on page '7 if needed) Frequency Distribution Frequency 0300 301600 601900 9011200 12011500 l_J A) Paste the Frequency Distribution Chart below for Credit Card Balance. B) Create a histogram of the Credit Card balance data. Paste your graph below. MATT-I309 lidterm Exam 4- C) Describe the shape of the histogram. Would this be considered a unimodal, sgmunetric distribution? 7. Connuing to focus on Credit Card Balance (Column E). A. Calculate the 5nu1nber summary for Credit Card Balance (Column E). Paste the summary below. (See Video link on page 7 if needed) B. Create a Box plot (Box 15: 1|Whisker) of Credit Card Balance. Paste your graph below. 8. Using the Percentilejnc Q ftmclion in Excel to calculate the 90th percentile of the Credit Card Balance data (Column E). Paste your answer below. How many people in the data set (Table 1) have a credit card balance above the 90111 percentile. (See Video link on page .7 if needed)