TP4 Khi deux densité répartition (XLSX) - Fichier XLS

Fichier partagé
TP4 Khi deux densité répartition (XLSX)

Aperçu texte

Réalisations Fonction LOI.KHIDEUX(A1;$E$2) Fonction KHIDEUX.INVERSE(proba;ddl)  Nombre de DDL
0 1.000000 0  6
0.1 0.999979932506376 0.0999999999999091  
0.2 0.999845346929735 0.199999999999989  
0.3 0.999497137623598 0.30000000000001  
0.4 0.998851518755138 0.399999999999999  
0.5 0.997838503310238 0.5  
0.6 0.996400506816911 0.600000000000005  
0.7 0.994491066615534 0.7  
0.8 0.992073668132746 0.800000000000003  
0.9 0.989120670203276 0.899999999999997  
1 0.985612322033029 1  
1.1 0.981535864909803 1.1  
1.2 0.976884712247367 1.2  
1.3 0.971657701996441 1.3  
1.4 0.965858415874292 1.4  
1.5 0.959494560255186 1.5  
1.6 0.95257740392851 1.6  
1.7 0.945121268271622 1.7  
1.8 0.937143065702081 1.8  
1.9 0.928661882570121 1.9  
2 0.919698602928606 2  
2.1 0.910275569875393 2.1  
2.2 0.900416281403305 2.2  
2.3 0.890145117916863 2.3  
2.4 0.87948709878363 2.4  
2.5 0.868467665482451 2.5  
2.6 0.85711248909197 2.6  
2.7 0.845447300031414 2.7  
2.8 0.83349773812263 2.8  
2.9 0.821289221188409 2.9  
3 0.808846830538058 3  
3.1 0.79619521181757 3.1  
3.2 0.783358489819263 3.2  
3.3 0.770360195955 3.3  
3.4 0.757223207198585 3.4  
3.5 0.743969695397218 3.5  
3.6 0.730621085939412 3.6  
3.7 0.717198024848034 3.7  
3.8 0.703720353442498 3.8  
3.9 0.690207089784074 3.9  
4 0.676676416183063 4  
4.1 0.663145672106677 4.1  
4.2 0.649631351882069 4.2  
4.3 0.63614910664051 4.3  
4.4 0.622713749996317 4.4  
4.5 0.609339266998278 4.5  0.1000
4.6 0.596038825932068 4.6  
4.7 0.582824792589778 4.7  
4.8 0.569708746657511 4.8  
4.9 0.556701499904064 4.9  
5 0.54381311588333 5  
5.1 0.531052930890343 5.1  
5.2 0.51842957593605 5.2  
5.3 0.505950999529002 5.3  
5.4 0.493624491073462 5.4  
5.5 0.481456704713016 5.5  
5.6 0.469453683466683 5.6  
5.7 0.457620883521066 5.7  
5.8 0.445963198557181 5.8  
5.9 0.434484984004425 5.9  
6 0.423190081126844 6  
6.1 0.412081840858415 6.1  
6.2 0.401163147314632 6.2  
6.3 0.39043644091732 6.3  
6.4 0.379903741078373 6.4  
6.5 0.369566668396101 6.5  
6.6 0.359426466325084 6.6  
6.7 0.349484022287043 6.7  
6.8 0.339739888196119 6.8  
6.9 0.330194300377379 6.9  
7 0.320847198862134 7  
7.1 0.311698246048066 7.1  
7.2 0.302746844716002 7.2  
7.3 0.293992155398697 7.3  
7.4 0.285433113100068 7.4  
7.5 0.277068443366107 7.5  
7.6 0.268896677711111 7.59999999999999  
7.7 0.260916168405052 7.69999999999999  
7.8 0.253125102629784 7.8  
7.9 0.245521516013402 7.90000000000001  
8 0.238103305553544 8.00000000000001  
8.1 0.230868241941589 8.1  
8.2 0.223813981300786 8.2  
8.3 0.216938076352204 8.3  
8.4 0.210237987023097 8.4  
8.5 0.203711090512896 8.5  
8.6 0.197354690832463 8.6  
8.7 0.191166027832633 8.7  
8.8 0.185142285738272 8.8  
8.9 0.179280601204283 8.9  
9 0.173578070910036 9  
9.1 0.168031758708737 9.1  
9.2 0.162638702348171 9.2  
9.3 0.157395919779159 9.3  
9.4 0.152300415067897 9.4  
9.5 0.147349183928148 9.5  
9.6 0.142539218889027 9.6  
9.7 0.137867514113802 9.7  
9.8 0.1333310698849 9.8  
9.9 0.12892689676991 9.9  
10 0.124652019483081 10  
10.1 0.120503480456428 10.1  
10.2 0.116478343134176 10.2  
10.3 0.112573695003915 10.3  
10.4 0.108786650377402 10.4  
10.5 0.105114352933602 10.5  
10.6 0.101553978036088 10.6  
10.7 0.0981027348365904 10.7  
10.8 0.0947578681760138 10.8  
10.9 0.0915166602938883 10.9  
11 0.0883764323567855 11  
11.1 0.0853345458158554 11.1  
11.2 0.0823884036032397 11.2  
11.3 0.0795354511767319 11.3  
11.4 0.0767731774216784 11.4  
11.5 0.0740991154187407 11.5  
11.6 0.0715108430857768 11.6  
11.7 0.0690059837017419 11.7  
11.8 0.0665822063201652 11.8  
11.9 0.0642372260794175 11.9  
12 0.061968804416659 12  
12.1 0.0597747491920355 12.1  
12.2 0.0576529147293826 12.2  
12.3 0.0556012017793952 12.3  
12.4 0.0536175574109333 12.4  
12.5 0.0516999748358483 12.5  
12.6 0.0498464931724497 12.6  
12.7 0.0480551971524637 12.7  
12.8 0.0463242167760893 12.8  
12.9 0.0446517269195091 12.9  
13 0.043035946898983 13  
13.1 0.0414751399954262 13.1  
13.2 0.0399676129431571 13.2  
13.3 0.0385117153862955 13.3  
13.4 0.0371058393060921 13.4  
13.5 0.0357484184222806 13.5  
13.6 0.0344379275713613 13.6  
13.7 0.0331728820645534 13.7  
13.8 0.031951837027983 13.8  
13.9 0.0307733867275202 13.9  
14 0.0296361638805218 14  
14.1 0.028538838956597 14.1  
14.2 0.027480119469371 14.2  
14.3 0.0264587492610931 14.3  
14.4 0.0254735077818123 14.4  
14.5 0.0245232093647193 14.5  
14.6 0.0236067024991489 14.6  
14.7 0.022722869102623 14.7  
14.8 0.0218706237932161 14.8  
14.9 0.0210489131634292 14.9  
15 0.0202567150566644 15  
15.1 0.0194930378473091 15.1  
15.2 0.0187569197253541 15.2  
15.3 0.0180474279863955 15.3  
15.4 0.0173636583277942 15.4  
15.5 0.0167047341517009 15.5  
15.6 0.0160698058755873 15.6  
15.7 0.0154580502508646 15.7  
15.8 0.0148686696901117 15.8  
15.9 0.0143008916033816 15.9  
16 0.013753967744003 16  
16.1 0.013227173564249 16.1  
16.2 0.0127198075811949 16.2  
16.3 0.0122311907530502 16.3  
16.4 0.0117606658662071 16.4  
16.5 0.0113075969332128 16.5  
16.6 0.0108713686018374 16.6  
16.7 0.0104513855753782 16.7  
16.8 0.0100470720443109 16.8  
16.9 0.00965787112936912 16.9  
17 0.00928324433611064 17  
17.1 0.00892267102100258 17.1  
17.2 0.00857564786903583 17.2  
17.3 0.0082416883828596 17.3  
17.4 0.00792032238340703 17.4  
17.5 0.00761109552196593 17.5  
17.6 0.00731356880363252 17.6  
17.7 0.00702731812207147 17.7  
17.8 0.00675193380549197 17.8  
17.9 0.00648702017373776 17.9  
18 0.00623219510637732 18  
18.1 0.00598708962167117 18.1  
18.2 0.00575134746628336 18.2  
18.3 0.00552462471559675 18.3  
18.4 0.00530658938448415 18.4  
18.5 0.00509692104838084 18.5  
18.6 0.00489531047449879 18.6  
18.7 0.00470145926301729 18.7  
18.8 0.00451507949808099 18.8  
18.9 0.00433589340843248 18.9  
19 0.00416363303750335 19  
19.1 0.00399803992278542 19.1  
19.2 0.0038388647843016 19.2  
19.3 0.00368586722199427 19.3  
19.4 0.00353881542184831 19.4  
19.5 0.0033974858705647 19.5  
19.6 0.00326166307860065 19.6  
19.7 0.00313113931139217 19.7  
19.8 0.00300571432857518 19.8  
19.9 0.0028851951310221 19.9  
20 0.00276939571551158 20  
20.1 0.00265813683685033 20.1  
20.2 0.0025512457772673 20.2  
20.3 0.00244855612290196 20.3  
20.4 0.00234990754721049 20.4  
20.5 0.00225514560111521 20.5  
20.6 0.00216412150972509 20.6  
20.7 0.00207669197545703 20.7  
20.8 0.00199271898739027 20.8  
20.9 0.0019120696366885 20.9  
21 0.0018346159379269 21  
21.1 0.00176023465616409 21.1  
21.2 0.00168880713960129 21.2  
21.3 0.00162021915767432 21.3  
21.4 0.00155436074442642 21.4  
21.5 0.00149112604701284 21.5  
21.6 0.00143041317919137 21.6  
21.7 0.00137212407965536 21.7  
21.8 0.00131616437506913 21.8  
21.9 0.00126244324766864 21.9  
22 0.00121087330729281 22  
22.1 0.00116137046771449 22.1  
22.2 0.00111385382714242 22.2  
22.3 0.00106824555276893 22.3  
22.4 0.00102447076924082 22.4  
22.5 0.000982457450933796 22.5  
22.6 0.000942136317913864 22.6  
22.7 0.000903440735471792 22.7  
22.8 0.000866306617119687 22.8  
22.9 0.000830672330941547 22.9  
23 0.000796478609192339 23  
23.1 0.000763668461043016 23.1  
23.2 0.00073218708837146 23.2  
23.3 0.000701981804502122 23.3  
23.4 0.000673001955799656 23.4  
23.5 0.000645198846024468 23.5  
23.6 0.000618525663360635 23.6  
23.7 0.000592937410029125 23.7  
23.8000000000001 0.000568390834401675 23.8000000000001  
23.9000000000001 0.000544844365533253 23.9000000000001  
24.0000000000001 0.000522258050032876 24.0000000000001  
24.1000000000001 0.000500593491195677 24.1000000000001  
24.2000000000001 0.000479813790320595 24.2000000000001  
24.3000000000001 0.000459883490140682 24.3000000000001  
24.4000000000001 0.000440768520295086 24.4000000000001  
24.5000000000001 0.000422436144773871 24.5000000000001  
24.6000000000001 0.000404854911268921 24.6000000000001  
24.7000000000001 0.000387994602366158 24.7000000000001  
24.8000000000001 0.000371826188516308 24.8000000000001  
24.9000000000001 0.000356321782723355 24.9000000000001  
25.0000000000001 0.000341454596891694 25.0000000000001  
Réalisations Densité de probabilité Fonction de répartition Nombre de DDL Ordre des quantiles Quantiles Question 4 Question 5
0 0 0 6 0.25 3.45 0.552 3.070
0.1 0.000594518390312946 2.00674936243979E-05  0.5 5.35  
0.2 0.0022620935450899 0.000154653070264672  0.9 10.64  
0.3 0.00484148236739095 0.000502862376401621  0.95 12.59  
0.4 0.00818730753077982 0.00114848124486213  0.98 15.03  
0.5 0.0121687622354907 0.00216149668976251     
0.6 0.0166684099653387 0.00359949318308947     
0.7 0.0215810727476356 0.00550893338446567     
0.8 0.0268128018414256 0.00792633186725384     
0.9 0.0322799251758523 0.0108793297967242     
1 0.0379081662320396 0.0143876779669707     
1.1 0.0436318294100243 0.018464135090197     
1.2 0.0493930472484624 0.0231152877526329     
1.3 0.0551410851703823 0.0283422980035589     
1.4 0.0608316997144477 0.0341415841257085     
1.5 0.0664265464792052 0.0405054397448139     
1.6 0.0718926342587555 0.0474225960714902     
1.7 0.0772018220832388 0.0548787317283782     
1.8 0.0823303560974713 0.0628569342979191     
1.9 0.0872584434169218 0.071338117429879     
2 0.0919698602928606 0.0803013970713942     
2.1 0.0964515920987622 0.0897244301246071     
2.2 0.100693502818669 0.0995837185966948     
2.3 0.104688031875949 0.109854882083137     
2.4 0.108429916288393 0.12051290121637     
2.5 0.111915936273512 0.131532334517549     
2.6 0.11514468255687 0.14288751090803     
2.7 0.118116343756784 0.154552699968586     
2.8 0.120832512331387 0.16650226187737     
2.9 0.123296007679302 0.178710778811591     
3 0.125510715083492 0.191153169461942     
3.1 0.127481439279688 0.20380478818243     
3.2 0.129213771516579 0.216641510180737     
3.3 0.130713969055001 0.229639804045     
3.4 0.131988846128101 0.242776792801415     
3.5 0.133045675454247 0.256030304602782     
3.6 0.133892099459485 0.269378914060588     
3.7 0.134536050427098 0.282801975151966     
3.8 0.134985678848428 0.296279646557502     
3.9 0.135249289301929 0.309792910215926     
4 0.135335283236613 0.323323583816937     
4.1 0.135252108081937 0.336854327893324     
4.2 0.135008212148913 0.350368648117931     
4.3 0.134612004826997 0.36385089335949     
4.4 0.134071821618424 0.377286250003684     
4.5 0.13339589358611 0.390660733001722     
4.6 0.132592320823408 0.403961174067932     
4.7 0.131669049583843 0.417175207410222     
4.8 0.130633852736754 0.430291253342489     
4.9 0.129494313240618 0.443298500095936     
5 0.128257810349842 0.456186884116671     
5.1 0.126931508293125 0.468947069109657     
5.2 0.125522347182224 0.48157042406395     
5.3 0.124037035929217 0.494049000470998     
5.4 0.122482046968194 0.506375508926538     
5.5 0.120863612593932 0.518543295286984     
5.6 0.119187722745427 0.530546316533317     
5.7 0.117460124076469 0.542379116478934     
5.8 0.115686320168596 0.554036801442819     
5.9 0.113871572754058 0.565515015995575     
6 0.112020903827694 0.576809918873156     
6.1 0.110139098537147 0.587918159141585     
6.2 0.108230708750523 0.598836852685368     
6.3 0.106300057209552 0.60956355908268     
6.4 0.104351242184618 0.620096258921627     
6.5 0.102388142555641 0.630433331603899     
6.6 0.100414423249876 0.640573533674916     
6.7 0.0984335409741833 0.650515977712957     
6.8 0.0964487501853424 0.660260111803881     
6.9 0.0944631092474884 0.669805699622621     
7 0.0924794867308504 0.679152801137866     
7.1 0.0905005678106381 0.688301753951935     
7.2 0.0885288607292279 0.697253155283998     
7.3 0.086566703288742 0.706007844601304     
7.4 0.0846162693447366 0.714566886899932     
7.5 0.082679575275032 0.722931556633893     
7.6 0.0807584864007578 0.731103322288889     
7.7 0.0788547233394614 0.739083831594948     
7.8 0.0769698682726712 0.746874897370216     
7.9 0.0751053711126186 0.754478483986598     
8 0.0732625555549367 0.761896694446456     
8.1 0.0714426250060731 0.769131758058412     
8.2 0.0696466683759017 0.776186018699214     
8.3 0.0678756657276016 0.783061923647796     
8.4 0.0661304937783067 0.789762012976903     
8.5 0.0644119312453248 0.796288909487104     
8.6 0.0627206640338988 0.802645309167537     
8.7 0.0610572902635326 0.808833972167367     
8.8 0.0594223251308512 0.814857714261728     
8.9 0.0578162056078139 0.820719398795717     
9 0.0562392949748517 0.826421929089964     
9.1 0.0546918871891774 0.831968241291263     
9.2 0.0531742110891117 0.837361297651829     
9.3 0.0516864344357942 0.842604080220841     
9.4 0.0502286677941151 0.847699584932103     
9.5 0.0488009682551023 0.852650816071852     
9.6 0.0474033430023554 0.857460781110973     
9.7 0.0460357527254158 0.862132485886198     
9.8 0.0446981148832233 0.8666689301151     
9.9 0.0433903068210249 0.87107310323009     
10 0.0421121687442842 0.875347980516919     
10.1 0.0408635065532883 0.879496519543572     
10.2 0.0396440945422654 0.883521656865824     
10.3 0.0384536779669177 0.887426304996085     
10.4 0.0372919754843428 0.891213349622598     
10.5 0.0361586814693592 0.894885647066398     
10.6 0.035053468211277 0.898446021963912     
10.7 0.0339759879951638 0.90189726516341     
10.8 0.0329258750716463 0.905242131823986     
10.9 0.0319027475192678 0.908483339706112     
11 0.0309062090033845 0.911623567643215     
11.1 0.0299358504355434 0.914665454184145     
11.2 0.0289912515372262 0.91761159639676     
11.3 0.0280719823117831 0.920464548823268     
11.4 0.0271776044283104 0.923226822578322     
11.5 0.0263076725211502 0.925900884581259     
11.6 0.0254617354086106 0.928489156914223     
11.7 0.0246393372344187 0.930994016298258     
11.8 0.0238400185353317 0.933417793679835     
11.9 0.0230633172382392 0.935762773920583     
12 0.0223087695899972 0.938031195583341     
12.1 0.0215759110231397 0.940225250807965     
12.2 0.0208642769605167 0.942347085270618     
12.3 0.0201734035618128 0.944398798220605     
12.4 0.019502828414802 0.946382442589067     
12.5 0.0188520911740987 0.948300025164152     
12.6 0.0182207341500693 0.95015350682755     
12.7 0.0176083028504722 0.951944802847536     
12.8 0.0170143464773011 0.953675783223911     
12.9 0.0164384183812121 0.955348273080491     
13 0.0158800764758256 0.956964053101017     
13.1 0.0153388836141009 0.958524860004574     
13.2 0.0148144079288966 0.960032387056843     
13.3 0.0143062231397409 0.961488284613705     
13.4 0.0138139088277531 0.962894160693908     
13.5 0.0133370506805745 0.964251581577719     
13.6 0.0128752407090859 0.965562072428639     
13.7 0.0124280774376143 0.966827117935447     
13.8 0.0119951660692499 0.968048162972017     
13.9 0.0115761186278264 0.96922661327248     
14 0.0111705540780428 0.970363836119478     
14.1 0.0107780984251378 0.971461161043403     
14.2 0.0103983847954586 0.972519880530629     
14.3 0.0100310534992045 0.973541250738907     
14.4 0.00967575207656176 0.974526492218188     
14.5 0.00933213532838412 0.975476790635281     
14.6 0.00899986533251999 0.976393297500851     
14.7 0.00867861144682703 0.977277130897377     
14.8 0.00836805029986385 0.978129376206784     
14.9 0.00806786577019598 0.978951086836571     
15 0.00777774895520391 0.979743284943336     
15.1 0.00749739813023336 0.980506962152691     
15.2 0.00722651869888242 0.981243080274646     
15.3 0.00696482313517644 0.981952572013605     
15.4 0.00671203091833955 0.982636341672206     
15.5 0.00646786846083181 0.983295265848299     
15.6 0.00623206903028256 0.983930194124413     
15.7 0.00600437266591385 0.984541949749135     
15.8 0.00578452609001292 0.985131330309888     
15.9 0.00557228261497933 0.985699108396619     
16 0.00536740204644019 0.986246032255997     
16.1 0.00516965058289704 0.986772826435751     
16.2 0.00497880071233861 0.987280192418805     
16.3 0.00479463110622608 0.98776880924695     
16.4 0.00461692651123172 0.988239334133793     
16.5 0.00444547763908619 0.988692403066787     
16.6 0.0042800810548667 0.989128631398163     
16.7 0.00412053906403523 0.989548614424622     
16.8 0.00396665959851488 0.989952927955689     
16.9 0.00381825610207236 0.990342128870631     
17 0.00367514741525476 0.990716755663889     
17.1 0.00353715766011139 0.991077328978998     
17.2 0.00340411612491354 0.991424352130964     
17.3 0.0032758571490691 0.99175831161714     
17.4 0.0031522200084135 0.992079677616593     
17.5 0.00303304880104368 0.992388904478034     
17.6 0.00291819233384843 0.992686431196368     
17.7 0.00280750400987499 0.992972681877929     
17.8 0.00270084171666003 0.993248066194508     
17.9 0.00259806771564125 0.993512979826262     
18 0.00249904853275526 0.993767804893623     
18.1 0.00240365485031702 0.994012910378329     
18.2 0.0023117614002666 0.994248652533717     
18.3 0.0022232468588601 0.994475375284403     
18.4 0.0021379937428729 0.994693410615516     
18.5 0.00205588830737577 0.994903078951619     
18.6 0.0019768204451368 0.995104689525501     
18.7 0.00190068358769511 0.995298540736983     
18.8 0.00182737460814601 0.995484920501919     
18.9 0.00175679372567111 0.995664106591568     
19 0.00168884441184124 0.995836366962497     
19.1 0.0016234332987148 0.996001960077215     
19.2 0.00156047008874927 0.996161135215698     
19.3 0.00149986746653919 0.996314132778006     
19.4 0.00144154101238942 0.996461184578152     
19.5 0.00138540911772893 0.996602514129435     
19.6 0.00133139290236657 0.996738336921399     
19.7 0.00127941613358692 0.996868860688608     
19.8 0.00122940514708144 0.996994285671425     
19.9 0.00118128876970706 0.997114804868978     
20 0.00113499824406212 0.997230604284488     
20.1 0.00109046715486678 0.99734186316315     
20.2 0.00104763135713323 0.997448754222733     
20.3 0.00100642890610891 0.997551443877098     
20.4 0.000966799988974136 0.99765009245279     
20.5 0.00092868685827405 0.997744854398885     
20.6 0.000892033767063232 0.997835878490275     
20.7 0.000856786905740128 0.997923308024543     
20.8 0.000822894340547234 0.99800728101261     
20.9 0.000790305953711987 0.998087930363311     
21 0.000758973385202406 0.998165384062073     
21.1 0.000728849976070771 0.998239765343836     
21.2 0.000699890713357925 0.998311192860399     
21.3 0.000672052176530256 0.998379780842326     
21.4 0.000645292485420916 0.998445639255574     
21.5 0.000619571249646459 0.998508873952987     
21.6 0.000594849519469773 0.998569586820809     
21.7 0.000571089738079966 0.998627875920345     
21.8 0.000548255695259672 0.998683835624931     
21.9 0.000526312482410212 0.998737556752331     
22 0.000505226448904931 0.998789126692707     
22.1 0.000484965159741141 0.998838629532286     
22.2 0.000465497354461085 0.998886146172858     
22.3 0.000446792907312537 0.998931754447231     
22.4 0.000428822788619755 0.998975529230759     
22.5 0.000411559027335733 0.999017542549066     
22.6 0.000394974674746935 0.999057863682086     
22.7 0.000379043769301942 0.999096559264528     
22.8 0.00036374130253578 0.99913369338288     
22.9 0.000349043186061967 0.999169327669058     
23 0.000334926219604728 0.999203521390808     
23.1 0.000321368060044134 0.999236331538957     
23.2 0.00030834719144737 0.999267812911629     
23.3 0.000295842896059679 0.999298018195498     
23.4 0.000283835226229019 0.9993269980442     
23.5 0.000272304977238833 0.999354801153976     
23.6 0.000261233661023825 0.999381474336639     
23.7 0.000250603480744074 0.999407062589971     
23.8000000000001 0.000240397306193242 0.999431609165598     
23.9000000000001 0.000230598650017227 0.999455155634467     
24.0000000000001 0.000221191644719806 0.999477741949967     
24.1000000000001 0.000212161020432686 0.999499406508804     
24.2000000000001 0.000203492083427491 0.999520186209679     
24.3000000000001 0.000195170695347908 0.999540116509859     
24.4000000000001 0.000187183253140609 0.999559231479705     
24.5000000000001 0.000179516669664082 0.999577563855226     
24.6000000000001 0.000172158354954958 0.999595145088731
TP4 Khi deux densité répartition (XLSX) - Fichier XLS

TP4 Khi deux densité répartition (XLSX)

Aperçu texte

Sur le même sujet

Partager le fichier

Lien court

Code HTML

Code BB

Lien permanent
