For the sale of production units, I have a excel table with two type of entries:
Number of units sold in a year (axis X) and unit price (axis Y).
When the number of units sold increase, the unit price decrease (see table and graph).
I did a scatter chart (smooth marked scatter) and added a trendline over the chart . I selected different types of trendlines (LOG, polymonial or power types) and displayed the equation on the chart for each type.
My goal is to compute thanks to the provided equation, the unit price for 15 units sold in a year.
I did the computation for 3 different choices of trendline types with the equation formula provided in option for each type, but the result are not correct at all.
The result should be in the range of 1,170,000 as can be seen on the graph. The results calculated with the equation formulas are far from correct
What could be the reason? Thank you!
Bookmarks