Linear-quadratic-and exponential trends to time series

Assignment Help Basic Statistics

Reference no: EM13136635

Make an Excel graph of the data on U.S. diesel new car sales. (b) Discuss the underlying causes that might explain the trend. (c) Use Excel, MegaStat, or MINITAB to fit three trends (linear, quadratic, and exponential) to the time series. (d) Which trend model do you think is best to make forecasts for the next 3 years? Why? (e) Use each of the three fitted trend equations to make numerical forecasts for 2004, 2005, and 2006. How much difference does the choice of model make? Which forecasts do you trust the most, and why? (f) If you have access to Ward's Automotive Yearbook, check your forecasts. How accurate were they?

U.S. Diesel New Car Sales, 1993-2003
Year Sales
1993 2,800
1994 3,577
1995 3,139
1996 8,469
1997 7,331
1998 10,972
1999 13,573
2000 22,634
2001 15,077
2002 31,430
2003 38,524

Reference no: EM13136635

Questions Cloud

Journal entry when recording the conversion : At June 30, 2009, the unamortized balance in the discount on bonds payable account was $4 million. On June 30, 2009, half the bonds were converted when Blair's common stock had a market price of $30 per share. What journal entry should Blair make ..

What is effect of a bargain purchase option on accounting : So what is the effect of a bargain purchase option on accounting for a capital-lease transaction by a lessee?

How much heat (in ) is required : How much heat (in ) is required to warm 12.0 of ice, initially at -12.0, to steam at 114.0? The heat capacity of ice is 2.09 and that of steam is 2.01 .

International standards on auditing : International Standards on Auditing (ISA) have been approved by the International Auditing and Assurance Board (IAASB). Recently, the IAASB has issued a number of proposed ISAs for comment

Linear-quadratic-and exponential trends to time series : Discuss the underlying causes that might explain the trend. (c) Use Excel, MegaStat, or MINITAB to fit three trends (linear, quadratic, and exponential) to the time series.

Determine effect on net income and earnings per share : It is estimated that the company will earn $800,000 before interest and taxes as a result of this purchase. The company has an estimated tax rate of 30% and has 90,000 shares of common stock outstanding prior to the new financing. Determine the ..

Determine the molar composition in percent of the mixture : a solution consisting of isobutyl bromide and isobutyl chloride is found to have a refractive index of 1.3931 at 20 degrees celsius. The refractive indices at 20 degrees celsius of isobutyl bromide and isobutyl chloride are 1.4368 and 1.3785

Empowered delegation for managers : Empowered delegation can produce all dimensions of empowerment, including a sense of competence, choice, impact, value, and security. Empowerment and delegation must be linked in the assignment of work.

Selling the old lathe and purchasing a new one : Ten years ago J-Bar Company purchased a lathe for $250,000. It was being depreciated on a straight-line basis to an estimated $25,000 salvage value over a 15 year period. The firm is considering selling the old lathe and purchasing a new one.

User Account

All Pages