Hi,
Recently I have fallen with the following problem:
One of the leading cold-drink manufacturer company has given the data to our company and they told to analyze the data very quickly because they will take quick action based on our recommendation . The structure of the data is as follows:
X: Money spend on Advertising in TV
Y: Distribution of their product
Month X Y Awareness
Jan'2005 - - -
.
.
.
December'2005 - - -
It is beleived that peoples awareness about a commodity increases as they see the TV advertisment. Another way to increase the peoples awareness is that a person went to a shop and he does see that a product is in that shop and thus he comes to know about that commodity. Therefore the data on Y (Distribution of their product ) is given. Thus we can think Awareness is a function of X and Y. We have to fit the model taking Awareness as an dependent varaible and X and Y as explanatory variable.
Here we have made already few consideration like following:
i) The people who is alredy aware thorugh TV advertisment and if he again becomes exposed to that commodity in the shop then it does not increase his/her awareness. And vice-versa...
ii) Peoples awareness will declines with the time
Can anybody suggest me that how can I improve my model further.
Any suggestion in this regard will be appreciable to me.
With regards,
Madan
--------------
Madan Gopal Kundu
Room no 18, Sukhatme Hostel
Indian Agricultural Statistics Research Institute
Library Avenue, Pusa
New Delhi 12
India
Web: http://www.freewebs.com/madanstata
mobile: 91-9868788406
e-mail: [log in to unmask]
Send instant messages to your online friends http://in.messenger.yahoo.com
|