Problem

(a) In Excel, convert each time-series variable into index numbers (1990 = 100). (b) What...

(a) In Excel, convert each time-series variable into index numbers (1990 = 100). (b) What is the 2004 index value for each time series? What does this tell you? (c) Plot all four series of index numbers on the same graph. Describe what you sec. (d) What is the advantage of using index numbers in plotting and comparing these data over time?  Prisons

U.S. Adults on Probation, in Jail or Prison, or on Parole, 1990-2004 (thousands)

Year

Probation

Jail

Prison

Parole

1990

2,670

403

743

531

1991

2,728

424

793

590

1992

2,812

442

851

659

1993

2,903

456

909

676

1994

2,981

480

990

690

1995

3,078

507

1,079

679

1996

3,165

510

1,128

680

1997

3,297

558

1,177

695

1998

3,670

584

1,224

696

1999

3,780

596

1,287

714

2000

3,826

621

1,316

724

2001

3,932

631

1,330

732

2002

4,024

665

1,368

751

2003

4,145

691

1,393

745

2004

4,151

714

1,422

765

Source: Statistical Abstract of the United Stairs. 2007. p. 209.

Step-by-Step Solution

Request Professional Solution

Request Solution!

We need at least 10 more requests to produce the solution.

0 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)


All students who have requested the solution will be notified once they are available.
Add your Solution
Textbook Solutions and Answers Search