English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

I know that it is a combination, and can be solved using the formula, but how does a graph or technology tell you that it really is?

2007-11-05 20:49:01 · 1 answers · asked by hypatia27 1 in Science & Mathematics Mathematics

1 answers

I'll explain how to do it in Excel.

In one column, put the numbers 1, 2, 3
In the second column, put the pattern numbers 3, 6, 10

Now select the 6 cells and click the 'Chart Wizard' (or Insert > Chart). Pick an X, Y scatter with straight lines.

On your graph, right-click on the line and choose 'Add Trendline'. I'd pick a 2nd order polynomial. Then click on the 'Options' tab and choose 'Display equation on chart'.

In this example you end up with:
y = 0.5x² + 1.5x + 1

Check the pattern by putting in additional numbers:
x = 4 --> y = 8 + 6 + 1 = 15
x = 5 --> y = 12.5 + 7.5 + 1 = 21
etc.

So this gives you a pattern of 3, 6, 10, 15, 21, 27, etc.

2007-11-05 20:59:33 · answer #1 · answered by Puzzling 7 · 0 0

fedest.com, questions and answers