<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />我有一些相當大的增長數據集,我希望通過以下方式消除增長數據:
- 確定每天的最大增長並存儲每天最大增長的日期時間
- 對於確定最大生長的每個連續日期時間運行線性回歸(雙變量(Y(生長),X(日期時間),擬合線)。 例如,按日期時間1和日期時間2回歸最大增長1和最大增長2,然後按日期時間2和日期時間3等最大增長2和最大增長3。
- 創建一個新變量(adj_growth),該變量是根據公式創建的,該公式使用線性回歸結果計算日期時間的增長,該日期時間位於確定最大增長的連續日期時間對之間。 例如,如果datetime> = datetime 1&datetime <= datetime 2,那麼,adj_growth = m + b *增長,否則datetime> = datetime 2&datetime <= datetime 3,那麼,adj_growth = m + b *增長,否則...... ............
我已經能夠編寫完成第1步的一些JSL(見下文),但我對如何完成第2步和第3步感到困惑。 我很感激有關如何解決這些問題的任何建議。 在此先感謝您的幫助!
清除日誌();
名稱默認為此處(1);
dt_growth =新表(“增長”,
新欄目(“日期和時間”,
數字,
連續,
格式(“m / d / yh:m”,12),
輸入格式(“m / d / yh:m”),
設定值(
[3225884400,3225888000,3225891600,3225895200,3225898800,
3225902400,3225906000,3225909600,3225913200,3225916800,
3225920400,3225924000,3225927600,3225931200,3225934800,
3225938400,3225942000,3225945600,3225949200,3225952800,
3225956400,3225960000,3225963600,3225967200,3225970800,
3225974400,3225978000,3225981600,3225985200,3225988800,
3225992400,3225996000,3225999600,3226003200,3226006800,
3226010400,3226014000,3226017600,3226021200,3226024800,
3226028400,3226032000,3226035600,3226039200,3226042800,
3226046400,3226050000,3226053600,3226057200,3226060800,
3226064400,3226068000,3226071600,3226075200,3226078800,
3226082400,3226086000,3226089600,3226093200,3226096800,
3226100400,3226104000,3226107600,3226111200,3226114800,
3226118400,3226122000,3226125600,3226129200,3226132800,
3226136400,3226140000,3226143600,3226147200,3226150800,
3226154400,3226158000,3226161600,3226165200,3226168800,
3226172400,3226176000,3226179600,3226183200,3226186800,
3226190400,3226194000,3226197600,3226201200,3226204800,
3226208400,3226212000,3226215600,3226219200,3226222800,
3226226400,3226230000,3226233600,3226237200,3226240800,
3226244400,3226248000,3226251600,3226255200,3226258800,
3226262400,3226266000,3226269600,3226273200,3226276800,
3226280400,3226284000,3226287600,3226291200,3226294800,
3226298400,3226302000,3226305600,3226309200,3226312800,
3226316400,3226320000,3226323600,3226327200,3226330800,
3226334400,3226338000,3226341600,3226345200,3226348800,
3226352400,3226356000,3226359600,3226363200,3226366800,
3226370400,3226374000,3226377600,3226381200,3226384800,
3226388400,3226392000,3226395600,3226399200,3226402800,
3226406400,3226410000,3226413600,3226417200,3226420800,
3226424400,3226428000,3226431600,3226435200,3226438800,
3226442400,3226446000,3226449600,3226453200,3226456800,
3226460400,3226464000,3226467600,3226471200,3226474800,
3226478400,3226482000,3226485600,3226489200,3226492800,
3226496400,3226500000,3226503600,3226507200,3226510800,
3226514400,3226518000,3226521600,3226525200,3226528800,
3226532400,3226536000,3226539600,3226543200,3226546800,
3226550400,3226554000,3226557600,3226561200,3226564800,
3226568400,3226572000,3226575600,3226579200,3226582800,
3226586400,3226590000,3226593600,3226597200,3226600800,
3226604400,3226608000,3226611600,3226615200,3226618800,
3226622400,3226626000,3226629600,3226633200,3226636800,
3226640400,3226644000,3226647600,3226651200,3226654800,
3226658400,3226662000,3226665600,3226669200,3226672800,
3226676400,3226680000,3226683600,3226687200,3226690800,
3226694400,3226698000,3226701600,3226705200,3226708800,
3226712400,3226716000,3226719600,3226723200,3226726800,
3226730400,3226734000,3226737600,3226741200,3226744800,
3226748400,3226752000,3226755600,3226759200,3226762800,
3226766400,3226770000,3226773600,3226777200,3226780800,
3226784400,3226788000,3226791600,3226795200,3226798800,
3226802400,3226806000,3226809600,3226813200,3226816800,
3226820400,3226824000,3226827600,3226831200,3226834800,
3226838400,3226842000,3226845600,3226849200,3226852800,
3226856400,3226860000,3226863600,3226867200,3226870800,
3226874400,3226878000,3226881600,3226885200,3226888800,
3226892400,3226896000,3226899600,3226903200,3226906800]
)
)
新列(“年”,數字,連續,格式(“最佳”,8),公式(年份(:名稱(“日期和時間”))),鎖定(1)),
新列(“月”,數字,連續,格式(“最佳”,8),公式(月(:名稱(“日期和時間”))),鎖(1)),
新列(“日”,數字,連續,格式(“最佳”,8),公式(日(:名稱(“日期和時間”))),鎖(1)),
新列(“小時”,數字,連續,格式(“最佳”,8),公式(小時(:名稱(“日期和時間”))),鎖定(1)),
新列(“日期”,數字,連續,格式(“m / d / y”,10),公式(日期MDY(:月,:日,:年)),鎖定(1)),
新專欄(“增長”,
數字,
連續,
格式(“固定十二月”,12,3),
設定值(
[-0.00100011424000851,-0.000363872799278378,-0.000363871984284188,
-0.00100005824000851,-0.00227235992075627,-0.00418081408649503,-
0.00545309175689348,-0.00736156445270497,-0.00736136657166755,-
0.00545294517616856,-0.00672516584616703,-0.00354446026036948,-
0.00227219704017202,0.00154456188025604,0.00726960356524363,
0.00790566809993933,0.0129946043300728,0.0142672814031039,
0.0142680804082943,0.0212680506560791,0.021269003361861,
0.0219050687116747,0.0212692891739123,0.014270349583592,
0.0161791280461629,0.0123615072003508,0.014269902140721,
0.0104520647031608,-0.0022725075312535,-0.00418091710202046,
0.00663394656359483,0.0123593477559727,0.0212654783489747,
0.0288989636199062,0.0346241368109538,0.0435298706416388,
0.0734286369895607,0.072790864489845,0.0632482414590739,
0.063884648195645,0.0740617924812754,0.10524374653983,
0.105238560337556,0.106520183190921,0.095705821744203,
0.0721597475663495,0.0823432919531381,0.0829770846230983,
0.0944282992395635,0.0918775750507814,。,。,。,。,。,。,。,。,。,。,
。,。,。,。,。,。,。,。,。,。,。,。,。,。,。,。,。,。,。,。,。,。,。
。,。,。,。,。,。,。,。,。,。,。,。,。,。,。,。,。,。,。,。,。,。,。
。,。,。,。,。,。,0.132598446121035,0.142136100159265,
0.144047485365236,0.141510082527217,0.133243284004832,
0.136430823506921,0.129433763704459,。,0.116070160678918,
0.115432357842292,0.117340824227052,0.114794572105785,
0.114790201208717,0.114151689739583,0.113513458180752,
0.112872468220974,0.115423050522635,0.143405851093052,
0.138950940416588,0.140217253219071,0.144662268859769,
0.14847441971641,0.152290783704404,0.155475963397883,
0.164426756532424,0.16760053536469,0.162514344711853,
0.159332058795417,0.151068736269937,0.149160923755755,
0.137709192270229,0.130708924366787,0.123070306637102,
0.117974687738857,0.119245809936872,0.17176106775782,
0.122413756226772,0.130047595709665,0.145948812468612,
0.150402142613181,。,。,0.05,0.04,0.045,。,。,。,。,。,。,。,。,。,
。,。,。,。,。,。,。,。,。,。,。,。,。,。,。,。,。,。,。,。,。,。,。
。,。,。,。,。,。,。,。,。,。,。,。,。,。,。,。,。,。,。,。,。,。,。
。,。,。,。,。,。,。,。,。,。,。,。,。,。,。,。,。,。,。,。,。,。,。
。,0.41763939536042,0.415693459004884,0.411893026189672,
0.409996367624642,0.406806168639344,0.405541937379636,
0.403607071498291,0.409315222566001,0.409944023628439,
0.409934840470904,0.413750645246311,0.417566432921535,
0.422655385641797,0.42965365812232,0.436654896453155,
0.44364930329344,0.45064765414928,0.457646036355387,
0.467820889024742,0.481185887340017,0.493284494492094,
0.49456564669957,0.499026564408861,0.501492132922427,
0.50285933023531,0.506056129447622,0.506702549723624,
0.506067464368605,0.507337632217846,0.504137348451565,
0.500946283675119,0.504757712657227,0.512386052830777,
0.520015386838913,0.529555420635595,0.539096576517502,
0.553087055836816,0.567072203175747,0.581062055491441,
0.593783392145494,0.603324019354862,0.617957789218505,
0.630681868813513,0.640872945402754,0.6656757530753031,
0.659356671575131,0.660007636808086,0.665113592325388]
)
)
);
等(2);
//每天獲得最高增長
總結(growth_date_list = by(dt_growth:Date),max_growth_list = Max(dt_growth:Growth));
//將max_growth_list(當前為矩陣[])轉換為列表{}
是List(max_growth_list = As List(max_growth_list));
等等(10);
//現在獲得最高增長的日期
對於(i = 1,i <= N項(max_growth_list),i ++,
one_growth_date = growth_date_list ;
one_growth = max_growth_list ;
//可以在不同的時間內獲得相同的最大增長
one_growth_date_max_rows = dt_growth <<獲取行所在的位置(
:Date == Num(one_growth_date)&:Growth == one_growth
);
對於(k = 1,k <= N行(one_growth_date_max_rows),k ++,
m = one_growth_date_max_rows;
one_date =:日期;
one_date_time =:name(“日期和時間”);
one_hour =:小時;
date_time_list = Insert(date_time_list,:name(“Date&Time”)));
hour_list =插入(hour_list,:小時);
打印(
“最大增長”||格式(one_growth,“Fixed Dec”,3)|| “發生在”||
格式(one_date_time,“m / d / yh:m”)
);
);
);