---

Overview

przeplywy_charakterystyczne
krzywa_prawdopodobienstwa

---

Sheet 1: przeplywy_charakterystyczne

	WQ	SQ	NQ
1961	8.61	3.78	1.67				WWQ	75.1920312			Q3,0%=	55.257	m3/s
1962	11.1	4.57	1.3				SWQ	20.2031744254545			Q1,0%=	65.932	m3/s
1963	6.65	2	0.23				NWQ	4.4616078			Q0,5%=	78.311	m3/s
1964	6.78	2.61	0.6								Q0,2%=	85.739	m3/s
1965	14.9	3.56	0.9				WSQ	16.6317421238042			Q0,1%=	88.215	m3/s
1966	12.9	3.45	0.71				SSQ	6.08724623078792
1967	18.2	6.71	2.65				NSQ	2
1968	17.1	5.75	0.93
1969	6.58	3.05	0.21				WNQ	4.0014624
1970	24	4.16	0.46				SNQ	1.37907164727273
1971	9.33	4.04	0.9				NNQ	0.21
1972	5.34	3.323	1.42
1973	14.59	5.558	1.37
1974	21.22	7.474	2.41
1975	39.86	9.652	1.13
1976	9.05	3.663	0.83
1977	41.65	12.583	2.39
1978	13.42	5.900	0.98
1979	75.19	11.198	1.15
1980	65.36	12.501	2.10
1981	48.98	12.847	2.71
1982	31.04	8.809	1.02
1983	6.61	2.538	0.41
1984	8.66	3.109	0.72
1985	17.86	6.406	2.01
1986	40.25	10.639	2.38
1987	30.73	8.613	3.73
1988	50.15	16.632	4.00
1989	16.30	4.746	0.43
1990	4.96	2.256	0.69
1991	4.46	2.063	0.45
1992	8.11	2.137	0.58
1993	6.94	2.613	1.02
1994	33.46	9.448	1.66
1995	12.09	5.354	1.97
1996	14.04	6.722	3.49
1997	11.15	6.159	2.84
1998	19.34	6.463	1.90
1999	41.34	12.816	0.87
2000	15.990	4.827	1.084
2001	15.990	7.402	2.839
2002	36.348	10.117	1.404
2003	12.090	4.420	0.671
2004	9.438	2.487	0.663
2005	15.210	4.066	0.967
2006	6.271	2.355	0.702
2007	29.094	7.249	0.897
2008	14.352	5.122	0.538
2009	8.580	2.723	0.811
2010	17.238	7.129	2.012
2011	41.730	10.383	1.154
2012	10.842	4.481	1.864
2013	21.528	8.007	2.075
2014	15.912	5.407	0.686
2015	12.246	2.724	0.257

---

Sheet 2: krzywa_prawdopodobienstwa

																										y=	7.5534	+	-9.9794
									0.10%				0.2%				0.5%				1%				3%
									X	Y			X	Y			X	Y			X	Y			X	Y
									0	88.2148			0	85.7389633333333			0	78.3114533333333			0	65.93227			0	55.256798
									13	88.2148			12.6722222222222	85.7389633333333			11.6888888888889	78.3114533333333			10.05	65.93227			8.63666666666667	55.256798
									13	88.2148			12.6722222222222	85.7389633333333			11.6888888888889	78.3114533333333			10.05	65.93227			8.63666666666667	55.256798
									13	0			12.6722222222222	0			11.6888888888889	0			10.05	0			8.63666666666667	0
										Oś X																											5%
										0	0		0.82	0		1.02	0		1.37	0		1.75	0		2.3	0		2.76	0		3.67	0		4.74	0		5.51	0		7.75	0		8.63666666666667	0		9.08	0		10.05	0		13	0
										0	90		0.82	90		1.02	90		1.37	90		1.75	90		2.3	90		2.76	90		3.67	90		4.74	90		5.51	90		7.75	90		8.63666666666667	90		9.08	90		10.05	90		13	90
		Sprawdzić zgodność tabeli!!!!!!!!!
Przeciągnij w dół lub usuń w zależności od ilości danych									Ciąg rozdzielczy
	m	WQ [m3/s]	Prawdopodobieństow						m	WQ [m3/s]	p% [p%=(2*m-1)/n*100%]							wartość X do wykresu
	1	75.1920312							1	75.1920312	0.91							10.3479797979798							X	%		Δx	Δ%
	2	65.3640546							2	65.3640546	2.73							8.75757575757576							0	100		0	0
	3	50.1540234							3	50.1540234	4.55							7.95151515151515							0.82	99		0.82	1
	4	48.9840234							4	48.9840234	6.36							7.45818181818182							1.02	98		0.2	1									Wklej wartości z tabeli po lewej i wklej jako warości a następnie posortuj od największej do najmniejszej
	5	41.7300078							5	41.7300078	8.18							7.06909090909091							1.37	95		0.35	3
	6	41.652039							6	41.652039	10.00							6.68							1.75	90		0.38	5				Lp.	rok	WQ	p[%]		WQ	p[%]
	7	41.3400234							7	41.3400234	11.82							6.46727272727273							2.3	80		0.55	10				1	1961	8.61	100.00%		75.19	0.91%
	8	40.2480078							8	41.3400234	13.64							6.25454545454546							2.76	70		0.46	10				2	1962	11.1	200.00%		65.36	2.73%
	9	39.8580078							9	39.8580078	15.45							6.04181818181818							3.67	50		0.91	20				3	1963	6.65	300.00%		50.15	4.55%
	10	36.3480234							10	36.3480234	17.27							5.82909090909091							4.74	30		1.07	20				4	1964	6.78	400.00%		48.98	6.36%
	11	33.4620156							11	33.4620156	19.09							5.61636363636364							5.51	20		0.77	10				5	1965	14.9	500.00%		41.730	8.18%
	12	31.0440078							12	31.0440078	20.91							5.44							6.68	10		1.17	10				6	1966	12.9	600.00%		41.65	10.00%
	13	30.7320312							13	30.7320312	22.73							5.3							7.75	5		1.07	5				7	1967	18.2	700.00%		41.34	11.82%
	14	29.0940234							14	29.0940234	24.55							5.16							9.08	2		1.33	3				8	1968	17.1	800.00%		40.25	13.64%
	15	24							15	24	26.36							5.02							10.05	1		0.970000000000001	1				9	1969	6.58	900.00%		39.86	15.45%
	16	21.5280156							16	21.5280156	28.18							4.88							13	0.1		2.95	0.9				10	1970	24	1000.00%		36.348	17.27%
	17	21.2160078							17	21.2160078	30.00							4.74															11	1971	9.33	1100.00%		33.46	19.09%
	18	19.3440234							18	19.3440234	31.82							4.64272727272727															12	1972	5.34	1200.00%		31.04	20.91%
	19	18.2							19	18.2	33.64							4.54545454545455															13	1973	14.59	1300.00%		30.73	22.73%
	20	17.8620624							20	17.8620624	35.45							4.44818181818182															14	1974	21.22	1400.00%		29.094	24.55%
	21	17.2380312							21	17.2380312	37.27							4.35090909090909															15	1975	39.86	1500.00%		24	26.36%
	22	17.1							22	17.1	39.09							4.25363636363636															16	1976	9.05	1600.00%		21.528	28.18%
	23	16.3020936							23	16.3020936	40.91							4.15636363636364															17	1977	41.65	1700.00%		21.22	30.00%
	24	15.9900234							24	15.9900234	42.73							4.05909090909091															18	1978	13.42	1800.00%		19.34	31.82%
	25	#N/A							25	#N/A	44.55							3.96181818181818															19	1979	75.19	1900.00%		18.2	33.64%
	26	15.9120234							26	15.9120234	46.36							3.86454545454545															20	1980	65.36	2000.00%		17.86	35.45%
	27	15.2100234							27	15.2100234	48.18							3.76727272727273															21	1981	48.98	2100.00%		17.238	37.27%
	28	14.9							28	14.9	50.00							3.67															22	1982	31.04	2200.00%		17.1	39.09%
	29	14.5860156							29	14.5860156	51.82							3.58727272727273															23	1983	6.61	2300.00%		16.30	40.91%
	30	14.3520312							30	14.3520312	53.64							3.50454545454545															24	1984	8.66	2400.00%		15.990	42.73%
	31	14.040039							31	14.040039	55.45							3.42181818181818															25	1985	17.86	2500.00%		15.990	44.55%
	32	13.4160078							32	13.4160078	57.27							3.33909090909091															26	1986	40.25	2600.00%		15.912	46.36%
	33	12.9							33	12.9	59.09							3.25636363636364															27	1987	30.73	2700.00%		15.210	48.18%
	34	12.2460078							34	12.2460078	60.91							3.17363636363636															28	1988	50.15	2800.00%		14.9	50.00%
	35	12.0900312							35	12.0900312	62.73							3.09090909090909															29	1989	16.30	2900.00%		14.59	51.82%
	36	12.0900234							36	12.0900234	64.55							3.00818181818182															30	1990	4.96	3000.00%		14.352	53.64%
	37	11.1540234							37	11.1540234	66.36							2.92545454545454															31	1991	4.46	3100.00%		14.04	55.45%
	38	11.1							38	11.1	68.18							2.84272727272727															32	1992	8.11	3200.00%		13.42	57.27%
	39	10.8420234							39	10.8420234	70.00							2.76															33	1993	6.94	3300.00%		12.9	59.09%
	40	9.4380156							40	9.4380156	71.82							2.67636363636364															34	1994	33.46	3400.00%		12.246	60.91%
	41	9.33							41	9.33	73.64							2.59272727272727															35	1995	12.09	3500.00%		12.09	62.73%
	42	9.0480078							42	9.0480078	75.45							2.50909090909091															36	1996	14.04	3600.00%		12.090	64.55%
	43	8.6580546							43	8.6580546	77.27							2.42545454545455															37	1997	11.15	3700.00%		11.15	66.36%
	44	8.61							44	8.61	79.09							2.34181818181818															38	1998	19.34	3800.00%		11.1	68.18%
	45	8.5800234							45	8.5800234	80.91							2.25															39	1999	41.34	3900.00%		10.842	70.00%
	46	8.1120234							46	8.1120234	82.73							2.15															40	2000	15.990	4000.00%		9.438	71.82%
	47	6.9420312							47	6.9420312	84.55							2.05															41	2001	15.990	4100.00%		9.33	73.64%
	48	6.78							48	6.78	86.36							1.95															42	2002	36.348	4200.00%		9.05	75.45%
	49	6.65							49	6.65	88.18							1.85															43	2003	12.090	4300.00%		8.66	77.27%
	50	6.6066234							50	6.6066234	90.00							1.75															44	2004	9.438	4400.00%		8.61	79.09%
	51	6.58							51	6.58	91.82							1.61181818181818															45	2005	15.210	4500.00%		8.580	80.91%
	52	6.2712936							52	6.2712936	93.64							1.47363636363636															46	2006	6.271	4600.00%		8.11	82.73%
	53	5.3352312							53	5.3352312	95.45							1.3169696969697															47	2007	29.094	4700.00%		6.94	84.55%
	54	4.9608312							54	4.9608312	97.27							1.10484848484848															48	2008	14.352	4800.00%		6.78	86.36%
	55	4.4616078							55	4.4616078	99.09							0.745454545454543															49	2009	8.580	4900.00%		6.65	88.18%
																																	50	2010	17.238	5000.00%		6.61	90.00%
																																	51	2011	41.730	5100.00%		6.58	91.82%
																																	52	2012	10.842	5200.00%		6.271	93.64%
																																	53	2013	21.528	5300.00%		5.34	95.45%
																																	54	2014	15.912	5400.00%		4.96	97.27%
																																	55	2015	12.246	5500.00%		4.46	99.09%
		Zestawienie przepływów
		Rok	WQ [m3/s]
	1	1961	8.61		44	8.61
	2	1962	11.1		38	11.1
	3	1963	6.65		49	6.65
	4	1964	6.78		48	6.78
	5	1965	14.9		28	14.9
	6	1966	12.9		33	12.9
	7	1967	18.2		19	18.2
	8	1968	17.1		22	17.1
	9	1969	6.58		51	6.58
	10	1970	24		15	24
	11	1971	9.33		41	9.33
	12	1972	5.3352312		53	5.3352312
	13	1973	14.5860156		29	14.5860156
	14	1974	21.2160078		17	21.2160078
	15	1975	39.8580078		9	39.8580078
	16	1976	9.0480078		42	9.0480078
	17	1977	41.652039		6	41.652039
	18	1978	13.4160078		32	13.4160078
	19	1979	75.1920312		1	75.1920312
	20	1980	65.3640546		2	65.3640546
	21	1981	48.9840234		4	48.9840234
	22	1982	31.0440078		12	31.0440078
	23	1983	6.6066234		50	6.6066234
	24	1984	8.6580546		43	8.6580546
	25	1985	17.8620624		20	17.8620624
	26	1986	40.2480078		8	40.2480078
	27	1987	30.7320312		13	30.7320312
	28	1988	50.1540234		3	50.1540234
	29	1989	16.3020936		23	16.3020936
	30	1990	4.9608312		54	4.9608312
	31	1991	4.4616078		55	4.4616078
	32	1992	8.1120234		46	8.1120234
	33	1993	6.9420312		47	6.9420312
	34	1994	33.4620156		11	33.4620156
	35	1995	12.0900312		35	12.0900312
	36	1996	14.040039		31	14.040039
	37	1997	11.1540234		37	11.1540234
	38	1998	19.3440234		18	19.3440234
	39	1999	41.3400234		7	41.3400234
	40	2000	15.9900234		24	15.9900234
	41	2001	15.9900234		24	15.9900234
	42	2002	36.3480234		10	36.3480234
	43	2003	12.0900234		36	12.0900234
	44	2004	9.4380156		40	9.4380156
	45	2005	15.2100234		27	15.2100234
	46	2006	6.2712936		52	6.2712936
	47	2007	29.0940234		14	29.0940234
	48	2008	14.3520312		30	14.3520312
	49	2009	8.5800234		45	8.5800234
	50	2010	17.2380312		21	17.2380312
	51	2011	41.7300078		5	41.7300078
	52	2012	10.8420234		39	10.8420234
	53	2013	21.5280156		16	21.5280156
	54	2014	15.9120234		26	15.9120234
	55	2015	12.2460078		34	12.2460078