RT-PCR数据分析通用表格

RelativeQuantitiveReal-TimePCRDataAnalysisWu&WangSampleandPositionWellDescriptionOverviewof96-WellPlate大概示意图A1controlA2123A3Asample1sample1sample1B1sample2Bsample2sampe2sample2B2Csample3sample3sample3B3Dsample4sample4sample4C1sample3Esample5sample5sample5C2Fsample6sample6sample6C3Gsample7sample7sample7D1sample4Hsample8sample8sample8D2D3IntruductionE1sample5YouneedtomodifythecontentsoftheblueshapedcellsE2OthercellswillbemodifiedautomaticallyE3modifyregionF1sample6automaticallymodifiedregionF2finalresultsF3Abbrivate:G1sample7TREtargetG2REFreferenceG3CalculateMethod:H1sample82^(-(delta-delta-CT))H2H3直方图是根据dataanalysis表中紫颜色的格的值画出的A4sample9Mean是平均值，Min和Max是用来画直方图上边那个误差bar的A5dataanalysis是按照每个样本重复三次计算的A6需要手动整理real-time机器给出的结果，然后贴到本excel中，excel会自动计算最终结果并画图B4sample10图的格式可根据需要修改B5B6C4sample11C5C6D4sample12D5D6E4sample13E5E6F4sample14F5F6G4sample15G5G6H4sample16H5H6A7sample17A8A9B7sample18B8B9C7sample19C8C9D7sample20D8D9E7sample21E8E9F7sample22F8F9G7sample23G8G9H7sample24H8H92007大概示意图456789sample9sample9sample9sample17sample17sample17sample10sample10sample10sample18sample18sample18sample11sample11sample11sample19sample19sample19sample12sample12sample12sample20sample20sample20sample13sample13sample13sample21sample21sample21sample14sample14sample14sample22sample22sample22sample15sample15sample15sample23sample23sample23sample16sample16sample16sample24sample24sample24YouneedtomodifythecontentsoftheblueshapedcellsOthercellswillbemodifiedautomatically直方图是根据dataanalysis表中紫颜色的格的值画出的Mean是平均值，Min和Max是用来画直方图上边那个误差bar的dataanalysis是按照每个样本重复三次计算的需要手动整理real-time机器给出的结果，然后贴到本excel中，excel会自动计算最终结果并画图只需要改这两行WellDescriptionCT/TRECT/REFSD-CT/TRESD-CT/REFAVECT/TREA1control19.0115.060.72397050.22338319.223333A218.6315.38A320.0314.95B1DAC48hr19.6814.90.790.02645819.28B218.3714.95B319.7914.94C1DAC96HR20.5914.950.19218050.07234220.416667C220.2114.94C320.4515.07D1D2D3E1E2E3F1F2F3G1这两行需要手动粘过来G2G3H1H2H3A4A5A6B4B5B6C4C5C6D4D5D6E4E5E6F4F5F6G4G5G6H4H5H6A7A8A9B7B8B9C7C8C9D7D8D9E7E8E9F7F8F9G7G8G9H7H8H92-delta-delta-CT(C.I)AVECT/REFdeltaCTSD-deltaCTdelta-delta-CTMeanMax15.134.093330.75764988011.69073420414.934.350.790442910.2566666670.837019611.44771362414.98666675.430.205345241.3366666670.39593440.456497407MinMax-meanMean-Min0.5914590230.6907342040.4085409770.4839367540.6106940110.3530828580.3434062250.0605630050.05252817800.20.40.60.811.21.41.61.8RelativemRNAlevel