20 POINTS PLEASE HELP Write an equation for a trend line and predict the value when x is 15
1 answer:
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<span>
</span>
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<span>
</span>
You might be interested in
Hey there! :)
Answer:
y = 5x + 10
Step-by-step explanation:
From the information given, we can derive the points (-2, 0) and (0, 10). Find the slope using the slope formula:
Plug in the points:
Simplify:
m = 5.
The equation in slope-intercept form is y = mx + b. We were already given the b value, or y-intercept as y = 10. Therefore:
y = 5x + 10 is the equation written in slope-intercept form.