Social Network For Analytic Professionals
Arun's Groups
-
Retail Analytics
26 members
-
Academic Corner
38 members
-
Bayesian Modeling
65 members
-
Non Parametric Statistics
35 members
-
Time Series
91 members
Arun's Discussions
Segmentation for TEST & CONTROL strategies
Started Nov. 25, 2009
Response rate forecasting
Replied Nov. 19, 2009
Discriminant Analysis on Categorical Variables
Replied Nov. 18, 2009
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 gro…
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 wo…
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 DI…
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 Stat…
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 inv…
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 & Reactive…
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 the…
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 12:23pm 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
Most Visited
© 2010 Created by Vincent Granville
