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 A B с D E F Employee Employee ID Gender Ethnicity PayRate Age 1 Satisfaction 23 45 2 1402065355 Female White 38.5 35 4.1 1409070147 1410071026 Female Male African American 33.5 38 3 Hispanic 40 42 4 1303054580 Male White 50.5 39 3.7 67 1307060077 Male White 54 40 4.6 1108426251 Female African American 44 42 3.4 8 9 10 1501072311 1403065874 1405067298 Female Male White 54.5 42 3.7 Male African American 42 45 3.5 Hispanic 55 50 4.1 11 1001944783 Female Hispanic 48.5 52 4 12 1107027351 Male Hispanic 53 54 4.5 13 1000974650 Male White 53 55 4.1 14 1110029990 Male White 55 57 5 15 1102024149 Female African American 52 58 4.8 16 1103024679 Female Hispanic 55 60 3.7 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? . 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 White African American Hispanic Frequency ⚫ 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. 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)? Using the Age variable (Column E), create a histogram using the following frequency distribution. Frequency Distribution 30-39 40-49 50-59 60-69

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 A B с D E F Employee Employee ID Gender Ethnicity PayRate Age 1 Satisfaction 23 45 2 1402065355 Female White 38.5 35 4.1 1409070147 1410071026 Female Male African American 33.5 38 3 Hispanic 40 42 4 1303054580 Male White 50.5 39 3.7 67 1307060077 Male White 54 40 4.6 1108426251 Female African American 44 42 3.4 8 9 10 1501072311 1403065874 1405067298 Female Male White 54.5 42 3.7 Male African American 42 45 3.5 Hispanic 55 50 4.1 11 1001944783 Female Hispanic 48.5 52 4 12 1107027351 Male Hispanic 53 54 4.5 13 1000974650 Male White 53 55 4.1 14 1110029990 Male White 55 57 5 15 1102024149 Female African American 52 58 4.8 16 1103024679 Female Hispanic 55 60 3.7 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? . 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 White African American Hispanic Frequency ⚫ 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. 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)? Using the Age variable (Column E), create a histogram using the following frequency distribution. Frequency Distribution 30-39 40-49 50-59 60-69

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018

18th Edition

ISBN:9780079039897

Author:Carter

Publisher:Carter

Chapter10: Statistics

Section10.2: Representing Data

Problem 22PFA

See similar textbooks