Good day,
I would like to ask help in doing a pareto frontier. I have two data sets, one is the load and the other one is the cost. I would like to have a pareto frontier for maximum load and minimum cost. I have attached the data sets I have
Good day,
I would like to ask help in doing a pareto frontier. I have two data sets, one is the load and the other one is the cost. I would like to have a pareto frontier for maximum load and minimum cost. I have attached the data sets I have
Last edited by ErikaRivera; 04-10-2021 at 06:23 AM.
I'm not familiar with this kind of chart/analysis, so I'm not sure what to recommend. Most internet searches for Pareto analysis demonstrate a column + line chart type, but I'm not sure that is what you are asking for. I found this old thread https://www.excelforum.com/excel-cha...-frontier.html that shows a Pareto frontier chart as basically an XY scatter chart with two data series -- the main data series plus another series for the "frontier". If this latter is what you are trying to do, it looks like creating the chart should be easy -- create a scatter chart with two data series. You will first need to analyze the data (the chart cannot do it for you) to determine where to draw the frontier. Since you have not explained how you intend to perform that analysis (it isn't obvious to me just looking at the data).
Since you have not performed any analysis in your file, how much of your question is about creating the chart and how much is how to analyze the data?
Originally Posted by shg
FYI The OP has seen the old thread as they posted to it before being asked to open this new thread.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
@AliGW: I noticed that after I had posted.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks