-
Smoothing data
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!!
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 |
-
Alright....I figured out how to use the TREND function. However, it only calculates a straight line. Can I estimate a polynomial line??
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules