Question

Q3) Given: X = 0 1 2 2.5 3 Y = 2 5.2 14.5 23.5 37.7...

Q3) Given: X = 0 1 2 2.5 3 Y = 2 5.2 14.5 23.5 37.7 Plot and determine the equation of the curve and corresponding R2 value that best represents the data using the trend line feature by checking all the curve options available in EXCEL. please explain thanks

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Step 1:

Create a new excel sheet and table down the X and Y value like below.

25557 2437 123 12345678

Step 2:

Select the portion of the points and then go to Insert tab and Select scattered chart .

Book1 -Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Shapes SmartArt Store PivotTable Recommended Table Pictur

Step 3:

Right click on the graph line and select Add tredline

Book1 - Excel CHART TOOLS FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEWVIEWDESIGN FORMAT Add Chart Quick Change Element LStep 4:

On the left side a panel will appear to add with tredline option. At the very botton is the optino to display R-squared value

Format Trendline TRENDLINE OPTIONS ▼ Logarithmic Polynomial Order Power Moving Average Period 2 Trendline Name Automatic Line

Step 5:

The chart will now display the graph along with R2 value

Chart Title 40 35 30 25 20 15 10 0 -5 10 215 3 3.5 1.5 0.5

Add a comment
Know the answer?
Add Answer to:
Q3) Given: X = 0 1 2 2.5 3 Y = 2 5.2 14.5 23.5 37.7...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT