ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 27 - TDA-C01 discussion

Report
Export

You have the following bar chart.

You want the chart to appear as shown in the Mowing exhibit.

What should you add?

A.
A reference band
Answers
A.
A reference band
B.
A reference line
Answers
B.
A reference line
C.
An average line
Answers
C.
An average line
D.
A distribution band
Answers
D.
A distribution band
Suggested answer: D

Explanation:

A reference band is a shaded area that shows a range of values on an axis. You can use a reference band to highlight a target range, a confidence interval, or a standard deviation. In this case, you want to add a reference band that shows the range of values from 0 to 100 on the y-axis. This will create a shaded area behind the bars that indicates the percentage of sales.

To add a reference band, you need to do the following steps:

Click on the Analytics tab on the left side of the workbook to open the Analytics pane. You will see a list of analytical objects that you can drag and drop onto your worksheet.

Drag Reference Band from the Analytics pane to Y-Axis on the worksheet. This will add a reference band on the y-axis that shows the average and confidence interval for all values.

Click on the Edit button on the reference band to open the Edit Reference Band dialog box. You will see options to customize your reference band.

Change the Band From value to 0 and the Band To value to 100. This will change the reference band to show the range of values from 0 to 100 on the y-axis.

Click OK to apply the changes. You will see that the reference band now shows a shaded area behind the bars.

asked 23/09/2024
Brent Varona
25 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first