USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
True
|
|
False
|
|
Either A or B
|
|
None of the above
|
Detailed explanation-1: -Answer: FALSE, because the graph that is useful displaying or representing the relationship between two or more measurement variables is the Scatterplot. While a bar graph is useful to represent two or more categorical variables simultaneously.
Detailed explanation-2: -A bar chart is used when you want to show a distribution of data points or perform a comparison of metric values across different subgroups of your data. From a bar chart, we can see which groups are highest or most common, and how other groups compare against the others.
Detailed explanation-3: -A bar diagram makes it easy to compare sets of data between different groups at a glance. The graph represents categories on one axis and a discrete value in the other. The goal is to show the relationship between the two axes. Bar charts can also show big changes in data over time.
Detailed explanation-4: -Double bar graph is useful for the comparison of data. Q. Bar graphs are usually used to represent ‘categorical data’ while histogram is usually used for ‘continuous data’.
Detailed explanation-5: -Multiple variable bar charts can be created from a single data file or from different data files. Typically, the X values (for vertical bars) are the same for each of the bar charts. However, the X values may be different between bar charts. When creating stacked bar charts, each row of data is considered a stack.