Hi - hoping someone can help me, I'm really struggling!
I have some data which I have plotted into a graph and created a power trend line.
I want to have the data that creates the power trend line in a table.
I have found formulas - but I just don't seem to be smart enough to put them into practice. Can anyone help me?
This is my original data;
<colgroup><col width="46" style="width: 35pt; mso-width-source: userset; mso-width-alt: 1682;">
<col width="46" style="width: 35pt; mso-width-source: userset; mso-width-alt: 1682;">
<tbody>
</tbody>
This is my graph with power trend line.
-- removed inline image ---
This is the table that I want to complete with the trend line data (up to 50,000)
<colgroup><col width="64" style="width: 48pt;" span="2">
<tbody>
</tbody>
This is the equation that I found;
<colgroup><col width="46" style="width: 35pt;" span="2">
<col width="82" style="width: 62pt; mso-width-source: userset; mso-width-alt: 2998;">
<col width="46" style="width: 35pt;" span="3">
<tbody>
</tbody>
Can anyone help me put this into practice?
I have some data which I have plotted into a graph and created a power trend line.
I want to have the data that creates the power trend line in a table.
I have found formulas - but I just don't seem to be smart enough to put them into practice. Can anyone help me?
This is my original data;
DATA | |
Quantity | Price |
100 | 70.07 |
200 | 101.33 |
300 | 215.6 |
400 | 280.19 |
500 | 283.51 |
500 | 62.52 |
1000 | 457.65 |
1000 | 457.65 |
1000 | 381.83 |
1000 | 295.37 |
1000 | 280.19 |
1500 | 338.49 |
1500 | 338.49 |
2000 | 458.15 |
2000 | 352.9 |
2000 | 332.02 |
2000 | 330.03 |
2550 | 267.34 |
3000 | 717.61 |
3000 | 555.17 |
3000 | 467.85 |
4000 | 1020.9 |
4000 | 773.65 |
4900 | 562.16 |
6000 | 365.44 |
8000 | 512.05 |
50000 | 1293.6 |
This is my graph with power trend line.
-- removed inline image ---
This is the table that I want to complete with the trend line data (up to 50,000)
Quantity | Price |
100 | |
101 | |
102 | |
103 | |
104 | |
105 | |
106 | |
107 | |
108 | |
109 | |
110 | |
111 | |
112 | |
113 | |
114 | |
115 | |
116 | |
117 | |
118 | |
119 | |
120 | |
121 | |
122 | |
123 | |
124 | |
125 | |
126 | |
127 |
This is the equation that I found;
Equation: y=c*x^b | |||
c: =EXP(INDEX(LINEST(LN,LN(x),,),1,2)) | |||
b: =INDEX(LINEST(LN,LN(x),,),1) |
Can anyone help me put this into practice?