Wednesday, 7 September 2011
Discriminant Function
Learnings from Business Analytics
Monday, 5 September 2011
The lesser used coefficient- Kendall’s Tau
Conjoint Analysis: Asking indirect questions to get direct answers!!
Sunday, 4 September 2011
A beginner’s insight into Regression Analysis in SPSS. (Data – Regression – ….)
Conjoint Analysis
Thursday, 1 September 2011
GAPMINDER....Make sense of the world with fun
Gapminder is a tool that allows the user to present a huge amount of world data visually in the form of moving, interactive graphs.Gapminder takes a stream of data dependent on time, and presents it visually, in the form of moving graphs. The strength of this tool is the data it gives access to. a staggering amount of worldwide data, from geographical disasters and national economy, to personal poverty and AIDS.
The data covered in Gapminder is worldwide. The data is displayed on a graph, with variables shown on the x-axis and y-axis with size and colour variations to depict magnitude and categories. The graph can compare multiple sets of data at one time, over a period of years which facilitates easy comparison. Sections of a graph can be zoomed in on, and the path of individual points can be followed, to emphasize specific data when needed. The Gapminder data can even be displayed over a map, so that statistical changes can be shown geographically.
Some of the projects undertaken by Gapminder are described below.
World Income Distribution is an interactive display of statistics on household income distribution for Bangladesh, Brazil, China, India, Indonesia, Japan, Nigeria, Pakistan and USA and the World as a whole in each year from 1970 to 1998.
Dollar Street is an interactive display of the world in the form of a street. The street number depicts the daily income per person in the family. All people of the world live on Dollar Street. The poorest live on the left end and the richest on the extreme right end. All other people live in between on a continuous scale of daily incomes.
Human Development Trends 2003 is a linear thematic Flash presentation is developed with United Nations Development Program (UNDP) for the release of the Human Development Report 200.
World Health Chart 2001 is a display of 50 to 100 years of health development for all countries of the World with time series for 35 indicators provided by the World Health Organization.
Posted by
Swati Agarwal
Finance
ANALYSIS OF FACTORS AFFECTING ECOMMERCE IN BANKS THROUGH DISCRIMINANT ANALYSIS
The objective of discriminant analysis in such scenarios is to understand the group differences and to predict the likelihood that an entity that will distinguish adopters and non-adopters of ecommerce based on their perception of the complexity involved in using ecommerce.
Discriminant analysis involves deriving a variate; in this case the variate is a linear combination of nine independent variables –
v Perceived complexity
v Perceived benefits
v Organizational competence
v Perceived compatibility
v Supporting industries e-readiness
v Top management support
v Market e-readiness
v IT capability
Government e-readiness that was used to discriminate between adopters and non-adopters of ecommerce. Discrimination is achieved by setting the variate’s weight for each variable to maximize the between-group variance relative to the within group variance.
The two groups (adopters/non-adopters) of this research are independent in the sense that they are separate samples containing different sets of individual subjects.
The group variable is adoption of ecommerce. The independent variable is Management support. It discriminates between adopters and non-adopters of ecommerce. Moreover, the adopters of ecommerce had greater support from management.
All the items within this variable were significant discriminators. The mean value for adopters was significantly larger than the mean value for non-adopters. This is consistent with assertion that top management support is crucial in the acquisition and diffusion of innovation.
A number of conclusions can be drawn from these results. Firstly, banks with a strong support and commitment to ecommerce from top management are more likely to adopt ecommerce. Secondly, banks that have the requisite IT and business resources (infrastructure and skills) for ecommerce adoption stand a better chance at adopting ecommerce. Thirdly, banks that have sound IT infrastructure in place are in a better position to adopt ecommerce.
Posted by
Neha Sharma
Finance
Wednesday, 31 August 2011
Of faulty assumptions and more
So I came across this technique that uses discriminant analysis to predict the failure of a bank. And if the two assumptions mentioned above were actually true, we would have beaten the financial crisis hands down and saved the financial giants from going down in the dumps. Having said that though, this technique is at least worth discussing.
Firms are divided into failing and non-failing firms and each is given a ‘discriminant score’. The technique works as follows:
Discriminant analysis is used to derive a linear combination of two or more independent variables that best discriminate the two groups under consideration, failing and non-failing companies. The discriminant analysis derives a linear combination from the following equation
Z = discriminant score
wi (i=1, 2, ... ,n) = discriminant weights
xi (i=1, 2, ... ,n ) = independent variables, that are various financial ratios in this case
The discriminant score given to each firm is then compared to a cut-off score to determine which group the company in question belongs to (failing or non- failing firm).
Now, in the perfect world where everything followed the ‘norm’, discriminant analysis would have worked perfectly given that the variables in every group followed a normal distribution and the covariance matrices for every group were equal. However, past experiments have revealed that firms and more often than not, failing firms, often violate this condition. So an aberration from the assumption is more of a norm than just an exception.
However, being the ‘bean counters’ that we finance guys are accused of being, a favourable discriminant score should make for a good enough premise for us to declare a firm failing or non- failing. No room for faulty assumptions there!
Reference : Paper titled ‘Choosing Bankruptcy predictors,using Discriminant Analysis, Logit Analysis and Genetic Algorithms’ by the Turku Centre for Computer Science
Using discriminant analysis to prevent bankruptcy
Earlier Ratio Analysis was used as an analytical technique to measure the performance of the companies. The performance of the companies, as measured by the ratios , such as profitability, liquidity and solvency prevailed as the most significant indicator but the order of their importance is not being clear , since in each and every case taken ,some different ratio came out as the most important factor and sometimes it might seem to be confusing , for instance, a firm with a poor profitability / solvency record may be regarded as potentially bankrupt.
Discriminant Analysis is a technique , which has been applied nowadays successfully to financial problems such as credit evaluation (as had been illustrated in class) and investment analysis. It is a parametric technique to determine , which weightings of quantitative variables or predictors best discriminate between 2 or more than 2 groups of cases. Analysis creates a discriminant function , which is a linear combination of the weightings and scores on these variables. The maximum no. Of functions is either the no. Of predictors or the no. of groups minus one , whichever of these two values is the smaller.
Z =a+W1*X1+W2*X2+.......+Wn*Xn
Where Zjk = Z score of discriminate function
a= intercept
Wi=Discriminant coefficient for the independent variable i
Xi =independent variable i
In a 2 group discriminant function, cutting score is used to classify he two groups uniquely. Optimal cutting score is halfway between the centroid of two groups.
The primary goal is to find dimensions that groups differ on and ,create classification functions , then we need to find along how many dimensions do groups differ reliably.
By discriminant analysis , we can find which ratios are affecting the performance of a company .
Z= a*X1+b*X2+c*X3+....+n*Xn
Where Xis can be working capital / total assets, retained earnings / total assets, EBIT/total assets, B/E value, sales/ total assets etc.
It can then be applied to similar other companies.
We use discriminant analysis in evaluating consumer loan application. A fast and efficient device for detecting unfavourable credit risks might avoid the loan officer to avoid disastrous decisions. Thus it can be thought of as a potential weapon to be used in business sector.
Posted by
Neeraj Kumar Singh
Finance
Tuesday, 30 August 2011
Perceptual Mapping
In today's class we learnt the concept of perceptual mapping
Perceptual mapping can be used to plot the interrelationships of variables among different clusters .Variables are rated on a range of attributes and are then mapped to show their relative positions. Perceptual maps are generally used for market segmentation and involve two steps of data collection and data analysis.Perceptual mapping allows the management to take a broad view of the strength and weakness of their products or service offerings relative to their competition. Also called the Multi Dimensional Scaling,
After plotting the perceptual maps for various attributes a 1st level analysis would throw up aspects that were ignored in the past.
Today's sessions also revolved around the interusage of SPSS and Permap and the analysis of various parameters thrown up by a customer satisfaction survey regarding a few stores.
For finance matters this technique is helpful in corelating the various behaviours of stocks and in determining the crucial factors involved in the price fluctuation of stocks.
Our Group measured the customer satisfaction between the four stores depending on the distance of the stores and the six attribute such as price satisfaction,variety satisfaction,organization satifaction,service satisfaction,item quality satisfaction,overall satisfaction.Then the frequency was calculated for the price satifaction and overall satifaction attributes . then the various parameters such as method of payment , variety satisfaction,item quality satisfaction , shopping frequency calculation,price satisfaction .
In al the above tests the null hypothesis was assumed as that there is no corelation between the distance of the store with the above mentioned variables.
According to the chi square results the null hypothesis was accepted in all the cases except for shopping frequency and variety satisfaction case.
From our set of data, we learnt that the closer the store, higher the price satisfaction. Through this one can infer that a customer wouldn’t mind paying a little extra, for the convenience of proximity that a store nearby gives him. Another finding showed that, for quality, people do not mind travelling that extra distance.
Posted by
Amit Kulkarni
Finance
PERCEPTUAL MAPPING: Segmentation, Targeting & Positioning
Perceptual mapping represents a geometric comparison of how competing products are perceived. One thing to note is that the closer products/brands are clustered together on a perceptual map, the greater the competition. The further apart the positions, the greater the opportunity for new brands to enter the market, simply because the competition is less intense.
Determining attribute importance and mapping the product across some attributes, we can discover how our brand and competing brands are perceived in the marketplace. Perceptual mapping can provide significant insight into how a market operates. For example, it provides marketers with an insight into how their brands are perceived and it also provides a view about how their competitors’ brands are perceived. In addition to this substitute products can be uncovered, based on their closeness to each other. All of the data reveal strengths and weaknesses that in turn can assist strategic decisions about how to differentiate on the attributes that matter to customers and how to compete more effectively in the target market.
Positioning Strategies
Understanding how products are positioned provides important inputs not only to the way a product performs but also to the marketing communications used to support a product. Through communications, and especially advertising, information can be conveyed about each attribute and in doing so adjust the perceptions customers have of the product.
Marketing communications can be used in one of two main ways to position a product, namely to position a brand either functionally or expressively (symbolically). Functionally positioned brands emphasize the features and benefits, whilst expressive brands emphasize the ego, social, and hedonic satisfactions that a brand can bring. Both approaches make a promise: with regard to, for example, hair care, a promise to deliver cleaner, shinier, and healthier hair (functional) or hair that we are confident to wear because we want to be seen and admired, or because it is important that we feel more self-assured (expressive).
Repositioning Strategies
Markets change and some change quickly. Technology, customer tastes, and competitors’ new products are some of the reasons for these changes. If the position adopted by a brand is strong, if it was the first to claim the position and the position is being continually reinforced with clear, simple messages, then there may be little need to alter the position originally adopted. However, most
marketers need to be alert and be prepared to reposition their brands as the relative positions occupied by brands, in the minds of customers, will be challenged and shifted around on a frequent basis. However, repositioning is difficult to accomplish, often because of the entrenched perceptions and attitudes held by buyers towards brands and the vast (media) resources required to make the changes.
Repositioning is essentially a task that revolves around the product and the way it is communicated. There are four main ways to approach repositioning a product. The choice of approach depends on each individual situation facing a brand. In some cases the brand needs to be adapted before re launch.
• Change the tangible attributes and then communicate the new product to the same market.
• Change the target market and deliver the same product.
• Change both the product (attributes) and the target market.
Monday, 29 August 2011
A Layman’s understanding of SELECTING CASES in Data
Sometimes a researcher may wish to restrict an analysis to only a subset of the data file. For example, a researcher might want to do an analysis on only the female participants, only on American citizens, or only on those who disagreed with a presented message. You can have SPSS only perform analyses on a subset of cases meeting specified criteria by selecting cases.
For example, suppose you believed that an experimental manipulation would work better on female participants. You might therefore want to do an analysis only on the female participants. Assuming that you had a variable named “gender” in your data set where men had a value of 1 & women had a value of 2, you could select only women for analysis in SPSS by taking the following steps:
ü
Choose Data Select Cases.
ü Click the radio button next to If condition is satisfied.
ü Click the If button.
ü Type gender=2 in the popup window. (Type through the buttons provided there. That would automatically adjust for required spaces).
ü Click the Continue button.
ü Click the OK button.
After running this procedure, the dataset will have slashes crossing out the cases that are excluded (in this case, it should cross out all the male participants). Any further analyses on this data set (until you issue another Select Cases command or load another data set) will be performed solely on the female participants.
An analyst can restrict the data set in more complicated ways by using the Boolean operator AND (represented by the symbol &) or the Boolean operator OR (represented by the symbol |). The & symbol tells SPSS that a case has to meet two specific criteria to be included in the analysis, while the | symbol tells SPSS that it should include a case if it meets either of two criteria. As an example, let us assume that the data set included a variable named class where 1 = freshmen, 2 = sophomore, 3 = junior & 4 = senior. If we only wanted to include cases that represented female juniors we would perform the following steps.
ü
Choose Data Select Cases.
ü Click the radio button next to If condition is satisfied.
ü Click the If button.
ü Type (gender=2) & (class=3) in the popup window.
ü Click the Continue button.
ü Click the OK button.
If we wanted to include cases that were either female or juniors (so that the analysis would include all females and any males who happened to be juniors) we would take the following steps.
ü
Choose Data Select Cases.
ü Click the radio button next to If condition is satisfied.
ü Click the If button.
ü Type (gender=2) | (class=3) in the popup window. Click the Continue button.
ü Click the OK button.
You may notice that one of the buttons on the selection keypad looks like “~=”. This symbol stands for “not equal to”. Sometimes it is easier to identify what cases to exclude than it is to identify what cases to include. For example, you could select everyone in the data set except sophomores by taking the following steps:
ü
Choose Data Select Cases.
ü Click the radio button next to If condition is satisfied.
ü Click the If button.
ü Type class~=2 in the popup window.
ü Click the Continue button.
ü Click the OK button.
References:
http://www.stat-help.com/spss.pdf
Sunday, 28 August 2011
Identification of false financial statements through SPSS
An external stakeholder can determine whether a financial statement is falsified before using such a financial statement as a base for investing, appraising, and taking other decisions.
There has been a research paper presented in the American University of Nigeria, which testified the efficacy of ‘CPT Analyses’ model for identifying false financial statements using SPSS. The paper demonstrate that conducting and implementing the proposed ‘CPT’Analysesor detection of false financial statements will, undoubtedly be helpful to professionals such asauditors, forensic accountants, insolvency practitioners, tax authorities, investors, consultants, banksand other users of financial statements.
SPSS help organizations succeed in combating fraud, waste, and abuse. For example, our solutions enable organizations to:
- Maximize tax revenues
- Manage compliance issues and detect improper payments
- Support anti-money-laundering efforts
- Combat other forms of fraud, waste, and abuse
Another major field of contribution is the health care sector, where deliberately submitting false claims to private health insurance plans or tax-funded insurance programs such as Medicare or Medicaid, is a serious and growing nationwide crime trend.
Likewise, there can be many other areas where SPSS can serve in and help the processes become smother.
http://www.sybase.com/content/1025531/iws_fraud_l02341.pdf
http://www.spss.com.sg/software_and_solutions.aspx?pageid=337&secid=300