There are 4,576 observations in the filtered data that includes the hardware industry, reps with a college degree, and reps who are older than 40 years. Copy these observations to a separate worksheet/dataframe in order to answer the following questions.
What is the average age of these sales representatives? What is the average NPS of these sales representatives? How many of these sales representatives have the “Diplomat” personality type? How many of these sales representatives make between $50,000 and $75,000 ($50,000 < Salary < $75,000) in salary? How many of these sales representatives are female and have been employed by the company for over five years?
Note: Round "Average age" and "Average NPS" to 2 decimal places.