Charts: Scatter chart MCQs Quiz | Class 9
This quiz is for Class 9 students studying Computer Applications (Code 165), Unit 3: Office Tools (Spreadsheets). It covers the topic of Scatter charts, focusing on the relationship between two variables. Attempt all questions and click ‘Submit Quiz’ to see your score, then download your answers as a PDF.
Understanding Scatter Charts
A Scatter Chart (also known as a scatter plot or XY graph) is a powerful tool used in spreadsheets and data analysis to visualize the relationship between two sets of numerical data. Each point on the chart represents a pair of values, one from each dataset, making it easy to see patterns, trends, and correlations.
Key Concepts of Scatter Charts
The primary purpose of a scatter chart is to determine if a relationship exists between two variables. This relationship is called correlation.
- Positive Correlation: When the value of one variable increases, the value of the other variable also tends to increase. On the chart, the points will generally trend upwards from left to right. For example, the more hours you study, the higher your exam score might be.
- Negative Correlation: When the value of one variable increases, the value of the other variable tends to decrease. The points on the chart will trend downwards from left to right. For example, as the temperature outside increases, the sales of winter coats might decrease.
- No Correlation: There is no apparent relationship between the two variables. The points on the chart are scattered randomly with no clear pattern. For example, there is likely no correlation between a person’s height and their favorite color.
Components of a Scatter Chart
| Component | Description |
|---|---|
| X-Axis (Horizontal) | Typically represents the independent variable—the one you control or that changes on its own. |
| Y-Axis (Vertical) | Typically represents the dependent variable—the one that is measured and is expected to be affected by the independent variable. |
| Data Points | Each dot on the chart represents a single observation with a value for both the X and Y variables. |
| Trendline (Optional) | A line drawn through the points to show the general direction or trend of the data. |
How to Create a Scatter Chart in a Spreadsheet
Creating a scatter chart is a straightforward process in most spreadsheet applications like Microsoft Excel or Google Sheets:
- Enter Your Data: Create two columns of data. For example, one column for “Hours Studied” and another for “Exam Score”.
- Select the Data: Highlight both columns of data, including the headers.
- Insert Chart: Go to the ‘Insert’ menu and choose ‘Chart’.
- Choose Chart Type: Select ‘Scatter’ or ‘XY (Scatter)’ from the list of available chart types.
- Customize: Add titles to the chart and axes to make it clear what the data represents. You can also customize colors and add a trendline.
Quick Revision Points
- Scatter charts are used to show the relationship between two numeric variables.
- Each dot on the chart is a pair of X and Y values.
- An upward trend (left to right) indicates a positive correlation.
- A downward trend (left to right) indicates a negative correlation.
- Randomly scattered points indicate no correlation.
- The X-axis usually shows the independent variable, and the Y-axis shows the dependent variable.
Practice Questions
Test your knowledge with these additional questions:
- If you were to plot a person’s age against their shoe size, what kind of correlation would you expect to see for a dataset of people aged 25 to 55?
- What is the main difference between a line chart and a scatter chart?
- Can a scatter chart be used with categorical data (e.g., ‘Red’, ‘Blue’, ‘Green’)? Why or why not?
- If a trendline on a scatter plot is almost perfectly horizontal, what does it suggest about the relationship between the variables?
- You want to see if there’s a link between the amount of rainfall and the number of umbrellas sold. Which variable would you place on the X-axis?
