2011年11月28日 星期一

[VBA] normscore functiom

## 套用在模組中
Function normscore(inde_num As Double, ref_leng As range)
X = Application.WorksheetFunction.Rank(inde_num, ref_leng, 1)
Y = Application.WorksheetFunction.Count(ref_leng) + 1
Z = Application.WorksheetFunction.NormSInv(X / Y)
normscore = Z
End Function

2011年11月23日 星期三

Genome Sizes

Table of Genome Sizes (haploid)
Base pairsGenesNotes
φX1745,38611virus of E. coli
Human mitochondrion16,56937
Epstein-Barr virus (EBV)172,28280causes mononucleosis
Nanoarchaeum equitans490,885552This parasitic member of the Archaea has the smallest genome of a true organism yet found.
nucleomorph of Guillardia theta551,264511all that remains of the nuclear genome of a red alga (a eukaryote) engulfed long ago by another eukaryote
Mycoplasma genitalium580,073485two of the smallest true organisms
Mycoplasma pneumoniae816,394680
Chlamydia trachomatis1,042,519936this bacterium causes the most common sexually-transmitted disease (STD) in the U.S.
Rickettsia prowazekii1,111,523834bacterium that causes epidemic typhus
Treponema pallidum1,138,0111,039bacterium that causes syphilis
Mimivirus1,181,4041,262A virus (of an amoeba) with a genome larger than the six cellular organisms above
Pelagibacter ubique1,308,7591,354smallest genome yet found in a free-living organism (marine α-proteobacterium)
Borrelia burgdorferi1.44 x 1061,738bacterium that causes Lyme disease [Note]
Campylobacter jejuni1,641,4811,708frequent cause of food poisoning
Helicobacter pylori1,667,8671,589chief cause of stomach ulcers (not stress and diet)
Thermoplasma acidophilum1,564,9051,509These unicellular microbes look like typical bacteria but their genes
are so different from those of either bacteria or eukaryotes that they are
classified in a third kingdom: Archaea.
Methanococcus jannaschii1,664,9701,783
Aeropyrum pernix1,669,6951,885
Methanobacterium
thermoautotrophicum
1,751,3772,008
Haemophilus influenzae1,830,1381,738bacterium that causes middle ear infections
Streptococcus pneumoniae2,160,8372,236the pneumococcus
Neisseria meningitidis2,184,4062,185Group A; causes occasional epidemics of meningitis in less developed countries.
Neisseria meningitidis2,272,3512,221Group B; the most frequent cause of meningitis in the U.S.
Encephalitozoon cuniculi2,507,5191,997(plus 69 RNA genes); a parasitic eukaryote.
Propionibacterium acnes2,560,2652,333causes acne
Listeria monocytogenes2,944,5282,9262,853 of these encode proteins; the rest RNAs
Deinococcus radiodurans3,284,1563,187on 2 chromosomes and 2 plasmids; bacterium noted for its resistance to radiation damage
Synechocystis3,573,4704,003a marine cyanobacterium ("blue-green alga")
Vibrio cholerae4,033,4603,890in 2 chromosomes; causes cholera
Mycobacterium tuberculosis4,411,5323,959causes tuberculosis
Mycobacterium leprae3,268,2031,604causes leprosy
Bacillus subtilis4,214,8144,779another bacterium
E. coli K-124,639,2214,3774,290 of these genes encode proteins; the rest RNAs
E. coli O157:H75.44 x 1065,416strain that is pathogenic for humans; has 1,346 genes not found in E. coli K-12
Agrobacterium tumefaciens4,674,0625,419Useful vector for making transgenic plants; shares many genes with Sinorhizobium meliloti
Salmonella enterica var Typhi4,809,0374,395+ 2 plasmids with 372 active genes; causes typhoid fever
Salmonella enterica var Typhimurium4,857,4324,450+ 1 plasmid with 102 active genes
Yersinia pestis4,826,1004,052on 1 chromosome + 3 plasmids; causes plague
Schizosaccharomyces pombe12,462,6374,929Fission yeast. A eukaryote with fewer genes than the four bacteria below.
Ralstonia solanacearum5,810,9225,129soil bacterium pathogenic for many plants; 1681 of its genes on a huge plasmid
Pseudomonas aeruginosa6.3 x 1065,570Increasingly common cause of opportunistic infections in humans.
Streptomyces coelicolor6,667,5077,842An actinomycete whose relatives provide us with many antibiotics
Sinorhizobium meliloti6,691,6946,204The rhizobial symbiont of alfalfa. Genome consists of one chromosome and 2 large plasmids.
Saccharomyces cerevisiae12,495,6825,770Budding yeast. A eukaryote.
Cyanidioschyzon merolae16,520,3055,331A unicellular red alga.
Plasmodium falciparum22,853,7645,268Plus 53 RNA genes. Causes the most dangerous form of malaria.
Thalassiosira pseudonana34.5 x 10611,242A diatom. Plus 144 chloroplast and 40 mitochondrial genes encoding proteins
Neurospora crassa38,639,76910,082Plus 498 RNA genes.
Naegleria gruberi41 x 10615,727This free-living unicellular organism lives as both an amoeboid and a flagellated form.
4,133 of its genes are also found in other eukaryotes suggesting that they were present in the
common ancestor of all eukaryotes. The great variety of functions encoded by these genes
also suggests that the common ancestor of all eukaryotes was itself as complex as many of the
present-day unicellular members.
Caenorhabditis elegans100,258,17121,733The first metazoan to be sequenced.
Arabidopsis thaliana115,409,949~28,000a flowering plant (angiosperm) See note.
Drosophila melanogaster122,653,977~17,000the "fruit fly"
Anopheles gambiae278,244,06313,683Mosquito vector of malaria.
Tetraodon nigroviridis (a pufferfish)3.42 x 10827,918Although Tetraodon seems to have more protein-encoding genes than we do, it has much less "junk" DNA so its total genome is about a tenth the size of ours.
Rice3.9 x 10828,236
Sea urchin8.14 x 108~23,300
Zebrafish1.2 x 10915,761
Dogs2.4 x 10919,300
Humans3.3 x 109~21,000[Link to more details.]
Mouse3.4 x 109~23,000
Amphibians109–1011?
Psilotum nudum2.5 x 1011?Note

2011年10月5日 星期三

[Coffee] 名詞備忘

1) Espresso 義式濃縮咖啡
小小杯的Espresso,是短時間內快速萃取的濃縮咖啡,可以用他來調配成各式花式咖啡。一般只有30毫升左右,味道很苦。
2) Americano 美式咖啡
小杯Espresso加入大半杯白開水。美式咖啡味道淡顏色淺,微酸微苦,可以加點糖和牛奶調和。
3) Caffé Latte 拿鐵咖啡
拿鐵咖啡是少量Espresso加入大量牛奶,上端會有一層奶泡,奶泡上可以發揮創意拉出各種各樣的拉花圖案。而“歐蕾咖啡”則是會將牛奶和咖啡同時倒入杯中。
4) Cappuccino 卡布奇諾
卡布奇諾和拿鐵咖啡有點相似,都是Espresso+牛奶+奶泡,但卡布奇諾奶泡比牛奶多,拿鐵則是牛奶比奶泡多,因此卡布奇諾通常比拿鐵小杯,且奶泡佔了很大部份,咖啡味濃。
5) Macchiato 瑪奇朵, Caramel Macchiato 焦糖瑪奇朵, Brown Sugar Macchiato 黑糖瑪奇朵
在Espresso只加入一些奶泡。可以大大享受到細膩綿密的奶泡,卻又不失咖啡原本的濃厚。
6) Caffé Mocha 摩卡咖啡
成份有Espresso、牛奶和巧克力醬,上方則是擠上鮮奶油和巧克力醬,另外也可以撒上可可粉或肉桂粉。風味很特別,層次很豐富。



2011年9月28日 星期三

[Drama] Wilfred slogan


EP1:Pilot:Happiness
理智和快樂不可能並存
"Sanity and happiness are an impossible combination." by Mark Twain.

EP2:Trust
只相信自己 就不會被背叛
"Trust thyself only, and another shall not betray thee." by Thomas Fuller.

EP3:Fear
恐懼有它的用處 懦弱卻沒有
"Fear has its use, but cowardice has none." by Mahatma Gandhi.

EP4:Acceptance
寬容才會有幸福 -
"Happiness can exist only in acceptance." by George Orwell.

EP5:Respect
想獲得尊重 就要先尊重自己
"Seek respect mainly from thyself, for it comes first from within." by Steven H. Coogler.

EP6:Conscience
良知是條不咬人的狗 但它總是叫個不停
"Conscience is the dog that can't bite, but will never stop barking." Proverb

EP7:Pride
通常傲慢是所有錯誤的根源
"In general, pride is at the bottom of all great mistakes." by Steven H. Coogler.

EP8:Anger
忍氣吞聲並不能讓怒氣平息 只會讓它越發膨脹
"Anger as soon as fed is dead - tis starving makes it fat." by Emiy Dickinson

EP9:Compassion
沒有憐憫之心 就不要對其妄加評論
"Make no judgements where you have no compassion." by Anne McCaffrey

EP10:Isolation
離群索居是事與願違的夢
"Isolation is a self-defeating dream." by Carlos Salinas de Gortari

EP11:Doubt
防人之心不可無 防過了頭反成仇
"Doubt must be no more than vigilance, otherwise it can become dangerous." by George C. Lichtenberg

EP12:Sacrifice
愛就是心甘情願的犧牲
"Love is a willingness to sacrifice." by Michael Novak

EP13:Identity
身份的價值在於它具有目的性
"The value of identity is that so often with it comes purpose." by Richard R. Grant


2011年9月24日 星期六

[Stat]共線性(Collinearity)與交互(Interaction)作用

交互作用

Interaction

共線性

Collinearty

範例

x1x2 y

y=α+β1x1+β2x2+ε

x1x2 y

y=α+β1x1+β2x2+ε

意義

2個變項一同對y作用時,有協同或拮抗現象,若2變項對y存在交互作用時,應該只放入交互作用項,EX: x1x2存在交互作用,則放入迴歸的應為x1*x2,而非x1x2

2變項之間的相關性很高,通常為Pearson's correlation大於0.8時,EX: x1x2有高度相關,表示x1x2y的影響存在共線性,此時只能選x1x2其中一個放入迴歸裡,判定的依據為看哪個變項對y的預測比較重要。

檢查方法

TWO-WAY ANOVA

相關矩陣、CI值、VIFTolerance

結論

所以當迴歸分析要放入變項時,要先檢查變項間的共線性,先解決共線性的問題,再去探討是否有交互作用項的存在。