You are a manager for Company ABC and decide to compile data and analyze your employees’ level of satisifaction. You create a survey to ask each employee to rate their level of satisfaction working at Company ABC. Table 1 shows data of 15 people employees that responded to your survey. Each of the employees have the same job title: Sales Representative. The data set includes variables regarding an employee ID, gender, ethnicity, region, pay rate, employee satisfaction rating. Each employee was asked to rate their level of satisfaction working at Company ABC. A composite score from 0 (lowest) to 5 (highest) is shown as the data variable employee satisfaction. Use the data from Table 1 below to answer Questions 1 – 7 below. Table 1: Employee Data on 15 Sales Representatives at Company ABC 1. You send the survey to all 20 employees and 15 responds. Identify the population. 2. What level of measurement is the variable: Employee ID? 3. Input the data from Table 1 into Excel. Calculate the descriptive statistics on the Pay Rate column (Column D) of the table. (See video links on the last page of this document if needed) • Paste your Excel descriptive statistics output for the pay rate variable below. • What is the mean pay rate of the sales representatives? • What is the standard deviation of pay rate? 4. From the data from Table 1, we can look at the Ethnicity variable. • Use the data from Table 1 to complete the frequency table of ethnicity (Column C) for the 15 participants. You can use the =countif (C2:C21, “White”) function in Excel. Ethnicity Frequency White African American Hispanic • Using the Ethnicity frequency table (from part A), create a pie chart for Ethnicity of employees. Make sure to include a title and each slice is clearly labeled. Paste your Pie Chart below. (See video links on the last page of this document if needed) • Using the Ethnicity frequency table (from part A), create a bar graph for Ethnicity of employees. Make sure to include a title your graph and label each axis. • Do you think the pie chart, or the bar graph displays the differences in the data more clearly for the Ethnicity variable? Explain your reasoning in 2 or 3 sentences. 5. Calculate the descriptive statistics for Employee Satisfaction (Column F) to answer the following questions. • Paste your Excel descriptive statistics output for the employee satisfaction variable below. • What is the mean employee satisfaction? • What is the minimum employee satisfaction rating? • What is the Employee ID of the employee with the lowest satisfaction rating (refer to Table 1)? 6. Using the Age variable (Column E), create a histogram using the following frequency distribution. Frequency Distribution 30-39 40-49 50-59 60-69 • Create a histogram of the Age data for the Sale Representatives. Paste your graph below. • In 2-3 sentences, describe the shape of the histogram in part A. Would this be considered a symmetric or skewed? If skewed, describe the skewness. 7. Continue to focus on Age variable (Column E). • Calculate the 5-number summary for Age (Column E). Paste the summary below. (See video links on the last page of this document if needed) • Create a Box plot (Box & Whisker) of Age. Paste your graph below.