excel - Calculate the average of Spearman correlation -


i have 2 columns , b contain spearman's correlation values follows:

 0.127272727    -0.260606061 -0.090909091    -0.224242424 0.345454545      0.745454545 0.478787879      0.660606061 -0.345454545    -0.333333333 0.151515152     -0.127272727 0.478787879     0.660606061 -0.321212121    -0.284848485 0.284848485     0.515151515 0.36969697     -0.139393939 -0.284848485    0.272727273

how can calculate average of correlation values in these 2 columns in excel or matlab ? found close answer in link : https://stats.stackexchange.com/questions/8019/averaging-correlation-values main point can not use mean or average in case, explained in link. proposed nice way that, dont know how implement in excel or matlab.

in matlab, define matrix these values , use mean function follows:

%define matrix m m = [0.127272727    -0.260606061; -0.090909091    -0.224242424; 0.345454545      0.745454545; 0.478787879      0.660606061; -0.345454545    -0.333333333; 0.151515152     -0.127272727; 0.478787879     0.660606061; -0.321212121    -0.284848485; 0.284848485     0.515151515; 0.36969697     -0.139393939; -0.284848485    0.272727273];  %calculates mean of each column meanvals = mean(m);

result

meanvals = 0.1085    0.1350

it possible calculate total meanm , mean of each row follows:

meanvals = mean(m); %total mean meanvals = mean(m,2); %mean of each row

Comments

Post a Comment

Popular posts from this blog

python - Selenium remoteWebDriver (& SauceLabs) Firefox moseMoveTo action exception -

while performing simple hover test on firefox through selenium (3.4.0) python bindings (3.4.3) using of available os in saucelabs (except linux, latest available firefox version old), performing following actionchain: hover = actionchains(driver) hover.move_to_element(elm_men_menu).perform() it throws following error: taceback: file [...] in testhover hover.perform() file "/usr/local/lib/python2.7/dist-packages/selenium/webdriver/common/action_chains.py", line 80, in perform action() file "/usr/local/lib/python2.7/dist-packages/selenium/webdriver/common/action_chains.py", line 290, in <lambda> command.move_to, {'element': to_element.id})) file "/usr/local/lib/python2.7/dist-packages/selenium/webdriver/remote/webdriver.py", line 256, in execute self.error_handler.check_response(response) file "/usr/local/lib/python2.7/...
Read more

Ansible warning on jinja2 braces on when -

i using code in vars my_var: "{{lookup('env','my_var') | default(true, true)}}" i using like - include: task.yml when: my_var this worked without issue in ansible 2.2 in ansible 2.3 warning this [warning]: when statements should not include jinja2 templating delimiters such {{ }} or {% %}. found: {{lookup('env','my_var') | default(true, true)}} so if use my_var: "lookup('env','my_var') | default(true, true)" , mean remove {{ }} , no warning my_var evaluated true no matter if pass false env variable. works fine in previous code gave how can fix it? the cleanest way set fact instead of using template in variable (it prevent lookup plugin being called multiple times in included tasks - not huge performance gain, cleaner): - set_fact: my_var: "{{lookup('env','my_var') | default(true, true)}}" also mind evaluate true in cases when environment my_var diff...
Read more

html - How to custom Bootstrap grid height? -

why bootstrap grid has height 591.067 ? did height came ? .main-post { padding: 20px; background-color: #fff; border: 1px solid #d8d8d8; margin-bottom: 100px; } .main-post .post-categories { margin-bottom: 10px } .main-post h3 { margin: 0 0 10px; color: #777; letter-spacing: -1px; font-weight: bold } .main-post .post-author, .main-post .post-date, .main-post .post-comments { font-size: 12px } .main-post img { display: block; margin: 10px 0; } .main-post .post-summary { line-height: 1.7; color: #888 } .main-post { color: #999 } <div class="col-sm-6"> <div class="main-post"> <h3 class="post-title"> <a href="#"> post title </a> </...
Read more