https://d2vlcm61l7u1fs.cloudfront.net/media%2F61c%2F61c9f4e1-a7fe-466e-87e4-a7b5873b69b4%2FphpHY77Q3.png
Formula:
Slope of trend line, G25 =SLOPE(E33:E56,D33:D56)
Intercept of trend line, G26 =INTERCEPT(E33:E56,D33:D56)
F33 =$G$26+D33*$G$25 copy to F33:F60
G33 =E33/F33 copy to G33:G56
H33 =AVERAGE(G33,G37,G41,G45,G49,G53) copy to H33:H36
H37 =H33 copy to H33:H60
I33 =H33*F33 copy to I33:I60
J33 =E33-I33 copy to J33:J56
K33 =ABS(J33) copy to K33:K56
“Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!”
What Students Are Saying About Us
.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐"Honestly, I was afraid to send my paper to you, but splendidwritings.com proved they are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 14***| Rating: ⭐⭐⭐⭐⭐
"The company has some nice prices and good content. I ordered a term paper here and got a very good one. I'll keep ordering from this website."