{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["المعطيات","الحل"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"المعطيات","index":0,"n_rows":16,"n_cols":28,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,2],[9,4,11,6],[9,7,11,10],[12,4,14,6],[12,7,14,10],[15,4,17,6],[15,7,17,10],[11,15,14,18],[0,27,1,27],[11,12,14,14],[8,12,10,15]]}
[]
[]
[null,null,{"$f":"IF(H10=\"\",\"\",H10)","v":1991},{"$f":"IFERROR(IF(D4=\"\",\"\",$C$3+D4-1),\"\")","v":1992},{"$f":"IFERROR(IF(E4=\"\",\"\",$C$3+E4-1),\"\")","v":1993},1994,1995,1996,1997,1998,1999,2000,2001,"","","","","","","","","","","","","","",{"$f":"IF(H13=\"\",\"\",H13)","v":2032}]
[null,"xi",{"$f":"IF(C3=\"\",\"\",C3-$C$3+1)","v":1},{"$f":"IF(C4>=$H$16,\"\",COLUMN(D4)-COLUMN($B$4))","v":2},{"$f":"IF(D4>=$H$16,\"\",COLUMN(E4)-COLUMN($B$4))","v":3},4,5,6,7,8,9,10,11,"","","","","","","","","","","","","","",{"$f":"IFERROR(IF(AB3=\"\",\"\",AB3-$C$3+1),\"\")","v":42}]
["إدخال قيم","yi",10.3,40.5,51.7,63.9,100.8,107.6,90.3,87.1,68.7,177,172,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"الحل!J67","v":540.80181818181825}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M12","v":540.80181818181825}]
[null,null,null,null,"إبتداءا من سنة",null,null,1991]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AB5","v":540.80181818181825},null,null,"الـــ yi المطلوبة بالتقريب"]
[null,null,null,null,"إلى غاية سنة",null,null,2032]
[]
[]
[null,null,null,null,"عدد الخانات",null,null,11]

{"sheet":"الحل","index":1,"n_rows":67,"n_cols":18,"rows_kept":67,"cut":false,"hidden":false,"merged":[[66,15,67,15],[66,9,67,14],[66,7,67,8],[62,8,63,8],[62,9,63,9],[62,4,63,4],[62,5,63,7],[64,15,65,15],[64,9,65,14],[62,16,63,16],[62,14,63,15],[62,13,63,13],[62,10,63,12],[60,4,60,10],[60,11,60,16],[56,5,56,8],[57,16,58,16],[57,15,58,15],[57,13,58,14],[57,12,58,12],[57,11,58,11],[57,10,58,10],[57,6,58,9],[8,3,8,8],[8,9,8,14],[1,1,1,4],[5,9,6,9],[5,10,6,10],[5,12,6,12],[5,14,6,14],[36,14,36,15],[37,14,37,15],[38,9,38,12],[39,10,42,10],[2,10,3,10],[2,12,3,12],[2,9,3,9],[2,14,3,14],[38,5,38,8],[39,16,42,16],[39,15,40,15],[41,15,42,15],[39,11,40,13],[41,11,42,13],[39,14,42,14],[39,7,42,9],[44,8,44,16],[46,11,46,13],[47,11,47,13],[46,14,46,15],[47,14,47,15],[48,8,49,9],[51,11,51,16],[52,16,53,16],[52,15,53,15],[52,13,53,14],[48,16,49,16],[48,10,49,10],[48,11,49,11],[48,15,49,15],[48,14,49,14],[48,12,49,13],[52,8,53,8],[52,12,53,12],[52,11,53,11],[52,10,53,10],[52,9,53,9],[54,16,55,16],[54,15,55,15],[54,11,55,14],[54,10,55,10],[54,8,55,8],[54,9,55,9]]}
[]
[null,"حساب x̅ و y̅:"]
[null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(L3/L4,\"\")","v":6},"=",{"$f":"IF(SUM(المعطيات!C4:AA4)=0,\"\",SUM(المعطيات!C4:AA4))","v":66},"=","∑(xi)","x̅ ="]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(المعطيات!C4:AA4)-COUNTBLANK(المعطيات!C4:AA4)=0,\"\",COUNTA(المعطيات!C4:AA4)-COUNTBLANK(المعطيات!C4:AA4))","v":11},null,"n"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(L6/L7,\"\")","v":88.172727272727272},"=",{"$f":"IF(SUM(المعطيات!C5:AA5)=0,\"\",SUM(المعطيات!C5:AA5))","v":969.9},"=","∑(yi)","y̅ ="]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(المعطيات!C5:AA5)=0,\"\",COUNTA(المعطيات!C5:AA5))","v":11},null,"n"]
[]
[null,{"$f":"IF(TRANSPOSE(xi)=0,\"\",TRANSPOSE(xi))","v":"xi"},"yi","x =  xi - x̅",null,null,null,null,null,"y =  yi - y̅",null,null,null,null,null,"∑(x.y)","∑(x)²","empty/no"]
[null,1,10.3,{"$f":"IFERROR(H10-F10,\"\")","v":-5},{"$f":"IF(B10=\"\",\"\",\"=\")","v":"="},{"$f":"IF(B10=\"\",\"\",$J$3)","v":6},{"$f":"IF(B10=\"\",\"\",\"-\")","v":"-"},{"$f":"B10","v":1},{"$f":"IF(B10=\"\",\"\",\"x =\")","v":"x ="},{"$f":"IFERROR(N10-L10,\"\")","v":-77.872727272727275},{"$f":"IF(C10=\"\",\"\",\"=\")","v":"="},{"$f":"IF(C10=\"\",\"\",$J$6)","v":88.172727272727272},{"$f":"IF(C10=\"\",\"\",\"-\")","v":"-"},{"$f":"C10","v":10.3},{"$f":"IF(C10=\"\",\"\",\"y =\")","v":"y ="},{"$f":"IFERROR(D10*J10,\"\")","v":389.36363636363637},{"$f":"IFERROR(D10*D10,\"\")","v":25},{"$f":"IF(B10=\"\",\"empty\",\"no\")","v":"no"}]
[null,2,40.5,{"$f":"IFERROR(H11-F11,\"\")","v":-4},{"$f":"IF(B11=\"\",\"\",\"=\")","v":"="},{"$f":"IF(B11=\"\",\"\",$J$3)","v":6},{"$f":"IF(B11=\"\",\"\",\"-\")","v":"-"},{"$f":"B11","v":2},{"$f":"IF(B11=\"\",\"\",\"x =\")","v":"x ="},{"$f":"IFERROR(N11-L11,\"\")","v":-47.672727272727272},{"$f":"IF(C11=\"\",\"\",\"=\")","v":"="},{"$f":"IF(C11=\"\",\"\",$J$6)","v":88.172727272727272},{"$f":"IF(C11=\"\",\"\",\"-\")","v":"-"},{"$f":"C11","v":40.5},{"$f":"IF(C11=\"\",\"\",\"y =\")","v":"y ="},{"$f":"IFERROR(D11*J11,\"\")","v":190.69090909090909},{"$f":"IFERROR(D11*D11,\"\")","v":16},{"$f":"IF(B11=\"\",\"empty\",\"no\")","v":"no"}]
[null,3,51.7,-3,"=",6,"-",3,"x =",-36.472727272727269,"=",88.172727272727272,"-",51.7,"y =",109.41818181818181,9,"no"]
[null,4,63.9,-2,"=",6,"-",4,"x =",-24.272727272727273,"=",88.172727272727272,"-",63.9,"y =",48.545454545454547,4,"no"]
[null,5,100.8,-1,"=",6,"-",5,"x =",12.627272727272725,"=",88.172727272727272,"-",100.8,"y =",-12.627272727272725,1,"no"]
[null,6,107.6,0,"=",6,"-",6,"x =",19.427272727272722,"=",88.172727272727272,"-",107.6,"y =",0,0,"no"]
[null,7,90.3,1,"=",6,"-",7,"x =",2.1272727272727252,"=",88.172727272727272,"-",90.3,"y =",2.1272727272727252,1,"no"]
[null,8,87.1,2,"=",6,"-",8,"x =",-1.0727272727272776,"=",88.172727272727272,"-",87.1,"y =",-2.1454545454545553,4,"no"]
[null,9,68.7,3,"=",6,"-",9,"x =",-19.472727272727269,"=",88.172727272727272,"-",68.7,"y =",-58.418181818181807,9,"no"]
[null,10,177,4,"=",6,"-",10,"x =",88.827272727272728,"=",88.172727272727272,"-",177,"y =",355.30909090909091,16,"no"]
[null,11,172,5,"=",6,"-",11,"x =",83.827272727272728,"=",88.172727272727272,"-",172,"y =",419.13636363636363,25,"no"]
[null,"","","","","","","","","","","","","","","","","empty"]
[null,"","","","","","","","","","","","","","","","","empty"]
[null,"","","","","","","","","","","","","","","","","empty"]
[null,"","","","","","","","","","","","","","","","","empty"]
[null,"","","","","","","","","","","","","","","","","empty"]
[null,"","","","","","","","","","","","","","","","","empty"]
[null,"","","","","","","","","","","","","","","","","empty"]
[null,"","","","","","","","","","","","","","","","","empty"]
[null,"","","","","","","","","","","","","","","","","empty"]
[null,"","","","","","","","","","","","","","","","","empty"]
[null,"","","","","","","","","","","","","","","","","empty"]
[null,"","","","","","","","","","","","","","","","","empty"]
[null,"","","","","","","","","","","","","","","","","empty"]
[null,"","","","","","","","","","","","","","","","","empty"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(P10:P34)=0,\"\",SUM(P10:P34))","v":1441.4},{"$f":"IF(SUM(Q10:Q34)=0,\"\",SUM(Q10:Q34))","v":110}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(P4:P27)=0,\"\",SUM(P4:P27))","v":1441.4},null,"∑(x.y) ="]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(Q9:Q32)=0,\"\",SUM(Q9:Q32))","v":110},null,"∑(x)² ="]
[null,null,null,null,null,"إيجــاد المطلوب:",null,null,null,"y=ax+B"]
[null,null,null,null,null,null,null,{"$f":"IFERROR(O37/O38,\"\")","v":13.103636363636365},null,null,"=",{"$f":"O37","v":1441.4},null,null,"=","∑(x.y)","a = "]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"O38","v":110},null,null,null,"∑(x)²"]
[]
[]
[null,null,null,null,null,null,null,null,"1+(السنة الأخيرة - السنة الأولى) = x"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"السنة الأخيرة=",null,null,{"$f":"IF(المعطيات!AB3=0,\"\",المعطيات!AB3)","v":2032}]
[null,null,null,null,null,null,null,null,null,null,null,"السنة الأولى=",null,null,{"$f":"IF(المعطيات!C3=0,\"\",المعطيات!C3)","v":1991}]
[null,null,null,null,null,null,null,null,{"$f":"\"=\"&\"  \"&(المعطيات!AB4)","v":"=  42"},null,1,"+",{"$f":"O48","v":1991},null,"-",{"$f":"O47","v":2032},"x="]
[]
[]
[null,null,null,null,null,"حســاب    B:",null,null,null,null,null,"المعادلة الإفتراضية:  y̅ = ax̅ + B"]
[null,null,null,null,null,null,null,null,"B","+",")",{"$f":"J3","v":6},"(",{"$f":"H40","v":13.103636363636365},null,"=",{"$f":"J6","v":88.172727272727272}]
[]
[null,null,null,null,null,null,null,null,null,"B","+",{"$f":"IFERROR(H40*J3,\"\")","v":78.621818181818185},null,null,null,"=",{"$f":"J6","v":88.172727272727272}]
[]
[]
[null,null,null,null,null,null,{"$f":"IFERROR((H40*J3)-J6,\"\")","v":-9.5509090909090872},null,null,null,"=",{"$f":"Q55","v":88.172727272727272},"-",{"$f":"L55","v":78.621818181818185},null,"=","B"]
[]
[]
[null,null,null,null,"بالتعويض في المعادلة الكلية",null,null,null,null,null,null,"  y   =   ax  +   B"]
[]
[null,null,null,null,")",{"$f":"G58","v":-9.5509090909090872},null,null,"(","+",{"$f":"\"(\"&\" \"&المعطيات!AB4&\" \"&\")\"","v":"( 42 )"},null,null,"x",{"$f":"H40","v":13.103636363636365},null,"y  ="]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(((O63*المعطيات!AB4)+G58),\"\")","v":540.80181818181825},null,null,null,null,null,"y  ="]
[]
[null,null,null,null,null,null,null,"بالتقريب",null,{"$f":"J65","v":540.80181818181825},null,null,null,null,null,"y  ="]