Re: Calculation question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi. I have a program that does this for me automatically.
If we were to plot these types of problems, what we would have are 4
straight line intervals. The problem is to calculate the equation of each
line (y = a*x+b).
We are given the slopes of each line (the 'a). We need to calculate the
y-intercepts 'b.

As we start from zero, the first one is easy. The intercept is zero.
=.0045+a1

For the second line, we need two points to calculate a straint line.
Therefore, let's pick two easy x-points. 100000, and 100001
1) (x,y) = (100000,100000*.0045) ->(100000,450)
2) (x,y) = (100001,450+.003)

Hence:

=INTERCEPT({450,450.003},{100000;100001})
returns:
150

Second equation is:
0.3%*A1+150

Keep going for each one.

Because the slopes are decreasing, we take the "Min."
Some problems, like commissions, are increasing, so we would want to take
the "Max" for those problems.
Hope this helps. :>)

=Min(0.0045*A1,150+0.003*A1,650+0.002*A1,1650+0.001*A1)
--
Dana DeLouis


"joeu2004" <joeu2004@xxxxxxxxxxx> wrote in message
news:1185086452.224437.175610@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Jul 21, 10:06 pm, "Dana DeLouis" <ddelo...@xxxxxxxxxxxxx> wrote:
Perhaps another option:
=MIN(0.1%*A1+1650, 0.2%*A1+650, 0.3%*A1+150, 0.45%*A1)

Excellent! I would only suggest an explanation of the "magic"
constants. I leave that to you to have the last word on the
subject ;-).



.

Relevant Pages

  • Re: interpretting F & t-vals from regression
    ... these are treatment contrasts so they may not be differences from zero. ... I have subjects each doing 5 durations. ... significant difference in the estimated slopes of intensity across ...
    (sci.stat.consult)
  • Re: compare robust regressions statistically
    ... % zero. ... % coefficient is the difference in slopes between group 2 and group 1. ... If the p-value is greater than alpha, there is insufficient % evidence to reject the null hypothesis. ... fprintf('The p-value for the Nullhypothesis slope1 is equal to other two slopes is %.2g \n',p1); ...
    (comp.soft-sys.matlab)
  • [WR]Copley half frozen
    ... First screen frost of the autumn in the lower village this morning, ... just above zero at the Met O site on the slopes. ...
    (uk.sci.weather)
  • Re: pdepe
    ... My concerne is the term f where the I have a zero in ... No, you can't use pdepe. ... Because of your second equation, ...
    (comp.soft-sys.matlab)
  • Re: V fit
    ... Oh geez. ... Do you know where the break lies? ... The slope for the part below zero is -1, ... Can we estimate the two slopes knowing ...
    (comp.soft-sys.matlab)