首页 error bars

error bars

举报
开通vip

error barsSheet1 100 103 98 87 87 85 91 86 75 73 65 63 70 66 63 53 43 39 36 40 37 40 38 43 41 35 38 27 21 23Sheet1 Readingsat1-MinuteIntervals±10%ErrorSheet2 BondIssue4556-A June October InFavor 22% 40% Opposed 58% 51% NoOpinion 20% 9%Sheet2 SamplingError=3.5%J...

error bars
Sheet1 100 103 98 87 87 85 91 86 75 73 65 63 70 66 63 53 43 39 36 40 37 40 38 43 41 35 38 27 21 23Sheet1 Readingsat1-MinuteIntervals±10%ErrorSheet2 BondIssue4556-A June October InFavor 22% 40% Opposed 58% 51% NoOpinion 20% 9%Sheet2 SamplingError=3.5%JuneOctoberBondIssue4556-ASheet3 Observation Value 1 4.22 Avg: 11.67 2 7.74 SD: 4.69 3 8.05 4 17.44 5 4.49 6 15.76 7 10.80 8 18.13 9 10.45 10 14.14 11 6.81 12 17.15 13 7.19 14 5.29 15 15.09 16 16.39 17 6.08 18 12.56 19 15.21 20 5.11 21 16.13 22 13.64 23 7.51 24 10.38 25 18.06 26 5.97 27 14.17 28 6.28 29 19.69 30 11.44 31 7.77 32 15.16 33 6.87 34 21.87 35 1.34 36 7.58 37 11.70 38 10.80 39 4.89 40 10.05 41 13.11 42 10.99 43 24.13 44 6.34 45 16.97 46 15.76 47 11.38 48 10.63 49 15.83 50 15.57 51 15.70 52 9.00 53 16.46 54 11.57 55 7.35 56 15.77 57 4.85 58 7.50 59 9.63 60 16.09 61 5.87 62 10.46 63 5.87 64 9.70 65 16.42 66 8.28 67 7.16 68 18.44 69 7.80 70 21.08 71 9.88 72 9.40 73 8.92 74 16.80 75 15.82 76 9.24 77 12.83 78 8.21 79 8.84 80 9.04 81 13.04 82 12.73 83 16.71 84 11.06 85 15.60 86 18.67 87 17.23 88 22.08 89 5.88 90 7.61 91 9.80 92 14.33 93 13.62 94 9.12 95 9.71 96 8.23 97 14.27 98 10.75 99 7.18 100 15.04Sheet3 100ObservationsSheet4 X Y 88.43 63.88 24.81 45.97 76.57 70.97 48.11 7.74 35.39 34.91 43.89 79.01 2.44 35.84 13.63 41.59Sheet4 XandY±10%Sheet5 Month ThisYear LastYear Difference Jan 94,640 57,894 -36,746 Feb 96,096 66,394 -29,702 Mar 111,552 88,816 -22,736 Apr 84,448 79,840 -4,608 May 75,712 71,093 -4,619 Jun 61,152 75,520 14,368 Jul 50,960 73,098 22,138 Aug 59,696 70,930 11,234 Sep 99,008 85,904 -13,104 Oct 108,832 97,552 -11,280 Nov 122,112 100,464 -21,648 Dec 117,936 110,656 -7,280Sheet5 -36746 -29702 -22736 -4608 -4619 14368 22138 11234 -13104 -11280 -21648 -7280VerticallinesrepresentprioryearsalesSalesbyMonthSheet6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0SalesbyMonthSheet7 TechSupportAverageDailyCallVolume Week-1 Week-2 Week-3 Week-4 Week-5 Week-6 Sunday 32 45 42 18 33 54 Monday 116 132 126 109 132 119 Tuesday 95 124 109 88 93 90 Wednesday 101 132 101 114 89 98 Thursday 88 103 132 136 99 112 Friday 67 74 104 121 110 87 Saturday 45 55 63 29 34 55 ChartData Week-1 Week-2 Week-3 Week-4 Week-5 Week-6 Average 77.71 95.00 96.71 87.86 84.29 87.86 Maximum 116 132 132 136 132 119 Minimum 32 45 42 18 33 54 Plus 38.286 37.000 35.286 48.143 47.714 31.143 Minus 45.714 50.000 54.714 69.857 51.286 33.857 2 2 3 1 1 1 3 4 2 1 1 1 2 3 1 3 1 2 2 2 1 5 1 1 2 2 3 1 3 1 2 2 1 5 1 2 2 1 1 1 1 2 3 4 3 2 1 2 2 2 2 1 1 2 3 5 1 5 1 1 2 1 2 1 3 2 2 2 1 5 1 2 3 3 2 2 1 3 2 2 3 1 1 3 2 2 1 1 1 2 3 3 2 1 1 2 3 3 2 3 1 3 2 3 1 4 1 3 4 3 1 1 3 1 1 1 5 1 3 2 4 2 1 1 2 2 2 3 1 1 3 2 3 3 1 1 3 3 4 2 1 1 1 2 2 2 1 1 3 2 2 1 5 1 1 3 3 2 2 1 1 3 2 2 1 1 3 2 2 2 2 1 2 2 2 3 5 1 3 2 3 1 5 1 1 3 5 1 4 1 1 2 2 1 5 1 2 2 4 2 1 1 3 2 1 3 4 1 1 2 2 1 4 3 1 3 2 3 4 3 3 2 3 3 5 1 1 2 2 2 1 1 1 2 2 1 5 3 3 2 4 2 1 1 3 2 3 2 1 1 3 2 2 2 1 1 2 2 2 3 4 1 3 2 1 1 4 1 3 2 2 3 1 1 1 2 4 3 4 1 3 2 2 3 1 1 2 3 4 1 1 1 3 2 2 2 1 1 3 2 2 2 1 3 3 3 4 1 5 3 3 2 4 2 1 1 1 2 2 2 1 1 2 1 2 1 1 1 3 2 2 3 4 1 2 3 3 3 2 1 3 2 2 2 1 1 2 3 3 1 1 1 2 3 5 3 5 1 1 3 3 2 1 1 3 2 3 3 4 1 2 3 2 3 5 1 3 3 3 3 1 1 2 2 2 3 1 1 3 2 3 3 1 1 3 2 2 1 5 1 2 2 2 1 5 1 2 3 5 1 4 1 3 2 3 3 5 4 3 3 4 1 4 1 1 3 3 2 2 1 3 2 5 1 4 1 2 3 4 1 5 3 3 2 3 3 4 1 3 2 3 3 3 4 1 2 3 2 2 2 3 1 3 3 1 4 1 2 2 1 3 1 1 3 2 3 2 1 3 1 2 3 3 1 1 1 1 2 3 1 1 2 2 2 1 3 1 3 2 2 1 1 1 1 2 2 1 1 1 1 1 3 2 1 4 2 2 3 3 4 3 3 2 4 1 5 1 3 1 3 3 1 1 3 2 2 1 1 1 3 1 2 2 5 1 2 2 3 3 5 1 3 2 3 1 5 4 2 2 3 3 5 1 3 1 1 1 5 1 3 3 4 3 1 1 3 2 3 3 1 1 3 3 4 3 1 1 2 2 2 3 5 1 2 2 2 1 5 1 1 1 2 1 5 1 1 2 2 1 2 1 1 3 4 3 1 1 2 2 2 2 1 1 1 3 3 3 2 1 1 2 1 3 5 1 1 3 4 3 5 1 3 3 3 2 1 1 2 1 1 3 2 1 4 1 1 3 5 3 3 1 2 2 3 1 3 1 2 2 3 2 1 1 2 2 1 2 1 1 2 2 4 1 4 1 1 2 2 1 5 1 3 1 1 2 1 1 3 2 2 2 1 1 3 3 5 1 1 1 2 2 2 1 5 1 2 3 2 3 5 1 1 2 3 1 3 1 3 2 2 1 5 1 2 2 5 1 5 3 3 3 3 2 1 1 2 2 4 2 1 1 3 2 2 3 2 1 2 2 5 1 4 1 2 2 2 3 4 2 3 1 1 1 5 1 2 3 5 1 3 1 1 2 2 2 3 3 1 2 5 3 1 1 2 2 3 2 1 4 1 3 4 3 5 1 3 3 3 1 5 2 1 1 1 3 1 1 1 2 3 3 1 1 1 2 3 1 3 1 2 2 3 1 4 1 1 2 3 1 1 1 2 3 3 3 5 1 3 3 2 1 1 3 2 2 2 1 3 1 3 1 2 3 1 2 2 2 3 5 1 3 2 2 3 4 1 2 2 2 2 1 1 1 2 3 1 4 3 2 2 2 1 3 2 2 4 3 5 1 3 2 4 3 5 1 1 2 2 1 5 1 2 2 2 3 1 1 1 2 2 1 1 3 3 2 4 3 1 1 3 2 4 3 1 1 3 2 3 3 2 1 1 2 3 1 1 2 1 2 3 5 1 1 3 3 1 1 1 1 2 2 3 1 1 2 2 2 3 1 1 1 2 2 1 5 1 3 2 2 3 5 1 3 4 2 3 1 2 2 2 1 5 1 2 2 2 2 5 1 3 2 2 3 5 1 1 2 1 3 2 1 2 2 3 3 5 1 3 1 4 3 1 1 3 2 2 3 4 3 3 2 2 2 2 1 2 2 2 1 5 1 2 3 3 3 2 1 2 2 2 2 1 1 1 2 2 2 2 1 2 2 3 1 1 1 1 2 4 2 1 1 3 2 2 2 1 1 2 3 3 1 4 1 1 2 2 1 5 1 2 2 2 1 5 1 2 2 3 3 4 1 3 3 2 3 1 1 3 2 2 2 1 3 2 2 3 3 5 1 2 2 5 1 5 2 2 2 3 1 5 1 3 2 4 1 3 1 2 2 2 2 1 1 2 2 4 2 1 1 2 2 1 2 1 1 3 2 3 1 5 1 1 3 3 3 5 1 1 1 2 1 1 2 2 4 3 5 1 3 2 3 1 5 1 3 2 2 2 1 1 2 2 4 2 3 1 2 2 1 1 5 1 3 2 2 3 5 1 2 2 2 3 2 1 3 2 2 3 5 1 1 2 2 3 1 1 3 2 3 2 1 3 3 2 4 3 5 1 3 2 3 1 5 1 1 2 2 2 1 1 3 2 2 2 1 1 3 2 2 1 1 3 1 2 2 3 3 3 1 2 2 1 1 1 1 2 3 1 4 1 1 3 3 3 4 1 3 2 2 2 1 1 2 2 3 2 1 1 1 2 1 2 1 1 2 2 2 3 1 1 3 3 2 3 1 1 2 3 3 2 1 1 1 3 2 1 5 1 1 2 2 2 2 1 1 2 2 2 2 1 3 2 2 3 1 1 1 3 2 2 1 3 3 2 2 3 5 1 1 3 2 2 1 1 3 2 2 2 1 1 3 2 2 2 1 1 2 2 2 5 1 2 1 2 3 1 1 2 2 1 1 1 1 2 2 2 1 1 2 2 2 2 4 1 1 2 2 1 1 1 2 2 4 2 1 1 2 2 2 1 4 3 2 2 2 2 3 1 2 1 1 2 2 1 1 2 2 2 2 1 1 2 1 3 3 1 1 2 3 2 1 1 2 2 3 1 5 1 1 2 2 1 3 1 3 4 3 5 1 1 2 4 2 1 1 1 2 4 1 3 1 2 2 2 2 1 1 3 2 3 3 5 1 3 2 2 3 5 1 2 2 2 2 1 1 2 2 2 2 1 3 3 2 2 2 1 1 3 2 3 2 1 1 2 1 3 2 1 1 2 2 1 3 5 2 2 2 3 2 1 1 3 2 2 2 1 1 2 2 3 2 1 1 2 3 5 3 1 1 2 1 2 3 2 3 2 2 3 2 1 1 2 1 3 2 1 1 2 2 2 2 1 1 1 2 2 2 1 3 1 3 3 2 1 1 3 2 3 2 1 1 2 2 2 2 1 1 1 2 2 2 1 1 3 2 2 3 1 1 2 2 2 1 1 1 3 1 2 2 1 1 3 3 2 1 5 1 1 2 2 2 1 1 3 2 2 2 1 1 2 3 4 3 1 1 2 2 3 2 1 1 2 3 3 2 1 1 1 1 1 2 1 1 1 2 2 2 5 1 3 2 2 2 1 1 3 2 3 2 1 1 1 3 2 2 1 1 3 2 5 2 1 1 1 2 1 2 2 3 2 2 2 2 1 1 3 3 4 2 1 1 2 1 2 2 1 3 2 2 2 2 1 1 2 2 4 2 2 1 1 2 4 2 1 1 3 1 1 2 1 3 1 2 3 2 1 1 2 2 2 2 1 1 3 2 4 2 1 1 3 2 2 2 1 1 3 1 2 2 1 1 2 2 2 2 1 1 1 2 3 3 2 1 3 2 2 2 1 1 2 3 4 2 1 1 3 2 3 2 1 1 3 2 2 2 1 1 2 1 2 3 5 1 3 3 3 3 1 1 2 2 2 3 1 1 3 2 1 2 1 1 2 2 1 2 5 4 3 2 2 2 1 1 2 2 2 2 5 1 1 3 5 3 1 1 1 2 3 2 1 1 2 1 3 2 1 1 2 2 2 1 5 1 3 2 3 3 5 1 2 2 2 2 1 1 3 2 2 2 1 1 2 2 2 2 1 1 2 2 2 3 1 1 2 2 3 2 1 1 2 2 2 2 1 1 1 1 1 1 5 1 2 2 2 1 3 1 1 2 2 2 1 1 2 2 2 2 1 1 1 1 3 2 3 1 2 3 4 3 2 1 3 1 3 3 1 1 3 1 2 2 1 1 1 1 2 1 1 2 1 1 1 1 1 3 2 2 2 1 1 2 2 3 2 1 1 1 2 2 1 5 1 1 2 1 1 4 2 3 2 3 2 1 1 2 2 3 2 1 1 3 2 3 1 5 1 2 1 2 2 1 3 3 2 2 1 1 3 1 3 1 5 1 2 2 2 1 4 1 2 2 2 2 1 1 2 2 3 2 1 1 3 2 2 3 2 1 1 2 2 3 2 1 1 2 2 3 5 3 1 1 2 2 2 1 1 2 2 3 5 1 2 1 2 2 1 1 1 2 2 3 1 1 3 2 2 1 1 1 2 2 2 3 1 1 3 2 2 3 1 1 2 2 2 1 4 1 2 2 3 1 5 3 3 2 1 2 1 1 3 2 3 3 1 1 3 2 3 2 1 1 2 2 3 2 1 3 2 3 3 2 1 1 2 3 2 1 4 1 1 2 2 1 2 1 3 2 1 2 1 1 2 2 3 2 1 3 3 1 2 3 1 1 3 2 3 2 2 1 1 2 2 2 1 1 3 1 2 3 5 1 1 2 3 2 5 1 2 3 2 2 4 1 3 2 1 3 2 1 3 2 2 2 1 1 3 2 3 2 1 1 1 2 1 1 4 3 2 2 1 2 1 1 3 2 1 2 3 1 1 2 1 2 5 1 1 2 2 3 1 1 3 2 3 2 1 1 3 2 2 2 1 1 3 2 3 2 1 1 1 1 1 2 2 1 3 3 2 2 1 1 3 2 3 2 1 1 1 2 2 2 1 1 1 2 2 2 1 1 2 2 2 2 2 1 2 2 2 2 2 1 1 1 1 2 2 3 3 2 2 2 2 1 1 2 1 2 1 1 2 2 2 2 1 1 3 2 1 2 1 1 1 2 2 3 1 1 2 1 2 2 1 1 2 2 2 2 5 1 2 2 2 2 1 3 2 2 3 2 1 1 3 2 3 2 1 1 3 1 1 3 4 1 2 2 4 2 1 1 3 1 1 2 1 1 2 3 3 2 1 1 3 1 2 2 2 3 3 2 4 1 1 1 1 3 2 3 1 1 2 1 2 2 1 1 3 1 1 2 1 1 3 2 1 2 1 1 3 3 2 2 5 1 1 3 4 1 4 1 1 2 2 2 1 1 3 1 2 2 1 4 3 2 2 2 1 1 3 1 2 2 1 2 2 2 1 2 1 1 1 2 2 3 1 1 3 2 1 2 1 1 3 2 2 2 1 1 2 1 1 2 1 1 3 2 5 3 1 1 1 3 4 2 2 3 2 1 1 2 1 1 3 2 1 2 1 1 1 2 2 2 1 1 1 2 2 2 1 1 2 3 3 3 5 1 2 2 2 2 1 1 2 2 3 3 1 3 3 3 3 2 1 1 3 1 2 2 1 1 1 2 2 2 1 1 1 2 2 2 1 1 3 2 1 2 2 1 2 2 2 2 1 1 1 1 1 2 3 1 3 3 2 2 4 1 3 3 4 2 1 1 2 2 3 2 1 1 1 2 3 3 5 1 1 2 3 1 5 1 2 1 1 5 1 1 2 2 2 1 1 3 2 2 2 1 1 2 2 2 2 1 1 1 2 2 2 1 1 2 2 1 2 1 1 3 2 2 2 1 1 1 2 2 3 1 1 2 2 2 2 1 3 1 2 2 2 1 1 3 2 3 2 1 1 3 2 3 2 1 1 2 2 1 2 1 1 2 2 1 2 1 1 3 2 2 2 1 1 2 1 2 2 1 1 1 2 3 3 1 1 3 2 2 2 1 1 2 2 1 3 4 1 3 1 1 2 1 1 1 2 3 2 1 1 1 2 3 2 1 4 1 2 2 2 1 1 2 4 2 1 1 2 3 3 2 1 1 2 2 4 2 1 1 2 3 3 2 1 3 1 1 1 2 1 1 3 2 3 2 5 4 3 1 1 2 1 1 3 2 1 2 4 1 1 2 2 3 3 2 1 3 3 2 1 1 2 1 1 2 1 1 2 2 2 1 4 1 3 2 3 2 1 1 3 1 2 3 5 1 1 2 2 3 1 1 2 2 2 2 1 1 2 2 3 2 1 1 2 2 3 2 1 1 2 2 1 2 2 1 3 1 1 2 1 1 3 2 2 3 1 1 3 3 2 3 1 1 2 2 2 2 1 3 3 2 1 2 1 1 2 2 2 2 1 1 1 2 3 2 1 1 1 3 2 3 1 1 1 2 2 2 1 1 3 3 3 2 2 1 3 2 2 2 1 1 2 3 4 2 1 1 3 3 5 2 1 1 2 2 2 2 1 1 2 2 2 1 1 3 2 1 1 2 1 1 2 2 2 1 1 1 2 3 2 1 1 1 3 4 3 1 1 3 1 2 2 1 1 1 3 2 3 1 1 2 2 2 1 2 1 2 2 2 2 1 1 2 1 1 2 2 1 2 3 2 1 1 2 3 2 3 1 1 2 2 4 2 1 1 3 2 1 1 1 1 3 2 2 1 5 1 3 2 2 2 1 1 3 2 3 3 5 1 2 2 3 2 1 4 1 3 2 3 2 1 2 2 1 1 3 1 1 2 2 2 5 1Sheet7 38.2857142857 45.7142857143 37 50 35.2857142857 54.7142857143 48.1428571429 69.8571428571 47.7142857143 51.2857142857 31.1428571429 33.8571428571TechSupportAverageDailyCallVolumeSheet8 X Y PredictedY Predicted-Actual 12 189 89.42 -99.58 38 121 210.03 89.03 54 195 284.25 89.25 59 341 307.44 -33.56 69 256 353.83 97.83 71 462 363.10 -98.90 74 354 377.02 23.02 88 412 441.96 29.96 91 500 455.88 -44.12 96 532 479.07 -52.93Sheet8 -99.5796182595 89.0269620929 89.2463961559 -33.5600306994 97.82711559 -98.8954551522 23.0206887347 29.9626935398 -44.1211625734 -52.9275894287YXY Month Data SD- SD+ Jan 68 42.79 76.37 Feb 72 42.79 76.37 Mar 45 42.79 76.37 Apr 55 42.79 76.37 May 44 42.79 76.37 Jun 23 42.79 76.37 Jul 67 42.79 76.37 Aug 79 42.79 76.37 Sep 56 42.79 76.37 Oct 67 42.79 76.37 Nov 83 42.79 76.37 Dec 56 42.79 76.37 Simulatederrorbars Data DataSD+SD-
本文档为【error bars】,请使用软件OFFICE或WPS软件打开。作品中的文字与图均可以修改和编辑, 图片更改请在作品中右键图片并更换,文字修改请直接点击文字进行修改,也可以新增和删除文档中的内容。
该文档来自用户分享,如有侵权行为请发邮件ishare@vip.sina.com联系网站客服,我们会及时删除。
[版权声明] 本站所有资料为用户分享产生,若发现您的权利被侵害,请联系客服邮件isharekefu@iask.cn,我们尽快处理。
本作品所展示的图片、画像、字体、音乐的版权可能需版权方额外授权,请谨慎使用。
网站提供的党政主题相关内容(国旗、国徽、党徽..)目的在于配合国家政策宣传,仅限个人学习分享使用,禁止用于任何广告和商用目的。
下载需要: ¥6.0 已有0 人下载
最新资料
资料动态
专题动态
个人认证用户
金喜
小学老师
格式:xls
大小:122KB
软件:Excel
页数:0
分类:
上传时间:2020-03-21
浏览量:0