Extracting data from Polynomial regression equation

dunlop407703

New Member
Joined
Oct 8, 2014
Messages
24
Hi all,

Apologies if this question seams disjointed but I am having trouble organising my thoughts. I've decided just to put what I can into words a hope someone can help.

I have a cumulative data set as follows. I have graphed this data and created a 3rd order polynomial regression equation to allow myself to accurately predict data.

6.35 x 0.15
DensityCum AshCum Yield
1.303.1820.32
1.354.8932.01
1.406.2137.58
1.457.4041.48
1.509.0245.70
1.6013.6255.80
1.7016.4862.29
1.8019.9369.47
2.0025.3679.77
2.2038.11100.00


<colgroup><col><col><col></colgroup><tbody>
</tbody>
From my regression equation I can predict the 'Cum Yield' (y) at an input 'Cum Ash' (x). What I would like to do is be able to calculate the new cumulative results after I remove a fraction from the data. For example if set 'Cum Ash' to 10%, the 'Cum Yield' is returned at 48.22%, based on that outcome I would then like to be able to say "given that I've removed the material up to a 10% cut off, how much of the remaining material do I need to get a sample at 30%".

Any input will be greatly appreciated.

Thanks
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Watch MrExcel Video

Forum statistics

Threads
1,099,521
Messages
5,469,143
Members
406,638
Latest member
Jack_Johnson

This Week's Hot Topics

Top