d***s 发帖数: 337 | 1 统计学高手救命
有大概200多条销售数据.分两大类:end user和distributor
要用excel表示这两类数据价钱的 “trend"并且显示在一张chart(XY scatter)图上
还要分颜色..怎么办啊~~~
或者介绍下我用小型的统计软件怎么可以做到吧~
//bow~ | C****e 发帖数: 107 | 2 Is it time series?
any way, if you want to plot two lines together in the same plot
in EXCEL, select "Insert" then "Chart", and under "Chart type",
select "line" (the third choice in my EXCEL.
Hope that helps.
【在 d***s 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 统计学高手救命 : 有大概200多条销售数据.分两大类:end user和distributor : 要用excel表示这两类数据价钱的 “trend"并且显示在一张chart(XY scatter)图上 : 还要分颜色..怎么办啊~~~ : 或者介绍下我用小型的统计软件怎么可以做到吧~ : //bow~
| d***s 发帖数: 337 | 3 I have 2 XY scatter plot, share same XY scales...
with a trendline (Linear)
would like to combine these 2 charts together..
so I can see the difference trend ar.. | C****e 发帖数: 107 | 4 Oh, is the following is what you want?
you have one X, two Y, say Y1, Y2,
you want to plot Y1 vs. X, and Y2 vs. X in one chart.
If that's what you want, you can try this in EXCEL:
Highlight the X, Y1 and Y2 from the data,
in "Chart", select "XY scatter", pick one type that you want,
(e.g., "scatter with data points connected by smoothed lines"
to see the trend), and you will have Y1 vs. X, and Y2 vs. X in one chart.
【在 d***s 的大作中提到】![](/moin_static193/solenoid/img/up.png) : I have 2 XY scatter plot, share same XY scales... : with a trendline (Linear) : would like to combine these 2 charts together.. : so I can see the difference trend ar..
| a***k 发帖数: 1255 | 5 这个和统计有什么关系啊?就用EXCEL作图就得啦,很简单的.
【在 d***s 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 统计学高手救命 : 有大概200多条销售数据.分两大类:end user和distributor : 要用excel表示这两类数据价钱的 “trend"并且显示在一张chart(XY scatter)图上 : 还要分颜色..怎么办啊~~~ : 或者介绍下我用小型的统计软件怎么可以做到吧~ : //bow~
| C****e 发帖数: 107 | 6 yeh, this is actually not a stat question. :)
It's much easier and flexible to do it in a stat software though,
such as in SPLUS.
【在 a***k 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 这个和统计有什么关系啊?就用EXCEL作图就得啦,很简单的.
| z****n 发帖数: 712 | 7 如果真这么简单应该不会上来问吧。
我的理解是她有两组数据,要画出来两组数据的同时还要画trend line在一幅图里面。
Excel作图里面可以画trend line,但是两组的trend line可能不容易画出来,可以用
data analysis tool 或者 stats tool先处理出trend line的data,再重新画出来。
【在 C****e 的大作中提到】![](/moin_static193/solenoid/img/up.png) : yeh, this is actually not a stat question. :) : It's much easier and flexible to do it in a stat software though, : such as in SPLUS.
| d***s 发帖数: 337 | 8 aiya..I have 2 variables x and y, 一共100个数
I want to have the trend of x1~x20 with y1~y20
and the trend of x21~x100和y21 y100
点做啊。excel..
晤改晒。。
【在 C****e 的大作中提到】![](/moin_static193/solenoid/img/up.png) : yeh, this is actually not a stat question. :) : It's much easier and flexible to do it in a stat software though, : such as in SPLUS.
| d***s 发帖数: 337 | 9 多谢甘多位教我~~
听日翻去仔细研究下先。。
【在 d***s 的大作中提到】![](/moin_static193/solenoid/img/up.png) : aiya..I have 2 variables x and y, 一共100个数 : I want to have the trend of x1~x20 with y1~y20 : and the trend of x21~x100和y21 y100 : 点做啊。excel.. : 晤改晒。。
| C****e 发帖数: 107 | 10 Sorry... Just saw your post.
Here is sth to try, not sure if it's excatly what you want though.
1. Keep X1-X100 in one column, say column 1
2. Put Y1-Y20 in column 2, leave the remaining of the column empty
3. Put Y21-Y100 in column 3, leave the the first 20 cells of column 3 empty
e.g.
x1 y1
x2 y2
x3 y3
...
x20 y20
x21 y21
...
x100 y100
4. Highlight columns 1-3, in "Chart", select "XY scatter", pick one type
that you want, (e.g., "scatter with data points c
【在 d***s 的大作中提到】![](/moin_static193/solenoid/img/up.png) : aiya..I have 2 variables x and y, 一共100个数 : I want to have the trend of x1~x20 with y1~y20 : and the trend of x21~x100和y21 y100 : 点做啊。excel.. : 晤改晒。。
|
|