Marketing | Business science | Decision support | Competitive intelligence | Life science | Research methodologies | Info-graphics |Tools | Books

Thursday 19 April 2012

Basics of stats

Eight Things You Should Know About Statistics! according to
 
1. Assumptions: What are the assumptions underpinning the research? As seen from recent debate on CBO numbers for the U.S. health reform package, assumptions matter tremendously.
2. History: How much historical data was used in the study? What was the time scale? As seen from the 2008 financial crisis, the models used by Wall Street mavens often only took into account 10 years of data in judging the volatility and probability of failure of complex financial instruments.
3. Samples: Are the samples selected randomly? From what populations? Is there enough data for statistical significance?
4. Data Quality: The output is only going to be as good as the quality of data feeding the analysis. Garbage in, garbage out.
5. Survivorship Bias: Author Nassim Taleb points out that “losers are often not in the sample.” Does the analysis include a population of survivors and those who also failed?
6. Falsification and Omission: Yes, in an era of IPCC’s Climate Gate, one needs to ascertain if data are hidden, missing or outliers ignored.
7. Association equals causation fallacy: Correlation does not equate to causation (a common mistake made by marketing and finance executives alike).
8. Proper Application of Statistics: The effective use of statistics by insurance actuaries, scientists, and even casino managers is well-documented. However, real danger results when mathematical concepts are used to denote certainty indecision-making and divining behavior of markets.

Monday 6 February 2012

Micro-array data analysis using R

Micro-array data analysis is the complicated procedure involving preprocessing, Statistical  analysis and finally giving biological meaning to the observed changes.  R programming makes Micro-array data analysis much simpler and analyst should know which point he has to stop.  In R, all the steps of Micro-array data analysis can be completed starting from preprocessing, hierarchical clustering, Heat maps, Statistical analysis and mapping to GO ontologies or KEGG pathways etc.  Data generated from different platform such as Affymetrix, Agilent, and Illumina can be analyzed in R. The important libraries required for the Micro-array data analysis are affy, limma, simpleaffy, amap, KEGG, geneListPie  etc. 

The following are screen shots of the analysis of Micro-array data analysis of high-throughput data Affymetrix platform
Chip QC

RNA degradation plot

Intensity Plot

HeatMap

KEGG Pathway mapping

Source:


Thursday 2 February 2012

Return of Investment from Solar Water Heater

Solar water heaters are becoming more popular because of higher electricity bill and they go green and environment friendly.  The solar heaters are safer compared to electric geysers.   The only requirement to install Solar heater is to have plenty of Sun light either on terrace or wall, which is free off course.  Solar heater in simple has two parts, one for heating/ collectors and other tank for collecting the hot water.
Though the initial investment to install Solar heater is huge, but is more economy since it will reduce the electricity bill of house hold by at least 40%.  The well maintained Solar heater will run for 15 to 20 years returning the investment within 8 years.  It is conclude from the plot that investment on Solar water heater is worth.  The ROI from Solar Water  Heater is shown as

* The use pattern and savings for southern region pertains to the typical climate of Bangalore, while those for western region relate typically to Pune climate.

Sources:

Tuesday 31 January 2012

Indian Australian White Wash 0-4

The recently concluded Border-Gavaskar Series opens many questions on Indian performance.  Overall with 8 innings of 4 Test matches, No batsman could able to score more than 300 runs.  Among the batsman, Kohli is the only person who scored 300 runs facing 579 balls with strike rate of 52%.   When considering the number of Balls faced, Kohli, Tendulkar and Dravid have faced more than 500 balls in 8 innings. 


Looking at the strike rate, we can clearly infer that Indian players are in rush to score runs and never want to be at crease for long time similar to T20 matches, which is the main reason for the recent devastating white wash in Australia.  BCCI should look into these criteria and should select team based on the situation and not on the names to save Indian Test Cricket




Data

PlayerRuns Scored in SeriesBalls faced in SeriesStrike rate in Series
Gambhir
181
445
40.6741573
Sehwag
198
257
77.04280156
Dravid
194
551
35.20871143
Tendulkar
287
518
55.40540541
Laxman
155
390
39.74358974
Kohli
300
579
51.8134715
Dhoni*
102
177
57.62711864
Ashwin*
163
225
72.44444444
Khan
69
86
80.23255814
Sharma
33
140
23.57142857
Yadav
28
81
34.56790123
Kumar*
11
24
45.83333333
Saha*
38
114
33.33333333
*Not played in all 8 innings



Source:
http://scores.sify.com/match/scorecard/AUS_IND_DEC26_DEC30.shtml
http://scores.sify.com/match/scorecard/AUS_IND_JAN03_JAN07.shtml
http://scores.sify.com/match/scorecard/AUS_IND_JAN13_JAN17_2012.shtml
http://scores.sify.com/match/scorecard/AUS_IND_JAN24_JAN28_2012.shtml

Monday 30 January 2012

From Crude Oil to Petrol bunk

The crude oil is a mixture of long hydrocarbon molecules which are recombined into shorter molecules during refining.  Typically one barrel of crude oil which equals 42 gallons (158 Ltr) will yield 44.6  gallons (164 Ltr) of refined products including tar, gasoline/petrol, diesel and jet fuel to heating oil and natural gas.

Currently crude oil is priced around $110, the following table gives the price of petroleum products to rise in Crude oil price


Ltr
Cost ($)
Cost Per ltr ($)*
Cost ($)
Cost Per ltr ($)*
Cost ($)
Cost Per ltr ($)*
1 Barrel crude oil
158.8
100
0.629881582
150
0.944822
200
1.259763
Petrol
74.6
47
0.629881582
70.5
0.944822
141
1.889645
Diesel and Heating oil
36.5
23
0.629881582
34.5
0.944822
69
1.889645
Other products
28.6
18
0.629881582
27
0.944822
54
1.889645
Jet fuel
15.9
10
0.629881582
15
0.944822
30
1.889645
Liquified petroleum/ LPG
6.4
4
0.629881582
6
0.944822
12
1.889645
Asphalt/Tar
4.8
3
0.629881582
4.5
0.944822
9
1.889645
*plus production charges


Indian Scenario,  For every Barrel of crude oil imported, the charge of the oil increases by import duty etc.  Finally when it is processed and goes to end user in the form of petrol, for every ltr of petrol, user will have to bear 100% additional charge to the basic crude oil price.
The forecasted fuel price in India, if the current tax system and other charges remain same is illustrated below.


<><>
<> Data
<><>

Barrel cost in $
80
100
150
200

Actual petrol price in Rs.*
23
30
47.2
94.5

Central share  (70% of basic)
18
21
33.04
66.15

State Govt Share (33% of basic, varies from State to State)
8
9.9
15.576
31.185

Transportation  (33% of Basic)
8
9.9
15.576
31.185

Dealer charge
1
1
1
1

Cost to end user Rs.
58
72
112
224

*Considering $ value at Rs. 50


The revenue generated from petrol selling in India, considering the average 5% increase from 2009, 3600,000 barrels per day, accounts for 13100000000 barrels per year for 2012.  The Government revenue generated from petrol sale alone is around 16 lakhs crores for Central Government and 7 lakhs crores for State Government  which off course vary for State to State depending on the taxation.

Watch out for our next blog will focus on alternative resources to reduce petrol consumption.


Sources: