# 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
by muskaans

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.
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.
click on thanks button above pls;;select best answer