HW 1: Approximation of discrete values by continuous diferenciable function (MS Excel)

HW 1: Approximation of discrete values by continuous diferenciable function (MS Excel)

In this homework, we set up the datas about virtual company's supply.
The Price is the independent variable and the Quality is the dependent variable.

P	1	2	3	4	5	6	7	8	9	10
Q	8	10	14	16	18	22	24	26	25	23

Like the first graph, it's based on the datas from the P and Q. However, in the economic graph, the independent variable P is in Y axis, and the dependent variable Q is in X axis.

The first graph is use the trend line to describe the trend of the Q, but here we use the binominal expression.

So, it's easy to find out that after the Q=6. the price start to decreasing.

Second graph has the same data with first graph, the only different is that they has different trend line. The second trend line is the linear expression. In the linear expression, it's hard to find out the real trend of P.