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

Hence, from the above line graph, the people who has spent three years since they purchased a mattress, has highest frequency.