{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["KNN Smoothing"],"not_rendered":{"charts":2,"external_links":1,"defined_names":23},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"KNN Smoothing","index":0,"n_rows":71,"n_cols":29,"rows_kept":71,"flags":["formulas_cached_only"]}
[null,null,"K-Nearest Neighbor for Smoothing"]
[null,null,"dx",0.1,null,"SSE",0]
[null,null,"K",1]
[]
[]
[null,"Data","X",1,1.2,3.2,4,5.1,{"$nulls":16},"This workbook is a companion of Kardi Teknomo's tutorial"]
[null,null,"Y",23,17,12,27,8,{"$nulls":16},"K Nearest Neighbors"]
[{"$nulls":24},"Copyright © 2008 by Kardi Teknomo"]
[null,null,"Distance",{"$nulls":6},"Nearest Neighbor Values"]
[null,null,"x","d(x, X1)","d(x, X2)","d(x, X3)","d(x, X4)","d(x,X5)",null,"Y1","Y2","Y3","Y4","Y5",null,"est. y","Y","sq. Error",{"$nulls":6},"Visit the complete version of this tutorial in ",{"$nulls":3},"http://people.revoledu.com/kardi/tutorial/index.html"]
[null,null,0,{"v":1,"d":"1.0"},1.2,3.2,{"v":4,"d":"4.0"},5.1,null,{"v":23,"d":"23.0"},"","","","",null,23]
[null,null,0.1,0.9,{"v":1.0999999999999999,"d":"1.1"},3.1,3.9,{"v":5,"d":"5.0"},null,{"v":23,"d":"23.0"},"","","","",null,23]
[null,null,0.2,0.8,{"v":1,"d":"1.0"},{"v":3,"d":"3.0"},3.8,{"v":4.8999999999999995,"d":"4.9"},null,{"v":23,"d":"23.0"},"","","","",null,23]
[null,null,0.30000000000000004,0.7,{"v":0.8999999999999999,"d":"0.9"},{"v":2.9000000000000004,"d":"2.9"},3.7,4.8,null,{"v":23,"d":"23.0"},"","","","",null,23]
[null,null,0.4,0.6,{"v":0.7999999999999999,"d":"0.8"},{"v":2.8000000000000003,"d":"2.8"},3.6,{"v":4.699999999999999,"d":"4.7"},null,{"v":23,"d":"23.0"},"","","","",null,23]
[null,null,0.5,0.5,0.7,2.7,3.5,4.6,null,{"v":23,"d":"23.0"},"","","","",null,23]
[null,null,0.6,0.4,0.6,2.6,3.4,4.5,null,{"v":23,"d":"23.0"},"","","","",null,23]
[null,null,0.7,{"v":0.30000000000000004,"d":"0.3"},0.5,2.5,3.3,{"v":4.3999999999999995,"d":"4.4"},null,{"v":23,"d":"23.0"},"","","","",null,23]
[null,null,0.7999999999999999,{"v":0.20000000000000007,"d":"0.2"},0.4,{"v":2.4000000000000004,"d":"2.4"},3.2,4.3,null,{"v":23,"d":"23.0"},"","","","",null,23]
[null,null,0.8999999999999999,{"v":0.10000000000000009,"d":"0.1"},{"v":0.30000000000000004,"d":"0.3"},{"v":2.3000000000000003,"d":"2.3"},3.1,{"v":4.199999999999999,"d":"4.2"},null,{"v":23,"d":"23.0"},"","","","",null,23]
[null,null,0.9999999999999999,{"v":1.1102230246251565e-16,"d":"0.0"},{"v":0.20000000000000007,"d":"0.2"},2.2,{"v":3,"d":"3.0"},4.1,null,{"v":23,"d":"23.0"},"","","","",null,23,23,0]
[null,null,1.0999999999999999,{"v":0.09999999999999987,"d":"0.1"},{"v":0.10000000000000009,"d":"0.1"},{"v":2.1000000000000005,"d":"2.1"},{"v":2.9000000000000004,"d":"2.9"},{"v":4,"d":"4.0"},null,{"v":23,"d":"23.0"},"","","","",null,23]
[null,null,1.2,{"v":0.19999999999999996,"d":"0.2"},{"v":0,"d":"0.0"},{"v":2,"d":"2.0"},2.8,{"v":3.8999999999999995,"d":"3.9"},null,"",{"v":17,"d":"17.0"},"","","",null,17,17,0]
[null,null,1.3,{"v":0.30000000000000004,"d":"0.3"},{"v":0.10000000000000009,"d":"0.1"},{"v":1.9000000000000001,"d":"1.9"},2.7,3.8,null,"",{"v":17,"d":"17.0"},"","","",null,17]
[null,null,1.4000000000000001,{"v":0.40000000000000013,"d":"0.4"},{"v":0.20000000000000018,"d":"0.2"},1.8,{"v":2.5999999999999996,"d":"2.6"},{"v":3.6999999999999993,"d":"3.7"},null,"",{"v":17,"d":"17.0"},"","","",null,17]
[null,null,1.5000000000000002,{"v":0.5000000000000002,"d":"0.5"},{"v":0.30000000000000027,"d":"0.3"},1.7,2.5,{"v":3.5999999999999996,"d":"3.6"},null,"",{"v":17,"d":"17.0"},"","","",null,17]
[null,null,1.6000000000000003,{"v":0.6000000000000003,"d":"0.6"},{"v":0.40000000000000036,"d":"0.4"},{"v":1.5999999999999999,"d":"1.6"},{"v":2.3999999999999995,"d":"2.4"},{"v":3.499999999999999,"d":"3.5"},null,"",{"v":17,"d":"17.0"},"","","",null,17]
[null,null,1.7000000000000004,{"v":0.7000000000000004,"d":"0.7"},{"v":0.5000000000000004,"d":"0.5"},{"v":1.4999999999999998,"d":"1.5"},2.3,{"v":3.3999999999999995,"d":"3.4"},null,"",{"v":17,"d":"17.0"},"","","",null,17]
[null,null,1.8000000000000005,{"v":0.8000000000000005,"d":"0.8"},{"v":0.6000000000000005,"d":"0.6"},{"v":1.3999999999999997,"d":"1.4"},{"v":2.1999999999999993,"d":"2.2"},{"v":3.299999999999999,"d":"3.3"},null,"",{"v":17,"d":"17.0"},"","","",null,17]
[null,null,1.9000000000000006,{"v":0.9000000000000006,"d":"0.9"},{"v":0.7000000000000006,"d":"0.7"},{"v":1.2999999999999996,"d":"1.3"},{"v":2.0999999999999996,"d":"2.1"},{"v":3.1999999999999993,"d":"3.2"},null,"",{"v":17,"d":"17.0"},"","","",null,17]
[null,null,2.0000000000000004,{"v":1.0000000000000004,"d":"1.0"},{"v":0.8000000000000005,"d":"0.8"},{"v":1.1999999999999997,"d":"1.2"},{"v":1.9999999999999996,"d":"2.0"},{"v":3.099999999999999,"d":"3.1"},null,"",{"v":17,"d":"17.0"},"","","",null,17]
[null,null,2.1000000000000005,{"v":1.1000000000000005,"d":"1.1"},{"v":0.9000000000000006,"d":"0.9"},{"v":1.0999999999999996,"d":"1.1"},{"v":1.8999999999999995,"d":"1.9"},{"v":2.999999999999999,"d":"3.0"},null,"",{"v":17,"d":"17.0"},"","","",null,17]
[null,null,2.2000000000000006,{"v":1.2000000000000006,"d":"1.2"},{"v":1.0000000000000007,"d":"1.0"},{"v":0.9999999999999996,"d":"1.0"},{"v":1.7999999999999994,"d":"1.8"},{"v":2.899999999999999,"d":"2.9"},null,"",{"v":17,"d":"17.0"},{"v":12,"d":"12.0"},"","",null,{"v":14.5,"d":"15"}]
[null,null,2.3000000000000007,{"v":1.3000000000000007,"d":"1.3"},{"v":1.1000000000000008,"d":"1.1"},{"v":0.8999999999999995,"d":"0.9"},{"v":1.6999999999999993,"d":"1.7"},{"v":2.799999999999999,"d":"2.8"},null,"","",{"v":12,"d":"12.0"},"","",null,12]
[null,null,2.400000000000001,{"v":1.4000000000000008,"d":"1.4"},{"v":1.2000000000000008,"d":"1.2"},{"v":0.7999999999999994,"d":"0.8"},{"v":1.5999999999999992,"d":"1.6"},{"v":2.699999999999999,"d":"2.7"},null,"","",{"v":12,"d":"12.0"},"","",null,12]
[null,null,2.500000000000001,{"v":1.5000000000000009,"d":"1.5"},{"v":1.300000000000001,"d":"1.3"},{"v":0.6999999999999993,"d":"0.7"},{"v":1.4999999999999991,"d":"1.5"},{"v":2.5999999999999988,"d":"2.6"},null,"","",{"v":12,"d":"12.0"},"","",null,12]
[null,null,2.600000000000001,{"v":1.600000000000001,"d":"1.6"},{"v":1.400000000000001,"d":"1.4"},{"v":0.5999999999999992,"d":"0.6"},{"v":1.399999999999999,"d":"1.4"},{"v":2.4999999999999987,"d":"2.5"},null,"","",{"v":12,"d":"12.0"},"","",null,12]
[null,null,2.700000000000001,{"v":1.700000000000001,"d":"1.7"},{"v":1.500000000000001,"d":"1.5"},{"v":0.4999999999999991,"d":"0.5"},{"v":1.299999999999999,"d":"1.3"},{"v":2.3999999999999986,"d":"2.4"},null,"","",{"v":12,"d":"12.0"},"","",null,12]
[null,null,2.800000000000001,{"v":1.8000000000000012,"d":"1.8"},{"v":1.6000000000000012,"d":"1.6"},{"v":0.399999999999999,"d":"0.4"},{"v":1.1999999999999988,"d":"1.2"},{"v":2.2999999999999985,"d":"2.3"},null,"","",{"v":12,"d":"12.0"},"","",null,12]
[null,null,2.9000000000000012,{"v":1.9000000000000012,"d":"1.9"},{"v":1.7000000000000013,"d":"1.7"},{"v":0.29999999999999893,"d":"0.3"},{"v":1.0999999999999988,"d":"1.1"},{"v":2.1999999999999984,"d":"2.2"},null,"","",{"v":12,"d":"12.0"},"","",null,12]
[null,null,3.0000000000000013,{"v":2.0000000000000013,"d":"2.0"},{"v":1.8000000000000014,"d":"1.8"},{"v":0.19999999999999885,"d":"0.2"},{"v":0.9999999999999987,"d":"1.0"},{"v":2.0999999999999983,"d":"2.1"},null,"","",{"v":12,"d":"12.0"},"","",null,12]
[null,null,3.1000000000000014,{"v":2.1000000000000014,"d":"2.1"},{"v":1.9000000000000015,"d":"1.9"},{"v":0.09999999999999876,"d":"0.1"},{"v":0.8999999999999986,"d":"0.9"},{"v":1.9999999999999982,"d":"2.0"},null,"","",{"v":12,"d":"12.0"},"","",null,12]
[null,null,3.2000000000000015,{"v":2.2000000000000015,"d":"2.2"},{"v":2.0000000000000018,"d":"2.0"},{"v":1.3322676295501878e-15,"d":"0.0"},{"v":0.7999999999999985,"d":"0.8"},{"v":1.8999999999999981,"d":"1.9"},null,"","",{"v":12,"d":"12.0"},"","",null,12,12,0]
[null,null,3.3000000000000016,{"v":2.3000000000000016,"d":"2.3"},{"v":2.1000000000000014,"d":"2.1"},{"v":0.10000000000000142,"d":"0.1"},{"v":0.6999999999999984,"d":"0.7"},{"v":1.799999999999998,"d":"1.8"},null,"","",{"v":12,"d":"12.0"},"","",null,12]
[null,null,3.4000000000000017,{"v":2.4000000000000017,"d":"2.4"},{"v":2.200000000000002,"d":"2.2"},{"v":0.2000000000000015,"d":"0.2"},{"v":0.5999999999999983,"d":"0.6"},{"v":1.699999999999998,"d":"1.7"},null,"","",{"v":12,"d":"12.0"},"","",null,12]
[null,null,3.5000000000000018,{"v":2.5000000000000018,"d":"2.5"},{"v":2.3000000000000016,"d":"2.3"},{"v":0.3000000000000016,"d":"0.3"},{"v":0.4999999999999982,"d":"0.5"},{"v":1.5999999999999979,"d":"1.6"},null,"","",{"v":12,"d":"12.0"},"","",null,12]
[null,null,3.600000000000002,{"v":2.600000000000002,"d":"2.6"},{"v":2.400000000000002,"d":"2.4"},{"v":0.4000000000000017,"d":"0.4"},{"v":0.39999999999999813,"d":"0.4"},{"v":1.4999999999999978,"d":"1.5"},null,"","","",{"v":27,"d":"27.0"},"",null,27]
[null,null,3.700000000000002,{"v":2.700000000000002,"d":"2.7"},{"v":2.5000000000000018,"d":"2.5"},{"v":0.5000000000000018,"d":"0.5"},{"v":0.29999999999999805,"d":"0.3"},{"v":1.3999999999999977,"d":"1.4"},null,"","","",{"v":27,"d":"27.0"},"",null,27]
[null,null,3.800000000000002,{"v":2.800000000000002,"d":"2.8"},{"v":2.6000000000000023,"d":"2.6"},{"v":0.6000000000000019,"d":"0.6"},{"v":0.19999999999999796,"d":"0.2"},{"v":1.2999999999999976,"d":"1.3"},null,"","","",{"v":27,"d":"27.0"},"",null,27]
[null,null,3.900000000000002,{"v":2.900000000000002,"d":"2.9"},{"v":2.700000000000002,"d":"2.7"},{"v":0.700000000000002,"d":"0.7"},{"v":0.09999999999999787,"d":"0.1"},{"v":1.1999999999999975,"d":"1.2"},null,"","","",{"v":27,"d":"27.0"},"",null,27]
[null,null,4.000000000000002,{"v":3.0000000000000018,"d":"3.0"},{"v":2.8000000000000016,"d":"2.8"},{"v":0.8000000000000016,"d":"0.8"},{"v":1.7763568394002505e-15,"d":"0.0"},{"v":1.0999999999999979,"d":"1.1"},null,"","","",{"v":27,"d":"27.0"},"",null,27,27,0]
[null,null,4.100000000000001,{"v":3.1000000000000014,"d":"3.1"},{"v":2.9000000000000012,"d":"2.9"},{"v":0.9000000000000012,"d":"0.9"},{"v":0.10000000000000142,"d":"0.1"},{"v":0.9999999999999982,"d":"1.0"},null,"","","",{"v":27,"d":"27.0"},"",null,27]
[null,null,4.200000000000001,{"v":3.200000000000001,"d":"3.2"},{"v":3.000000000000001,"d":"3.0"},{"v":1.0000000000000009,"d":"1.0"},{"v":0.20000000000000107,"d":"0.2"},{"v":0.8999999999999986,"d":"0.9"},null,"","","",{"v":27,"d":"27.0"},"",null,27]
[null,null,4.300000000000001,{"v":3.3000000000000007,"d":"3.3"},{"v":3.1000000000000005,"d":"3.1"},{"v":1.1000000000000005,"d":"1.1"},{"v":0.3000000000000007,"d":"0.3"},{"v":0.7999999999999989,"d":"0.8"},null,"","","",{"v":27,"d":"27.0"},"",null,27]
[null,null,4.4,{"v":3.4000000000000004,"d":"3.4"},3.2,{"v":1.2000000000000002,"d":"1.2"},{"v":0.40000000000000036,"d":"0.4"},{"v":0.6999999999999993,"d":"0.7"},null,"","","",{"v":27,"d":"27.0"},"",null,27]
[null,null,4.5,3.5,3.3,{"v":1.2999999999999998,"d":"1.3"},0.5,{"v":0.5999999999999996,"d":"0.6"},null,"","","",{"v":27,"d":"27.0"},"",null,27]
[null,null,4.6,{"v":3.5999999999999996,"d":"3.6"},{"v":3.3999999999999995,"d":"3.4"},{"v":1.3999999999999995,"d":"1.4"},{"v":0.5999999999999996,"d":"0.6"},0.5,null,"","","","",{"v":8,"d":"8.0"},null,8]
[null,null,4.699999999999999,{"v":3.6999999999999993,"d":"3.7"},{"v":3.499999999999999,"d":"3.5"},{"v":1.4999999999999991,"d":"1.5"},{"v":0.6999999999999993,"d":"0.7"},{"v":0.40000000000000036,"d":"0.4"},null,"","","","",{"v":8,"d":"8.0"},null,8]
[null,null,4.799999999999999,{"v":3.799999999999999,"d":"3.8"},{"v":3.5999999999999988,"d":"3.6"},{"v":1.5999999999999988,"d":"1.6"},{"v":0.7999999999999989,"d":"0.8"},{"v":0.3000000000000007,"d":"0.3"},null,"","","","",{"v":8,"d":"8.0"},null,8]
[null,null,4.899999999999999,{"v":3.8999999999999986,"d":"3.9"},{"v":3.6999999999999984,"d":"3.7"},{"v":1.6999999999999984,"d":"1.7"},{"v":0.8999999999999986,"d":"0.9"},{"v":0.20000000000000107,"d":"0.2"},null,"","","","",{"v":8,"d":"8.0"},null,8]
[null,null,4.999999999999998,{"v":3.9999999999999982,"d":"4.0"},{"v":3.799999999999998,"d":"3.8"},{"v":1.799999999999998,"d":"1.8"},{"v":0.9999999999999982,"d":"1.0"},{"v":0.10000000000000142,"d":"0.1"},null,"","","","",{"v":8,"d":"8.0"},null,8]
[null,null,5.099999999999998,{"v":4.099999999999998,"d":"4.1"},{"v":3.8999999999999977,"d":"3.9"},{"v":1.8999999999999977,"d":"1.9"},{"v":1.0999999999999979,"d":"1.1"},{"v":1.7763568394002505e-15,"d":"0.0"},null,"","","","",{"v":8,"d":"8.0"},null,8,8,0]
[null,null,5.1999999999999975,{"v":4.1999999999999975,"d":"4.2"},{"v":3.9999999999999973,"d":"4.0"},{"v":1.9999999999999973,"d":"2.0"},{"v":1.1999999999999975,"d":"1.2"},{"v":0.09999999999999787,"d":"0.1"},null,"","","","",{"v":8,"d":"8.0"},null,8]
[null,null,5.299999999999997,{"v":4.299999999999997,"d":"4.3"},{"v":4.099999999999997,"d":"4.1"},{"v":2.099999999999997,"d":"2.1"},{"v":1.2999999999999972,"d":"1.3"},{"v":0.1999999999999975,"d":"0.2"},null,"","","","",{"v":8,"d":"8.0"},null,8]
[null,null,5.399999999999997,{"v":4.399999999999997,"d":"4.4"},{"v":4.199999999999997,"d":"4.2"},{"v":2.1999999999999966,"d":"2.2"},{"v":1.3999999999999968,"d":"1.4"},{"v":0.29999999999999716,"d":"0.3"},null,"","","","",{"v":8,"d":"8.0"},null,8]
[null,null,5.4999999999999964,{"v":4.4999999999999964,"d":"4.5"},{"v":4.299999999999996,"d":"4.3"},{"v":2.2999999999999963,"d":"2.3"},{"v":1.4999999999999964,"d":"1.5"},{"v":0.3999999999999968,"d":"0.4"},null,"","","","",{"v":8,"d":"8.0"},null,8]
[null,null,5.599999999999996,{"v":4.599999999999996,"d":"4.6"},{"v":4.399999999999996,"d":"4.4"},{"v":2.399999999999996,"d":"2.4"},{"v":1.599999999999996,"d":"1.6"},{"v":0.49999999999999645,"d":"0.5"},null,"","","","",{"v":8,"d":"8.0"},null,8]
[null,null,5.699999999999996,{"v":4.699999999999996,"d":"4.7"},{"v":4.499999999999996,"d":"4.5"},{"v":2.4999999999999956,"d":"2.5"},{"v":1.6999999999999957,"d":"1.7"},{"v":0.5999999999999961,"d":"0.6"},null,"","","","",{"v":8,"d":"8.0"},null,8]
[null,null,5.799999999999995,{"v":4.799999999999995,"d":"4.8"},{"v":4.599999999999995,"d":"4.6"},{"v":2.599999999999995,"d":"2.6"},{"v":1.7999999999999954,"d":"1.8"},{"v":0.6999999999999957,"d":"0.7"},null,"","","","",{"v":8,"d":"8.0"},null,8]
[null,null,5.899999999999995,{"v":4.899999999999995,"d":"4.9"},{"v":4.699999999999995,"d":"4.7"},{"v":2.699999999999995,"d":"2.7"},{"v":1.899999999999995,"d":"1.9"},{"v":0.7999999999999954,"d":"0.8"},null,"","","","",{"v":8,"d":"8.0"},null,8]
[null,null,5.999999999999995,{"v":4.999999999999995,"d":"5.0"},{"v":4.7999999999999945,"d":"4.8"},{"v":2.7999999999999945,"d":"2.8"},{"v":1.9999999999999947,"d":"2.0"},{"v":0.899999999999995,"d":"0.9"},null,"","","","",{"v":8,"d":"8.0"},null,8]