The daily sales of bread loafs of company is given in the following
table. Use spreadsheet software to find the moving averages for the
length of 7.
(12 Marks)
Day Sale (Number of
loafs)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
4500
5001
2449
5300
4990
4445
1007
6066
3055
4931
4444
3330
4450
3055
3499
Answers
Answered by
4
By moving averages of length of 7 days, if you mean averages of first 7 days, then average of 2nd day to 8th day and like this, the solution is in attached spreadshet.
Two excel sheets are there. If you are using newer version of MS office, open the first one, otherwise open the second one.
Two excel sheets are there. If you are using newer version of MS office, open the first one, otherwise open the second one.
Attachments:
Answered by
4
Moving average chart is used to plot the average of multiple days rather than directly the data. The moving averages chart is a smoothened curve for identifying trends eliminating short term abrupt changes.
The average is calculated taking into account 7 points as: 3 previous points, the current point, and 3 points after the current point.
In the beginning and in the end there is an adaptation of the formula of average calculation done.
I have also plotted the charts two types - for you to see the use of the moving averages.
The average is calculated taking into account 7 points as: 3 previous points, the current point, and 3 points after the current point.
In the beginning and in the end there is an adaptation of the formula of average calculation done.
I have also plotted the charts two types - for you to see the use of the moving averages.
Attachments:
kvnmurty:
click on thanks button above pls;;select best answer
Similar questions