1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Orlov [11]
3 years ago
8

Consider the data in the Excel file Consumer Price Index. Use simple linear regression to forecast the data. What would be the f

orecasts 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 ?

Business
1 answer:
Digiron [165]3 years ago
3 0

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

You might be interested in
Pump prices slide as crude oil falls to​ six-year low The average price for regular gasoline at U.S. pumps fell almost 4 cents i
max2010maxim [7]

Answer:

lower the cost of producing gasoline and increase the supply of gasoline 

Explanation:

Crude oil is an input needed in the production of gasoline. If the price of crude oil falls, it would become cheaper to make gasoline and therefore the supply of gasoline would increase.

5 0
3 years ago
Demand per hour for gasoline at a local station is normally distributed with a mean of 875 gallons and std deviation of 55 gallo
marusya05 [52]

The probability that demand is greater than 1800 gallons over a 2 hour period is : 0.5

<u>Given data :</u>

Mean value of gasoline per hour = 875 gallons

Standard deviation = 55 gallons

<h3>Determine the probability of demand being greater than 1800 gallons over 2 hours </h3>

Demand for gas in 1 hour = X₁

Demand for gas in 2 hours = X₁ + X₂

Therefore ; ( X₁ + X₂) ~ N ( u₁+u₂, sd₁² + sd₂² )

In order to  calculate probabilities for normals apply the equation below

Z = ( X- u ) / sd

where : u = 1800, sd = √ ( 55² + 55² ) = 77.78

using the z-table

P( Y > 1800) = P( Z > ( 1800 - 1800 ) / 77.78)

                    = P( Z>0 ) = 0.5

Hence we can conclude that The probability that demand is greater than 1800 gallons over a 2 hour period is : 0.5.

Learn more about probability : brainly.com/question/24756209

#SPJ1

5 0
2 years ago
Is the general rise in prices throughout an economy.
Salsk061 [2.6K]

Answer:yes

Explanation:

4 0
3 years ago
Read 2 more answers
Evaluate Microsoft’s product and marketing evolution over the years. What has the company done well, and where did it falter?
OverLord2011 [107]

Explanation:

Microsoft is a giant technology company with worldwide influence.

Its success and reputation have ensured the company the position of the most valuable company in the world by market capital.

The popularization of the Windows Operating System, worldwide, was the product that consolidated the company as a giant in the business world. Technological companies, should focus on innovation, as each day more advances in technology appear to correct possible system errors, make the user's performance and use better and make production costs cheaper. With regard to the Operating System for computers, Microsoft has always evolved in launching new, more evolved versions, and making the previous ones obsolete for use, but one of the company's failures was to have lost the timing to develop an OS aimed at the use in cell phones, since that the company tried to enter this market, but was unsuccessful, and was defeated by its biggest competitors: Google and Apple.

8 0
4 years ago
Suppose the demand function for good X is given by:
fiasKO [112]

Answer:

Explanation:

Q(8) =15 - 0.5 x 10 - 0.8 x 8 = 15-5-6.4=3.6

Q(10) =15 - 0.5 x 10 - 0.8 x 10 =15-5-8= 2

Cross Elasticity = -0.2 / 0.8 = -0.4

7 0
3 years ago
Other questions:
  • Instead of offering the same benefit package to every employee, cassandra's company allows her to choose whether she wants day c
    6·1 answer
  • Entries for notes payable Bull City Industries is considering issuing a $100,000, 7% note to a creditor on account. Assume a 360
    11·1 answer
  • What is the difference between Special warranty deed vs general warranty deed
    15·1 answer
  • The following logo is present on the letterhead of an organization. Which category of communication does this involve?
    9·2 answers
  • Misbah Corporation manufactures two styles of lampslong dasha Bedford Lamp and a Lowell Lamp. The following per unit data are​ a
    13·1 answer
  • A sector fund specializing in commercial bank stocks had average daily assets of $3.7 billion during the year. This fund sold $1
    7·1 answer
  • Essence of Skunk Fragrances Calculate the average collection period. (Do not round intermediate calculations and round your answ
    13·1 answer
  • Economists Kenneth Chay and Michael Greenstone found that in the two years following the passage of the Clean Air Act of 1970, t
    7·1 answer
  • Every line manager is a HR Manager-explain?
    13·1 answer
  • Early access to medical care, from ems through reperfusion, improves overall outcomes by:________
    7·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!