Blog

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?

A control chart is a specific type of:

Based on the data shown below, what value would be returned by the following formula? =SQRT(-D5)

Which of the following does not allow a user to add data visualization directly in the cell(s) in an Excel worksheet?

Mary works as a business analyst for a local bookstore, and she would like to study the total number of books sold by genre and format (hardcover vs. paperback). Which chart type would be best suited for this type of analysis?

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