---

Overview

przeplywy_charakterystyczne
krzywa_prawdopodobienstwa

---

Sheet 1: przeplywy_charakterystyczne

	WQ	SQ	NQ
1961	8.61	3.78	1.67				WWQ	75.1920312			Q3,0%=	41.599	m3/s
1962	11.1	4.57	1.3				SWQ	20.2031744254545			Q1,0%=	49.436	m3/s
1963	6.65	2	0.23				NWQ	4.4616078			Q0,5%=	58.523	m3/s
1964	6.78	2.61	0.6								Q0,2%=	63.976	m3/s
1965	14.9	3.56	0.9				WSQ	16.6317421238042			Q0,1%=	65.793	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=	5.545	+	-6.2917
									0.10%				0.2%				0.5%				1%				3%
									X	Y			X	Y			X	Y			X	Y			X	Y
									0	65.7933			0	63.9757722222222			0	58.5231888888889			0	49.43555			0	41.5986166666667
									13	65.7933			12.6722222222222	63.9757722222222			11.6888888888889	58.5231888888889			10.05	49.43555			8.63666666666667	41.5986166666667
									13	65.7933			12.6722222222222	63.9757722222222			11.6888888888889	58.5231888888889			10.05	49.43555			8.63666666666667	41.5986166666667
									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	41.7300078							1	41.7300078	0.91							10.3479797979798							X	%		Δx	Δ%
	2	41.652039							2	41.652039	2.73							8.75757575757576							0	100		0	0
	3	41.3400234							3	41.3400234	4.55							7.95151515151515							0.82	99		0.82	1
	4	40.2480078							4	40.2480078	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	39.8580078							5	39.8580078	8.18							7.06909090909091							1.37	95		0.35	3
	6	36.3480234							6	36.3480234	10.00							6.68							1.75	90		0.38	5				Lp.	rok	WQ	p[%]		WQ	p[%]
	7	33.4620156							7	33.4620156	11.82							6.46727272727273							2.3	80		0.55	10				1	1961	8.61	100.00%		41.730	0.98%
	8	31.0440078							8	33.4620156	13.64							6.25454545454546							2.76	70		0.46	10				2	1962	11.1	200.00%		41.65	2.94%
	9	30.7320312							9	30.7320312	15.45							6.04181818181818							3.67	50		0.91	20				3	1963	6.65	300.00%		41.34	4.90%
	10	29.0940234							10	29.0940234	17.27							5.82909090909091							4.74	30		1.07	20				4	1964	6.78	400.00%		40.25	6.86%
	11	24							11	24	19.09							5.61636363636364							5.51	20		0.77	10				5	1965	14.9	500.00%		39.86	8.82%
	12	21.5280156							12	21.5280156	20.91							5.44							6.68	10		1.17	10				6	1966	12.9	600.00%		36.348	10.78%
	13	21.2160078							13	21.2160078	22.73							5.3							7.75	5		1.07	5				7	1967	18.2	700.00%		33.46	12.75%
	14	19.3440234							14	19.3440234	24.55							5.16							9.08	2		1.33	3				8	1968	17.1	800.00%		31.04	14.71%
	15	18.2							15	18.2	26.36							5.02							10.05	1		0.970000000000001	1				9	1969	6.58	900.00%		30.73	16.67%
	16	17.8620624							16	17.8620624	28.18							4.88							13	0.1		2.95	0.9				10	1970	24	1000.00%		29.094	18.63%
	17	17.2380312							17	17.2380312	30.00							4.74															11	1971	9.33	1100.00%		24	20.59%
	18	17.1							18	17.1	31.82							4.64272727272727															12	1972	5.34	1200.00%		21.528	22.55%
	19	16.3020936							19	16.3020936	33.64							4.54545454545455															13	1973	14.59	1300.00%		21.22	24.51%
	20	15.9900234							20	15.9900234	35.45							4.44818181818182															14	1974	21.22	1400.00%		19.34	26.47%
	21	#N/A							21	#N/A	37.27							4.35090909090909															15	1975	39.86	1500.00%		18.2	28.43%
	22	15.9120234							22	15.9120234	39.09							4.25363636363636															16	1976	9.05	1600.00%		17.86	30.39%
	23	15.2100234							23	15.2100234	40.91							4.15636363636364															17	1977	41.65	1700.00%		17.238	32.35%
	24	14.9							24	14.9	42.73							4.05909090909091															18	1978	13.42	1800.00%		17.1	34.31%
	25	14.5860156							25	14.5860156	44.55							3.96181818181818															19	1979	31.04	1900.00%		16.30	36.27%
	26	14.3520312							26	14.3520312	46.36							3.86454545454545															20	1980	6.61	2000.00%		15.990	38.24%
	27	14.040039							27	14.040039	48.18							3.76727272727273															21	1981	8.66	2100.00%		15.990	40.20%
	28	13.4160078							28	13.4160078	50.00							3.67															22	1982	17.86	2200.00%		15.912	42.16%
	29	12.9							29	12.9	51.82							3.58727272727273															23	1983	40.25	2300.00%		15.210	44.12%
	30	12.2460078							30	12.2460078	53.64							3.50454545454545															24	1984	30.73	2400.00%		14.9	46.08%
	31	12.0900312							31	12.0900312	55.45							3.42181818181818															25	1985	16.30	2500.00%		14.59	48.04%
	32	12.0900234							32	12.0900234	57.27							3.33909090909091															26	1986	4.96	2600.00%		14.352	50.00%
	33	11.1540234							33	11.1540234	59.09							3.25636363636364															27	1987	4.46	2700.00%		14.04	51.96%
	34	11.1							34	11.1	60.91							3.17363636363636															28	1988	8.11	2800.00%		13.42	53.92%
	35	10.8420234							35	10.8420234	62.73							3.09090909090909															29	1989	6.94	2900.00%		12.9	55.88%
	36	9.4380156							36	9.4380156	64.55							3.00818181818182															30	1990	33.46	3000.00%		12.246	57.84%
	37	9.33							37	9.33	66.36							2.92545454545454															31	1991	12.09	3100.00%		12.09	59.80%
	38	9.0480078							38	9.0480078	68.18							2.84272727272727															32	1992	14.04	3200.00%		12.090	61.76%
	39	8.6580546							39	8.6580546	70.00							2.76															33	1993	11.15	3300.00%		11.15	63.73%
	40	8.61							40	8.61	71.82							2.67636363636364															34	1994	19.34	3400.00%		11.1	65.69%
	41	8.5800234							41	8.5800234	73.64							2.59272727272727															35	1995	41.34	3500.00%		10.842	67.65%
	42	8.1120234							42	8.1120234	75.45							2.50909090909091															36	1996	15.990	3600.00%		9.438	69.61%
	43	6.9420312							43	6.9420312	77.27							2.42545454545455															37	1997	15.990	3700.00%		9.33	71.57%
	44	6.78							44	6.78	79.09							2.34181818181818															38	1998	36.348	3800.00%		9.05	73.53%
	45	6.65							45	6.65	80.91							2.25															39	1999	12.090	3900.00%		8.66	75.49%
	46	6.6066234							46	6.6066234	82.73							2.15															40	2000	9.438	4000.00%		8.61	77.45%
	47	6.58							47	6.58	84.55							2.05															41	2001	15.210	4100.00%		8.580	79.41%
	48	6.2712936							48	6.2712936	86.36							1.95															42	2002	6.271	4200.00%		8.11	81.37%
	49	5.3352312							49	5.3352312	88.18							1.85															43	2003	29.094	4300.00%		6.94	83.33%
	50	4.9608312							50	4.9608312	90.00							1.75															44	2004	14.352	4400.00%		6.78	85.29%
	51	4.4616078							51	4.4616078	91.82							1.61181818181818															45	2005	8.580	4500.00%		6.65	87.25%
	52	#N/A								#N/A	#VALUE!							#VALUE!															46	2006	17.238	4600.00%		6.61	89.22%
	53	#N/A								#N/A	#VALUE!							#VALUE!															47	2007	41.730	4700.00%		6.58	91.18%
	54	#N/A								#N/A	#VALUE!							#VALUE!															48	2008	10.842	4800.00%		6.271	93.14%
	55	#N/A								#N/A	#VALUE!							#VALUE!															49	2009	21.528	4900.00%		5.34	95.10%
																																	50	2010	15.912	5000.00%		4.96	97.06%
																																	51	2011	12.246	5100.00%		4.46	99.02%
																																		2012		#VALUE!			#VALUE!
																																		2013		#VALUE!			#VALUE!
																																		2014		#VALUE!			#VALUE!
																																		2015		#VALUE!			#VALUE!
		Zestawienie przepływów
		Rok	WQ [m3/s]
	1	1961	8.61		40	8.61
	2	1962	11.1		34	11.1
	3	1963	6.65		45	6.65
	4	1964	6.78		44	6.78
	5	1965	14.9		24	14.9
	6	1966	12.9		29	12.9
	7	1967	18.2		15	18.2
	8	1968	17.1		18	17.1
	9	1969	6.58		47	6.58
	10	1970	24		11	24
	11	1971	9.33		37	9.33
	12	1972	5.3352312		49	5.3352312
	13	1973	14.5860156		25	14.5860156
	14	1974	21.2160078		13	21.2160078
	15	1975	39.8580078		5	39.8580078
	16	1976	9.0480078		38	9.0480078
	17	1977	41.652039		2	41.652039
	18	1978	13.4160078		28	13.4160078
	19	1979	31.0440078		8	31.0440078
	20	1980	6.6066234		46	6.6066234
	21	1981	8.6580546		39	8.6580546
	22	1982	17.8620624		16	17.8620624
	23	1983	40.2480078		4	40.2480078
	24	1984	30.7320312		9	30.7320312
	25	1985	16.3020936		19	16.3020936
	26	1986	4.9608312		50	4.9608312
	27	1987	4.4616078		51	4.4616078
	28	1988	8.1120234		42	8.1120234
	29	1989	6.9420312		43	6.9420312
	30	1990	33.4620156		7	33.4620156
	31	1991	12.0900312		31	12.0900312
	32	1992	14.040039		27	14.040039
	33	1993	11.1540234		33	11.1540234
	34	1994	19.3440234		14	19.3440234
	35	1995	41.3400234		3	41.3400234
	36	1996	15.9900234		20	15.9900234
	37	1997	15.9900234		20	15.9900234
	38	1998	36.3480234		6	36.3480234
	39	1999	12.0900234		32	12.0900234
	40	2000	9.4380156		36	9.4380156
	41	2001	15.2100234		23	15.2100234
	42	2002	6.2712936		48	6.2712936
	43	2003	29.0940234		10	29.0940234
	44	2004	14.3520312		26	14.3520312
	45	2005	8.5800234		41	8.5800234
	46	2006	17.2380312		17	17.2380312
	47	2007	41.7300078		1	41.7300078
	48	2008	10.8420234		35	10.8420234
	49	2009	21.5280156		12	21.5280156
	50	2010	15.9120234		22	15.9120234
	51	2011	12.2460078		30	12.2460078
	52	2012			#VALUE!
	53	2013			#VALUE!
	54	2014			#VALUE!
	55	2015			#VALUE!