Growth Series Microsoft Excel ke Fill Series feature ka ek type hai. Iska use aisi number series create karne ke liye hota hai jahan har next value previous value ko ek fixed number se multiply karke generate hoti hai.
Simple words mein, Linear Series mein fixed amount add/subtract hota hai, jabki Growth Series mein fixed ratio se value increase/decrease hoti hai.
Starting Value = 2
Step Value = 2
Result:
2 → 4 → 8 → 16 → 32 → 64
Yahan har value ko 2 se multiply kiya ja raha hai.
Growth Series ko simple form mein is tarah samajh sakte hain:
Next Value = Previous Value × Step Value
Example:
2 × 3 = 6
6 × 3 = 18
18 × 3 = 54
54 × 3 = 162
Series:
2 → 6 → 18 → 54 → 162
Suppose:
Result:
5 → 10 → 20 → 40 → 80
Har next value previous value ka 2 times hai.
| Linear Series | Growth Series |
|---|---|
| Fixed amount add/subtract hota hai | Fixed ratio se multiply hota hai |
| 10, 20, 30, 40 | 10, 20, 40, 80 |
| Step Value = 10 | Step Value = 2 |
| Difference same rehta hai | Ratio same rehta hai |
| Regular numerical sequence | Rapid/compound growth pattern |
Linear:
10 → 20 → 30 → 40 → 50
Growth:
10 → 20 → 40 → 80 → 160
Growth Series ka use un situations mein kiya ja sakta hai jahan values percentage ya ratio ke basis par grow karti hain.
Examples:
Leave a Reply