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

2

Answers

2015-10-20T15:55:51+05:30

This Is a Certified Answer

×
Certified answers contain reliable, trustworthy information vouched for by a hand-picked team of experts. Brainly has millions of high quality answers, all of them carefully moderated by our most trusted community members, but certified answers are the finest of the finest.
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.
2 4 2
2015-10-20T16:38:58+05:30

This Is a Certified Answer

×
Certified answers contain reliable, trustworthy information vouched for by a hand-picked team of experts. Brainly has millions of high quality answers, all of them carefully moderated by our most trusted community members, but certified answers are the finest of the finest.
     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.
2 5 2
click on thanks button above pls;;select best answer