Question

In: Statistics and Probability

Number of U.S. New Car Dealerships, 2003–2009 Year Dealerships 2003 21,725 2004 21,650 2005 21,640 2006...

Number of U.S. New Car Dealerships, 2003–2009
Year	Dealerships
2003	21,725
2004	21,650
2005	21,640
2006	21,495
2007	20,770
2008	20,010
2009	18,460

(a)

Use Excel, MegaStat, or MINITAB to fit three trends (linear, quadratic, exponential) to the time series. (A negative value should be indicated by a minus sign. Do not round the intermediate calculations.Round your final answers to 4 decimal places.)

FILL IN "_____" IN LINEAR AND QUADRATIC


Linear	y_t = -498.035t + ____
Quadratic	y_t = -146.25t² + 671.96t + _____
Exponential	y_t = 22934e ^-.025t

(b-1)

Use each of the three fitted trend equations to make numerical forecasts for the next 3 years. (Do not round the intermediate calculations.Round your final answers to 1 decimal place.)

FILL IN EXPONENTIAL

t	Linear	Quadratic	Exponential
8	18829.3	17074.3
9	18331.3	15260.0
10	17833.2	13153.2

Expert Solution

Lets do it in excel ,

so the regression equation for linear is Y = 22813.57 - 498.035*Time

simillarly we fit the equation for quadratic and exponential as

the equation is Y = exp(-2.976) + 21558.55

Alright Dude, If that worked for you... don't forget to give THUMBS UP.(that will work for me!)

orchestra answered 3 years ago

Year 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 Dividend $ 7.46 $ 7.91...

Year 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 Dividend $ 7.46 $ 7.91 $ 8.38 $ 8.80 $ 9.24 $ 9.70 $ 10.28 $ 10.79 $ 11.33 $ 12.01 Find both the arithmetic growth rate and the geometric growth rate of the dividends for Davy's Crock Pot Stores. Assuming the January 1, 2011 price of the stock is $110.00, determine the current required rate of return for the company (use the geometric growth rate to calculate the...

Consider the data in the following table: Year 2004 2005 2006 2007 2008 2009 Stock A...

Consider the data in the following table: Year 2004 2005 2006 2007 2008 2009 Stock A -10% 20% 5% -5% 2% 9% Stock B 21% 7% 30% -3% -8% 25% Use the above information to answer the following questions. Round your answers to four decimal places (i.e. 0.0105). 1. Estimate the average return for stock A. 2. Estimate the average return for stock B. 3. Estimate the volatility of stock A. 4.Estimate the volatility of stock B. 5 .Estimate the...

Consider the following price data from 2002 to 2010 Year 2002 2003 2004 2005 2006 2007...

Consider the following price data from 2002 to 2010 Year 2002 2003 2004 2005 2006 2007 2008 2009 2010 Price 3.34 3.56 3.61 4.06 4.25 4.37 4.68 4.59 4.81 a. Compute the simple price index using 2002 as the base year. (Round your answers to 2 decimal places.) Year Price index 2002 2003 2004 2005 2006 2007 2008 2009 2010 b. Update the index numbers with a base year revised from 2002 to 2005. (Round your answers to 2 decimal...

Year Percentage 2000 28 2001 32 2002 36 2003 40 2004 44 2005 51 2006 53...

Year Percentage 2000 28 2001 32 2002 36 2003 40 2004 44 2005 51 2006 53 2007 57 2008 60 2009 66 Forecast the percentage of tax returns that will be electronically filed for 2010 using exponential smoothing with trend adjustment. alpha= 0.3 and beta= 0.4. Then calculate MAD. ---------------------------------------------------------------------------------------------------------------------------------------------------------------------- Quarter Price Q1 2017 186.3 Q2 2017 190.9 Q3 2017 195.2 Q4 2017 195.2 Q1 2018 198.7 Q2 2018 201.2 Forecast the price index for Q3 2018 using a three-period...

year Percentage 2000 28 2001 32 2002 37 2003 43 2004 47 2005 52 2006 56...

year Percentage 2000 28 2001 32 2002 37 2003 43 2004 47 2005 52 2006 56 2007 58 2008 61 2009 66 Forecast the percentage of tax returns that will be electronically filed for 2010 using exponential smoothing with trend adjustment. Set alphaα =0.5 and β=0.6

2003 2004 2005 2006 Cash and Short Term Investments 51.421 58.054 60.651 72.122 Accounts Receivable 12.394...

2003 2004 2005 2006 Cash and Short Term Investments 51.421 58.054 60.651 72.122 Accounts Receivable 12.394 17.256 25.158 30.919 Inventory 4.350 5.398 7.358 8.714 Prepaid Expenses and Deferred Taxes 3.887 3.905 9.607 15.863 Current Assets 72.052 84.613 102.774 127.618 Property, Plant and Equipment 146.362 201.725 268.809 345.977 Goodwill and Other Assets 38.421 38.334 66.084 69.014 Total Assets 256.835 324.672 437.667 542.609 Accounts Payable 8.072 5.840 4.422 5.800 Acrued Expenses and Deferred Revenue 37.571 49.865 82.443 103.810 Current Liabilities 45.643 55.705...

A polling organization conducted telephone surveys in March of 2004, 2005 and 2006. In each year,...

A polling organization conducted telephone surveys in March of 2004, 2005 and 2006. In each year, 1001 people age 18 or older were asked about whether they planned to use a credit card to pay federal income taxes that year. The data are given in the accompanying table. Is there evidence that the proportion falling in the three credit card response categories is not the same for all three years? Test the relevant hypotheses using a 0.05 significance level. (Round...

India's Current Account Assumptions (millions USD) 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013...

India's Current Account Assumptions (millions USD) 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 Goods: exports 77,939 102,175 123,876 153,530 199,065 167,958 230,967 307,847 298,321 319,110 329,633 Goods: imports -95,539 -134,692 -166,572 -208,611 -291,740 -247,908 -324,320 -428,021 -450,249 -433,760 -415,529 Balance on goods -17,600 -32,517 -42,696 -55,081 -92,675 -79,950 -93,353 -120,174 -151,928 -114,650 -85,895 Services: credit 38,281 52,527 69,440 86,552 106,054 92,889 117,068 138,528 145,525 148,649 156,252 Services: debit -35,641 -47,287 -58,514 -70,175 -87,739 -80,349 -114,739 -125,041...

The consumer Price Index for the different years are as follows. 2003 10.75 2004 89.25 2005...

The consumer Price Index for the different years are as follows. 2003 10.75 2004 89.25 2005 83.34 2006 56.25 1) Calculate Inflation rate for 2003, 2004, and 2005. 2) What kind of fiscal policy will you use to fight against inflation. Explain it briefly.

This is a tableau question. Year Sales 2005 49387 2006 53412 2007 56783 2008 58436 2009...

This is a tableau question. Year Sales 2005 49387 2006 53412 2007 56783 2008 58436 2009 59994 2010 61515 2011 63182 2012 67989 2013 70448 2014 72601 2015 75482 2016 78341 2017 81111 2018 82517 2019 83275 2020 84005 I. (a) Determine the trend line using both linear and two nonlinear equations Hint: You can choose any two of the nonlinear options in edit trend lines within Tableau. (b) Write down the equations (coefficients). Hint: Double click on trend line...