blob: 39d42527c711bc8a61b0868e39b0d3c1849e6c42 [file] [log] [blame]
<!-- HTML header for doxygen 1.8.4-->
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<meta http-equiv="X-UA-Compatible" content="IE=9"/>
<meta name="generator" content="Doxygen 1.8.10"/>
<meta name="keywords" content="madlib,postgres,greenplum,machine learning,data mining,deep learning,ensemble methods,data science,market basket analysis,affinity analysis,pca,lda,regression,elastic net,huber white,proportional hazards,k-means,latent dirichlet allocation,bayes,support vector machines,svm"/>
<title>MADlib: robust.sql_in File Reference</title>
<link href="tabs.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="dynsections.js"></script>
<link href="navtree.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="resize.js"></script>
<script type="text/javascript" src="navtreedata.js"></script>
<script type="text/javascript" src="navtree.js"></script>
<script type="text/javascript">
$(document).ready(initResizable);
$(window).load(resizeHeight);
</script>
<link href="search/search.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="search/searchdata.js"></script>
<script type="text/javascript" src="search/search.js"></script>
<script type="text/javascript">
$(document).ready(function() { init_search(); });
</script>
<script type="text/x-mathjax-config">
MathJax.Hub.Config({
extensions: ["tex2jax.js", "TeX/AMSmath.js", "TeX/AMSsymbols.js"],
jax: ["input/TeX","output/HTML-CSS"],
});
</script><script src="../mathjax/MathJax.js"></script>
<!-- hack in the navigation tree -->
<script type="text/javascript" src="navtree_hack.js"></script>
<link href="doxygen.css" rel="stylesheet" type="text/css" />
<link href="madlib_extra.css" rel="stylesheet" type="text/css"/>
<!-- google analytics -->
<script>
(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
})(window,document,'script','//www.google-analytics.com/analytics.js','ga');
ga('create', 'UA-45382226-1', 'auto');
ga('send', 'pageview');
</script>
</head>
<body>
<div id="top"><!-- do not remove this div, it is closed by doxygen! -->
<div id="titlearea">
<table cellspacing="0" cellpadding="0">
<tbody>
<tr style="height: 56px;">
<td id="projectlogo"><a href="http://madlib.incubator.apache.org"><img alt="Logo" src="madlib.png" height="50" style="padding-left:0.5em;" border="0"/ ></a></td>
<td style="padding-left: 0.5em;">
<div id="projectname">
<span id="projectnumber">1.8</span>
</div>
<div id="projectbrief">User Documentation for MADlib</div>
</td>
<td> <div id="MSearchBox" class="MSearchBoxInactive">
<span class="left">
<img id="MSearchSelect" src="search/mag_sel.png"
onmouseover="return searchBox.OnSearchSelectShow()"
onmouseout="return searchBox.OnSearchSelectHide()"
alt=""/>
<input type="text" id="MSearchField" value="Search" accesskey="S"
onfocus="searchBox.OnSearchFieldFocus(true)"
onblur="searchBox.OnSearchFieldFocus(false)"
onkeyup="searchBox.OnSearchFieldChange(event)"/>
</span><span class="right">
<a id="MSearchClose" href="javascript:searchBox.CloseResultsWindow()"><img id="MSearchCloseImg" border="0" src="search/close.png" alt=""/></a>
</span>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<!-- end header part -->
<!-- Generated by Doxygen 1.8.10 -->
<script type="text/javascript">
var searchBox = new SearchBox("searchBox", "search",false,'Search');
</script>
</div><!-- top -->
<div id="side-nav" class="ui-resizable side-nav-resizable">
<div id="nav-tree">
<div id="nav-tree-contents">
<div id="nav-sync" class="sync"></div>
</div>
</div>
<div id="splitbar" style="-moz-user-select:none;"
class="ui-resizable-handle">
</div>
</div>
<script type="text/javascript">
$(document).ready(function(){initNavTree('robust_8sql__in.html','');});
</script>
<div id="doc-content">
<!-- window showing the filter options -->
<div id="MSearchSelectWindow"
onmouseover="return searchBox.OnSearchSelectShow()"
onmouseout="return searchBox.OnSearchSelectHide()"
onkeydown="return searchBox.OnSearchSelectKey(event)">
</div>
<!-- iframe showing the search results (closed by default) -->
<div id="MSearchResultsWindow">
<iframe src="javascript:void(0)" frameborder="0"
name="MSearchResults" id="MSearchResults">
</iframe>
</div>
<div class="header">
<div class="summary">
<a href="#func-members">Functions</a> </div>
<div class="headertitle">
<div class="title">robust.sql_in File Reference</div> </div>
</div><!--header-->
<div class="contents">
<p>SQL functions for robust variance linear and logistic regression.
<a href="#details">More...</a></p>
<table class="memberdecls">
<tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="func-members"></a>
Functions</h2></td></tr>
<tr class="memitem:a3f978229f9a2e229276278985d76c438"><td class="memItemLeft" align="right" valign="top">bytea8&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="robust_8sql__in.html#a3f978229f9a2e229276278985d76c438">robust_linregr_transition</a> (bytea8 state, float8 y, float8[] x, float8[] coef)</td></tr>
<tr class="separator:a3f978229f9a2e229276278985d76c438"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ad85d9925cbab4b59acd798a7b32671ff"><td class="memItemLeft" align="right" valign="top">bytea8&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="robust_8sql__in.html#ad85d9925cbab4b59acd798a7b32671ff">robust_linregr_merge_states</a> (bytea8 state1, bytea8 state2)</td></tr>
<tr class="separator:ad85d9925cbab4b59acd798a7b32671ff"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a458741a15dc6c2ca627f0d1c1d19b7f8"><td class="memItemLeft" align="right" valign="top">robust_linregr_result&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="robust_8sql__in.html#a458741a15dc6c2ca627f0d1c1d19b7f8">robust_linregr_final</a> (bytea8 state)</td></tr>
<tr class="separator:a458741a15dc6c2ca627f0d1c1d19b7f8"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ade1af85b04294ee404a638aa2bfbf051"><td class="memItemLeft" align="right" valign="top">aggregate bytea8&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="robust_8sql__in.html#ade1af85b04294ee404a638aa2bfbf051">robust_linregr</a> (float8 dependentVariable, float8[] independentVariables, float8[] coef)</td></tr>
<tr class="separator:ade1af85b04294ee404a638aa2bfbf051"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a390473d2fd45e268f0fc13ca971b49b4"><td class="memItemLeft" align="right" valign="top">varchar&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="robust_8sql__in.html#a390473d2fd45e268f0fc13ca971b49b4">robust_variance_linregr</a> (varchar message)</td></tr>
<tr class="separator:a390473d2fd45e268f0fc13ca971b49b4"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:aec15331f90464a70c222774d78a5caf2"><td class="memItemLeft" align="right" valign="top">varchar&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="robust_8sql__in.html#aec15331f90464a70c222774d78a5caf2">robust_variance_linregr</a> ()</td></tr>
<tr class="separator:aec15331f90464a70c222774d78a5caf2"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a3f79ad2b83c9749fa85d4f96a12c5af0"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="robust_8sql__in.html#a3f79ad2b83c9749fa85d4f96a12c5af0">robust_variance_linregr</a> (varchar source_table, varchar out_table, varchar dependent_varname, varchar independent_varname, varchar grouping_cols, boolean verbose_mode)</td></tr>
<tr class="separator:a3f79ad2b83c9749fa85d4f96a12c5af0"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a80b264be3cd0784d49424efee14b78a8"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="robust_8sql__in.html#a80b264be3cd0784d49424efee14b78a8">robust_variance_linregr</a> (varchar source_table, varchar out_table, varchar dependent_varname, varchar independent_varname, varchar grouping_cols)</td></tr>
<tr class="separator:a80b264be3cd0784d49424efee14b78a8"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ac513ea8711b165dac3f75e0c5f4a577f"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="robust_8sql__in.html#ac513ea8711b165dac3f75e0c5f4a577f">robust_variance_linregr</a> (varchar source_table, varchar out_table, varchar dependent_varname, varchar independent_varname)</td></tr>
<tr class="separator:ac513ea8711b165dac3f75e0c5f4a577f"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a840ddaa14013c4445b7a0d55e9489d8d"><td class="memItemLeft" align="right" valign="top">float8[]&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="robust_8sql__in.html#a840ddaa14013c4445b7a0d55e9489d8d">robust_logregr_step_transition</a> (float8[] state, boolean y, float8[] x, float8[] coef)</td></tr>
<tr class="separator:a840ddaa14013c4445b7a0d55e9489d8d"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:aa715a6f6885b56d919a243ec4ff07fde"><td class="memItemLeft" align="right" valign="top">float8[]&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="robust_8sql__in.html#aa715a6f6885b56d919a243ec4ff07fde">robust_logregr_step_merge_states</a> (float8[] state1, float8[] state2)</td></tr>
<tr class="separator:aa715a6f6885b56d919a243ec4ff07fde"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:af8efdd02ad3155411507bf786095a562"><td class="memItemLeft" align="right" valign="top">robust_logregr_result&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="robust_8sql__in.html#af8efdd02ad3155411507bf786095a562">robust_logregr_step_final</a> (float8[] state)</td></tr>
<tr class="separator:af8efdd02ad3155411507bf786095a562"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a6a9290aafa048bcb7cdc13410d5814aa"><td class="memItemLeft" align="right" valign="top">aggregate robust_logregr_result&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="robust_8sql__in.html#a6a9290aafa048bcb7cdc13410d5814aa">robust_logregr</a> (boolean dependentVariable, float8[] independentVariables, float8[] coef)</td></tr>
<tr class="separator:a6a9290aafa048bcb7cdc13410d5814aa"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:abc20ec2c5e74f268e7727c33a4bb9054"><td class="memItemLeft" align="right" valign="top">varchar&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="robust_8sql__in.html#abc20ec2c5e74f268e7727c33a4bb9054">robust_variance_logregr</a> (varchar message)</td></tr>
<tr class="separator:abc20ec2c5e74f268e7727c33a4bb9054"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a0c426835208c1c9b14a9cce168c8bf87"><td class="memItemLeft" align="right" valign="top">varchar&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="robust_8sql__in.html#a0c426835208c1c9b14a9cce168c8bf87">robust_variance_logregr</a> ()</td></tr>
<tr class="separator:a0c426835208c1c9b14a9cce168c8bf87"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a815cadfeb54447993db9ce2bd2aa709e"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="robust_8sql__in.html#a815cadfeb54447993db9ce2bd2aa709e">robust_variance_logregr</a> (varchar source_table, varchar out_table, varchar dependent_varname, varchar independent_varname, varchar grouping_cols, integer max_iter, varchar optimizer, float8 tolerance, boolean verbose_mode)</td></tr>
<tr class="memdesc:a815cadfeb54447993db9ce2bd2aa709e"><td class="mdescLeft">&#160;</td><td class="mdescRight">The robust logistic regression function. <a href="#a815cadfeb54447993db9ce2bd2aa709e">More...</a><br /></td></tr>
<tr class="separator:a815cadfeb54447993db9ce2bd2aa709e"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a0924470ae6bf5bb3b4b03e41f69d6f7b"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="robust_8sql__in.html#a0924470ae6bf5bb3b4b03e41f69d6f7b">robust_variance_logregr</a> (varchar source_table, varchar out_table, varchar dependent_variable, varchar independent_variable, varchar grouping_cols, integer max_iter, varchar optimizer, float8 tolerance)</td></tr>
<tr class="separator:a0924470ae6bf5bb3b4b03e41f69d6f7b"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a9a9a8c67a89f4ecf6e783762536239bc"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="robust_8sql__in.html#a9a9a8c67a89f4ecf6e783762536239bc">robust_variance_logregr</a> (varchar source_table, varchar out_table, varchar dependent_variable, varchar independent_variable, varchar grouping_cols, integer max_iter, varchar optimizer)</td></tr>
<tr class="separator:a9a9a8c67a89f4ecf6e783762536239bc"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:aef8d807073c9e5a8c62b6a318b5048a1"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="robust_8sql__in.html#aef8d807073c9e5a8c62b6a318b5048a1">robust_variance_logregr</a> (varchar source_table, varchar out_table, varchar dependent_variable, varchar independent_variable, varchar grouping_cols, integer max_iter)</td></tr>
<tr class="separator:aef8d807073c9e5a8c62b6a318b5048a1"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a89770eec0b2e47c714a755b5b1697dd9"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="robust_8sql__in.html#a89770eec0b2e47c714a755b5b1697dd9">robust_variance_logregr</a> (varchar source_table, varchar out_table, varchar dependent_variable, varchar independent_variable, varchar grouping_cols)</td></tr>
<tr class="separator:a89770eec0b2e47c714a755b5b1697dd9"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ab73b9a117ba6bd637bac5757ed122d59"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="robust_8sql__in.html#ab73b9a117ba6bd637bac5757ed122d59">robust_variance_logregr</a> (varchar source_table, varchar out_table, varchar dependent_variable, varchar independent_variable)</td></tr>
<tr class="separator:ab73b9a117ba6bd637bac5757ed122d59"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a3928ec1e3935e8dc4dbcb9e705805660"><td class="memItemLeft" align="right" valign="top">float8[]&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="robust_8sql__in.html#a3928ec1e3935e8dc4dbcb9e705805660">mlogregr_robust_step_transition</a> (float8[] state, integer y, integer numcategories, integer ref_category, float8[] x, float8[] coef)</td></tr>
<tr class="separator:a3928ec1e3935e8dc4dbcb9e705805660"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a123149abbf366743e04ecb6fc7f8b9d9"><td class="memItemLeft" align="right" valign="top">float8[]&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="robust_8sql__in.html#a123149abbf366743e04ecb6fc7f8b9d9">mlogregr_robust_step_merge_states</a> (float8[] state1, float8[] state2)</td></tr>
<tr class="separator:a123149abbf366743e04ecb6fc7f8b9d9"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a6bfc968b23887a0a8ddd69a5c3350ba9"><td class="memItemLeft" align="right" valign="top">robust_mlogregr_result&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="robust_8sql__in.html#a6bfc968b23887a0a8ddd69a5c3350ba9">mlogregr_robust_step_final</a> (float8[] state)</td></tr>
<tr class="separator:a6bfc968b23887a0a8ddd69a5c3350ba9"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a209021ac52461f029353cec7fb900cd4"><td class="memItemLeft" align="right" valign="top">aggregate robust_mlogregr_result&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="robust_8sql__in.html#a209021ac52461f029353cec7fb900cd4">robust_mlogregr</a> (integer dependentVariable, integer numCategories, integer ref_category, float8[] independentVariables, float8[] coef)</td></tr>
<tr class="separator:a209021ac52461f029353cec7fb900cd4"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a1f27c072a4ef885a55825f75d12b3bd8"><td class="memItemLeft" align="right" valign="top">varchar&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="robust_8sql__in.html#a1f27c072a4ef885a55825f75d12b3bd8">robust_variance_mlogregr</a> (varchar message)</td></tr>
<tr class="separator:a1f27c072a4ef885a55825f75d12b3bd8"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:abd0fb2d66b0dcb4ee6649aaa97bc62f9"><td class="memItemLeft" align="right" valign="top">varchar&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="robust_8sql__in.html#abd0fb2d66b0dcb4ee6649aaa97bc62f9">robust_variance_mlogregr</a> ()</td></tr>
<tr class="separator:abd0fb2d66b0dcb4ee6649aaa97bc62f9"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a8ee938491f0cd0eda60c9fd320740566"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="robust_8sql__in.html#a8ee938491f0cd0eda60c9fd320740566">robust_variance_mlogregr</a> (varchar source_table, varchar out_table, varchar dependent_varname, varchar independent_varname, integer ref_category, varchar grouping_cols, varchar optimizer_params, boolean verbose_mode)</td></tr>
<tr class="memdesc:a8ee938491f0cd0eda60c9fd320740566"><td class="mdescLeft">&#160;</td><td class="mdescRight">Compute robust regression diagnostic statistics for multinomial logistic regression. <a href="#a8ee938491f0cd0eda60c9fd320740566">More...</a><br /></td></tr>
<tr class="separator:a8ee938491f0cd0eda60c9fd320740566"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a2a00a61722a2b92fca37883c795598f6"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="robust_8sql__in.html#a2a00a61722a2b92fca37883c795598f6">robust_variance_mlogregr</a> (varchar source_table, varchar out_table, varchar dependent_varname, varchar independent_varname, integer ref_category, varchar grouping_cols, varchar optimizer_params)</td></tr>
<tr class="separator:a2a00a61722a2b92fca37883c795598f6"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:afe0d690ca9e2a75f8fd157b548ece204"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="robust_8sql__in.html#afe0d690ca9e2a75f8fd157b548ece204">robust_variance_mlogregr</a> (varchar source_table, varchar out_table, varchar dependent_varname, varchar independent_varname, integer ref_category, varchar grouping_cols)</td></tr>
<tr class="separator:afe0d690ca9e2a75f8fd157b548ece204"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:af3b1cba3e31f65233524d110f5873682"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="robust_8sql__in.html#af3b1cba3e31f65233524d110f5873682">robust_variance_mlogregr</a> (varchar source_table, varchar out_table, varchar dependent_varname, varchar independent_varname, integer ref_category)</td></tr>
<tr class="separator:af3b1cba3e31f65233524d110f5873682"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a93031a31e4c93d3caa22d963927e75c8"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="robust_8sql__in.html#a93031a31e4c93d3caa22d963927e75c8">robust_variance_mlogregr</a> (varchar source_table, varchar out_table, varchar dependent_varname, varchar independent_varname)</td></tr>
<tr class="separator:a93031a31e4c93d3caa22d963927e75c8"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a99a3252474c5fbb2982e461325b1838d"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="robust_8sql__in.html#a99a3252474c5fbb2982e461325b1838d">robust_variance_mlogregr</a> (varchar source_table, varchar out_table, varchar dependent_varname, varchar independent_varname, integer ref_category, varchar grouping_cols, integer max_iter, varchar optimizer, float8 tolerance, boolean verbose_mode)</td></tr>
<tr class="separator:a99a3252474c5fbb2982e461325b1838d"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a08cd16eaf72e07c3034951863951d7e1"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="robust_8sql__in.html#a08cd16eaf72e07c3034951863951d7e1">robust_variance_mlogregr</a> (varchar source_table, varchar out_table, varchar dependent_varname, varchar independent_varname, integer ref_category, varchar grouping_cols, integer max_iter, varchar optimizer, float8 tolerance)</td></tr>
<tr class="separator:a08cd16eaf72e07c3034951863951d7e1"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:abdebb95685f06580eade2941a2edd2af"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="robust_8sql__in.html#abdebb95685f06580eade2941a2edd2af">robust_variance_mlogregr</a> (varchar source_table, varchar out_table, varchar dependent_varname, varchar independent_varname, integer ref_category, varchar grouping_cols, integer max_iter, varchar optimizer)</td></tr>
<tr class="separator:abdebb95685f06580eade2941a2edd2af"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a4ebbb7afe6193dfa77116a5c3ae9b7dc"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="robust_8sql__in.html#a4ebbb7afe6193dfa77116a5c3ae9b7dc">robust_variance_mlogregr</a> (varchar source_table, varchar out_table, varchar dependent_varname, varchar independent_varname, integer ref_category, varchar grouping_cols, integer max_iter)</td></tr>
<tr class="separator:a4ebbb7afe6193dfa77116a5c3ae9b7dc"><td class="memSeparator" colspan="2">&#160;</td></tr>
</table>
<a name="details" id="details"></a><h2 class="groupheader">Detailed Description</h2>
<div class="textblock"><dl class="section date"><dt>Date</dt><dd>2012</dd></dl>
<dl class="section see"><dt>See also</dt><dd>For a brief introduction to robust variance, see <a class="el" href="group__grp__robust.html">Robust Variance</a> </dd></dl>
</div><h2 class="groupheader">Function Documentation</h2>
<a class="anchor" id="a6bfc968b23887a0a8ddd69a5c3350ba9"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">robust_mlogregr_result mlogregr_robust_step_final </td>
<td>(</td>
<td class="paramtype">float8[]&#160;</td>
<td class="paramname"><em>state</em></td><td>)</td>
<td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="a123149abbf366743e04ecb6fc7f8b9d9"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">float8 [] mlogregr_robust_step_merge_states </td>
<td>(</td>
<td class="paramtype">float8[]&#160;</td>
<td class="paramname"><em>state1</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">float8[]&#160;</td>
<td class="paramname"><em>state2</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="a3928ec1e3935e8dc4dbcb9e705805660"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">float8 [] mlogregr_robust_step_transition </td>
<td>(</td>
<td class="paramtype">float8[]&#160;</td>
<td class="paramname"><em>state</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>y</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>numcategories</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>ref_category</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">float8[]&#160;</td>
<td class="paramname"><em>x</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">float8[]&#160;</td>
<td class="paramname"><em>coef</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="ade1af85b04294ee404a638aa2bfbf051"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">aggregate bytea8 robust_linregr </td>
<td>(</td>
<td class="paramtype">float8&#160;</td>
<td class="paramname"><em>dependentVariable</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">float8[]&#160;</td>
<td class="paramname"><em>independentVariables</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">float8[]&#160;</td>
<td class="paramname"><em>coef</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="a458741a15dc6c2ca627f0d1c1d19b7f8"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">robust_linregr_result robust_linregr_final </td>
<td>(</td>
<td class="paramtype">bytea8&#160;</td>
<td class="paramname"><em>state</em></td><td>)</td>
<td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="ad85d9925cbab4b59acd798a7b32671ff"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">bytea8 robust_linregr_merge_states </td>
<td>(</td>
<td class="paramtype">bytea8&#160;</td>
<td class="paramname"><em>state1</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">bytea8&#160;</td>
<td class="paramname"><em>state2</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="a3f978229f9a2e229276278985d76c438"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">bytea8 robust_linregr_transition </td>
<td>(</td>
<td class="paramtype">bytea8&#160;</td>
<td class="paramname"><em>state</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">float8&#160;</td>
<td class="paramname"><em>y</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">float8[]&#160;</td>
<td class="paramname"><em>x</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">float8[]&#160;</td>
<td class="paramname"><em>coef</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="a6a9290aafa048bcb7cdc13410d5814aa"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">aggregate robust_logregr_result robust_logregr </td>
<td>(</td>
<td class="paramtype">boolean&#160;</td>
<td class="paramname"><em>dependentVariable</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">float8[]&#160;</td>
<td class="paramname"><em>independentVariables</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">float8[]&#160;</td>
<td class="paramname"><em>coef</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="af8efdd02ad3155411507bf786095a562"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">robust_logregr_result robust_logregr_step_final </td>
<td>(</td>
<td class="paramtype">float8[]&#160;</td>
<td class="paramname"><em>state</em></td><td>)</td>
<td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="aa715a6f6885b56d919a243ec4ff07fde"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">float8 [] robust_logregr_step_merge_states </td>
<td>(</td>
<td class="paramtype">float8[]&#160;</td>
<td class="paramname"><em>state1</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">float8[]&#160;</td>
<td class="paramname"><em>state2</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="a840ddaa14013c4445b7a0d55e9489d8d"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">float8 [] robust_logregr_step_transition </td>
<td>(</td>
<td class="paramtype">float8[]&#160;</td>
<td class="paramname"><em>state</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">boolean&#160;</td>
<td class="paramname"><em>y</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">float8[]&#160;</td>
<td class="paramname"><em>x</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">float8[]&#160;</td>
<td class="paramname"><em>coef</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="a209021ac52461f029353cec7fb900cd4"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">aggregate robust_mlogregr_result robust_mlogregr </td>
<td>(</td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>dependentVariable</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>numCategories</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>ref_category</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">float8[]&#160;</td>
<td class="paramname"><em>independentVariables</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">float8[]&#160;</td>
<td class="paramname"><em>coef</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="a390473d2fd45e268f0fc13ca971b49b4"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">varchar robust_variance_linregr </td>
<td>(</td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>message</em></td><td>)</td>
<td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="aec15331f90464a70c222774d78a5caf2"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">varchar robust_variance_linregr </td>
<td>(</td>
<td class="paramname"></td><td>)</td>
<td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="a3f79ad2b83c9749fa85d4f96a12c5af0"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">void robust_variance_linregr </td>
<td>(</td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>source_table</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>out_table</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>dependent_varname</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>independent_varname</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>grouping_cols</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">boolean&#160;</td>
<td class="paramname"><em>verbose_mode</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="a80b264be3cd0784d49424efee14b78a8"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">void robust_variance_linregr </td>
<td>(</td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>source_table</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>out_table</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>dependent_varname</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>independent_varname</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>grouping_cols</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="ac513ea8711b165dac3f75e0c5f4a577f"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">void robust_variance_linregr </td>
<td>(</td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>source_table</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>out_table</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>dependent_varname</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>independent_varname</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="abc20ec2c5e74f268e7727c33a4bb9054"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">varchar robust_variance_logregr </td>
<td>(</td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>message</em></td><td>)</td>
<td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="a0c426835208c1c9b14a9cce168c8bf87"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">varchar robust_variance_logregr </td>
<td>(</td>
<td class="paramname"></td><td>)</td>
<td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="a815cadfeb54447993db9ce2bd2aa709e"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">void robust_variance_logregr </td>
<td>(</td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>source_table</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>out_table</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>dependent_varname</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>independent_varname</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>grouping_cols</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>max_iter</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>optimizer</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">float8&#160;</td>
<td class="paramname"><em>tolerance</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">boolean&#160;</td>
<td class="paramname"><em>verbose_mode</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
<dl class="params"><dt>Parameters</dt><dd>
<table class="params">
<tr><td class="paramname">source_table</td><td>String identifying the input table </td></tr>
<tr><td class="paramname">out_table</td><td>String identifying the output table to be created </td></tr>
<tr><td class="paramname">dependent_varname</td><td>Column containing the dependent variable </td></tr>
<tr><td class="paramname">independent_varname</td><td>Column containing the array of independent variables </td></tr>
<tr><td class="paramname">grouping_cols</td><td>Columns to group by. </td></tr>
<tr><td class="paramname">max_iter</td><td>Integer identifying the maximum iterations used by the logistic regression solver. Default is 20. </td></tr>
<tr><td class="paramname">optimizer</td><td>String identifying the optimizer used in the logistic regression. See the documentation in the logistic regression for the available options. Default is irls. </td></tr>
<tr><td class="paramname">tolerance</td><td>Float identifying the tolerance of the logistic regression optimizer. Default is 1e-4. </td></tr>
<tr><td class="paramname">verbose_mode</td><td>Boolean specifying if the regression fit should print any warning messages. Default is false. </td></tr>
</table>
</dd>
</dl>
<dl class="section user"><dt></dt><dd>To include an intercept in the model, set one coordinate in the <code>independent_varname</code> array to 1.</dd></dl>
<dl class="section return"><dt>Returns</dt><dd>A composite value:<ul>
<li><code>std_err FLOAT8[]</code> - Array of huber-white standard errors, \( \mathit{se}(c_1), \dots, \mathit{se}(c_k) \)</li>
<li><code>t_stats FLOAT8[]</code> - Array of t-statistics, \( \boldsymbol t \)</li>
<li><code>p_values FLOAT8[]</code> - Array of p-values, \( \boldsymbol p \)</li>
</ul>
</dd></dl>
<dl class="section user"><dt>Usage</dt><dd>For function summary information. Run sql&gt; select robust_variance_logregr('help'); OR sql&gt; select <a class="el" href="robust_8sql__in.html#abc20ec2c5e74f268e7727c33a4bb9054">robust_variance_logregr()</a>; OR sql&gt; select robust_variance_logregr('?'); For function usage information. Run sql&gt; select robust_variance_logregr('usage');<ul>
<li>Compute the coefficients, and the get the robust diagnostic statistics: <pre>
select robust_variance_logregr(source_table, out_table, regression_type, dependentVariable, independentVariables, NULL );
</pre></li>
<li>If the coefficients are already known, they can be provided directly <pre>select robust_variance_logregr(source_table, out_table, regression_type, dependentVariable, independentVariables, coef );
</pre> </li>
</ul>
</dd></dl>
</div>
</div>
<a class="anchor" id="a0924470ae6bf5bb3b4b03e41f69d6f7b"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">void robust_variance_logregr </td>
<td>(</td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>source_table</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>out_table</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>dependent_variable</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>independent_variable</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>grouping_cols</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>max_iter</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>optimizer</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">float8&#160;</td>
<td class="paramname"><em>tolerance</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="a9a9a8c67a89f4ecf6e783762536239bc"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">void robust_variance_logregr </td>
<td>(</td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>source_table</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>out_table</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>dependent_variable</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>independent_variable</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>grouping_cols</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>max_iter</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>optimizer</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="aef8d807073c9e5a8c62b6a318b5048a1"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">void robust_variance_logregr </td>
<td>(</td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>source_table</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>out_table</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>dependent_variable</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>independent_variable</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>grouping_cols</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>max_iter</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="a89770eec0b2e47c714a755b5b1697dd9"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">void robust_variance_logregr </td>
<td>(</td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>source_table</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>out_table</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>dependent_variable</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>independent_variable</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>grouping_cols</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="ab73b9a117ba6bd637bac5757ed122d59"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">void robust_variance_logregr </td>
<td>(</td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>source_table</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>out_table</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>dependent_variable</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>independent_variable</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="a1f27c072a4ef885a55825f75d12b3bd8"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">varchar robust_variance_mlogregr </td>
<td>(</td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>message</em></td><td>)</td>
<td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="abd0fb2d66b0dcb4ee6649aaa97bc62f9"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">varchar robust_variance_mlogregr </td>
<td>(</td>
<td class="paramname"></td><td>)</td>
<td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="a8ee938491f0cd0eda60c9fd320740566"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">void robust_variance_mlogregr </td>
<td>(</td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>source_table</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>out_table</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>dependent_varname</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>independent_varname</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>ref_category</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>grouping_cols</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>optimizer_params</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">boolean&#160;</td>
<td class="paramname"><em>verbose_mode</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
<p>&ndash; NOTICE ---------------------------------------------------------&mdash;&mdash; &ndash; All functions calling other modeling functions should be in the format: &ndash; accept a model table created by the underlying modeling function &ndash; and extract all parameters from the model table and summary table CREATE OR REPLACE FUNCTION MADlib.robust_variance_mlogregr( model_table VARCHAR &ndash; name of the mlogregr model table , out_table VARCHAR &ndash; name of output table ) RETURNS VOID AS $$ PythonFunction(regress, robust_mlogistic, robust_variance_mlogregr_new) $$ LANGUAGE plpythonu; &ndash; END OF NOTICE ---------------------------------------------------------&mdash;&mdash; </p><dl class="params"><dt>Parameters</dt><dd>
<table class="params">
<tr><td class="paramname">source_table</td><td>name of input table, VARCHAR </td></tr>
<tr><td class="paramname">out_table</td><td>name of output table, VARCHAR </td></tr>
<tr><td class="paramname">dependent_varname</td><td>dependent variable, VARCHAR </td></tr>
<tr><td class="paramname">independent_varname</td><td>independent variables, VARCHAR </td></tr>
<tr><td class="paramname">ref_category</td><td>Integer specifying the reference category. Default is 0. </td></tr>
<tr><td class="paramname">grouping_cols</td><td>grouping variables, VARCHAR. Default is NULL. Currently a placeholder. </td></tr>
<tr><td class="paramname">max_iter</td><td>Integer identifying the maximum iterations used by the logistic regression solver. Default is 20. </td></tr>
<tr><td class="paramname">optimizer</td><td>String identifying the optimizer used in the multinomial logistic regression. See the documentation in the multinomial logistic regression for the available options. Default is 'irls'. </td></tr>
<tr><td class="paramname">tolerance</td><td>Float identifying the tolerance of the multinomial logistic regression optimizer. Default is 1e-4. </td></tr>
<tr><td class="paramname">verbose_mode</td><td>Boolean specifying if the multinomial logistic regression solver should print any warnings. Currently a placeholder.</td></tr>
</table>
</dd>
</dl>
<dl class="section user"><dt></dt><dd>To include an intercept in the model, set one coordinate in the <code>independentVariables</code> array to 1.</dd></dl>
<dl class="section user"><dt>Usage</dt><dd><pre>
SELECT madlib.robust_variance_mlogregr(
<em>'source_table'</em>, -- name of input table, VARCHAR
<em>'out_table'</em>, -- name of output table, VARCHAR
<em>'dependent_varname'</em>, -- dependent variable, VARCHAR
<em>'independent_varname'</em>, -- independent variables, VARCHAR
<em>ref_category</em>, -- [OPTIONAL] Integer specifying the reference category. Default is 0.
<em>'grouping_cols'</em>, -- [OPTIONAL] grouping variables, VARCHAR. Default is NULL.
<em>max_iter</em>, -- [OPTIONAL] Integer identifying the maximum iterations used by the logistic regression solver. Default is 20.
<em>'optimizer'</em>, -- [OPTIONAL] String identifying the optimizer used in the multinomial logistic regression. See the documentation in the multinomial logistic regression for the available options. Default is irls.
<em>tolerance</em>, -- [OPTIONAL] Float identifying the tolerance of the multinomial logistic regression optimizer. Default is 1e-4.
<em>verbose_mode</em> -- [OPTIONAL] Boolean specifying if the regression fit should print any warning messages. Default is false.
);
</pre></dd></dl>
<dl class="section return"><dt>Returns</dt><dd>A composite value:<ul>
<li><code>ref_category INTEGER</code> - The reference category</li>
<li><code>coef FLOAT8[] </code> - The coefficients for the regression</li>
<li><code>std_err FLOAT8[]</code> - Array of huber-white standard errors,</li>
<li><code>z_stats FLOAT8[]</code> - Array of Wald z-statistics,</li>
<li><code>p_values FLOAT8[]</code> - Array of p-values, </li>
</ul>
</dd></dl>
</div>
</div>
<a class="anchor" id="a2a00a61722a2b92fca37883c795598f6"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">void robust_variance_mlogregr </td>
<td>(</td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>source_table</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>out_table</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>dependent_varname</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>independent_varname</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>ref_category</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>grouping_cols</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>optimizer_params</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="afe0d690ca9e2a75f8fd157b548ece204"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">void robust_variance_mlogregr </td>
<td>(</td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>source_table</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>out_table</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>dependent_varname</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>independent_varname</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>ref_category</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>grouping_cols</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="af3b1cba3e31f65233524d110f5873682"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">void robust_variance_mlogregr </td>
<td>(</td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>source_table</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>out_table</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>dependent_varname</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>independent_varname</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>ref_category</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="a93031a31e4c93d3caa22d963927e75c8"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">void robust_variance_mlogregr </td>
<td>(</td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>source_table</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>out_table</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>dependent_varname</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>independent_varname</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="a99a3252474c5fbb2982e461325b1838d"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">void robust_variance_mlogregr </td>
<td>(</td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>source_table</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>out_table</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>dependent_varname</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>independent_varname</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>ref_category</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>grouping_cols</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>max_iter</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>optimizer</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">float8&#160;</td>
<td class="paramname"><em>tolerance</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">boolean&#160;</td>
<td class="paramname"><em>verbose_mode</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="a08cd16eaf72e07c3034951863951d7e1"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">void robust_variance_mlogregr </td>
<td>(</td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>source_table</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>out_table</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>dependent_varname</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>independent_varname</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>ref_category</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>grouping_cols</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>max_iter</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>optimizer</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">float8&#160;</td>
<td class="paramname"><em>tolerance</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="abdebb95685f06580eade2941a2edd2af"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">void robust_variance_mlogregr </td>
<td>(</td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>source_table</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>out_table</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>dependent_varname</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>independent_varname</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>ref_category</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>grouping_cols</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>max_iter</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>optimizer</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="a4ebbb7afe6193dfa77116a5c3ae9b7dc"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">void robust_variance_mlogregr </td>
<td>(</td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>source_table</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>out_table</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>dependent_varname</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>independent_varname</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>ref_category</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">varchar&#160;</td>
<td class="paramname"><em>grouping_cols</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>max_iter</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
</div><!-- contents -->
</div><!-- doc-content -->
<!-- start footer part -->
<div id="nav-path" class="navpath"><!-- id is needed for treeview function! -->
<ul>
<li class="navelem"><a class="el" href="dir_68267d1309a1af8e8297ef4c3efbcdba.html">src</a></li><li class="navelem"><a class="el" href="dir_efbcf68973d247bbf15f9eecae7f24e3.html">ports</a></li><li class="navelem"><a class="el" href="dir_a4a48839224ef8488facbffa8a397967.html">postgres</a></li><li class="navelem"><a class="el" href="dir_dc596537ad427a4d866006d1a3e1fe29.html">modules</a></li><li class="navelem"><a class="el" href="dir_ac52a4b89b7b1b1591f2952b5cbd041a.html">regress</a></li><li class="navelem"><a class="el" href="robust_8sql__in.html">robust.sql_in</a></li>
<li class="footer">Generated on Mon Jul 27 2015 20:37:45 for MADlib by
<a href="http://www.doxygen.org/index.html">
<img class="footer" src="doxygen.png" alt="doxygen"/></a> 1.8.10 </li>
</ul>
</div>
</body>
</html>