XY Scatter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
I get the impression that you are misunderstanding exactly what an X
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. Remebe
back in algebra when you would plot y=x^2 on a graph? Those were X
plots.

Does that make sense
 
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?
 
I don't know what it's using either. If Excel can't figure out b
itself what you intend for the X-values, and you don't manuall
specify, then it will assume the series of integers {1,2,3,...}. Righ
click on your chart->select "source data"->select the "series" tab a
the top, and see what it's using for the x data for the data series
 
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.
 
Back
Top