Search results

Narayan, Have you been to make any sense of it? Kay

That would be great. Thanks Narayan. kay

Hi Narayan, Thanks for the explanation. We presently have this one year data and nothing more. What would you suggest on how to calculate the impact of those variables on the dependent variable? Would sure like to see the how it can be done if done with two variables which are the payment...

https://www.box.com/s/f621f117d873d359b15c Hi Narayank991, Thanks for your response. Your assumptions are indeed correct. The discounts are decided based on market conditions and in which month we are. The discount of 70% are given to staff and others are just to increase number of buyers...

I have been working on some data for some weeks and my dumb head is just useless in excel and I seek your expert assistance. Explaining it sounds so easy but execution in a brick wall. I have several variables which causes the price of my product to go down on a monthly basis. I want to be...

Can anyone help with a formular on how to calculate the % variance between 2 negative numbers? I have in column f4 -2.241 and -2.888 in colum g4. Can anyone help with a formular to get the right answer? Right now =-ABS(F4-G4)/ABS(F4)

Hello People, I have two sets of data. One is the spread of students across different regions and the other is the revenue generated by the students in the regions. I want to increase the fee by 3% but do not want to have a blanket increase of 3% across region. I want to know using weighted...

Thanks gentlemaen. Issue resolved.

Hello Fred, I mean rows B% ad B6. Thanks

I need help in calculating 6 months rolling for tow sets of data: I have a three year data that shows (1) The conversation rate of a student to a program and (2) The study fees. These two informations are by month. I want to calculate 6 months rolling forward and plot this into a chart...

@Faseeh When I enter a fee I do not see any change in the corressponding chart. Is this normal or am i missing something?

Thanks Gentle men

SIRJB7 and Faseeh, Thanks a bunch. Your input has greatly helped. Even though you both approaches it form different angel, the result is the same.

https://rapidshare.com/files/4273617159/pricing_analysis.xls This is the link to the sheet. Kindly send back to kay.lawal@ymail.com

I have sent the file to you. Thanks

Dear Freinds, I have been strugling with an issue for the past one week. I have a set of historical data containing number for students in a program and the average prices for the programs per month, quater and year. I want to see if price increase will have any effect on the number fo student...

I'm new to this site and so far i am excited. Am actually doing for excle table that would allow me to see the effect of price increase based on historical data. I need to build a model. Who can HELP