{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["12°C","15°C","18°C","20°C","24°C","30°C","régression linéaire"],"not_rendered":{"charts":7,"images":0,"macros":1,"external_links":6,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"12°C","index":0,"n_rows":300,"n_cols":17,"rows_kept":300,"cut":false,"hidden":false,"merged":[]}
[413,null,"taux de C02 en ppm pour une eau de mer à 12 °c"]
[416,null,null,null,null,null,null,null,"borne sup"]
[413,null,null,null,null,null,null,null,"de l'intervalle","intervalle","fréquence"]
[412,null,null,null,null,"population",300,null,400,"]0;400]",{"$f":"FREQUENCY(A1:A300,I4:I12)","v":34}]
[417,null,null,null,null,"min",{"$f":"MIN(A1:A300)","v":400},null,405,"]400;405]",52]
[427,null,null,null,10,"max",{"$f":"MAX(A1:A300)","v":439},null,410,"]405;410]",81]
[417,null,"liste générée",400,null,"moyenne",{"$f":"AVERAGE(A1:A300)","v":410.35333333333335},null,415,"]410;415]",59]
[418,null,null,410,null,"écart type",{"$f":"STDEV(A1:A300)","v":7.509313429524143},null,420,"]415;420]",48]
[415,null,null,411,null,"incertitude",{"$f":"G8/300^0.5","v":0.43355041299650354},null,425,"]420;425]",19]
[415,null,null,419,null,null,null,null,430,"]425;430]",3]
[431,null,null,402,null,"échantillon",30,null,435,"]430;435]",3]
[420,null,null,411,null,"min",{"$f":"MIN(D7:D36)","v":400},null,440,"]435;440]",1]
[431,null,null,408,null,"max",{"$f":"MAX(D7:D36)","v":430}]
[439,null,null,405,null,"moyenne me",{"$f":"AVERAGE(D7:D36)","v":408.86666666666667}]
[433,null,null,409,null,"écart type σe",{"$f":"STDEV(D7:D36)","v":7.1954647274292274}]
[424,null,null,400]
[409,null,null,413,null,"estimation ","ponctuelle",null,null,null,null,"intervalle de confiance ","confiance à 95%du taux moyen de CO2 en ppm donné par le capteur pour 30 valeurs"]
[408,null,null,415,null,"écart type"]
[410,null,null,413,null,"population",{"$f":"G15*30^0.5/29^0.5","v":7.3184730348909328},null,null,null,null,null,"[",{"$f":"G7-1.96*G8/30^0.5","v":407.66616003360514},";",{"$f":"G7+1.96*G8/30^0.5","v":413.04050663306157},"]"]
[416,null,null,402]
[415,null,null,400]
[412,null,null,417]
[420,null,null,404]
[408,null,null,402]
[419,null,null,404]
[424,null,null,419]
[405,null,null,408]
[418,null,null,430]
[408,null,null,407]
[415,null,null,413]
[416,null,null,408]
[413,null,null,417]
[416,null,null,401]
[411,null,null,405]
[415,null,null,400]
[422,null,null,413]
[415]
[417]
[409]
[409]
[417]
[412]
[417]
[411]
[405]
[419]
[407]
[414]
[420]
[412]
[413]
[415]
[407]
[407]
[408]
[413]
[419]
[420]
[419]
[418]
[424]
[417]
[415]
[405]
[419]
[424]
[416]
[413]
[413]
[404]
[404]
[407]
[406]
[400]
[422]
[420]
[404]
[407]
[420]
[425]
[409]
[407]
[411]
[410]
[400]
[400]
[404]
[400]
[409]
[407]
[403]
[400]
[410]
[411]
[412]
[400]
[401]
[404]
[405]
[400]
[409]
[406]
[406]
[404]
[400]
[409]
[404]
[421]
[407]
[410]
[408]
[414]
[413]
[402]
[404]
[405]
[400]
[402]
[404]
[407]
[414]
[406]
[411]
[409]
[415]
[415]
[411]
[403]
[407]
[406]
[401]
[406]
[404]
[401]
[408]
[410]
[410]
[400]
[411]
[400]
[416]
[424]
[408]
[405]
[410]
[418]
[411]
[420]
[402]
[403]
[424]
[417]
[400]
[413]
[403]
[409]
[408]
[408]
[406]
[404]
[401]
[416]
[409]
[406]
[410]
[407]
[413]
[404]
[407]
[417]
[415]
[417]
[410]
[424]
[419]
[415]
[410]
[414]
[423]
[412]
[409]
[415]
[406]
[407]
[408]
[401]
[410]
[400]
[402]
[405]
[401]
[417]
[401]
[422]
[403]
[413]
[414]
[409]
[410]
[416]
[420]
[410]
[420]
[406]
[405]
[406]
[417]
[408]
[425]
[417]
[419]
[400]
[412]
[407]
[407]
[408]
[405]
[414]
[400]
[406]
[424]
[413]
[412]
[408]
[400]
[419]
[406]
[405]
[411]
[410]
[408]
[406]
[400]
[406]
[422]
[400]
[410]
[420]
[425]
[430]
[418]
[427]
[416]
[417]
[423]
[415]
[416]
[409]
[421]
[413]
[404]
[404]
[417]
[406]
[412]
[410]
[402]
[413]
[413]
[420]
[411]
[413]
[403]
[411]
[415]
[406]
[404]
[408]
[415]
[404]
[400]
[402]
[404]
[402]
[400]
[400]
[400]
[400]
[400]
[401]
[400]
[400]
[400]
[400]
[400]
[406]
[406]
[408]
[400]
[401]
[403]
[410]
[401]
[400]
[400]
[400]
[400]
[415]
[410]
[402]

{"sheet":"15°C","index":1,"n_rows":300,"n_cols":17,"rows_kept":300,"cut":false,"hidden":false,"merged":[]}
[441,null,"taux de C02 en ppm pour une eau de mer à 15 °c"]
[441,null,null,null,null,null,null,null,"borne sup"]
[447,null,null,null,null,null,null,null,"de l'intervalle","intervalle","fréquence"]
[451,null,null,null,null,"population",300,null,420,"]0;420]",{"$f":"FREQUENCY(A1:A300,I4:I15)","v":1}]
[443,null,null,null,null,"min",{"$f":"MIN(A1:A300)","v":420},null,425,"]420;425]",16]
[447,null,null,null,10,"max",{"$f":"MAX(A1:A300)","v":474},null,430,"]425;430]",20]
[450,null,"liste générée",450,null,"moyenne",{"$f":"AVERAGE(A1:A300)","v":444},null,435,"]430;435]",30]
[453,null,null,438,null,"écart type",{"$f":"STDEV(A1:A300)","v":11.557620659881763},null,440,"]435;440]",55]
[449,null,null,447,null,"incertitude",{"$f":"G8/300^0.5","v":0.66727953991743161},null,445,"]440;445]",55]
[442,null,null,442,null,null,null,null,450,"]445;450]",40]
[456,null,null,463,null,"échantillon",30,null,455,"]450;455]",28]
[442,null,null,424,null,"min",{"$f":"MIN(D7:D36)","v":424},null,460,"]455;460]",26]
[447,null,null,463,null,"max",{"$f":"MAX(D7:D36)","v":463},null,465,"]460;465]",16]
[456,null,null,427,null,"moyenne me",{"$f":"AVERAGE(D7:D36)","v":443.83333333333331},null,470,"]465:470]",4]
[443,null,null,446,null,"écart type σe",{"$f":"STDEV(D7:D36)","v":10.201701458270483},null,475,"]470;475]",9]
[445,null,null,440]
[461,null,null,443,null,"estimation ","ponctuelle"]
[442,null,null,441,null,"ecart-type"]
[438,null,null,443,null,"population",{"$f":"G15*(30^0.5/29^0.5)","v":10.376102150532621},null,null,null,null,null,"intervalle de confiance ","confiance à 95%du taux moyen de CO2 en ppm donné par le capteur sur 30 valeurs"]
[434,null,null,437]
[441,null,null,439,null,null,null,null,null,null,null,null,"[",{"$f":"G7-1.96*G8/30^0.5","v":439.86415856295008},";",{"$f":"G7+1.96*G8/30^0.5","v":448.13584143704992},"]"]
[441,null,null,463]
[443,null,null,449]
[443,null,null,447]
[447,null,null,449]
[442,null,null,439]
[444,null,null,434]
[449,null,null,426]
[442,null,null,459]
[440,null,null,449]
[445,null,null,431]
[457,null,null,447]
[445,null,null,440]
[453,null,null,443]
[448,null,null,454]
[444,null,null,442]
[439]
[454]
[450]
[443]
[441]
[447]
[434]
[434]
[440]
[445]
[431]
[436]
[441]
[432]
[437]
[463]
[460]
[469]
[453]
[458]
[463]
[449]
[428]
[430]
[425]
[420]
[430]
[430]
[440]
[451]
[463]
[471]
[474]
[473]
[464]
[472]
[461]
[471]
[471]
[468]
[473]
[473]
[463]
[461]
[442]
[435]
[439]
[434]
[425]
[437]
[440]
[444]
[424]
[438]
[438]
[446]
[442]
[438]
[424]
[430]
[431]
[428]
[421]
[433]
[435]
[438]
[426]
[436]
[429]
[429]
[436]
[424]
[431]
[439]
[429]
[424]
[442]
[428]
[436]
[451]
[433]
[442]
[449]
[433]
[438]
[438]
[444]
[446]
[447]
[438]
[436]
[433]
[433]
[422]
[426]
[425]
[423]
[435]
[435]
[431]
[426]
[435]
[435]
[440]
[444]
[438]
[425]
[451]
[451]
[435]
[432]
[427]
[424]
[445]
[447]
[440]
[424]
[430]
[438]
[454]
[438]
[452]
[457]
[450]
[448]
[450]
[451]
[442]
[438]
[450]
[437]
[438]
[449]
[442]
[446]
[445]
[437]
[445]
[455]
[451]
[426]
[438]
[427]
[435]
[423]
[431]
[440]
[457]
[460]
[460]
[460]
[456]
[452]
[440]
[442]
[438]
[442]
[449]
[456]
[445]
[456]
[454]
[454]
[466]
[453]
[456]
[463]
[463]
[456]
[452]
[453]
[456]
[466]
[463]
[456]
[456]
[461]
[463]
[456]
[472]
[456]
[459]
[452]
[451]
[438]
[463]
[436]
[453]
[445]
[433]
[446]
[446]
[439]
[438]
[429]
[426]
[443]
[426]
[432]
[436]
[424]
[438]
[454]
[438]
[452]
[457]
[450]
[448]
[450]
[451]
[442]
[438]
[450]
[437]
[438]
[449]
[442]
[447]
[450]
[453]
[449]
[439]
[456]
[442]
[447]
[456]
[439]
[445]
[461]
[442]
[438]
[434]
[439]
[441]
[443]
[443]
[447]
[442]
[431]
[447]
[450]
[453]
[449]
[439]
[456]
[442]
[447]
[456]
[439]
[445]
[461]
[442]
[438]
[434]
[439]
[441]
[443]
[443]
[447]
[442]
[431]
[437]
[425]
[439]

{"sheet":"18°C","index":2,"n_rows":300,"n_cols":17,"rows_kept":300,"cut":false,"hidden":false,"merged":[]}
[607,null,"taux de C02 en ppm pour une eau de mer à 18 °c"]
[588,null,null,null,null,null,null,null,"borne sup"]
[580,null,null,null,null,null,null,null,"de l'intervalle","intervalle","fréquence"]
[606,null,null,null,null,"population",300,null,560,"]0;560]",{"$f":"FREQUENCY(A1:A300,I4:I15)","v":6}]
[589,null,null,null,null,"min",{"$f":"MIN(A1:A300)","v":479},null,565,"]560;565]",24]
[594,null,null,null,10,"max",{"$f":"MAX(A1:A300)","v":611},null,570,"]565;570]",34]
[595,null,"liste générée",580,null,"moyenne",{"$f":"AVERAGE(A1:A300)","v":581.52666666666664},null,575,"]570;575]",44]
[479,null,null,589,null,"écart type",{"$f":"STDEV(A1:A300)","v":14.018714995413477},null,580,"]575;580]",46]
[580,null,null,598,null,"incertude",{"$f":"G8/300^0.5","v":0.8093708876294613},null,585,"]580;585]",40]
[599,null,null,561,null,null,null,null,590,"]585;590]",28]
[595,null,null,592,null,"échantillon",30,null,595,"]590;595]",27]
[608,null,null,579,null,"min",{"$f":"MIN(D7:D36)","v":561},null,600,"]595;600]",21]
[571,null,null,574,null,"max",{"$f":"MAX(D7:D36)","v":605},null,605,"]600;605]",20]
[599,null,null,590,null,"moyenne me",{"$f":"AVERAGE(D7:D36)","v":582.23333333333335},null,610,"]605;610]",9]
[598,null,null,589,null,"écart type σe",{"$f":"STDEV(D7:D36)","v":12.22683124521029},null,615,"]610;615]",1]
[609,null,null,595]
[580,null,null,580,null,"estimation","ponctuelle"]
[599,null,null,592,null,"écart type"]
[595,null,null,593,null,"population",{"$f":"G15*30^0.5/29^0.5","v":12.435852048461529}]
[595,null,null,584,null,null,null,null,null,null,null,null,"intervalle de confiance ","confiance à 95%du taux moyen de CO2 en ppm donné par le capteur"]
[580,null,null,602]
[595,null,null,567]
[593,null,null,569,null,null,null,null,null,null,null,null,"[",{"$f":"G7-1.96*G8/30^0.5","v":576.51013393225367},";",{"$f":"G7+1.96*G8/30^0.5","v":586.54319940107962},"]"]
[609,null,null,571]
[597,null,null,580]
[595,null,null,595]
[593,null,null,571]
[592,null,null,569]
[593,null,null,567]
[593,null,null,572]
[595,null,null,580]
[600,null,null,573]
[595,null,null,601]
[593,null,null,567]
[595,null,null,582]
[592,null,null,605]
[609]
[609]
[603]
[607]
[611]
[592]
[589]
[588]
[579]
[590]
[585]
[591]
[585]
[587]
[599]
[585]
[584]
[584]
[581]
[578]
[582]
[585]
[583]
[580]
[589]
[590]
[570]
[580]
[583]
[580]
[581]
[586]
[580]
[578]
[580]
[582]
[580]
[570]
[580]
[580]
[583]
[579]
[574]
[583]
[583]
[573]
[574]
[576]
[578]
[573]
[573]
[571]
[574]
[572]
[572]
[561]
[583]
[565]
[581]
[582]
[573]
[579]
[577]
[581]
[583]
[581]
[582]
[581]
[575]
[572]
[575]
[584]
[581]
[581]
[561]
[563]
[577]
[560]
[579]
[569]
[570]
[589]
[584]
[578]
[577]
[561]
[561]
[589]
[569]
[561]
[564]
[601]
[588]
[600]
[580]
[600]
[581]
[601]
[578]
[598]
[599]
[601]
[567]
[598]
[600]
[586]
[597]
[576]
[599]
[595]
[595]
[604]
[603]
[602]
[601]
[597]
[605]
[605]
[603]
[593]
[593]
[606]
[600]
[600]
[601]
[595]
[600]
[578]
[601]
[602]
[586]
[601]
[592]
[589]
[588]
[579]
[590]
[585]
[591]
[585]
[587]
[599]
[580]
[584]
[580]
[580]
[578]
[582]
[575]
[563]
[571]
[569]
[563]
[570]
[569]
[575]
[573]
[573]
[586]
[573]
[567]
[575]
[579]
[578]
[570]
[567]
[567]
[569]
[569]
[574]
[564]
[561]
[573]
[568]
[568]
[578]
[573]
[573]
[571]
[567]
[572]
[562]
[561]
[569]
[565]
[566]
[566]
[563]
[560]
[567]
[568]
[565]
[564]
[563]
[560]
[565]
[562]
[588]
[567]
[560]
[566]
[571]
[568]
[567]
[560]
[589]
[569]
[570]
[589]
[564]
[589]
[578]
[573]
[561]
[576]
[579]
[574]
[564]
[601]
[600]
[587]
[585]
[601]
[602]
[601]
[584]
[579]
[587]
[574]
[579]
[578]
[573]
[576]
[605]
[571]
[593]
[567]
[571]
[574]
[569]
[571]
[566]
[574]
[578]
[589]
[585]
[573]
[568]
[571]
[589]
[583]
[572]
[580]
[583]
[578]
[574]
[585]
[585]
[574]
[575]
[584]
[589]
[570]
[571]

{"sheet":"20°C","index":3,"n_rows":300,"n_cols":16,"rows_kept":300,"cut":false,"hidden":false,"merged":[]}
[705,null,"taux de C02 en ppm pour une eau de mer à 20 °c"]
[707,null,null,null,null,null,null,null,"borne sup"]
[701,null,null,null,null,null,null,null,"de l'intervalle","intervalle","fréquence"]
[689,null,null,null,null,"population",300,null,665,"]0;665]",{"$f":"FREQUENCY(A1:A300,I4:I13)","v":2}]
[705,null,null,null,null,"min",{"$f":"MIN(A1:A300)","v":665},null,670,"]665;670]",31]
[694,null,null,null,10,"max",{"$f":"MAX(A1:A300)","v":707},null,675,"]670;675]",90]
[690,null,"liste générée",684,null,"moyenne",{"$f":"AVERAGE(A1:A300)","v":678.90333333333331},null,680,"]675;680]",83]
[687,null,null,673,null,"écart type",{"$f":"STDEV(A1:A300)","v":8.274592749664377},null,685,"]680;685]",39]
[683,null,null,680,null,"incertitude",{"$f":"G8/300^0.5","v":0.4777338351453253},null,690,"]685;690]",34]
[676,null,null,672,null,null,null,null,695,"]690;695]",6]
[699,null,null,675,null,"échantillon",30,null,700,"]695;700]",8]
[673,null,null,689,null,"min",{"$f":"MIN(D7:D36)","v":666},null,705,"]700;705]",6]
[683,null,null,687,null,"max",{"$f":"MAX(D7:D36)","v":689},null,710,"}705;710]",1]
[676,null,null,667,null,"moyenne me",{"$f":"AVERAGE(D7:D36)","v":676.5333333333333}]
[671,null,null,676,null,"écart type σe",{"$f":"STDEV(D7:D36)","v":6.7809740594845449}]
[678,null,null,675]
[678,null,null,666,null,"estimation ","ponctuelle"]
[671,null,null,676,null,"écart type",null,null,null,null,null,"intervalle de confiance ","confiance à 95%du taux moyen de CO2 en ppm donné par le capteur"]
[673,null,null,671,null,"population",{"$f":"G15*30^0.5/29^0.5","v":6.89689654310388}]
[673,null,null,684]
[674,null,null,667,null,null,null,null,null,null,null,"[",{"$f":"G7-1.96*G8/30^0.5","v":675.94230834593554},";",{"$f":"G7+1.96*G8/30^0.5","v":681.86435832073107},"]"]
[674,null,null,671]
[683,null,null,683]
[690,null,null,689]
[670,null,null,671]
[670,null,null,675]
[672,null,null,680]
[684,null,null,679]
[670,null,null,678]
[678,null,null,679]
[675,null,null,674]
[678,null,null,674]
[678,null,null,667]
[676,null,null,671]
[675,null,null,674]
[678,null,null,689]
[678]
[679]
[685]
[674]
[676]
[679]
[679]
[675]
[675]
[671]
[678]
[679]
[677]
[678]
[674]
[678]
[672]
[687]
[672]
[671]
[687]
[674]
[675]
[673]
[689]
[689]
[672]
[679]
[679]
[673]
[685]
[675]
[676]
[685]
[679]
[690]
[679]
[687]
[685]
[671]
[670]
[681]
[684]
[679]
[687]
[674]
[679]
[678]
[673]
[676]
[695]
[671]
[693]
[667]
[665]
[667]
[669]
[671]
[666]
[667]
[678]
[689]
[685]
[667]
[668]
[671]
[689]
[683]
[672]
[680]
[683]
[678]
[674]
[679]
[685]
[674]
[675]
[684]
[689]
[670]
[671]
[666]
[667]
[678]
[689]
[685]
[667]
[668]
[671]
[689]
[683]
[672]
[680]
[683]
[678]
[700]
[694]
[698]
[684]
[674]
[675]
[680]
[679]
[672]
[684]
[689]
[674]
[683]
[690]
[670]
[670]
[672]
[684]
[670]
[678]
[675]
[678]
[678]
[676]
[675]
[678]
[678]
[679]
[685]
[674]
[676]
[679]
[679]
[675]
[675]
[671]
[678]
[679]
[677]
[678]
[674]
[678]
[672]
[687]
[672]
[671]
[687]
[674]
[675]
[673]
[682]
[690]
[698]
[700]
[689]
[678]
[699]
[700]
[700]
[678]
[689]
[674]
[681]
[675]
[704]
[703]
[681]
[701]
[678]
[671]
[673]
[673]
[674]
[674]
[683]
[690]
[670]
[670]
[672]
[684]
[670]
[678]
[675]
[678]
[678]
[676]
[675]
[678]
[678]
[679]
[685]
[674]
[676]
[679]
[679]
[675]
[675]
[671]
[678]
[679]
[677]
[678]
[674]
[678]
[672]
[687]
[672]
[671]
[687]
[674]
[675]
[673]
[689]
[689]
[672]
[679]
[679]
[673]
[685]
[675]
[676]
[685]
[679]
[690]
[679]
[687]
[685]
[671]
[670]
[681]
[684]
[679]
[687]
[674]
[679]
[678]
[673]
[676]
[695]
[671]
[693]
[667]
[665]
[667]
[669]
[671]
[666]
[667]
[678]
[689]
[685]
[667]
[668]
[671]
[689]
[683]
[672]
[680]
[683]
[678]
[674]
[679]
[685]
[674]
[675]
[684]
[689]
[670]
[671]

{"sheet":"24°C","index":4,"n_rows":300,"n_cols":16,"rows_kept":300,"cut":false,"hidden":false,"merged":[]}
[793,null,"taux de C02 en ppm pour une eau de mer à 24 °c"]
[794,null,null,null,null,null,null,null,"borne sup"]
[806,null,null,null,null,null,null,null,"de l'intervalle","intervalle","fréquence"]
[807,null,null,null,null,"population",300,null,780,"]0;780]",{"$f":"FREQUENCY(A1:A300,I4:I12)","v":6}]
[805,null,null,null,null,"min",{"$f":"MIN(A1:A300)","v":779},null,785,"]780;785]",4]
[806,null,null,null,10,"max",{"$f":"MAX(A1:A300)","v":820},null,790,"]785;790]",14]
[806,null,"liste générée",803,null,"moyenne",{"$f":"AVERAGE(A1:A300)","v":803.05016722408027},null,795,"]790;795]",28]
[806,null,null,799,null,"écart type",{"$f":"STDEV(A1:A300)","v":8.6800410360809828},null,800,"]795;800]",61]
[794,null,null,804,null,"incertitude",{"$f":"G8/300^0.5","v":0.50114240287583534},null,805,"]800;805]",62]
[807,null,null,794,null,null,null,null,810,"]805;810]",58]
[793,null,null,816,null,"échantillon",30,null,815,"]810;815]",50]
[807,null,null,795,null,"min",{"$f":"MIN(D7:D36)","v":790},null,820,"]815;820]",16]
[806,null,null,792,null,"max",{"$f":"MAX(D7:D36)","v":816}]
[808,null,null,799,null,"moyenne me",{"$f":"AVERAGE(D7:D36)","v":802.89655172413791}]
[797,null,null,802,null,"écart type σe",{"$f":"STDEV(D7:D36)","v":7.5467345236495058}]
[804,null,null,798]
[795,null,null,790,null,"estimation ","ponctuelle",null,null,null,null,"intervalle de confiance ","confiance à 95%du taux moyen de CO2 en ppm donné par le capteur"]
[790,null,null,806,null,"écart type"]
[796,null,null,813,null,"population",{"$f":"G15*30^0.5/29^0.5","v":7.6757478780028672}]
[791,null,null,806,null,null,null,null,null,null,null,"[",{"$f":"G7-1.96*G8/30^0.5","v":799.94405443073265},";",{"$f":"G7+1.96*G8/30^0.5","v":806.15628001742789},"]"]
[791,null,null,807]
[793,null,null,814]
[791,null,null,797]
[792,null,null,798]
[797,null,null,793]
[803,null,null,797]
[797,null,null,816]
[792,null,null,804]
[799,null,null,811]
[799,null,null,814]
[820,null,null,806]
[803,null,null,803]
[798,null,null,799]
[805,null,null,811]
[799,null,null,"_810"]
[820,null,null,797]
[817]
[816]
[806]
[802]
[801]
[804]
[806]
[800]
[807]
[798]
[810]
[809]
[810]
[811]
[806]
[814]
[805]
[799]
[799]
[803]
[817]
[818]
[798]
[813]
[799]
[816]
[797]
[804]
[798]
[790]
[792]
[787]
[779]
[783]
[791]
[789]
[800]
[792]
[806]
[815]
[814]
[803]
[798]
[805]
[799]
[813]
[820]
[816]
[806]
[802]
[801]
[804]
[806]
[800]
[807]
[798]
[810]
[809]
[810]
[811]
[806]
[814]
[805]
[799]
[797]
[803]
[803]
[798]
[805]
[799]
[813]
[809]
[816]
[806]
[802]
[801]
[804]
[806]
[800]
[807]
[798]
[810]
[809]
[810]
[811]
[806]
[814]
[805]
[799]
[780]
[803]
[811]
[814]
[779]
[803]
[798]
[805]
[799]
[813]
[815]
[816]
[806]
[802]
[801]
[804]
[806]
[800]
[807]
[798]
[810]
[809]
[810]
[811]
[806]
[814]
[805]
[799]
[780]
[803]
[811]
[814]
[779]
[814]
[803]
[798]
[805]
[799]
[813]
[814]
[816]
[806]
[802]
[801]
[804]
[806]
[800]
[807]
[798]
[810]
[809]
[810]
[811]
[806]
[814]
[805]
[799]
[795]
[803]
[803]
[798]
[805]
[799]
[813]
[805]
[801]
[815]
[801]
[802]
[803]
[813]
[814]
[809]
[803]
[811]
[814]
[796]
[813]
[799]
[808]
[797]
[804]
[787]
[790]
[792]
[787]
[796]
[783]
[791]
[789]
[800]
[792]
[806]
[815]
[814]
[803]
[798]
[805]
[799]
[813]
[800]
[816]
[806]
[813]
[814]
[809]
[803]
[811]
[814]
[798]
[813]
[799]
[808]
[797]
[804]
[787]
[790]
[792]
[787]
[779]
[783]
[791]
[793]
[803]
[792]
[806]
[819]
[814]
[803]
[813]
[799]
[808]
[797]
[804]
[805]
[790]
[792]
[787]
[794]
[783]
[791]
[789]
[803]
[792]
[806]
[815]
[814]
[803]
[798]
[805]
[799]
[813]
[815]
[816]
[806]
[798]
[797]
[797]
[795]
[800]
[792]
[806]
[815]
[814]
[803]
[798]
[805]
[799]
[813]
[803]
[816]
[806]
[813]
["_810"]
[812]

{"sheet":"30°C","index":5,"n_rows":314,"n_cols":16,"rows_kept":314,"cut":false,"hidden":false,"merged":[]}
[915,null,"taux de C02 en ppm pour une eau de mer à 30 °c"]
[920,null,null,null,null,null,null,null,"borne sup"]
[930,null,null,null,null,null,null,null,"de l'intervalle","intervalle","fréquence"]
[934,null,null,null,null,"population",300,null,900,"]0;900]",{"$f":"FREQUENCY(A1:A300,I4:I12)","v":13}]
[933,null,null,null,null,"min",{"$f":"MIN(A1:A300)","v":898},null,905,"]900;905]",31]
[932,null,null,null,10,"max",{"$f":"MAX(A1:A300)","v":937},null,910,"]905;910]",33]
[899,null,"liste générée",898,null,"moyenne",{"$f":"AVERAGE(A1:A300)","v":916.98},null,915,"]910;915]",56]
[907,null,null,918,null,"écart type",{"$f":"STDEV(A1:A300)","v":9.5937340197376635},null,920,"]915;920]",76]
[930,null,null,914,null,"incertitude",{"$f":"G8/300^0.5","v":0.55389449188292095},null,925,"]920;925]",30]
[910,null,null,914,null,null,null,null,930,"]925;930]",30]
[937,null,null,905,null,"échantillon",30,null,935,"]930;935]",30]
[934,null,null,919,null,"min",{"$f":"MIN(D7:D36)","v":898},null,940,"]935;940]",1]
[935,null,null,935,null,"max",{"$f":"MAX(D7:D36)","v":935}]
[908,null,null,914,null,"moyenne me",{"$f":"AVERAGE(D7:D37)","v":918.29032258064512}]
[909,null,null,915,null,"écart type σe",{"$f":"STDEV(D7:D36)","v":10.402530638174584}]
[910,null,null,923]
[924,null,null,935,null,"estimation ","ponctuelle",null,null,null,null,"intervalle de confiance ","confiance à 95%du taux moyen de CO2 en ppm donné par le capteur"]
[914,null,null,914,null,"écart type"]
[916,null,null,931,null,"population",{"$f":"G15*30^0.5/29^0.5","v":10.580364556565225},null,null,null,null,"[",{"$f":"G7-1.96*G8/30^0.5","v":913.54692637156757},";",{"$f":"G7+1.96*G8/30^0.5","v":920.41307362843247},"]"]
[917,null,null,914]
[915,null,null,918]
[918,null,null,914]
[918,null,null,927]
[919,null,null,924]
[917,null,null,917]
[916,null,null,924]
[925,null,null,904]
[924,null,null,899]
[923,null,null,906]
[915,null,null,930]
[915,null,null,930]
[916,null,null,915]
[928,null,null,933]
[906,null,null,903]
[914,null,null,915]
[927,null,null,927]
[914,null,null,932]
[908]
[906]
[907]
[908]
[928]
[923]
[931]
[906]
[918]
[915]
[916]
[917]
[915]
[914]
[916]
[920]
[919]
[915]
[915]
[920]
[924]
[929]
[927]
[932]
[899]
[901]
[922]
[910]
[898]
[928]
[927]
[903]
[905]
[910]
[924]
[914]
[916]
[917]
[915]
[918]
[918]
[919]
[917]
[916]
[925]
[924]
[923]
[915]
[915]
[916]
[928]
[901]
[914]
[927]
[914]
[904]
[906]
[905]
[915]
[920]
[930]
[934]
[933]
[932]
[899]
[901]
[930]
[910]
[898]
[934]
[935]
[903]
[905]
[910]
[924]
[914]
[916]
[917]
[915]
[918]
[918]
[919]
[917]
[916]
[925]
[924]
[923]
[915]
[915]
[916]
[928]
[901]
[914]
[927]
[914]
[904]
[906]
[905]
[908]
[928]
[930]
[931]
[906]
[918]
[915]
[916]
[917]
[915]
[914]
[916]
[920]
[919]
[915]
[915]
[920]
[930]
[934]
[933]
[932]
[899]
[901]
[930]
[910]
[898]
[934]
[935]
[903]
[905]
[910]
[924]
[914]
[916]
[917]
[915]
[918]
[918]
[919]
[917]
[916]
[925]
[924]
[923]
[915]
[915]
[916]
[928]
[901]
[914]
[927]
[914]
[904]
[906]
[905]
[932]
[899]
[901]
[923]
[910]
[898]
[934]
[935]
[903]
[905]
[910]
[924]
[914]
[916]
[917]
[915]
[918]
[918]
[919]
[917]
[916]
[925]
[924]
[923]
[915]
[915]
[916]
[928]
[901]
[914]
[924]
[914]
[904]
[906]
[905]
[908]
[928]
[930]
[931]
[906]
[918]
[915]
[916]
[917]
[915]
[914]
[916]
[920]
[919]
[915]
[915]
[920]
[930]
[934]
[933]
[932]
[899]
[901]
[930]
[910]
[898]
[934]
[932]
[899]
[901]
[930]
[910]
[898]
[934]
[935]
[903]
[905]
[910]
[924]
[914]
[916]
[917]
[915]
[918]
[918]
[919]
[917]
[916]
[925]
[924]
[923]
[915]
[915]
[916]
[923]
[901]
[914]
[927]
[914]
[904]
[906]
[905]
[908]
[928]
[930]
[931]
[906]
[918]
[915]
[916]
[917]
[915]
[914]
[916]
[920]
[919]
[915]
[915]
[920]
[930]
[934]
[933]
[932]
[899]
[901]
[930]
[910]
[898]
[934]

{"sheet":"régression linéaire","index":6,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["température en °c de la mer","Taux de CO2  moyen en pmm à la surface de la mer"]
[12,410]
[15,444]
[18,581]
[20,679]
[24,803]
[30,917]