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:

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?

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:
Amrit Lal Ahuja, PhD (IP)
Education
  • 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.

View More Free Quizzes
Related BrainMass Solutions

  • Types of Forecasting and Statistical Quality Control

    Statistical time-series forecasting - These models focus on projections in trends, cyclicality and seasonality based on historical data compiled over the course of many years or instances.

  • Moving Average Approach and Exponential Smoothing approach

    Statsoft, Electronic Statistic Textbook (undated). Time Series Analysis. Accessed on 9/18/2011 from http://www.statsoft.com/textbook/time-series-analysis/#simple. Victoriano, Praxedes S. (1990).

  • Economics and management

    dividing the R2 by the F-Statistic 13. The forecasting technique, which predicts technological trends and is carried out by a sequential series of written questions and answers is A. the Delphi method B.

  • Statistical Terms in Managerial Finance

    Among other things, serial correlation (and trends) can severely reduce the effective number of degrees of freedom in a time series (see formula at (5) reference below) FINAL COMMENTS I HOPE THIS HELPS AND TAKE CARE.

  • A problem on Regression analysis

    For each graph, provide a trend line, fixed cost, variable cost, and R-square statistic. 3. (6 pts.) Nine time series lines 4. (3 pts.) Summary table 5. (3 pts.)

  • Define regression, time series plot, calculators to use

    Trend, The upward and downward movements in a time series Cyclical , trends upward or downward over time series, but longer term of more than a year Seasonal, trends upward or downward in short time frame; a fluctuation that occurs during a year, year

  • T-test for slope in the regression analysis

    It would also be helpful if you could obtain the series of residuals, and show step by step how to obtain the standard error and the R-squared statistic for the regression, as well as the standard errors of the estimators of B1 and B0.

  • Time-Series line chart

    If a fitted trend is called for, use Excel's option to display the equation and R2 statistic. Include printed copies of all relevant graphs with answers See attached Please see the attached file.

  • Time Series

    Time series decomposition deconstructs a time series into different components one of which is a seasonal component. Winters' method takes exponential smoothing and adds in trends and seasonality factors.

View More Related Solutions