Question

In a survey, several people were asked how many years it has been since they purchased a mattress. The results are shown in Table $2.38$

Short answer

The output for line graph,

Step-by-step solution

Content Introduction

Line graphs are used to track changes across time, both short and long. When there are fewer changes, line graphs are preferable over bar graphs. Line graphs can also be used to compare changes for multiple groups over the same time period.

Content Explanation

The output for line graph,

The line graph is made in excel as follow:

1. Select the given data and go to Insert in the menu bar.
2. select "Insert line Chart" from the heading "Charts".
3. Select 2-D line charts.
4. Click on displayed chart and on the right hand side of the chart, a plus sign can be seen.
5. Click on it and select chart elements written As Axis title, data label, Chart type, Legend, Label, as shown in the time series below