The quarterly sales figures for the number of shoes (pairs) sold at a shoe shop is...

 

Transcribed Image Text:

The quarterly sales figures for the number of shoes (pairs) sold at a shoe shop is shown on the table below. Enter the following data into Excel. Year 2017 2018 2019 2020 Quarter 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 Required (using Excel): 1. Draw a line graph to represent the sales figures. 2. Show formulas and calculate the moving averages. Sales 139 135 91 113 145 137 85 118 150 141 89 119 156 149 105 125 3. Show formulas and calculate the centre moving averages. 4. Present the original sales data and the trend of sales figures on the same line graph. The quarterly sales figures for the number of shoes (pairs) sold at a shoe shop is shown on the table below. Enter the following data into Excel. Year 2017 2018 2019 2020 Quarter 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 Required (using Excel): 1. Draw a line graph to represent the sales figures. 2. Show formulas and calculate the moving averages. Sales 139 135 91 113 145 137 85 118 150 141 89 119 156 149 105 125 3. Show formulas and calculate the centre moving averages. 4. Present the original sales data and the trend of sales figures on the same line graph.

Answer rating: 100% (QA)

1 The line graph to represent the sales 2 Formula and calculation of the moving averages Moving Aver... View the full answer