Excel 2010 Statistics #23: Scatter Diagram to show Relationship Between Two Quantitative Variables
HTML-код
- Опубликовано: 30 июн 2011
- Download Excel File: people.highline.edu/mgirvin/A...
1. See how to create a Scatter Diagram to show Relationship Between Two Quantitative Variables
2. Direct or Positive Relationship
3. Indirect or Inverse or Negative Relationship
4. No Relationship
5. Trendline
6. Link Chart Labels to Cells with Formulas
7. Custom Number Format to show values in Millions
This is for the Highline Community College Busn 210 Statistical Analysis for Business and Economics taught by Michael Girvin
God bless you!! You are my life saver. Thank you so much.
I am seriously addicted to these videos!
@pineappleryan96 , I am glad that it helped!
thanks man, you helped me out a lot with a school project good work!!
Thanks man, great work. I got what I was looking for.
Another great video - thank you.
If you were to ever record Macros, it would make a difference, otherwise it is the same. Ctrl + * selects "Current Range" (Table), Ctrl + A selects all.
Great work. Thanks! However, i still have a problem. I am writing my dissertation now on the so called oil curse. I need to do a scatter, showing the relationship between oil rents as % of GDP and GDP per capita annual % growth in 9 oil producing countries. I did the scatter for each country, but what i really need is, all of these 9 countries to be in one scatter plot, i.e the scatter dots to represent a country, rater that the variables. So, when i do the trend line, some countries will be above the line and some will be below it, showing negative growth. How I can do that???? I'm desperate! Thank you!
hi
i just wanna know onething ,if interchanging Cause ( X-axis) and Effect (Y-axis) will it make any difference to the conclusion? i am asking this as which one to chose as X-axis value and which one to chose as Y- axis value while comparing two data?
Nice video - btw, what is the name of the book that you keep referring to in your videos ? Can you please share the details with us ?
Why use 'CTRL + *' vs 'CTRL + A' to select a range?
hey, how to do when i was right click but it isn't trendline show
does excel only use one color to display the data for two quantitative variables?
You can right-click the markers and point to Format and change it.
ExcelIsFun
Hi thanks for replying..no I mean does it create two separate scatter plots for each variable? It looks like it's showing just one pattern for one set of data (inches only) is that how it is?. I want to compare height vs wingspan but it creates just one (The default color is fine). I'm thinking it just does one pattern...we were given instructions from 2007 and 2010 might be very different.
is it possible Scatter Diagram to show Relationship for trend line Between 3 Quantitative Variables
give me a replay please
did you figure it out