Portfolio Project309

Portfolio Project Josue Oreste MATH309 – Statistics Professor W. Rava February 25, 2024

ID Gender Ethnicity Age Pay rate Employee Satisfactio n 1 Female Caucasian 27 27.8 2.7 2 Male African American 37 55.5 3.5 3 Male Asian 35 65.5 4.4 4 Female Hispanic 22 35.5 5.0 5 Female indigenous American 75 75.5 4.7 6 Male Caucasian 47 55.5 3.2 7 Male African American 55 45.6 3.5 8 Female Asian 33 49.5 3.3 9 Female Hispanic 22 48.5 3.8 10 Male Caucasian 38 49.5 4.4 11 Male African American 57 55.5 2.2 12 Male Asian 63 45.5 4.2 13 Male Hispanic 45 45.5 4.1 14 Female Caucasian 33 61.5 4.5 15 Female Caucasian 31 45.5 4.3 16 Female Caucasian 18 49.5 3.8 17 Female African American 16 45.5 4.1 18 Male African American 40 46.5 4.4 19 Male Hispanic 48 45.5 3.8 20 Male indigenous American 46 65.5 4.1 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? 20 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) Column1 Mean 50.72 Standard Error 2.39645132 Median 49 Mode 45.5 Standard Deviation 10.7172561 Sample Variance 114.859579

40% 33% 27% Types White African American Hispanic 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. White African American Hispanic 0 1 2 3 4 5 6 7 6 5 4 Types Frequency Number Race 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 I believe that the pie chart and bar graph both displays different data. I say this because the pie chart shows a percentage, whereas the bar graph shows numbers and not percentages. 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. Question 5 Mean 3.9 Standard Error 0.1526950 9 Median 4.1 Mode 4.4 Standard Deviation 0.6828731 9 Sample Variance 0.4663157 9 Kurtosis 0.8048419 2 Skewness -0.8781997 Range 2.8 Minimum 2.2 Maximum 5 Sum 78 Count 20 What is the mean employee satisfaction? 3.9 What is the minimum employee satisfaction rating? 2.2 What is the Employee ID of the employee with the lowest satisfaction rating? The Employee ID of the employee with the lowest satisfaction rating is employee 11 who is a male. 6. Using the Age variable (Column E), create a histogram using the following frequency distribution.

Skewness 0.52082419 Range 59 Minimum 16 Maximum 75 Sum 788 Count 20 Low median high 16 30 37.5 47.25 75 Create a Box plot (Box & Whisker) of Age. Paste your graph below.