XY Scatter
 

Another question for my stats assignment. Could use some help. Our project
is to determine if two variables are correlated. We wanted to show that
there is a correlation between public transportation ridership and median
household income.

We have twenty suburban cities selected and ridership and income data for
those cities. The professor suggested that we use a scatter plot but it
looks really funny. I was expecting to see a double axis with the name of
the city in the label on the X axis (that one runs along the bottom right?)
but I didn't. I just have three columns as seen in the example below. I used
the canned XY scatter chart. Is there another/better way to show the
correlation?

City Ridership Income
Cicero, IL 1726 $36,247

XY Scatter
 

I get the impression that you are misunderstanding exactly what an XY
plot is. An XY plot uses a numerical axis for both the X and Y axis,
meaning that you won't see city names as the labels for the X axis.
You are looking for a number on the X axis.

An XY plot is used to show a relationsip between 2 numbers. Remeber
back in algebra when you would plot y=x^2 on a graph? Those were XY
plots.

Does that make sense?


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=566498

XY Scatter
 

I guess I did misunderstand. Partly because my data looks so screwy. One
column lists salaries ranging from $24,000 to $200,000. These are on the Y
axis and are plotted correctly. The X axes should then show the ridership
percentage ranging from 0.09% to 64.73%. But the points are all on the zero
X axis and spaces evenly from 0-25. I don't understand how it is showing the
precentages? I thought maybe the scale was off but when I change the scale
to match the percentage all of the points get bunched up near zero. What is
it plotting?

"MrShorty" wrote:


I get the impression that you are misunderstanding exactly what an XY
plot is. An XY plot uses a numerical axis for both the X and Y axis,
meaning that you won't see city names as the labels for the X axis.
You are looking for a number on the X axis.

An XY plot is used to show a relationsip between 2 numbers. Remeber
back in algebra when you would plot y=x^2 on a graph? Those were XY
plots.

Does that make sense?


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=566498

XY Scatter
 

I don't know what it's using either. If Excel can't figure out by
itself what you intend for the X-values, and you don't manually
specify, then it will assume the series of integers {1,2,3,...}. Right
click on your chart-select "source data"-select the "series" tab at
the top, and see what it's using for the x data for the data series.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=566498

XY Scatter
 

I don't know what it's using either. If Excel can't figure out by
itself what you intend for the X-values, and you don't manually
specify, then it will assume the series of integers {1,2,3,...}. Right
click on your chart-select "source data"-select the "series" tab at
the top, and see what it's using for the x data for the data series.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=566498