Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

When trying to display the mean values of a variable in a pivot chart. Which of the four pivotchart elds should the column name be

image text in transcribedimage text in transcribed
image text in transcribedimage text in transcribed
When trying to display the mean values of a variable in a pivot chart. Which of the four pivotchart elds should the column name be added to? A. Axis (categories) box B. Filters box C. Values box D. Legend (series) box QUESTION 2 When creating a graph/chart. Which of the following would be considered a best practice? A. Maximize the number of visual elements to ensure as much information as possible is displayed. B. Minimize the number of visual elements, so that the graph can be quickly interpreted. c_ Avoid thinking of the "story" you're trying to tell with the graph. Just provide the information in an objective manner and let the audience decide what the story is. People do not like the storytelling approach because it can come across as not being genuine. D.All of these are best practice recommendations. QUESTION 3 When you need to change the summary statistic that is displayed in a pivot chartltable (e.g., from a sum to a count), how do you change the summary statistic being displayed? A. Manually type in =count on the sheet outside of the pivot table, and the pivot table and chart will update. |3_ You would need to change the data being used in the pivot chartltable. No function in a pivot chartltable can change the the statistic being used to summarize the data. c_ When the column name is in the Values box, click the dropdown for that column and then click "value eld settings" and change the statistic from Sum to Count. D. Move the column from the Axis (categories) box to the Legend (series) box. '(UIUIIVII r Victoria is presenting the mean values of engagement for two different groups (Store A and Store B). The mean values are only collected at one point in time (e.g., a snapshot of what is happening at each store). Which type of chart should Victoria use? A. A line chart B. A pie chart C. All types of charts would be equally effective. D.A bar of column chart QUESTION 5 You are evaluating adverse impact based on race. There are over 1,000 applicants from each group, so sample size is not an issue. The group with the highest selection rate (BlacklAfrican American) has a selection rate of .50. The Asian applicants have a selection rate of .30. Based on this information, which of the following has occured? A. Adverse impact against Black applicants B. No adverse impact because the selection rates do not violate the 4/5ths rule. C. Adverse impact against Asian applicants. D. No adverse impact because being Asian is not a protected characteristic

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Exploring The Hospitality Industry

Authors: John R Walker

2nd Edition

013243766X, 9780132437660

More Books

Students also viewed these General Management questions

Question

=+23. Advertising strategies EVPI.

Answered: 1 week ago

Question

Context, i.e. the context of the information presented and received

Answered: 1 week ago