MATH HELP!!

[Rebecca 0]

In keeping with the general lameness of the day, I need help with a cumulative sum formula. I used to know it...

I have:

Conversions per month
Sales per month
12 months

My monthly converted customers accumulate sales at the same rate from January to December.

How do I arrive at the December cumulative total with one formula?

you've got to ask yourself one question: 'Do I feel loquacious?' -- well do you, punk?

[Rebecca 0]

If you're wondering why I don't ask one of the whiz kids in my office... well, don't, 'cause there ain't any.

Bueller?

you've got to ask yourself one question: 'Do I feel loquacious?' -- well do you, punk?

[AggieDave 6]

See linked formula.

http://upload.wikimedia.org/math/f/d/2/fd2660e8d2c2d8539e3962b48a3ba1c5.png


It looks complicated so I guess it'll work for you.

--"When I die, may I be surrounded by scattered chrome and burning gasoline."

[Rebecca 0]

Seems I'd need 3 more variables... plus the definitions of the variables...

Aw hell. This is so frustrating. I've been banging my head on the desk, but it hasn't fallen out yet. I coulda sworn it was in there!

you've got to ask yourself one question: 'Do I feel loquacious?' -- well do you, punk?

[livendive 8]

Quote

I have:

Conversions per month
Sales per month
12 months

My monthly converted customers accumulate sales at the same rate from January to December.

How do I arrive at the December cumulative total with one formula?

I don't think I understand the question. Are you saying there's a rate at which you get converted customers, and once converted, those customers accumulate sales for you? And you're trying to figure out the annual amount of converted sales knowing that the January converted customers who are retained the entire year will accumulate approximately 12 times the sales of those customers who don't convert till December, but total December sales will be approximately 12 times January sales?

If I understand the question correctly, and if monthly conversions = C and monthly sales per conversion = S, then wouldn't the annual sales be 78(C*S)? (78 being the summation of 12)

Blues,
Dave

"I AM A PROFESSIONAL EXTREME ATHLETE!"
(drink Mountain Dew)

[NWFlyer 2]

Math is hard. Let's go to the mall!

"There is only one basic human right, the right to do as you damn well please. And with it comes the only basic human duty, the duty to take the consequences." -P.J. O'Rourke

[Rebecca 0]

OMG!! DUUUUUUHHHHHH!!!

Yep. That's it.

Thank you for being gentle about it. Musta given myself one too many forehead whacks to the desk.

you've got to ask yourself one question: 'Do I feel loquacious?' -- well do you, punk?

[shropshire 0]

<> - to spell


.

(.)Y(.)
Chivalry is not dead; it only sleeps for want of work to do. - Jerome K Jerome

[Rebecca 0]

Quote

Math is hard. Let's go to the mall!

One of our favorite expressions around here when people prove themselves incompetent is:

"But this is HAAARD!"


Anyway, I found an awesome pair of pants at Ann Taylor for $19.99. They're having a great sale right now.

you've got to ask yourself one question: 'Do I feel loquacious?' -- well do you, punk?

[Rebecca 0]

Quote

<> - to spell


.

Ah yes, yet another intriguing little English language discrepancy. We say Math. You say Maths. Adding that extra letter just wasn't worth pointing out that it's a pluralized word...

you've got to ask yourself one question: 'Do I feel loquacious?' -- well do you, punk?

[shropshire 0]

No but it's a slow evening and fun from time to time

(.)Y(.)
Chivalry is not dead; it only sleeps for want of work to do. - Jerome K Jerome

[guppie01 0]

Got it turns me on when you talk smart...

g

"Let's do something romantic this Saturday... how bout we bust out the restraints?"
Raddest Ho this side of Jersey #1 - MISS YOU
OMG, is she okay?

[shropshire 0]

e=mc^2

(.)Y(.)
Chivalry is not dead; it only sleeps for want of work to do. - Jerome K Jerome

[pBASEtobe 0]

Quote

See linked formula.

http://upload.wikimedia.org/math/f/d/2/fd2660e8d2c2d8539e3962b48a3ba1c5.png


It looks complicated so I guess it'll work for you.

You realize that's the formula for the drag force on an object.

That would work to help find terminal velocity.

[livendive 8]

Quote

Got it turns me on when you talk smart...

All questions are female. All answers are male. If you’re wondering why this might be the case, you are thinking with your feminine sensibilities. If you’re considering why this is the case, you are thinking with your masculine senses. Questions are creative, intimidating, and periodically irritating. We may think them docile, we may try to ignore or suppress them, but their destabilizing power persists, pushing us toward our proper destiny. Answers are protective, giving us some ground, however shaky, on which to stand. Answers are cool, logical, but they can also become stubborn know-it-alls, resisting the emergence of new questions and answers and deteriorating into conservative old farts. Truth is a precarious balance between poignancy and peace. Truth lies within the perpetual prance of Yin and Yang.

Blues,
Dave

"I AM A PROFESSIONAL EXTREME ATHLETE!"
(drink Mountain Dew)