Blog

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. David needs to create a summary that shows the number of patients seen by Work Type and Smoking Status. He creates a PivotTable, places Work Type in the Columns area, Smoking Status in the Rows area, and Heart Disease? in the Values area. Will this result the summary he needs?

Based on the data shown below, what value would be returned by the following formula? =B5/B4

Natalie works as a data analyst in a cardiology clinic, and she would like to study the relationship between the resting heart rate and the weight of a cohort of patients. Which chart type would be best suited for this type of analysis?

The Dollar Shack sells two different types of party supplies – balloons and hats – in six different colors. The table below shows the number of units that were sold this quarter by type and color. For each color, you would like to know what percent of the units sold were balloons and what percent were hats. You want to type a formula in cell G4 that you can copy the formula to the right and down to cell H9 in order to calculate the appropriate values for each color and item type. What formula should you type in cell G4?  

Generative Artificial Intelligence is

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

In supply chain activities, inbound logistics is the customer focus. 

An organization’s purchasing cost is $100 million and profit is $20 million before tax. With all else being equal, a 20 percent reduction in purchase cost spend would result in an increase in profit of ______%. 

Most organizational objectives can be summarized as:

The product of a PCR reaction using Taq polymerase is a double stranded DNA terminating in a: