Курсовая работа: Статистический анализ деятельности предприятия

ActiveCell.FormulaR1C1 = _

"=(R[-2]C*R[-10]C+R[-2]C[1]*R[-10]C[1]+R[-2]C[2]*R[-10]C[2]+R[-2]C[3]*R[-10]C[3]+R[-2]C[4]*R[-10]C[4]+R[-2]C[5]*R[-10]C[5])/R[-67]C[1]"

Range("C117").Select

ActiveWindow.SmallScroll Down:=9

Range("C117").Select

ActiveCell.FormulaR1C1 = _

"=(R[-10]C[8]*R[-10]C[-1]+R[-9]C[8]*R[-9]C[-1]+R[-8]C[8]*R[-8]C[-1]+R[-7]C[8]*R[-7]C[-1]+R[-6]C[8]*R[-6]C[-1])/R[-68]C[1]"

Range("C118").Select

ActiveWindow.SmallScroll Down:=6

ActiveCell.FormulaR1C1 = _

"=(R[-4]C*R106C3+R[-4]C[1]*R106C4+R[-4]C[2]*R106C5+R[-4]C[3]*R106C6+R[-4]C[4]*R106C7+R[-4]C[5]*R106C8)/R[-69]C[1]"

Range("C119").Select

ActiveWindow.SmallScroll Down:=6

Range("C118").Select

ActiveCell.FormulaR1C1 = _

"=(R[-4]C*R106C3^2+R[-4]C[1]*R106C4^2+R[-4]C[2]*R106C5^2+R[-4]C[3]*R106C6^2+R[-4]C[4]*R106C7^2+R[-4]C[5]*R106C8^2)/R[-69]C[1]"

Range("C119").Select

ActiveCell.FormulaR1C1 = _

"=(R[-12]C[8]*R[-12]C[-1]^2+R[-11]C[8]*R[-11]C[-1]^2+R[-10]C[8]*R[-10]C[-1]^2+R[-9]C[8]*R[-9]C[-1]^2+R[-8]C[8]*R[-8]C[-1]^2)/R[-70]C[1]"

Range("F116").Select

ActiveCell.FormulaR1C1 = "=SQRT(R[2]C[-3]-RC[-3]^2)"

Range("F117").Select

ActiveCell.FormulaR1C1 = "=коень(R[2]C[-3]-RC[-3]^2)"

Range("F117").Select

Columns("F:F").ColumnWidth = 11

Columns("F:F").ColumnWidth = 10.14

ActiveCell.FormulaR1C1 = "=SQRT(R[2]C[-3]-RC[-3]^2)"

Range("F118").Select

ActiveCell.FormulaR1C1 = "=R[-5]C[4]"