Format t-stat in square brackets

7 次查看（过去 30 天）
Parveshsingh Seeballack
回答： Star Strider 2021-9-16
Hi All
I am trying to format the below code such that the t-stats are in square brackets.
if freq ==1 % for monthly sample
disp(' Table 5, Appendix Format')
disp(' SPX Pseudo Spreads')
lbs = {'HOVS','t-stat','Pseudo Spread','t-stat','Term Spread','t-stat','Real FFR','t-stat','VIX','t-stat','R2'};
disp('')
disp(' Panel A: Payroll Growth')
disp('')
for kk=1:11
fprintf('%14s %7.2f %7.2f %7.2f %7.2f %7.2f %7.2f \n',...
char(lbs(kk)),TABLE_Final_Appendix(kk,:,1))
end
Also, how do I export the results in excel format.
Thank you four your help.
Regards
Parvesh

请先登录，再回答此问题。

回答（1 个）

Star Strider
Star Strider 2021-9-16
Ran in:
With respect to the square brackets —
x = randn(1,5);
fprintf('[%8.4f]\n',x)
[ 0.2151] [ 0.7526] [ 0.0942] [ -0.9181] [ -0.0554]
‘Also, how do I export the results in excel format.’
It might be easiest to save all that to a cell array, then use the writecell function.
Another option is to create it as a table, and use writetable.
However, it might be best to write it line-by-line to a text file, and use the approopriate combination of 'HeaderLines' and other options with respect to reading it (as a table or matrix). Writing it and reading it later are going to be something of a challenge, regardless.
.

类别

在 Help Center 和 File Exchange 中查找有关 Tables 的更多信息

标签

产品


版本

R2020b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by