Arun's Groups
-
Retail Analytics
26 members
-
Academic Corner
38 members
-
Bayesian Modeling
64 members
-
Non Parametric Statistics
35 members
-
Time Series
89 members
Arun's Discussions
Segmentation for TEST & CONTROL strategies
Started Nov 25
Response rate forecasting
Replied Nov 19
RSS
Loading feed
Arun's Page
Latest Activity
The TEST & CONTROL strategy is a popular strategy of the Marketing world used to compare sales across different schemes to measure the effectiveness of each individual scheme/campaign.
I've got about 100 regions, which I'll need to split into 3 g...
Hi Veerendra,
This is one problem that the entire Direct Marketing - Marketing in general - face, trying to predict the response rate for the upcoming campaigns using past campaign data. CRM solutions kind of address this issue, but I have never ...
Scatter Plot with 10 Clusters using Canonical Structures
Scatter Plot with 6 Clusters using Canonical Structures
MDS Plot after find distance between 10 clusters using PROC DISTANCE
MDS Plot after find distance between 6 clusters using PROC ...
UPDATES:
I used the unsupervised learning method of Kohonen Vectors to arrive at a couple of solutions (not robust or checked for optimacy). The first time I used 10 Clusters, and the second time, I used 6 Clusters. After this, I used the Mean St...
Arun, we use n-d methods including visualisation which have been likened to a high-speed form of discriminant analysis. We have no problem handling a mix of continuous and categorical variables. Its a little-known method but if you would like to i...
I went through the entire article! Whoa! That's some real nuisance.
Now, amidst all this, I do have questions about how they categorize Click Fraud. It's being said that there are two ways to do this, esp the way Google does - Proactive & Reactiv...
I do not have much time currently, but I cannot hold back to remark this:
Kohonen is equal to k-Means if a) k = number of neurons used in the map and b) k-means is implemented in the way that the center is adjusted instead of simple calculating t...
Profile Information
- Field of Expertise:
- Marketing Databases, SAS, Statistical Consulting
- Years of Experience in Analytical Role:
- 1.5
- Professional Status:
- Other
- Interests:
- Finding a New Position, Networking, New Venture, Other
- Your Company:
- Target Corporation
- Industry:
- Retail
- How did you find out about AnalyticBridge?
Comment Wall (1 comment)
- At 11:23am on May 26, 2009,
Michael Schneider said… - Arun,
Thanks for replyihg back. I think I figured this out.
I'm creating a VB module to value non-performing loans, and I want to add summary stats on the portfolio and the expected performance, generated automatically via VBA in Excel.
So, I want to loop over the columns, adding summaries for each columns, such as:
=sum(The entries in the columns), or
=Sumproduct(Column(0), Column(j))/Sum(Column(0))
etc.
Now I understand that inside of VBA this can be done by string processing in VB to generate the right string in the Worksheet cell:
Here is an example: (I would think this can be simplified....)
Sub Summary()
Dim rng As Range, rng0 As Range
Dim cNumRow As Integer, cNumCol As Integer, j As Integer
cNumRow = Range([A2], [A2].End(xlDown)).count
cNumCol = Range([A2], [A2].End(xlToRight)).count
Set rng0 = Range([A2], [A2].Offset(cNumRow - 1))
For j = 1 To 4
Set rng = Range(Cells(2, j), Cells(cNumRow + 1, j))
With [A1].Offset(0, j - 1)
If (j = 1) Then
.Formula = "=sum(" & rng.Address(0, 0) & ")"
ElseIf (j = 2) Then
.Formula = "=average(" & rng.Address(0, 0) & ")"
ElseIf (j = 3) Then
.Formula = "=sumproduct(" & rng0.Address(0, 0) & "," & rng.Address(0, 0) & ")"
ElseIf (j = 4) Then
.Formula = "=sumproduct(" & rng0.Address(0, 0) & "," & rng.Address(0, 0) & ")/sum(" & rng0.Address(0, 0) & ")"
End If
End With
Next j
End Sub
Featured
Advertisement
Analytic Jobs
Events
© 2009 Created by Vincent Granville
