Questions and Answers
What type of graph should you plot if you are investigating an association between two variables?
Scatter graph
When collecting frequency data, which type of graph may be appropriate?
Bar chart
Which type of graph is suitable for comparing different sets of data?
Bar graph
In Excel, what type of graph should you select for bar charts?
Signup and view all the answers
What is a common mistake when selecting the 'Line' option in the Graph Type in Excel?
Signup and view all the answers
What is the most suitable type of graph for comparing different sets of data?
Signup and view all the answers
Which type of graph should you plot if you are investigating an association between two variables?
Signup and view all the answers
What is a common mistake when selecting the 'Line' option in the Graph Type in Excel?
Signup and view all the answers
When collecting frequency data, which type of graph may be appropriate?
Signup and view all the answers
Which type of graph is not suitable for representing an association between two variables?
Signup and view all the answers
When using Excel to plot a graph, what is a common mistake when selecting the 'Line' option in the Graph Type?
Signup and view all the answers
If you are investigating an association between two variables, which type of graph should you plot?
Signup and view all the answers
What type of graph is suitable for comparing different sets of data in Excel?
Signup and view all the answers
When collecting frequency data, which type of graph may be appropriate?
Signup and view all the answers
In Excel, what should you do in the Chart Options step when plotting a graph?
Signup and view all the answers
Study Notes
Graph Types and Their Uses
- When investigating an association between two variables, a scatter graph (or X-Y graph) is the most suitable type of graph to plot.
Frequency Data
- When collecting frequency data, a bar chart or a histogram may be an appropriate type of graph to use.
Comparing Data Sets
- To compare different sets of data, a bar chart or a column chart is a suitable type of graph.
Excel Graphing Mistakes
- A common mistake when selecting the 'Line' option in the Graph Type in Excel is to use it to connect categorical data, rather than continuous data.
Excel Graphing Tips
- In Excel, when selecting a graph type, choose the 'Column' option for bar charts.
- In the Chart Options step when plotting a graph in Excel, ensure that the correct graph type and data are selected.
Unsuitable Graph Types
- A line graph is not suitable for representing an association between two variables, as it is used to show trends over time or continuous data.
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.