Purchase Solution

Statistic Trends/Series

Not what you're looking for?

Ask Custom Question

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?

Purchase this Solution

Solution Summary

The significant strides in math and science by women of all ethnic backgrounds are analyzed. The solution answers the question(s) below

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 provided by:
  • BEng, Allahabad University, India
  • MSc , Pune University, India
  • PhD (IP), Pune University, India
Recent Feedback
  • " In question 2, you incorrectly add in the $3.00 dividend that was just paid to determine the value of the stock price using the dividend discount model. In question 4 response, it should have also been recognized that dividend discount models are not useful if any of the parameters used in the model are inaccurate. "
  • "feedback: fail to recognize the operating cash flow will not begin until the end of year 3."
  • "Answer was correct"
  • "Great thanks"
  • "Perfect solution..thank you"
Purchase this Solution

Free BrainMass Quizzes
Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.