Explore BrainMass

Explore BrainMass

    Statistic Trends/Series

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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:

    1990 429
    1991 426
    1992 428
    1993 428
    1994 425

    1990 419
    1991 418
    1992 419
    1993 420
    1994 421

    1990 499
    1991 497
    1992 499
    1993 502
    1994 501

    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 December 24, 2021, 4:48 pm ad1c9bdddf

    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