trenline fomular help

Joined
May 15, 2011
Messages
1
Reaction score
0
When I created the polinomial trend line in Excel, what does x2 means?'
y = -3E-05x2 + 0.0024x - 0.0038
R² = 0.9949

I have an exsiting curve below, measure month 1-43
how do I raised the whole curve higher?
Months 12345678910111213141516171819202122232425262728293031323334353637383940414243
Mean 0.06%0.09%0.12%0.17%0.23%0.29%0.35%0.43%0.50%0.57%0.65%0.72%0.79%0.86%0.92%0.98%1.03%1.08%1.13%1.17%1.21%1.24%1.27%1.30%1.32%1.34%1.36%1.38%1.39%1.40%1.41%1.42%1.43%1.44%1.45%1.45%1.46%1.46%1.47%1.47%1.47%1.48%1.48%
UCL 0.49%0.52%0.56%0.60%0.66%0.72%0.79%0.86%0.93%1.01%1.08%1.15%1.22%1.29%1.35%1.41%1.47%1.52%1.56%1.60%1.64%1.67%1.70%1.73%1.75%1.77%1.79%1.81%1.82%1.84%1.85%1.86%1.86%1.87%1.88%1.88%1.89%1.89%1.90%1.90%1.90%1.91%1.91%
LCL -0.38%-0.35%-0.31%-0.26%-0.21%-0.15%-0.08%-0.01%0.07%0.14%0.22%0.29%0.36%0.43%0.49%0.55%0.60%0.65%0.70%0.74%0.77%0.81%0.84%0.86%0.89%0.91%0.93%0.94%0.96%0.97%0.98%0.99%1.00%1.01%1.01%1.02%1.03%1.03%1.03%1.04%1.04%1.04%1.05%

anyone, help
 
Last edited:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top