asked 196k views
5 votes
20 POINTS PLEASE HELP Write an equation for a trend line and predict the value when x is 15

X 0 3 6 9 12
Y 17.5 35.4 50.5 60.6 66.3

asked
User Fortega
by
8.7k points

1 Answer

3 votes
Attached is what you can do on excel.

Add the values as presented on the image. Select the values and then go t the menu "Insert" and look for "Charts" and then "Insert scatter chart". After this, select one of the dots from the graph and then press the right button of the mouse and select "add trendline". Now you have a trend line. Format the trendline selecting the option "Display Equation on chart" (and also if you want "Display R-squared value on chart"). Now you have the equation and you can easily predict the value when X is 15, you just need to substitute on the equation the X by the 15:
y = 4.0933Χ + 21.5 <=> y = 82.8995
20 POINTS PLEASE HELP Write an equation for a trend line and predict the value when-example-1

No related questions found

Welcome to Qamnty — a place to ask, share, and grow together. Join our community and get real answers from real people.