Question

Which of the following charts is used to show trend over time? Multiple Choice

1. Scatter plots
2. Pie charts
3. Line charts
4. Symbol maps
5. Treemaps

Which of the following is not part of common steps in using a data analysis tool?

1. Get data
2. Set relationships among tables
3. Select the attributes for the visualization
4. Deliver the visualization to the decision maker
5. None of the choices are correct.

Which of the following is not a characteristic of an Excel table?

1. No blank rows
2. Includes charts
3. No blank columns
4. Includes a header row
5. None of the choices are correct.

Please Answer all questions thank you

Answer 1

c. Line charts

Line charts are one of the ways of plotting the data in excel. They are usually ideal for time series data because time series data has fluctuations and they are better visualised in this type of plot. Every increase or decrease is properly mapped in line charts.

d. Deliver the visualisation to decision maker

Data analysis process involve some series of steps which include

Dedining the problem

Collecting data

Cleaning the data

Analysing data

Interpreting the results

So first three options are part of common data analysis tool but option d deliver the visualisation to decision maker does not necesaarily require much use of data analysis tool so this is not a common step to be included.

b. Includes charts

No blank row no blank column and including a header row are all the characteristics of excel table but chart is a separate option to visualise this data in the form of graph and is not a characteristic of excel table.