- #1
seasnake
- 42
- 0
Can anyone figure this out... searching for an algebraic equation (not a student)
I'm trying to unravel some equations in a spreadsheet and as such I need to find a non-time-series, algebraic equation for the following data expressed for finding C:
A + B always equals 10 (i.e. A1 + B1 = 10; A2 + B2 = 10; ...)
when:
A0 = 0... B0 = 10 ... C0 = 10
A1 = 1 ... B1 = 9 ... C1 = 4
A2 = 2 ... B2 = 8 ... C2 = 2
A3 = 3 ... B3 = 7 ... C3 = 0.83 repeating 3
A4 = 4 ... B4 = 6 ... C4 = 0.2
A5 = 5 ... B5 = 5 ... C5 = 0
A6 = 6 ... B6 = 4 ... C6 = 0.2
A7 = 7 ... B7 = 3 ... C7 = 0.83 repeating 3
A8 = 8 ... B8 = 2 ... C8 = 2
A9 = 9 ... B9 = 1 ... C9 = 4
A10 = 10 ... B10 = 0 ... C10 = 10
an eqational attempts would be something along the lines of:
(A - B) / (A + B) = C
(A - B) / (A times B) = C
(A - B)^2 / (A + B) = C
Note: C3 = C7 = 0.83 = 5 / 6 (serves as a decent clue as it displays both a numerator and a denominator)
once again, I am not seeking a time series equation...
I'm trying to unravel some equations in a spreadsheet and as such I need to find a non-time-series, algebraic equation for the following data expressed for finding C:
A + B always equals 10 (i.e. A1 + B1 = 10; A2 + B2 = 10; ...)
when:
A0 = 0... B0 = 10 ... C0 = 10
A1 = 1 ... B1 = 9 ... C1 = 4
A2 = 2 ... B2 = 8 ... C2 = 2
A3 = 3 ... B3 = 7 ... C3 = 0.83 repeating 3
A4 = 4 ... B4 = 6 ... C4 = 0.2
A5 = 5 ... B5 = 5 ... C5 = 0
A6 = 6 ... B6 = 4 ... C6 = 0.2
A7 = 7 ... B7 = 3 ... C7 = 0.83 repeating 3
A8 = 8 ... B8 = 2 ... C8 = 2
A9 = 9 ... B9 = 1 ... C9 = 4
A10 = 10 ... B10 = 0 ... C10 = 10
an eqational attempts would be something along the lines of:
(A - B) / (A + B) = C
(A - B) / (A times B) = C
(A - B)^2 / (A + B) = C
Note: C3 = C7 = 0.83 = 5 / 6 (serves as a decent clue as it displays both a numerator and a denominator)
once again, I am not seeking a time series equation...
Last edited: