# Tutor profile: Alexandra T.

## Questions

### Subject: Visual Basic Programming

Explain what the following line of code does: Dim i As Integer For i = 10 To 1 Step -1 If INSTR(1, ActiveWorkbook.Sheets(1).Cells(i, 1).Value2, "-") = TRUE Then ActiveWorkbook.Sheets(1).Cells(i, 1).Interior.ColorIndex = 3 End If Next i

The code does the following: 1. It loops through rows 1 to 10 starting with row 10 (bottom up) 2. For each row it looks at the value of the cell in column 1 3. It then determines if the cell contains "-" 4. If it does contain "-" then it colors the cell red

### Subject: SAT

Which of the following lines does not intersect y = 5x + 2? A. -5x + 2y = 4 B. -2x + 5y = -3 C. 10x - y = 1 D. 3x + y = 17 E. 5x - y = -29

To answer this question we first need to solve each equation for y. A .-5x + 2y = 4 2y = 5x + 4 y = 5/2x + 4 B. -2x + 5y = -3 5y = 2x - 3 y = 2/5x - 3/5 C. 10x - y = 1 -y = -10x + 1 y = 10x - 1 D. 3x + y = 17 y = -3x + 17 E. 5x - y = -29 -y = -5x -29 y = 5x + 29 Next we compare the slopes. The slope of the original equation is 5. A. The slope of this equation is 5/2. Because this is different that 5 at some point the graphs will intersect. B. The slope of this equation is 2/5. Because this is different that 5 at some point the graphs will intersect. C. The slope of this equation is 10. Because this is different that 5 at some point the graphs will intersect. D. The slope of this equation is -3. Because this is different that 5 at some point the graphs will intersect. E The slope of this equation is 5. This is the same slope as the original equation. We must now look at the intercept to determine if this equation produces the same line as the original equation or a parallel line. Parallel lines never intersect. The intercept of the original equation is 2 but is 29 in this equation. Since the slopes are the same but the intercepts are different the equations produce parallel lines that do not intersect. The correct answer is E

### Subject: Statistics

Using the empirical rule what percent of the data lies between 2 standard deviations?

The empirical rule is also referred to as the 68-95-99.7 rule. This is because it says that 68% of the data lies between 1 standard deviation, 95% between 2 standard deviations and 99.7% between 3 standard deviations.

## Contact tutor

needs and Alexandra will reply soon.