A control chart is a specific type of:

Samantha created a PivotTable of employee hours worked, grouped by department. She now wants to quickly filter the PivotTable to see results for just one department without manually expanding or collapsing rows. Which tool should she use?

Gerald created the PivotTable below that summarizes total the Total ED Visits in the past 12 months by smoking status and residence type. Instead of the integer values shown here, Gerald would like the PivotTable to show what percent of the ED visits were for rural patients vs. urban patients for each smoking status. How could he accomplish this?

The data below shows monthly patient volumes at five urgent care locations. Which formula was used to calculate the value in cell J8 (shown in green here)?

The data below shows the team payroll (in millions of $) and the total wins for every Major League Baseball team in the 2015 season. Which formula could be used to calculate the number of teams in Major League Baseball?

The screenshot below shows a subset of a data set of 263 patients at a local hospital. Variables include gender, age, whether the patient has heart disease or hypertension, whether they have suffered a stroke, their type of work and residence, average glucose level, BMI, smoking status, and the number of times they have visited the hospital’s Emergency Department (ED) in the past 12 months. What formula would return the median BMI of patients who have had a stroke?

Based on the data shown below, what value would be returned by the following formula? =IF(A2=January,1,0)

Terry Shivo illustrated which concept?

An organization will outsource its “management demand for purchase” activity if it signed a Source-to-Contract (S2c) outsourcing contract. 

What type of team only has supply/purchasing departments?