How To Make a X Y Scatter Chart in Excel With Slope, Y Intercept & R Value

This video tutorial explains how to make a X Y Scatter Chart in excel and how to use to calculate the slope of the straight line equation as well as the y intercept and correlation coefficient or R value. It explains how to do this using the trendline feature of the excel graph and the slope function and intercept function in excel.
Excel Tutorial For Beginners:
• Excel Tutorial For Beg...
Top 30 Excel Tips & Shortcuts:
• Top 30 Excel 2016 Tips...
_________________________________________
Excel - Statistics - Mean, Median, Mode:
• Statistics - Excel
Excel Scatter Charts:
• How To Make a X Y Scat...
Excel - Finding Slope & Y-Intercept:
• Excel Basics - Linear ...
Solving Polynomial Equations - Goal Seek:
• Solving Polynomial Equ...
__________________________________________
How To Calculate Loan Payments In Excel:
• How To Calculate Loan ...
How To Create an Amortization Table:
• How To Create an Amort...
How To Look Up Customer Data In Excel:
• VLookUp - How To Extra...
How To Create a Data Entry Form In Excel:
• How To Create a Data E...
_________________________________________
KZbin Channel Growth Accelerator:
/ youtubechannelgrowthac...
Algebra For Beginners:
www.video-tutor.net/algebra-f...
Final Exams and Video Playlists:
www.video-tutor.net/
Full-Length Math & Science Videos:
/ collections

[@TheOrganicChemistryTutor]

Final Exams and Video Playlists: www.video-tutor.net/

[@mariaorsic9763]

I have listened to many of your tutorials. You have a RARE gift.

[@rajnajat]

Thanks for putting things so simply. Nobody has explained the R value so precisely and simply. Keep up the good work !

[@adzhaguri]

You are every where. Thank you for being very helpful and useful for us students. God bless you

[@jamestrujillo5195]

You pretty much covered everything quickly. Thank you👍

[@77icky]

Yo bruh you just literally save my class. Big ups on your channel.

[@abdalrahmanarrob6802]

I LOVE YOU, your videos always save me, Thank you so much for all the great videos

[@madeleinealinyoh6473]

i just want to say u saved my life .. i was literally panicking on how to make a graph like this for my chem class little did i know the power of youtube.. thank u my friend

[@akimanagodiolla1071]

Your videos are always helpful. Thank you so much

[@shazeb1995]

wow! here is the solution, thank you Sir, such a wonderful explanation .

[@maheeshkumarthapa3016]

appreciative, Effective teaching methodology having different parameters calculations.

[@jebthompson1400]

You just made my math assignment so easy!

[@gautamhathiwala7267]

Thank you so much sir for the wonderful guidance in using excel.

[@joshuastephenkingsly]

This was very helpful! Thank you!

[@user-cs1gh4pu9v]

GOLD, this is GOLD!

[@jaderiley3496]

Thank you so much this helped me with my Biology Assignment!!

[@stumbling_]

You are easily the best resource a student of any level could possibly have!

[@Scriabinfan593]

i freaking hate lab reports i should've known that you could choose any major if you wanted to go to med school. I should've majored in math lol.

[@chrizsKo-mn2gl]

This, your channel has helped me a lot.. thank you so so much 🙌🏿🔥

[@varunbendre]

THANK YOU SO MUCH FOR THIS

[@quick_bits]

Thank you so much, this video helped for my university project

[@bemoisns7589]

this was helpful thank you very much!!

[@lenizhao8990]

thank you so much. It is very helpful

[@amansinghal7597]

Thanks guy you help me a lot by knowledge full video

[@alyssatorres5897]

Omg thank you so much!!! You saved my life!!!!! Lol 😆

[@tayoolagbiyan2992]

Thank you so very much. I can shout Eureka!!!

[@mohannadalhuwaish3242]

HUGE FAN!!!!!

[@FeraleHubbard]

YOU, ARE, AWESOME

[@a.f6517]

Appreciate it man ❤

[@georg3267]

thank you so much

[@awesomemangoes8072]

you are a hero

[@amerqutaish2192]

Thanks dude

[@o_xtanjax_o767]

Anyone know how to change the R^2 value to another value so I can determine what the scatter plot would look like?

[@rojinabed2631]

thank you :)

[@qlays3332]

i love you! tqsm

[@funZ00]

Thanks...

[@kilopo3030]

Wondering if it works if the X value is a negative.

[@KrishnaKumar-ts1hf]

good video

[@falconeye577]

Is it possibel to include a veribale within the SLOPE and INTERCEPT formula Something like this =Slope(A1:A(1+G1),B1:B(1+G1)) In G1 you would put the number of rows you have data in Thus, if you put 17 in G1 the formula would read as follows =Slope(A1:A(1+17),B1:B(1+17)) or =Slope(A1:A18,B1:B18) This would remove the need to click on the box and drag the two range boxes down for the Slope and Intercept

[@michaelurner3601]

What if I have more than one y value on an x value? If I did an experiment in triplicate so I have 3 y values at a single x value.

[@aslhanaslhan1092]

Hello I did linear regression, but my teacher did not accept it because the number of steps in the formula was low. How can I increase it?

[@lanreadeleye9657]

how can i change my x values to months, like january, february and more

[@gigglesMcdougal]

chart elements does not pop up for me help

[@kristenreneecastillo7995]

My chart doesn't show a plus sign to click, how else can I do this?

[@vickyt1233]

same

[@Dagasm]

Yup same here. I'm using this online Excel the school provides students, which seems to be missing some nice features that tutorials implement. And my lab gets instructions on how to make graphs using a different version of Excel...

[@divyavashisth8484]

Please suggest why my m=0 in every scatter I'm plotting

[@feedypvepvp3936]

#Name? error

[@onyiboemmanuel6060]

If you are not the best, then BEST has never been used correctly.

[@isisastudillo2849]

1 #tutor

[@jasonsiow4560]

Bob ross excel edition.

[@owenntuka5314]

I have 2 lines on the ahh chart ,wtf , i need a line with only (x,y) not 2 lines f lines, whats wrong with excel😡😡 Mine is not working ....

[@adamjankulovski9189]

Any fellow UofW students

[@Xylem1342]

god like dont knwo hw his brain functions

[@AbdulSalam-ij1my]

Bkwaas

[@mairarubab7100]

hahaha