Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started