Share
Explore BrainMass

Statistic Trends/Series

Please see below:

Citing significant strides in math and science by women of all ethnic backgrounds, the College Broad says that the male-female gap on Scholastic Assessment Test scores continue to narrow among high school students. The average SAT scores for men and women from 1990 to 1994 are shown below:

Verbal
Men
1990 429
1991 426
1992 428
1993 428
1994 425

Verbal
Women
1990 419
1991 418
1992 419
1993 420
1994 421

Math
Men
1990 499
1991 497
1992 499
1993 502
1994 501

Math
Women
1990 455
1991 453
1992 456
1993 457
1994 460

Please show me how to display in excel each of the four time series on the same axis.

Also, do you see any patterns if yes can you please explain what?

Solution Preview

Please see attached excel file.
All the data are there as well as time series plot is also there.
The method is quite simple, just go to chart and select line and rest of the steps need not required to do any ...

Solution Summary

The solution answers the question(s) below

$2.19