JenniferMurphy
Well-known Member
- Joined
- Jul 23, 2011
- Messages
- 2,531
- Office Version
- 365
- Platform
- Windows
I have some data that I know follows a power curve. I have plotted the data, generated a trendline, and have the power function displayed on the chart. Here's the current set of data and the displayed trendline equation. The value "0.01" in H2 is a temporary value because Excel's power function curve fitting algorithm cannot handle zeroes. (sigh)
<tbody>
</tbody>
y=798.59e-1.371x
As I run each trial, I add to the corresponding tally. For example, if the next trial results in a Value of "3", I will increment D2 from 14 to 15.
I would like to add a new row (3) that wold show the expected tally as computed by the trendline. And I would like that data to be dynamically and automatically updated when I update a value.
<tbody>
</tbody>
Is there any way to do this that might be simple enough for me to understand?
A | B | C | D | E | F | G | H | |
1 | N | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
2 | Actual Tally | 122 | 43 | 14 | 6 | 1 | 1 | 0.01 |
<tbody>
</tbody>
y=798.59e-1.371x
As I run each trial, I add to the corresponding tally. For example, if the next trial results in a Value of "3", I will increment D2 from 14 to 15.
I would like to add a new row (3) that wold show the expected tally as computed by the trendline. And I would like that data to be dynamically and automatically updated when I update a value.
A | B | C | D | E | F | G | H | |
1 | N | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
2 | Actual Tally | 122 | 43 | 14 | 6 | 1 | 1 | 0.01 |
3 | Expected Tally | ?? | ?? | ?? | ?? | ?? | ?? | ?? |
<tbody>
</tbody>
Is there any way to do this that might be simple enough for me to understand?