# 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?

Â© BrainMass Inc. brainmass.com March 4, 2021, 5:44 pm ad1c9bdddfhttps://brainmass.com/statistics/time-series-analysis/statistic-trends-series-8789

#### 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 significant strides in math and science by women of all ethnic backgrounds are analyzed. The solution answers the question(s) below