doggo2683 doggo2683

30-04-2020
Business

contestada

Consider the data in the Excel file Consumer Price Index. Use simple linear regression to forecast the data. What would be the forecasts for the next two months? (Your regression equation should be look like CPI = a + b T. The T is year and 1990=1; 1991=2; 1992=3; 1993=4; 1994=5; 1995=6; 1996=7; 1997=8; 1998=9; 1999=10) Year CPI 1990 169.3 1991 170.0 1992 172.4 1993 175.3 1994 177.2 1995 176.8 1996 179.1 1997 180.1 1998 ? 1999 ?

Respuesta :

temmydbrain temmydbrain

07-05-2020

Answer:

CPI(1998) = 182.32

CPI(1999) = 183.94

Explanation:

1.

Using excel regression analysis, the regression results are below:

This gives regression equation as: CPI = 167.73 + 1.62T

Kindly check the attached image below for the step by step explanation.

In order to find CPI values for 1998 and 1999, substitute value of T = 9 and 10 respectively

This gives:

CPI(1998) = 182.32

CPI(1999) = 183.94

Ver imagen temmydbrain

Answer Link

Otras preguntas

Use the passage from Jacob Riis's "How the Other Half Lives" to answer the question. "Let him take into a tenement block a handful of flowers from the fields an

Which of the following theories argues that organized crime and normal business are similar activities on different ends of a spectrum of legitimacy?

Susan Marciano invested part of her 10,000 bonus in a fund that paid 10% profit and invested the rest in stocks that suffers a 3%loss find the amount of each in

What is the volume of a small cone if: Two cones are similar. The lateral area of the small cone is equal to 60pi cm squared. The radius and the slant height of

Write the equation of the mirror line for the segment with endpoints (5, 4) and (-1, -1). Find the reflection of point A(3, -2) through the mirror line of y = 1

Colonies were mostly run for the benefit of mother countries, but some people believed the colonial system helped everyone because it spread European civilizati

Although the Supreme Court decision in Regents of the University of California v. Bakke (1978) forbade the use of quotas as a basis for college admission, it co

The numbers should be added to the merged array in an alternating pattern: first from list 1, then from list 2, then list 1 again, etc. If a number in one of th

Computer companies buying hardware components from component-makers, assembling them in their own facilities, and selling completed systems to consumers and bus

Suppose Thelma and Louise both sell tomatoes in a perfectly competitive market. If Louise increases the amount of tomatoes that she sells in the market, _____.