| /* ----------------------------------------------------------------------- *//** |
| * |
| * Licensed to the Apache Software Foundation (ASF) under one |
| * or more contributor license agreements. See the NOTICE file |
| * distributed with this work for additional information |
| * regarding copyright ownership. The ASF licenses this file |
| * to you under the Apache License, Version 2.0 (the |
| * "License"); you may not use this file except in compliance |
| * with the License. You may obtain a copy of the License at |
| * |
| * http://www.apache.org/licenses/LICENSE-2.0 |
| * |
| * Unless required by applicable law or agreed to in writing, |
| * software distributed under the License is distributed on an |
| * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY |
| * KIND, either express or implied. See the License for the |
| * specific language governing permissions and limitations |
| * under the License. |
| * |
| *//* ----------------------------------------------------------------------- */ |
| |
| /* ----------------------------------------------------------------------------- |
| * Test F-test. |
| * |
| * Example ("JAHANMI2.DAT") taken from: |
| * http://www.itl.nist.gov/div898/handbook/eda/section3/eda359.htm |
| * -------------------------------------------------------------------------- */ |
| |
| CREATE TABLE jahanmi2 ( |
| Run INTEGER, |
| Lab INTEGER, |
| Batch INTEGER, |
| Y FLOAT8, |
| X1 FLOAT8, |
| X2 FLOAT8, |
| X3 FLOAT8 |
| ); |
| |
| COPY jahanmi2 FROM stdin; |
| 1 1 1 608.781 -1 -1 -1 |
| 2 1 2 569.670 -1 -1 -1 |
| 62 1 2 587.695 -1 1 1 |
| 90 1 2 592.845 -1 1 1 |
| 151 2 1 753.333 1 1 1 |
| 179 2 1 635.079 1 1 1 |
| 180 2 2 534.236 1 1 1 |
| 181 2 1 716.926 1 -1 -1 |
| 182 2 2 606.188 1 -1 -1 |
| 299 3 1 701.716 1 -1 1 |
| 300 3 2 627.516 1 -1 1 |
| 301 3 1 382.133 1 1 -1 |
| 302 3 2 574.522 1 1 -1 |
| 303 3 1 719.744 1 1 -1 |
| 389 4 1 775.272 -1 -1 1 |
| 390 4 2 579.167 -1 -1 1 |
| 421 4 1 708.885 -1 1 -1 |
| 450 4 2 703.980 -1 1 -1 |
| 541 5 1 715.224 -1 -1 -1 |
| 569 5 1 776.197 -1 -1 -1 |
| 570 5 2 345.294 -1 -1 -1 |
| 571 5 1 547.099 1 -1 1 |
| 572 5 2 570.999 1 -1 1 |
| 573 5 1 619.942 1 -1 1 |
| 629 6 1 684.523 1 1 1 |
| 630 6 2 552.304 1 1 1 |
| 631 6 1 717.159 -1 1 -1 |
| 632 6 2 545.303 -1 1 -1 |
| 633 6 1 721.343 -1 1 -1 |
| 749 7 1 690.826 1 1 -1 |
| 750 7 2 472.463 1 1 -1 |
| 811 7 1 666.893 -1 1 1 |
| 812 7 2 645.932 -1 1 1 |
| 813 7 1 759.860 -1 1 1 |
| 929 8 1 682.500 -1 -1 1 |
| 930 8 2 684.167 -1 -1 1 |
| 931 8 1 658.116 1 -1 -1 |
| 932 8 2 672.153 1 -1 -1 |
| 933 8 1 738.213 1 -1 -1 |
| \. |
| |
| CREATE TABLE f_test AS |
| SELECT (f_test((2 - batch)::BOOLEAN, y)).* FROM jahanmi2; |