cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Naohiro Masukawa

%3CLINGO-SUB%20id%3D%22lingo-sub-779220%22%20slang%3D%22ja-JP%22%20mode%3D%22CREATE%22%3EIs%20the%20economic%20downturn%20signal%20on%3F%20Calculate%20and%20visualize%20the%20signal%20%22therm%20rule%22%20in%20JMP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-779220%22%20slang%3D%22ja-JP%22%20mode%3D%22CREATE%22%3E%3CP%3E%3CFONT%20size%3D%224%22%3ELast%20weekend%2C%20while%20the%20world%20was%20paying%20attention%20to%20the%20performance%20of%20athletes%20at%20the%20Paris%20Olympics%2C%20the%20July%20employment%20statistics%20were%20released%20in%20the%20United%20States.%20The%20unemployment%20rate%20in%20this%20employment%20statistics%20exceeded%20market%20expectations%2C%20and%20the%20%22Sahm%20%3CSTRONG%3E%E2%80%8B%E2%80%8BRule%3C%2FSTRONG%3E%20%2C%22%20a%20signal%20of%20an%20economic%20recession%2C%20was%20lit%2C%20which%20became%20a%20hot%20topic.%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3EThe%20Sarm%20rule%20is%20calculated%20based%20on%20the%20unemployment%20rate%20proposed%20by%20former%20Federal%20Reserve%20Board%20member%20Claudia%20Sarm.%20Specifically%2C%20%3CSTRONG%3Eit%20states%20that%20if%20the%20value%20(percentage)%20exceeds%200.5%2C%20there%20is%20a%20high%20possibility%20of%20the%20economy%20falling%20into%20a%20recession.%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3EIn%20this%20employment%20report%2C%20the%20unemployment%20rate%20for%20July%202024%20was%20announced%20to%20be%204.3%25%2C%20with%20the%20therm%20rule%20percentage%20being%200.53%2C%20the%20first%20time%20it%20has%20exceeded%200.5%20since%20COVID-19.%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Masukawa_Nao_0-1722835890787.png%22%20style%3D%22width%3A%20532px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Masukawa_Nao_0-1722835890787.png%22%20style%3D%22width%3A%20532px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Masukawa_Nao_0-1722835890787.png%22%20style%3D%22width%3A%20532px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F66826iF115834205918278%2Fimage-dimensions%2F532x386%3Fv%3Dv2%22%20width%3D%22532%22%20height%3D%22386%22%20role%3D%22button%22%20title%3D%22Masukawa_Nao_0-1722835890787.png%22%20alt%3D%22Masukawa_Nao_0-1722835890787.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3EThe%20Therm%20Rule%20percentage%20is%20calculated%20from%20the%20monthly%20unemployment%20rate%20using%20the%20following%20definition%3A%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3E%E2%91%A0%20Average%20unemployment%20rate%20for%20the%20past%20three%20months%20(three-month%20moving%20average)%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3E%E2%91%A1The%20minimum%20of%20the%20three-month%20moving%20average%20over%20the%20past%2012%20months%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3E%3CSTRONG%3EPercentage%20(therm%20rule)%20%3D%20%E2%91%A0%20-%20%E2%91%A1%20(if%20%E2%89%A7%200.5%20the%20therm%20rule%20signal%20will%20light%20up)%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3EIn%20this%20blog%2C%20we%20will%20calculate%20this%20percentage%20using%20monthly%20unemployment%20rate%20data%20in%20a%20JMP%20data%20table%20and%20visualize%20the%20trend%20in%20this%20value%20using%20a%20graph.%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%225%22%20color%3D%22%23FF6600%22%3EFunction%20to%20calculate%20moving%20average%20in%20JMP%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3EThe%20therm%20rule%20percentage%20is%20calculated%20as%20follows%3A%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3COL%20class%3D%22lia-list-style-type-lower-roman%22%3E%0A%3CLI%3E%3CFONT%20size%3D%224%22%3ECalculate%20the%20%223-Month%20Average%22%20from%20the%20%22Unemployment%20Rate%22%20(%E2%91%A0)%3C%2FFONT%3E%3C%2FLI%3E%0A%3CLI%3E%3CFONT%20size%3D%224%22%3ECalculate%20%22Minimum%20of%203-Month%20Average%20in%20Prior%2012%20Months%22%20from%20%223-Month%20Moving%20Average%22%3C%2FFONT%3E%3C%2FLI%3E%0A%3CLI%3E%3CFONT%20size%3D%224%22%3ESubtract%20%E2%91%A1%20from%20%E2%91%A0%20(Percentage%20(Sahm%20Rule))%3C%2FFONT%3E%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Masukawa_Nao_0-1722844502907.png%22%20style%3D%22width%3A%20525px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Masukawa_Nao_0-1722844502907.png%22%20style%3D%22width%3A%20525px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Masukawa_Nao_0-1722844502907.png%22%20style%3D%22width%3A%20525px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F66829i90C65A86E2FECD04%2Fimage-dimensions%2F525x358%3Fv%3Dv2%22%20width%3D%22525%22%20height%3D%22358%22%20role%3D%22button%22%20title%3D%22Masukawa_Nao_0-1722844502907.png%22%20alt%3D%22Masukawa_Nao_0-1722844502907.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3EAs%20an%20example%2C%20to%20calculate%20the%20percentage%20for%20the%20most%20recent%20month%20of%20July%202024%2C%20follow%20these%20steps%3A%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3COL%20class%3D%22lia-list-style-type-lower-roman%22%3E%0A%3CLI%3E%3CFONT%20size%3D%224%22%3E3-month%20moving%20average%3A%20(4%20%2B%204.1%20%2B%204.3)%20%C3%B7%203%20%3D%204.13%3C%2FFONT%3E%3C%2FLI%3E%0A%3CLI%3E%3CFONT%20size%3D%224%22%3EMinimum%20of%203-month%20moving%20average%20(yellow%20part%20above)%20over%20the%20past%2012%20months%20%3D%203.6%20(July%202023)%3C%2FFONT%3E%3C%2FLI%3E%0A%3CLI%3E%3CFONT%20size%3D%224%22%3EPercentage%3A%204.13%20-%203.6%20%3D%200.53%3C%2FFONT%3E%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3ELet's%20calculate%20it%20using%20the%20JMP%20formula.%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3ETo%20calculate%20the%20three-month%20moving%20average%20of%20i.%2C%20use%20the%20%3CFONT%20color%3D%22%23000000%22%3ECol%20Moving%20Average()%3C%2FFONT%3E%20function%20to%20calculate%20the%20moving%20average%20and%20specify%20the%20following%20formula%3A%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Masukawa_Nao_0-1722845179312.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Masukawa_Nao_0-1722845179312.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Masukawa_Nao_0-1722845179312.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F66831i8EF02412279A748D%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Masukawa_Nao_0-1722845179312.png%22%20alt%3D%22Masukawa_Nao_0-1722845179312.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3EThere%20are%20many%20arguments%2C%20but%20by%20clicking%20the%20%3F%20icon%20at%20the%20top%20of%20the%20formula%20editor%2C%20help%20will%20appear%20and%20you%20can%20check%20the%20meaning%20of%20each%20argument.%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Masukawa_Nao_1-1722845317543.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Masukawa_Nao_1-1722845317543.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Masukawa_Nao_1-1722845317543.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F66832iB90A84C386C64F7D%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Masukawa_Nao_1-1722845317543.png%22%20alt%3D%22Masukawa_Nao_1-1722845317543.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3EThe%20numeric%20arguments%201%2C%202%2C%200%2C%20and%201%20have%20the%20following%20meanings%3A%3C%2FFONT%3E%3C%2FP%3E%0A%3CTABLE%20border%3D%221%22%20width%3D%22100%25%22%3E%0A%3CTBODY%3E%0A%3CTR%3E%0A%3CTD%20width%3D%2221.913580246913575%25%22%3E%3CSTRONG%3E%3CFONT%20size%3D%224%22%3Eargument%3C%2FFONT%3E%3C%2FSTRONG%3E%3C%2FTD%3E%0A%3CTD%20width%3D%226.584362139917703%25%22%3E%3CSTRONG%3E%3CFONT%20size%3D%224%22%3E%E5%80%A4%3C%2FFONT%3E%3C%2FSTRONG%3E%3C%2FTD%3E%0A%3CTD%20width%3D%2271.50205761316873%25%22%3E%3CSTRONG%3E%3CFONT%20size%3D%224%22%3Emeaning%3C%2FFONT%3E%3C%2FSTRONG%3E%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3CTR%3E%0A%3CTD%20width%3D%2221.913580246913575%25%22%3E%3CFONT%20size%3D%224%22%3Eweighting%3C%2FFONT%3E%3C%2FTD%3E%0A%3CTD%20width%3D%226.584362139917703%25%22%3E%3CFONT%20size%3D%224%22%3E1%3C%2FFONT%3E%3C%2FTD%3E%0A%3CTD%20width%3D%2271.50205761316873%25%22%3E%3CFONT%20size%3D%224%22%3EWhen%20calculating%20the%20moving%20average%2C%20the%20weight%20is%20set%20to%201%20(no%20weighting%20is%20given%20to%20past%20values).%3C%2FFONT%3E%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3CTR%3E%0A%3CTD%20width%3D%2221.913580246913575%25%22%3E%3CFONT%20size%3D%224%22%3Ebefore%3C%2FFONT%3E%3C%2FTD%3E%0A%3CTD%20width%3D%226.584362139917703%25%22%3E%3CFONT%20size%3D%224%22%3E2%3C%2FFONT%3E%3C%2FTD%3E%0A%3CTD%20width%3D%2271.50205761316873%25%22%3E%3CFONT%20size%3D%224%22%3EThe%20target%20is%20up%20to%20two%20points%20in%20time%20(the%20average%20of%20the%20current%20point%2C%20the%20point%20one%20point%20in%20time%2C%20and%20the%20point%20two%20points%20in%20time)%3C%2FFONT%3E%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3CTR%3E%0A%3CTD%20width%3D%2221.913580246913575%25%22%3E%3CFONT%20size%3D%224%22%3Eafter%3C%2FFONT%3E%3C%2FTD%3E%0A%3CTD%20width%3D%226.584362139917703%25%22%3E%3CFONT%20size%3D%224%22%3E0%3C%2FFONT%3E%3C%2FTD%3E%0A%3CTD%20width%3D%2271.50205761316873%25%22%3E%3CFONT%20size%3D%224%22%3EValues%20%E2%80%8B%E2%80%8Bafter%20the%20current%20time%20are%20not%20included%3C%2FFONT%3E%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3CTR%3E%0A%3CTD%20width%3D%2221.913580246913575%25%22%3E%3CFONT%20size%3D%224%22%3Epartial%20window%20is%20missing%3C%2FFONT%3E%3C%2FTD%3E%0A%3CTD%20width%3D%226.584362139917703%25%22%3E%3CFONT%20size%3D%224%22%3E1%3C%2FFONT%3E%3C%2FTD%3E%0A%3CTD%20width%3D%2271.50205761316873%25%22%3E%3CFONT%20size%3D%224%22%3EIf%20you%20set%20it%20to%201%2C%20the%20data%20that%20has%20values%20%E2%80%8B%E2%80%8Bup%20to%20two%20points%20in%20time%20will%20be%20included%20(in%20the%20example%2C%20the%20values%20%E2%80%8B%E2%80%8Bin%20the%20first%20and%20second%20rows%20will%20be%20missing%20values).%20If%20you%20set%20it%20to%200%2C%20the%20first%20row%20will%20contain%20the%20current%20value%2C%20and%20the%20second%20row%20will%20contain%20the%20average%20of%20the%20current%20value%20and%20the%20value%20one%20point%20in%20time%20before.%3C%2FFONT%3E%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3C%2FTBODY%3E%0A%3C%2FTABLE%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3EThe%20minimum%20value%20of%20the%20three-month%20moving%20average%20for%20the%20past%2012%20months%20in%20%E2%85%B1%20uses%20%3CSTRONG%3Ethe%20Lag(x%2C%20n)%3C%2FSTRONG%3E%20function%2C%20where%20n%20returns%20the%20value%20of%20column%20x%20n%20points%20prior.%20Here%2C%20we%20are%20calculating%20the%20minimum%20value%20among%20the%20three-month%20moving%20averages%20from%201%20point%20prior%20to%2012%20points%20prior.%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Masukawa_Nao_0-1722846578989.png%22%20style%3D%22width%3A%20289px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Masukawa_Nao_0-1722846578989.png%22%20style%3D%22width%3A%20289px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Masukawa_Nao_0-1722846578989.png%22%20style%3D%22width%3A%20289px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F66833iD0A4947E19E457E3%2Fimage-dimensions%2F289x327%3Fv%3Dv2%22%20width%3D%22289%22%20height%3D%22327%22%20role%3D%22button%22%20title%3D%22Masukawa_Nao_0-1722846578989.png%22%20alt%3D%22Masukawa_Nao_0-1722846578989.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%20color%3D%22%23000000%22%3EFinally%2C%20subtract%20the%20value%20found%20in%20ii%20from%20the%20value%20found%20in%20i.%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%225%22%20color%3D%22%23FF6600%22%3EChanges%20in%20unemployment%20rate%20and%20therm%20rule%20since%202000%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3ENow%20that%20we%20have%20the%20values%2C%20we%20can%20use%20Graph%20Builder%20to%20plot%20the%20unemployment%20rate%20(top%20of%20the%20graph)%20and%20the%20therm%20rule%20percentage%20(bottom%20of%20the%20graph)%20over%20time.%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Masukawa_Nao_3-1722847254717.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Masukawa_Nao_3-1722847254717.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Masukawa_Nao_3-1722847254717.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F66837iB40D89E5DA6566F5%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Masukawa_Nao_3-1722847254717.png%22%20alt%3D%22Masukawa_Nao_3-1722847254717.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3EThe%20trend%20in%20the%20unemployment%20rate%20is%20shown%20by%20the%20orange%20broken%20line%2C%20and%20although%20there%20is%20a%20slight%20upward%20trend%2C%20looking%20at%20the%20smooth%20line%20(red%20dotted%20line)%2C%20it%20is%20difficult%20to%20say%20that%20the%20trend%20is%20still%20upward.%20If%20the%20unemployment%20rate%20continues%20to%20remain%20flat%20or%20rise%20in%20the%20future%2C%20the%20smooth%20line%20will%20also%20show%20an%20upward%20trend.%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3ELooking%20at%20the%20therm%20rule%20percentages%20(blue%20bar%20graph)%2C%20we%20can%20see%20that%20there%20have%20been%20three%20large%20peaks%20in%20the%20past%202000s.%3C%2FFONT%3E%3CFONT%20size%3D%224%22%3EThe%20main%20causes%20of%20these%20peaks%20are%20the%20IT%20bubble%20around%202001%2C%20the%20Lehman%20shock%20around%202008%2C%20and%20the%20coronavirus%20shock%20of%202020.%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3EExcluding%20the%20coronavirus%20shock%2C%20in%20the%20most%20recent%20period%20(2023%20to%20July%202024)%2C%20it%20appears%20that%20a%20peak%20is%20beginning%20to%20form%2C%20similar%20to%20those%20seen%20during%20the%20IT%20bubble%20and%20the%20Lehman%20shock.%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3EWill%20the%20economy%20really%20enter%20a%20recession%3F%20Incidentally%2C%20if%20the%20unemployment%20rate%20announced%20next%20month%20(August%202024)%20is%203.9%25%2C%20the%20percentage%20will%20be%200.47%2C%20which%20is%20below%200.5.%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Masukawa_Nao_4-1722847954892.png%22%20style%3D%22width%3A%20488px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Masukawa_Nao_4-1722847954892.png%22%20style%3D%22width%3A%20488px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Masukawa_Nao_4-1722847954892.png%22%20style%3D%22width%3A%20488px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F66839i1FBEEF2AA599EA5D%2Fimage-dimensions%2F488x177%3Fv%3Dv2%22%20width%3D%22488%22%20height%3D%22177%22%20role%3D%22button%22%20title%3D%22Masukawa_Nao_4-1722847954892.png%22%20alt%3D%22Masukawa_Nao_4-1722847954892.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3EIt%20seems%20unlikely%20that%20the%20unemployment%20rate%20will%20suddenly%20drop%20by%20that%20much%2C%20but%20it%20would%20be%20a%20good%20idea%20to%20continue%20to%20keep%20an%20eye%20on%20the%20Sarm%20rule%2C%20which%20is%20an%20economic%20signal.%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3EData%20source%3A%20%3CA%20href%3D%22https%3A%2F%2Ffred.stlouisfed.org%2Fseries%2FUNRATE%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EUnemployment%20Rate%20(UNRATE)%20%7C%20FRED%20%7C%20St.%20Louis%20Fed%20(stlouisfed.org)%3C%2FA%3E%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3Eby%20Naohiro%20Masukawa%20(JMP%20Japan)%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2FNaohiro-Masukawa%2Fbg-p%2Fnmasukawa-blog%22%20target%3D%22_blank%22%3ENaohiro%20Masukawa%20-%20JMP%20User%20Community%3C%2FA%3E%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-779220%22%20slang%3D%22ja-JP%22%20mode%3D%22CREATE%22%3E%3CLINGO-LABEL%3EData%20Blending%20and%20Cleanup%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EData%20Exploration%20and%20Visualization%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-797100%22%20slang%3D%22ja-JP%22%20mode%3D%22CREATE%22%3ERe%3A%20Recession%20signal%20light%3F%20Calculate%20and%20visualize%20the%20signal%20%22therm%20rule%22%20in%20JMP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-797100%22%20slang%3D%22ja-JP%22%20mode%3D%22CREATE%22%3E%3CP%3ELast%20weekend%2C%20the%20employment%20report%20for%20August%20was%20released%2C%20showing%20the%20unemployment%20rate%20at%204.2%25%2C%20down%200.1%25%20from%204.3%25%20in%20July%2C%20but%20the%20therm%20rule%20calculation%20gave%20it%20a%20rate%20of%200.57%2C%20still%20above%200.5.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20667px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20667px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F68058i45BAADF62DE5DB6A%2Fimage-dimensions%2F667x412%3Fv%3Dv2%22%20width%3D%22667%22%20height%3D%22412%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
景気後退のシグナル点灯?? JMPでシグナル「サームルール」を算出し視覚化する

先週末、世界中がパリオリンピックの選手の活躍に注目していた中、アメリカでは7月の雇用統計が発表されました。今回の雇用統計では失業率が市場予想を上回り、景気後退のシグナルである「サームルール(Sahm Rule)」が点灯されたことが話題となりました。

 

サームルールとは、元FRBのクローディア・サーム氏が提唱した失業率より計算されます。具体的には、その値(パーセンテージ)が0.5を上回ると、景気後退に陥る可能性が高いとされています。

 

今回の雇用統計では、2024年7月の失業率が4.3%と発表され、サームルールによるパーセンテージが0.53となり、コロナ以降初めて0.5を上回りました。

 

Masukawa_Nao_0-1722835890787.png

 

サームルールによるパーセンテージは、月次の失業率より以下の定義で算出されます。

 

①直近3か月の失業率の平均(3か月移動平均)

②過去12か月間の3か月移動平均の最小値

 

パーセンテージ (サームルール)= ① -   ②      ( ≧  0.5   だとサームルールのシグナル点灯)

 

本ブログでは、失業率の月次データから、JMPのデータテーブルでこのパーセンテージを算出し、その値の推移をグラフで可視化してみます。

 

JMPで移動平均を算出する関数

サームルールによるパーセンテージは、次の手順で算出します。

 

  1.  "失業率(Unemployment Rate)"から " 3か月移動平均(3-Month Average)"を算出 (①)
  2.  "3か月移動平均" から "過去12か月間の3か月移動平均の最小値(Minimum of 3-Month Average in Prior 12 Months" を算出
  3. ①から②を引き算する (Percentage(Sahm Rule))

 

Masukawa_Nao_0-1722844502907.png

例として直近2024年7月のパーセンテージを算出するには、次のような手順で計算します。

 

  1. 3か月移動平均: (4 + 4.1 + 4.3) ÷ 3   = 4.13
  2. 過去12か月間の3か月移動平均(上記黄色部分)の最小値 = 3.6 (2023年7月)
  3. パーセンテージ: 4.13- 3.6   = 0.53

 

JMPの計算式を使って算出してみましょう。

 

i.の3か月移動平均は、移動平均を求める Col Moving Average() 関数を使用し、次のような計算式を指定します。

 

Masukawa_Nao_0-1722845179312.png

 

引数が多いですが、計算式エディタ上側にある?のアイコンをクリックするとヘルプが表示され、各引数の意味を確認できます。

 

Masukawa_Nao_1-1722845317543.png

 

数字の引数 1,2,0,1は、それぞれ以下の意味を持ちます。 

引数 意味
weighting 1 移動平均を求めるときの重みを1にする(過去の値に対する重みはつけない)。
before 2 2時点前までを対象にする(現時点、1時点前、2時点前の3時点の平均をとる)
after 0 現時点より後の値は対象としない
partial window is missing 1 1にすると2時点前まで値があるものを対象とする(例では1行目と2行目の値は欠測値となる)。0にすると1行目には現時点の値、2行目には現時点の値と1時点前の値の平均が入る。

 

 

ⅱの過去12か月間の3か月移動平均の最小値は、Lag(x, n) 関数を使っています。nは列xのn時点前の値を返します。ここでは1時点前から12時点前の3か月移動平均の中で最小値を求めます。

 

Masukawa_Nao_0-1722846578989.png

 

最後に、iで求めた値からiiで求めた値を引き算します。

 

2000年以降の失業率とサームルールの推移

値が求められたので、「グラフビルダー」を使って失業率(グラフ上側)、サームルールによるパーセンテージ(グラフ下側)の推移を示します。

 

Masukawa_Nao_3-1722847254717.png

 

失業率の推移をオレンジ色の折れ線で示しており、若干上昇傾向が見られますが、平滑線(赤い点線)を見ると、まだ上昇トレンドにあるとは言い難い状態です。今後も失業率が横ばいまたは上昇する場合、平滑線も上昇トレンドを形成するでしょう。

 

サームルールによるパーセンテージ(青色の棒グラフ)をみると、2000年代では過去に3回ほど大きな山が見られます。これらの山は、2001年頃のITバブル、2008年頃のリーマンショック、2020年のコロナショックが主な原因です。

 

コロナショックは除くと、直近(2023年~2024年7月)では、ITバブル、リーマンショックのときのような山が形成されつつあるように見えてしまいます。

 

果たして、景気は後退局面に入るのでしょうか。ちなみに、次月の発表(2024年8月の失業率)が3.9%であれば、パーセンテージは0.47となり、0.5を下回ります。

 

Masukawa_Nao_4-1722847954892.png

 

急にそこまで失業率が下がる可能性は低い気がしますが、今後も景気シグナルであるサームルールを注視しておくと良いでしょう。

 

 

データの出典:Unemployment Rate (UNRATE) | FRED | St. Louis Fed (stlouisfed.org)

 

by 増川 直裕(JMP Japan)

Naohiro Masukawa - JMP User Community

 

Last Modified: Aug 5, 2024 5:39 AM
Comments