Assignment 1-KPI Part 2
abparsley
EmployeeSatisfactionPart2Student.xlsxInstructions
| Instructions | Hint |
| Raw Data includes a list of employees who took an Employee Satisfaction Survey and how they described their satisfaction level. | |
| Employee Satisfaction Rating contains a conversion from the Satisfaction Description to the Satisfaction Rating. | |
| Employee Data contains a list of all employees, their gender, and their department/function. | |
| In Raw Data, create a new column in C labeled Overall Satisfaction Rating | Data Input |
| In Raw Data, create a new column in D labeled Gender | Data Input |
| In Raw Data, create a new column in E labeled Department | Data Input |
| Using the Employee Satisfaction Rating Table, populate the column for Overall Satisfaction Rating (1-5) | Vlookup |
| Using the Employee Data tab, populate the columns for Gender and Department | Vlookup |
| Insert a Pivot Table & Pivot Chart on a new Sheet | Insert Pivot Chart & Pivot Table |
| Label the new sheet "Results" | Rename |
| Select Gender for Columns | Select |
| Select Department for Rows | Select |
| Select Average of Averall Satisfaction Rating for Values | Select |
| If necessary change the Value Field Setting to Average (it may be set to Sum) | |
| If necessary, change the column heading of the last column to Average rather than Total | |
| On the chart, insert a title of "Employee Satisfaction by Department & Gender - Your LAST NAME" | Insert Chart Title |
| Format the vertical (up & down) axis for a maximum value of 5 | Format axis |
| Format your Raw Data, Pivot Table and Pivot Chart to look Professional | |
| Your Pivot Chart should appear as the one below |
Raw Data
| Name | Overall Satisfaction Description |
| Wilma | Neutral |
| Willis | Very Satisfied |
| Willie | Satisfied |
| Willie | Neutral |
| William | Dissatisfied |
| Willard | Satisfied |
| Wilbur | Dissatisfied |
| Wilbert | Satisfied |
| Wesley | Very Satisfied |
| Wayne | Dissatisfied |
| Warren | Dissatisfied |
| Wanda | Very Satisfied |
| Walter | Neutral |
| Wallace | Neutral |
| Vivian | Neutral |
| Virginia | Neutral |
| Virgil | Very Satisfied |
| Violet | Neutral |
| Viola | Very Satisfied |
| Vincent | Neutral |
| Victor | Neutral |
| Vernon | Satisfied |
| Verna | Neutral |
| Vera | Neutral |
| Velma | Satisfied |
| Tony | Dissatisfied |
| Tom | Satisfied |
| Thomas | Very Satisfied |
| Theresa | Neutral |
| Theodore | Very Satisfied |
| Thelma | Neutral |
| Sylvia | Neutral |
| Steve | Dissatisfied |
| Stephen | Satisfied |
| Stella | Very Satisfied |
| Stanley | Dissatisfied |
| Sophie | Very Dissatisfied |
| Sidney | Dissatisfied |
| Shirley | Very Satisfied |
| Sarah | Satisfied |
| Sara | Satisfied |
| Samuel | Satisfied |
| Sam | Neutral |
| Salvatore | Satisfied |
| Sally | Dissatisfied |
| Ruth | Neutral |
| Russell | Very Satisfied |
| Rudolph | Very Dissatisfied |
| Ruby | Very Satisfied |
| Roy | Neutral |
| Rosie | Neutral |
| Rosemary | Very Dissatisfied |
| Rose | Satisfied |
| Rosa | Dissatisfied |
| Ronald | Satisfied |
| Roland | Satisfied |
| Roger | Neutral |
| Roberta | Satisfied |
| Robert | Neutral |
| Rita | Dissatisfied |
| Richard | Very Satisfied |
| Rebecca | Satisfied |
| Raymond | Very Satisfied |
| Ray | Neutral |
| Ralph | Satisfied |
| Rachel | Very Satisfied |
| Phyllis | Very Dissatisfied |
| Phillip | Neutral |
| Philip | Neutral |
| Peter | Neutral |
| Peggy | Very Satisfied |
| Pearl | Dissatisfied |
| Pauline | Dissatisfied |
| Paul | Dissatisfied |
| Patrick | Neutral |
| Patricia | Very Satisfied |
| Otis | Satisfied |
| Oscar | Very Satisfied |
| Orville | Very Satisfied |
| Opal | Very Dissatisfied |
| Oliver | Satisfied |
| Olga | Very Dissatisfied |
| Norman | Neutral |
| Norma | Satisfied |
| Nora | Satisfied |
| Nicholas | Very Dissatisfied |
| Nellie | Very Satisfied |
| Nathaniel | Dissatisfied |
| Naomi | Very Satisfied |
| Nancy | Very Satisfied |
| Myrtle | Neutral |
| Muriel | Satisfied |
| Morris | Very Satisfied |
| Miriam | Satisfied |
| Minnie | Neutral |
| Milton | Very Dissatisfied |
| Mildred | Dissatisfied |
| Mike | Dissatisfied |
| Michael | Neutral |
| Merle | Very Satisfied |
| Melvin | Dissatisfied |
| Maxine | Satisfied |
| Max | Satisfied |
| Maurice | Very Satisfied |
| Mattie | Neutral |
| Matthew | Very Satisfied |
| Mary | Neutral |
| Marvin | Neutral |
| Martin | Very Satisfied |
| Martha | Satisfied |
| Marshall | Satisfied |
| Marjorie | Satisfied |
| Marion | Very Dissatisfied |
| Marion | Satisfied |
| Marilyn | Very Dissatisfied |
| Marie | Dissatisfied |
| Marian | Dissatisfied |
| Maria | Very Satisfied |
| Marguerite | Neutral |
| Margie | Neutral |
| Margaret | Neutral |
| Marcella | Very Satisfied |
| Manuel | Neutral |
| Mamie | Satisfied |
| Mae | Very Satisfied |
| Madeline | Very Satisfied |
| Mable | Neutral |
| Mabel | Very Satisfied |
| Lyle | Very Satisfied |
| Luther | Satisfied |
| Lula | Dissatisfied |
| Lucy | Very Satisfied |
| Lucille | Satisfied |
| Lowell | Satisfied |
| Louise | Very Satisfied |
| Louis | Very Satisfied |
| Lorraine | Very Satisfied |
| Loretta | Neutral |
| Lola | Dissatisfied |
| Lois | Very Satisfied |
| Lloyd | Dissatisfied |
| Lillie | Neutral |
| Lillian | Neutral |
| Lewis | Very Satisfied |
| Lester | Neutral |
| Leslie | Very Dissatisfied |
| Leroy | Very Dissatisfied |
| Leonard | Neutral |
| Leona | Satisfied |
| Leon | Very Satisfied |
| Leo | Very Satisfied |
| Lena | Very Satisfied |
| Leland | Neutral |
| Lee | Very Satisfied |
| Lawrence | Neutral |
| Laverne | Dissatisfied |
| Laura | Neutral |
| Larry | Neutral |
| Kenneth | Neutral |
| Keith | Dissatisfied |
| Kathryn | Neutral |
| Kathleen | Neutral |
| Katherine | Very Satisfied |
| Junior | Very Satisfied |
| June | Very Satisfied |
| Julius | Satisfied |
| Julia | Very Dissatisfied |
| Juanita | Neutral |
| Joyce | Very Satisfied |
| Josephine | Dissatisfied |
| Joseph | Satisfied |
| Jose | Neutral |
| Johnny | Dissatisfied |
| Johnnie | Very Satisfied |
| John | Very Satisfied |
| Joe | Neutral |
| Joan | Neutral |
| Jimmy | Very Satisfied |
| Jimmie | Very Dissatisfied |
| Jim | Satisfied |
| Jessie | Very Satisfied |
| Jessie | Very Satisfied |
| Jesse | Neutral |
| Jerry | Neutral |
| Jerome | Neutral |
| Jennie | Satisfied |
| Jeanne | Neutral |
| Jeanette | Very Satisfied |
| Jean | Satisfied |
| Jay | Neutral |
| Janet | Neutral |
| Jane | Very Satisfied |
| James | Satisfied |
| Jacqueline | Neutral |
| Jacob | Satisfied |
| Jack | Very Satisfied |
| Ivan | Satisfied |
| Irving | Satisfied |
| Irvin | Very Satisfied |
| Irene | Neutral |
| Ira | Satisfied |
| Inez | Satisfied |
| Ida | Very Dissatisfied |
| Hugh | Neutral |
| Hubert | Satisfied |
| Howard | Very Satisfied |
| Horace | Neutral |
| Homer | Neutral |
| Hilda | Very Dissatisfied |
| Herman | Very Satisfied |
| Herbert | Neutral |
| Henry | Satisfied |
| Helen | Very Satisfied |
| Hazel | Neutral |
| Hattie | Satisfied |
| Harvey | Very Satisfied |
| Harry | Neutral |
| Harriet | Dissatisfied |
| Harold | Neutral |
| Guy | Satisfied |
| Grace | Neutral |
| Gordon | Very Satisfied |
| Gloria | Neutral |
| Glenn | Very Satisfied |
| Glen | Satisfied |
| Gladys | Very Dissatisfied |
| Gilbert | Neutral |
| Gertrude | Very Satisfied |
| Geraldine | Very Satisfied |
| Gerald | Dissatisfied |
| Georgia | Neutral |
| George | Satisfied |
| Genevieve | Neutral |
| Geneva | Satisfied |
| Gene | Neutral |
| Frederick | Neutral |
| Fred | Very Satisfied |
| Franklin | Satisfied |
| Frank | Neutral |
| Francis | Very Satisfied |
| Frances | Very Dissatisfied |
| Floyd | Satisfied |
| Florence | Satisfied |
| Flora | Very Satisfied |
| Fannie | Neutral |
| Everett | Neutral |
| Evelyn | Satisfied |
| Eva | Satisfied |
| Eunice | Dissatisfied |
| Eugene | Dissatisfied |
| Ethel | Neutral |
| Esther | Very Dissatisfied |
| Ervin | Satisfied |
| Ernest | Very Dissatisfied |
| Erma | Dissatisfied |
| Emma | Dissatisfied |
| Emily | Very Dissatisfied |
| Emil | Satisfied |
| Elsie | Very Satisfied |
| Elmer | Very Satisfied |
| Ellen | Neutral |
| Ella | Neutral |
| Elizabeth | Very Satisfied |
| Eleanor | Dissatisfied |
| Elaine | Neutral |
| Eileen | Satisfied |
| Edwin | Very Satisfied |
| Edward | Very Satisfied |
| Edna | Very Dissatisfied |
| Edmund | Neutral |
| Edith | Very Satisfied |
| Edgar | Neutral |
| Eddie | Very Satisfied |
| Earnest | Very Satisfied |
| Earl | Satisfied |
| Duane | Dissatisfied |
| Douglas | Neutral |
| Dorothy | Satisfied |
| Doris | Very Dissatisfied |
| Dora | Satisfied |
| Donna | Satisfied |
| Donald | Neutral |
| Don | Neutral |
| Dolores | Very Satisfied |
| Dewey | Neutral |
| Dennis | Neutral |
| Delores | Very Satisfied |
| Delbert | Neutral |
| Dean | Neutral |
| David | Neutral |
| Daniel | Satisfied |
| Dan | Neutral |
| Dale | Very Satisfied |
| Daisy | Satisfied |
| Curtis | Very Dissatisfied |
| Cora | Neutral |
| Constance | Very Satisfied |
| Clyde | Very Satisfied |
| Clinton | Neutral |
| Clifton | Neutral |
| Clifford | Neutral |
| Clayton | Dissatisfied |
| Claude | Neutral |
| Clarence | Neutral |
| Clara | Satisfied |
| Claire | Satisfied |
| Christine | Dissatisfied |
| Chester | Neutral |
| Charlotte | Satisfied |
| Charlie | Very Satisfied |
| Charles | Neutral |
| Cecil | Neutral |
| Catherine | Satisfied |
| Carrie | Satisfied |
| Carolyn | Neutral |
| Caroline | Dissatisfied |
| Carol | Satisfied |
| Carl | Neutral |
| Calvin | Neutral |
| Bruce | Dissatisfied |
| Bonnie | Very Satisfied |
| Bobby | Very Dissatisfied |
| Bob | Satisfied |
| Blanche | Satisfied |
| Billy | Dissatisfied |
| Billie | Very Satisfied |
| Billie | Neutral |
| Bill | Very Satisfied |
| Beverly | Very Satisfied |
| Beulah | Dissatisfied |
| Betty | Very Satisfied |
| Bette | Satisfied |
| Bessie | Satisfied |
| Bertha | Neutral |
| Bernice | Neutral |
| Bernard | Satisfied |
| Bennie | Dissatisfied |
| Benjamin | Very Dissatisfied |
| Ben | Dissatisfied |
| Beatrice | Very Dissatisfied |
| Barbara | Satisfied |
| Audrey | Neutral |
| Arthur | Neutral |
| Arnold | Dissatisfied |
| Arlene | Very Satisfied |
| Archie | Neutral |
| Anthony | Dissatisfied |
| Annie | Dissatisfied |
| Anne | Dissatisfied |
| Anna | Very Satisfied |
| Ann | Neutral |
| Anita | Dissatisfied |
| Angelo | Neutral |
| Andrew | Neutral |
| Alvin | Neutral |
| Alton | Neutral |
| Alma | Very Satisfied |
| Allen | Very Satisfied |
| Alice | Very Dissatisfied |
| Alfred | Satisfied |
| Alexander | Very Satisfied |
| Alex | Very Satisfied |
| Alberta | Dissatisfied |
| Albert | Very Dissatisfied |
| Agnes | Satisfied |
| Ada | Dissatisfied |
Employee Satisfaction Rating
| Overall Satisfaction Desription | Overall Satisfaction Rating |
| Very Dissatisfied | 1 |
| Dissatisfied | 2 |
| Neutral | 3 |
| Satisfied | 4 |
| Very Satisfied | 5 |
Employee Data
| Name | Gender | Department |
| Ada | Female | Accounting |
| Agnes | Female | Supply Chain |
| Albert | Male | Accounting |
| Alberta | Female | Accounting |
| Alex | Male | Engineering |
| Alexander | Male | Engineering |
| Alfred | Male | Engineering |
| Alice | Female | Accounting |
| Allen | Male | Engineering |
| Alma | Female | Engineering |
| Alton | Male | Marketing |
| Alvin | Male | Marketing |
| Andrew | Male | HR |
| Angelo | Male | Marketing |
| Anita | Female | Accounting |
| Ann | Female | Marketing |
| Anna | Female | Supply Chain |
| Anne | Female | Accounting |
| Annie | Female | Accounting |
| Anthony | Male | Accounting |
| Archie | Male | HR |
| Arlene | Female | Supply Chain |
| Arnold | Male | Accounting |
| Arthur | Male | Marketing |
| Audrey | Female | Accounting |
| Barbara | Female | Supply Chain |
| Beatrice | Female | Accounting |
| Ben | Male | Accounting |
| Benjamin | Male | Accounting |
| Bennie | Male | Accounting |
| Bernard | Male | Supply Chain |
| Bernice | Female | Marketing |
| Bertha | Female | HR |
| Bessie | Female | Supply Chain |
| Bette | Female | HR |
| Betty | Female | Supply Chain |
| Beulah | Female | Accounting |
| Beverly | Female | Supply Chain |
| Bill | Male | Engineering |
| Billie | Male | Engineering |
| Billie | Male | HR |
| Billy | Male | Accounting |
| Blanche | Female | Supply Chain |
| Bob | Male | Engineering |
| Bobby | Male | Accounting |
| Bonnie | Female | Supply Chain |
| Bruce | Male | Accounting |
| Calvin | Male | Marketing |
| Carl | Male | HR |
| Carol | Female | Supply Chain |
| Caroline | Female | Accounting |
| Carolyn | Female | HR |
| Carrie | Female | HR |
| Catherine | Female | Engineering |
| Cecil | Male | HR |
| Charles | Male | Marketing |
| Charlie | Male | Supply Chain |
| Charlotte | Female | Marketing |
| Chester | Male | Marketing |
| Christine | Female | Accounting |
| Claire | Female | Supply Chain |
| Clara | Female | Supply Chain |
| Clarence | Male | Marketing |
| Claude | Male | Supply Chain |
| Clayton | Male | Accounting |
| Clifford | Male | HR |
| Clifton | Male | HR |
| Clinton | Male | HR |
| Clyde | Male | Engineering |
| Constance | Female | Engineering |
| Cora | Female | Marketing |
| Curtis | Male | Accounting |
| Daisy | Female | HR |
| Dale | Male | Engineering |
| Dan | Male | Marketing |
| Daniel | Male | Engineering |
| David | Male | HR |
| Dean | Male | Marketing |
| Delbert | Male | Marketing |
| Delores | Female | Engineering |
| Dennis | Male | HR |
| Dewey | Male | HR |
| Dolores | Female | Engineering |
| Don | Male | Supply Chain |
| Donald | Male | Marketing |
| Donna | Female | Supply Chain |
| Dora | Female | HR |
| Doris | Female | Accounting |
| Dorothy | Female | Engineering |
| Douglas | Male | HR |
| Duane | Male | Marketing |
| Earl | Male | HR |
| Earnest | Male | Supply Chain |
| Eddie | Male | Engineering |
| Edgar | Male | HR |
| Edith | Female | Supply Chain |
| Edmund | Male | Marketing |
| Edna | Female | Accounting |
| Edward | Male | Supply Chain |
| Edwin | Male | Engineering |
| Eileen | Female | Supply Chain |
| Elaine | Female | HR |
| Eleanor | Female | Accounting |
| Elizabeth | Female | Supply Chain |
| Ella | Female | Marketing |
| Ellen | Female | Marketing |
| Elmer | Male | Supply Chain |
| Elsie | Female | Engineering |
| Emil | Male | Supply Chain |
| Emily | Female | Accounting |
| Emma | Female | HR |
| Erma | Female | Marketing |
| Ernest | Male | Accounting |
| Ervin | Male | Marketing |
| Esther | Female | Accounting |
| Ethel | Female | Marketing |
| Eugene | Male | Accounting |
| Eunice | Female | Accounting |
| Eva | Female | Supply Chain |
| Evelyn | Female | Engineering |
| Everett | Male | HR |
| Fannie | Female | Marketing |
| Flora | Female | Engineering |
| Florence | Female | Engineering |
| Floyd | Male | Marketing |
| Frances | Female | Accounting |
| Francis | Male | Engineering |
| Frank | Male | HR |
| Franklin | Male | Marketing |
| Fred | Male | Engineering |
| Frederick | Male | Marketing |
| Gene | Male | HR |
| Geneva | Female | Engineering |
| Genevieve | Female | HR |
| George | Male | HR |
| Georgia | Female | Marketing |
| Gerald | Male | Accounting |
| Geraldine | Female | Engineering |
| Gertrude | Female | Engineering |
| Gilbert | Male | Marketing |
| Gladys | Female | Accounting |
| Glen | Male | Supply Chain |
| Glenn | Male | Engineering |
| Gloria | Female | Accounting |
| Gordon | Male | Engineering |
| Grace | Female | HR |
| Guy | Male | HR |
| Harold | Male | Marketing |
| Harriet | Female | Accounting |
| Harry | Male | Marketing |
| Harvey | Male | Supply Chain |
| Hattie | Female | Marketing |
| Hazel | Female | Marketing |
| Helen | Female | Supply Chain |
| Henry | Male | Supply Chain |
| Herbert | Male | Marketing |
| Herman | Male | Engineering |
| Hilda | Female | Accounting |
| Homer | Male | Marketing |
| Horace | Male | HR |
| Howard | Male | Engineering |
| Hubert | Male | Supply Chain |
| Hugh | Male | Marketing |
| Ida | Female | Accounting |
| Inez | Female | Supply Chain |
| Ira | Male | Supply Chain |
| Irene | Female | Marketing |
| Irvin | Male | Engineering |
| Irving | Male | Supply Chain |
| Ivan | Male | Supply Chain |
| Jack | Male | Supply Chain |
| Jacob | Male | HR |
| Jacqueline | Female | Marketing |
| James | Male | Accounting |
| Jane | Female | Engineering |
| Janet | Female | HR |
| Jay | Male | Marketing |
| Jean | Female | Supply Chain |
| Jeanette | Female | Engineering |
| Jeanne | Female | HR |
| Jennie | Female | Supply Chain |
| Jerome | Male | HR |
| Jerry | Male | HR |
| Jesse | Male | Marketing |
| Jessie | Male | Engineering |
| Jessie | Male | Supply Chain |
| Jim | Male | Supply Chain |
| Jimmie | Male | Accounting |
| Jimmy | Male | Engineering |
| Joan | Female | Marketing |
| Joe | Male | HR |
| John | Male | Supply Chain |
| Johnnie | Male | Engineering |
| Johnny | Male | Accounting |
| Jose | Male | HR |
| Joseph | Male | Engineering |
| Josephine | Female | Accounting |
| Joyce | Female | Engineering |
| Juanita | Female | Marketing |
| Julia | Female | Accounting |
| Julius | Male | HR |
| June | Female | Engineering |
| Junior | Male | Engineering |
| Katherine | Female | Engineering |
| Kathleen | Female | HR |
| Kathryn | Female | Marketing |
| Keith | Male | Accounting |
| Kenneth | Male | Accounting |
| Larry | Male | Marketing |
| Laura | Female | Marketing |
| Laverne | Female | Accounting |
| Lawrence | Male | Marketing |
| Lee | Male | Engineering |
| Leland | Male | Marketing |
| Lena | Female | Engineering |
| Leo | Male | Engineering |
| Leon | Male | Supply Chain |
| Leona | Female | Marketing |
| Leonard | Male | Marketing |
| Leroy | Male | Accounting |
| Leslie | Male | Accounting |
| Lester | Male | Marketing |
| Lewis | Male | Engineering |
| Lillian | Female | HR |
| Lillie | Female | Marketing |
| Lloyd | Male | Accounting |
| Lois | Female | Supply Chain |
| Lola | Female | Accounting |
| Loretta | Female | HR |
| Lorraine | Female | Engineering |
| Louis | Male | Supply Chain |
| Louise | Female | Engineering |
| Lowell | Male | Supply Chain |
| Lucille | Female | Engineering |
| Lucy | Female | Supply Chain |
| Lula | Female | Accounting |
| Luther | Male | Marketing |
| Lyle | Male | Engineering |
| Mabel | Female | Supply Chain |
| Mable | Female | HR |
| Madeline | Female | Engineering |
| Mae | Female | Engineering |
| Mamie | Female | Supply Chain |
| Manuel | Male | Marketing |
| Marcella | Female | Engineering |
| Margaret | Female | Accounting |
| Margie | Female | HR |
| Marguerite | Female | HR |
| Maria | Female | Engineering |
| Marian | Female | Accounting |
| Marie | Female | Accounting |
| Marilyn | Female | Accounting |
| Marion | Male | Accounting |
| Marion | Male | Marketing |
| Marjorie | Female | HR |
| Marshall | Male | HR |
| Martha | Female | Engineering |
| Martin | Male | Engineering |
| Marvin | Male | Marketing |
| Mary | Female | Accounting |
| Matthew | Male | Engineering |
| Mattie | Female | HR |
| Maurice | Male | Engineering |
| Max | Male | Supply Chain |
| Maxine | Female | Supply Chain |
| Melvin | Male | Accounting |
| Merle | Male | Supply Chain |
| Michael | Male | Marketing |
| Mike | Male | Accounting |
| Mildred | Female | Accounting |
| Milton | Male | Accounting |
| Minnie | Female | Marketing |
| Miriam | Female | Supply Chain |
| Morris | Male | Engineering |
| Muriel | Female | Marketing |
| Myrtle | Female | Marketing |
| Nancy | Female | Engineering |
| Naomi | Female | Supply Chain |
| Nathaniel | Male | Accounting |
| Nellie | Female | Engineering |
| Nicholas | Male | Accounting |
| Nora | Female | Supply Chain |
| Norma | Female | Marketing |
| Norman | Male | Marketing |
| Olga | Female | Accounting |
| Oliver | Male | HR |
| Opal | Female | Accounting |
| Orville | Male | Supply Chain |
| Oscar | Male | Engineering |
| Otis | Male | HR |
| Patricia | Female | Engineering |
| Patrick | Male | Marketing |
| Paul | Male | Accounting |
| Pauline | Female | HR |
| Pearl | Female | Accounting |
| Peggy | Female | Supply Chain |
| Peter | Male | HR |
| Philip | Male | HR |
| Phillip | Male | HR |
| Phyllis | Female | Accounting |
| Rachel | Female | Engineering |
| Ralph | Male | Marketing |
| Ray | Male | Marketing |
| Raymond | Male | Supply Chain |
| Rebecca | Female | HR |
| Richard | Male | Engineering |
| Rita | Female | HR |
| Robert | Male | Accounting |
| Roberta | Female | Supply Chain |
| Roger | Male | Accounting |
| Roland | Male | Supply Chain |
| Ronald | Male | Marketing |
| Rosa | Female | Accounting |
| Rose | Female | Engineering |
| Rosemary | Female | Accounting |
| Rosie | Female | Marketing |
| Roy | Male | HR |
| Ruby | Female | Engineering |
| Rudolph | Male | Accounting |
| Russell | Male | Engineering |
| Ruth | Female | Marketing |
| Sally | Female | Accounting |
| Salvatore | Male | HR |
| Sam | Male | HR |
| Samuel | Male | Engineering |
| Sara | Female | Supply Chain |
| Sarah | Female | HR |
| Shirley | Female | Engineering |
| Sidney | Male | Accounting |
| Sophie | Female | Accounting |
| Stanley | Male | HR |
| Stella | Female | Supply Chain |
| Stephen | Male | Engineering |
| Steve | Male | Accounting |
| Sylvia | Female | Marketing |
| Thelma | Female | HR |
| Theodore | Male | Supply Chain |
| Theresa | Female | Marketing |
| Thomas | Male | Marketing |
| Tom | Male | Supply Chain |
| Tony | Male | Accounting |
| Velma | Female | Supply Chain |
| Vera | Female | Accounting |
| Verna | Female | HR |
| Vernon | Male | Marketing |
| Victor | Male | Marketing |
| Vincent | Male | HR |
| Viola | Female | Engineering |
| Violet | Female | Marketing |
| Virgil | Male | Engineering |
| Virginia | Female | HR |
| Vivian | Female | Marketing |
| Wallace | Male | HR |
| Walter | Male | Marketing |
| Wanda | Female | Engineering |
| Warren | Male | Accounting |
| Wayne | Male | Accounting |
| Wesley | Male | Engineering |
| Wilbert | Male | Supply Chain |
| Wilbur | Male | Accounting |
| Willard | Male | Supply Chain |
| William | Male | Accounting |
| Willie | Male | Engineering |
| Willis | Male | Engineering |
| Wilma | Female | Marketing |
