Задание 1 простое (скопировать в блокнот - сохранить в формате .htm - открыть в браузере IE скопировать = вставить на выделенную ячейку A1 экселя)
<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:m="http://schemas.microsoft.com/office/2004/12/omml"
xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=windows-1251">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 11">
<link rel=Edit-Time-Data
href="Задание%20171%20172%207%2004%2023.files/editdata.mso">
<link rel=OLE-Object-Data
href="Задание%20171%20172%207%2004%2023.files/oledata.mso">
<!--[if gte mso 9]><xml>
<o:DocumentProperties>
<o:Author>ЛЮТОВ</o:Author>
<o:LastAuthor>ЛЮТОВ</o:LastAuthor>
<o:Created>2023-04-06T07:23:37Z</o:Created>
<o:LastSaved>2023-04-06T07:39:31Z</o:LastSaved>
<o:Company>НГИА</o:Company>
<o:Version>11.9999</o:Version>
</o:DocumentProperties>
</xml><![endif]-->
<style>
<!--table
{mso-displayed-decimal-separator:"\,";
mso-displayed-thousand-separator:" ";}
@page
{margin:.98in .79in .98in .79in;
mso-header-margin:.5in;
mso-footer-margin:.5in;}
.font5
{color:windowtext;
font-size:12.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:"Arial Cyr";
mso-generic-font-family:auto;
mso-font-charset:204;}
tr
{mso-height-source:auto;}
col
{mso-width-source:auto;}
br
{mso-data-placement:same-cell;}
.style0
{mso-number-format:General;
text-align:general;
vertical-align:bottom;
white-space:nowrap;
mso-rotate:0;
mso-background-source:auto;
mso-pattern:auto;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:"Arial Cyr";
mso-generic-font-family:auto;
mso-font-charset:204;
border:none;
mso-protection:locked visible;
mso-style-name:Обычный;
mso-style-id:0;}
td
{mso-style-parent:style0;
padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:"Arial Cyr";
mso-generic-font-family:auto;
mso-font-charset:204;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
border:none;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:locked visible;
white-space:nowrap;
mso-rotate:0;}
.xl24
{mso-style-parent:style0;
font-size:12.0pt;
text-align:center;
vertical-align:middle;
border-top:1.0pt solid windowtext;
border-right:none;
border-bottom:1.0pt solid windowtext;
border-left:none;
background:#FFFF99;
mso-pattern:auto none;
white-space:normal;}
.xl25
{mso-style-parent:style0;
font-size:12.0pt;
font-family:"Times New Roman", serif;
mso-font-charset:204;
text-align:center;
border-top:none;
border-right:1.0pt solid windowtext;
border-bottom:1.0pt solid windowtext;
border-left:1.0pt solid windowtext;
white-space:normal;}
.xl26
{mso-style-parent:style0;
font-size:12.0pt;
font-family:"Times New Roman", serif;
mso-font-charset:204;
text-align:center;
border-top:none;
border-right:1.0pt solid windowtext;
border-bottom:1.0pt solid windowtext;
border-left:none;
white-space:normal;}
.xl27
{mso-style-parent:style0;
font-size:12.0pt;
font-weight:700;
font-family:"Times New Roman", serif;
mso-font-charset:204;
text-align:center;
vertical-align:middle;
border:1.0pt solid windowtext;
white-space:normal;}
.xl28
{mso-style-parent:style0;
font-size:12.0pt;
font-family:"Times New Roman", serif;
mso-font-charset:204;
text-align:center;
border-top:none;
border-right:1.0pt solid windowtext;
border-bottom:none;
border-left:none;
white-space:normal;}
.xl29
{mso-style-parent:style0;
border-top:1.0pt solid windowtext;
border-right:none;
border-bottom:1.0pt solid windowtext;
border-left:1.0pt solid windowtext;
background:#FFFF99;
mso-pattern:auto none;}
.xl30
{mso-style-parent:style0;
border-top:1.0pt solid windowtext;
border-right:none;
border-bottom:1.0pt solid windowtext;
border-left:none;
background:#FFFF99;
mso-pattern:auto none;}
.xl31
{mso-style-parent:style0;
border-top:1.0pt solid windowtext;
border-right:1.0pt solid windowtext;
border-bottom:1.0pt solid windowtext;
border-left:none;
background:#FFFF99;
mso-pattern:auto none;}
.xl32
{mso-style-parent:style0;
border-top:1.0pt solid windowtext;
border-right:1.0pt solid windowtext;
border-bottom:none;
border-left:1.0pt solid windowtext;
background:#FFFF99;
mso-pattern:auto none;}
.xl33
{mso-style-parent:style0;
border-top:none;
border-right:1.0pt solid windowtext;
border-bottom:none;
border-left:1.0pt solid windowtext;}
.xl34
{mso-style-parent:style0;
font-size:12.0pt;
font-family:"Times New Roman", serif;
mso-font-charset:204;
text-align:center;
border-top:none;
border-right:1.0pt solid windowtext;
border-bottom:none;
border-left:1.0pt solid windowtext;
white-space:normal;}
.xl35
{mso-style-parent:style0;
color:red;
font-size:12.0pt;
text-align:center;
vertical-align:middle;
border-top:1.0pt solid windowtext;
border-right:none;
border-bottom:1.0pt solid windowtext;
border-left:1.0pt solid windowtext;
background:#FFFF99;
mso-pattern:auto none;
white-space:normal;}
.xl36
{mso-style-parent:style0;
color:red;
font-size:16.0pt;
font-weight:700;
vertical-align:middle;
border-top:1.0pt solid windowtext;
border-right:none;
border-bottom:none;
border-left:1.0pt solid windowtext;
white-space:normal;}
.xl37
{mso-style-parent:style0;
color:red;
font-size:16.0pt;
font-weight:700;
vertical-align:middle;
border-top:1.0pt solid windowtext;
border-right:none;
border-bottom:none;
border-left:none;
white-space:normal;}
.xl38
{mso-style-parent:style0;
color:red;
font-size:16.0pt;
font-weight:700;
vertical-align:middle;
border-top:1.0pt solid windowtext;
border-right:1.0pt solid windowtext;
border-bottom:none;
border-left:none;
white-space:normal;}
.xl39
{mso-style-parent:style0;
color:red;
font-size:16.0pt;
font-weight:700;
vertical-align:middle;
border-top:none;
border-right:none;
border-bottom:none;
border-left:1.0pt solid windowtext;
white-space:normal;}
.xl40
{mso-style-parent:style0;
color:red;
font-size:16.0pt;
font-weight:700;
vertical-align:middle;
white-space:normal;}
.xl41
{mso-style-parent:style0;
color:red;
font-size:16.0pt;
font-weight:700;
vertical-align:middle;
border-top:none;
border-right:1.0pt solid windowtext;
border-bottom:none;
border-left:none;
white-space:normal;}
.xl42
{mso-style-parent:style0;
color:red;
font-size:16.0pt;
font-weight:700;
vertical-align:middle;
border-top:none;
border-right:none;
border-bottom:1.0pt solid windowtext;
border-left:1.0pt solid windowtext;
white-space:normal;}
.xl43
{mso-style-parent:style0;
color:red;
font-size:16.0pt;
font-weight:700;
vertical-align:middle;
border-top:none;
border-right:none;
border-bottom:1.0pt solid windowtext;
border-left:none;
white-space:normal;}
.xl44
{mso-style-parent:style0;
color:red;
font-size:16.0pt;
font-weight:700;
vertical-align:middle;
border-top:none;
border-right:1.0pt solid windowtext;
border-bottom:1.0pt solid windowtext;
border-left:none;
white-space:normal;}
-->
</style>
<!--[if gte mso 9]><xml>
<x:ExcelWorkbook>
<x:ExcelWorksheets>
<x:ExcelWorksheet>
<x:Name>Лист1</x:Name>
<x:WorksheetOptions>
<x:Print>
<x:ValidPrinterInfo/>
<x:PaperSizeIndex>9</x:PaperSizeIndex>
<x:HorizontalResolution>600</x:HorizontalResolution>
<x:VerticalResolution>600</x:VerticalResolution>
</x:Print>
<x:Zoom>130</x:Zoom>
<x:Selected/>
<x:Panes>
<x:Pane>
<x:Number>3</x:Number>
<x:ActiveRow>9</x:ActiveRow>
<x:ActiveCol>11</x:ActiveCol>
</x:Pane>
</x:Panes>
<x:ProtectContents>False</x:ProtectContents>
<x:ProtectObjects>False</x:ProtectObjects>
<x:ProtectScenarios>False</x:ProtectScenarios>
</x:WorksheetOptions>
</x:ExcelWorksheet>
</x:ExcelWorksheets>
<x:WindowHeight>8760</x:WindowHeight>
<x:WindowWidth>16275</x:WindowWidth>
<x:WindowTopX>120</x:WindowTopX>
<x:WindowTopY>75</x:WindowTopY>
<x:ProtectStructure>False</x:ProtectStructure>
<x:ProtectWindows>False</x:ProtectWindows>
</x:ExcelWorkbook>
</xml><![endif]-->
</head>
<body link=blue vlink=purple>
<table x:str border=0 cellpadding=0 cellspacing=0 width=847 style='border-collapse:
collapse;table-layout:fixed;width:635pt'>
<col width=124 style='mso-width-source:userset;mso-width-alt:4534;width:93pt'>
<col width=64 span=11 style='width:48pt'>
<col width=19 style='mso-width-source:userset;mso-width-alt:694;width:14pt'>
<tr height=136 style='mso-height-source:userset;height:102.0pt'>
<td colspan=12 height=136 class=xl35 width=828 style='height:102.0pt;
width:621pt'>Задание на 07 04 23 <font class="font5"><span
style='mso-spacerun:yes'> </span>При работе с рефрактометром были получены
данные о показателе преломления раствора сахара при некоторых концентрациях.
Определите для своего варианта коэффициенты линейной регрессии зависимости n
(C%), и далее рассчитайте неизвестную концентрацию раствора по найденному
показателю преломления.<span style='mso-spacerun:yes'> </span>Отобразите
экспериментальные точки на плоскости n (C%), а также постройте график
регрессионной модели.</font></td>
<td rowspan=7 class=xl32 width=19 style='width:14pt'> </td>
</tr>
<tr height=65 style='mso-height-source:userset;height:48.75pt'>
<td height=65 class=xl27 width=124 style='height:48.75pt;border-top:none;
width:93pt'>Вариант / Концентрация (%)</td>
<td class=xl27 width=64 style='border-top:none;border-left:none;width:48pt'
x:num>1</td>
<td class=xl27 width=64 style='border-top:none;border-left:none;width:48pt'
x:num>2</td>
<td class=xl27 width=64 style='border-top:none;border-left:none;width:48pt'
x:num>3</td>
<td class=xl27 width=64 style='border-top:none;border-left:none;width:48pt'
x:num>4</td>
<td class=xl27 width=64 style='border-top:none;border-left:none;width:48pt'
x:num>5</td>
<td class=xl27 width=64 style='border-top:none;border-left:none;width:48pt'
x:num>6</td>
<td colspan=5 rowspan=6 class=xl36 width=320 style='border-right:1.0pt solid black;
border-bottom:1.0pt solid black;width:240pt'>Вариант 1 - первой 1/3 части
группы 171<span style='mso-spacerun:yes'> </span>и т. д.</td>
</tr>
<tr height=22 style='height:16.5pt;mso-yfti-firstrow:yes;mso-yfti-irow:0'>
<td height=22 class=xl25 width=124 style='height:16.5pt;width:93pt' x:num>5</td>
<td class=xl26 width=64 style='width:48pt' x:num="1.3340000000000001"><span
style='mso-ansi-language:RU;mso-bidi-font-size:10pt'>1,334</span></td>
<td class=xl26 width=64 style='width:48pt' x:num="1.3320000000000001"><span
style='mso-ansi-language:RU;mso-bidi-font-size:10pt'>1,332</span></td>
<td class=xl26 width=64 style='width:48pt' x:num="1.333"><span
style='mso-ansi-language:RU;mso-bidi-font-size:10pt'>1,333</span></td>
<td class=xl26 width=64 style='width:48pt' x:num="1.335"><span
style='mso-ansi-language:RU;mso-bidi-font-size:10pt'>1,335</span></td>
<td class=xl26 width=64 style='width:48pt' x:num="1.339"><span
style='mso-ansi-language:RU;mso-bidi-font-size:10pt'>1,339</span></td>
<td class=xl26 width=64 style='width:48pt' x:num="1.337"><span
style='mso-ansi-language:RU;mso-bidi-font-size:10pt'>1,337</span></td>
</tr>
<tr height=22 style='height:16.5pt'>
<td height=22 class=xl25 width=124 style='height:16.5pt;width:93pt' x:num>7</td>
<td class=xl26 width=64 style='width:48pt' x:num="1.34"><span
style='mso-ansi-language:RU;mso-bidi-font-size:10pt'>1,34</span></td>
<td class=xl26 width=64 style='width:48pt' x:num="1.337"><span
style='mso-ansi-language:RU;mso-bidi-font-size:10pt'>1,337</span></td>
<td class=xl26 width=64 style='width:48pt' x:num="1.341"><span
style='mso-ansi-language:RU;mso-bidi-font-size:10pt'>1,341</span></td>
<td class=xl26 width=64 style='width:48pt' x:num="1.3480000000000001"><span
style='mso-ansi-language:RU;mso-bidi-font-size:10pt'>1,348</span></td>
<td class=xl26 width=64 style='width:48pt' x:num="1.3420000000000001"><span
style='mso-ansi-language:RU;mso-bidi-font-size:10pt'>1,342</span></td>
<td class=xl26 width=64 style='width:48pt' x:num="1.3460000000000001"><span
style='mso-ansi-language:RU;mso-bidi-font-size:10pt'>1,346</span></td>
</tr>
<tr height=22 style='height:16.5pt'>
<td height=22 class=xl25 width=124 style='height:16.5pt;width:93pt' x:num>9</td>
<td class=xl26 width=64 style='width:48pt' x:num="1.3480000000000001"><span
style='mso-ansi-language:RU;mso-bidi-font-size:10pt'>1,348</span></td>
<td class=xl26 width=64 style='width:48pt' x:num="1.349"><span
style='mso-ansi-language:RU;mso-bidi-font-size:10pt'>1,349</span></td>
<td class=xl26 width=64 style='width:48pt' x:num="1.351"><span
style='mso-ansi-language:RU;mso-bidi-font-size:10pt'>1,351</span></td>
<td class=xl26 width=64 style='width:48pt' x:num="1.3560000000000001"><span
style='mso-ansi-language:RU;mso-bidi-font-size:10pt'>1,356</span></td>
<td class=xl26 width=64 style='width:48pt' x:num="1.3560000000000001"><span
style='mso-ansi-language:RU;mso-bidi-font-size:10pt'>1,356</span></td>
<td class=xl26 width=64 style='width:48pt' x:num="1.3540000000000001"><span
style='mso-ansi-language:RU;mso-bidi-font-size:10pt'>1,354</span></td>
</tr>
<tr height=22 style='height:16.5pt'>
<td height=22 class=xl25 width=124 style='height:16.5pt;width:93pt' x:num>11</td>
<td class=xl26 width=64 style='width:48pt' x:num="1.35"><span
style='mso-ansi-language:RU;mso-bidi-font-size:10pt'>1,35</span></td>
<td class=xl26 width=64 style='width:48pt' x:num="1.39"><span
style='mso-ansi-language:RU;mso-bidi-font-size:10pt'>1,39</span></td>
<td class=xl26 width=64 style='width:48pt' x:num="1.3560000000000001"><span
style='mso-ansi-language:RU;mso-bidi-font-size:10pt'>1,356</span></td>
<td class=xl26 width=64 style='width:48pt' x:num="1.359"><span
style='mso-ansi-language:RU;mso-bidi-font-size:10pt'>1,359</span></td>
<td class=xl26 width=64 style='width:48pt' x:num="1.359"><span
style='mso-ansi-language:RU;mso-bidi-font-size:10pt'>1,359</span></td>
<td class=xl26 width=64 style='width:48pt' x:num="1.36"><span
style='mso-ansi-language:RU;mso-bidi-font-size:10pt'>1,36</span></td>
</tr>
<tr height=22 style='height:16.5pt'>
<td height=22 class=xl34 width=124 style='height:16.5pt;width:93pt'>Cx</td>
<td class=xl28 width=64 style='width:48pt' x:num="1.353"><span
style='mso-ansi-language:RU;mso-bidi-font-size:10pt'>1,353</span></td>
<td class=xl28 width=64 style='width:48pt' x:num="1.34"><span
style='mso-ansi-language:RU;mso-bidi-font-size:10pt'>1,34</span></td>
<td class=xl28 width=64 style='width:48pt' x:num="1.34"><span
style='mso-ansi-language:RU;mso-bidi-font-size:10pt'>1,34</span></td>
<td class=xl28 width=64 style='width:48pt' x:num="1.349"><span
style='mso-ansi-language:RU;mso-bidi-font-size:10pt'>1,349</span></td>
<td class=xl28 width=64 style='width:48pt' x:num="1.343"><span
style='mso-ansi-language:RU;mso-bidi-font-size:10pt'>1,343</span></td>
<td class=xl28 width=64 style='width:48pt' x:num="1.353"><span
style='mso-ansi-language:RU;mso-bidi-font-size:10pt'>1,353</span></td>
</tr>
<tr height=18 style='height:13.5pt'>
<td colspan=13 height=18 class=xl29 style='border-right:1.0pt solid black;
height:13.5pt'> </td>
</tr>
<![if supportMisalignedColumns]>
<tr height=0 style='display:none'>
<td width=124 style='width:93pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=19 style='width:14pt'></td>
</tr>
<![endif]>
</table>
</body>
</html>