PDA

View Full Version : Smoothing data



jmenche
06-16-2015, 05:24 AM
Howdy,

This is not a programming issue but an advanced formula one (I think). I have A LOT of weekly data by A LOT of stores. I want to calculate a "smooth" number for each week by using the value from a fitted trend line. It is easy to do for 1 store but I cannot create 2,000 charts to find 2,000 trend line formulas.

Is there an easier way?

Here is some sample data from one store.

Thanks!!
:beerchug:
Jeff







Week

Sales





1

167





2

138





3

151





4

191





5

169





6

170





7

162





8

169





9

157





10

170





11

138





12

134





13

163





14

137





15

161





16

143





17

159





18

171





19

160





20

149





21

190





22

156





23

189





24

185





25

188





26

196





27

152





28

169





29

155





30

133





31

155





32

136





33

140





34

157





35

147





36

113





37

146





38

148





39

170





40

145





41

154





42

154





43

191





44

153





45

170





46

170





47

149





48

143





49

148





50

169





51

155





52

146

jmenche
06-16-2015, 05:31 AM
Alright....I figured out how to use the TREND function. However, it only calculates a straight line. Can I estimate a polynomial line??