The attached excel data has the following three variables:  the number of new cars sold (NCS; in millions of dollars);  index of consumer sentiment (ICS);  and prime loan rate (Prime). 1. Formulate and estimate a model of the effect of ICS and Prime on the number of new cars sold (NCS). Use the data from January 2002 to December 2010 for the purpose of estimation. 2. Plot the number of new cars over time. What do you infer? 3. Based on what you learnt from the plot, can you formulate and estimate a “best” model. Note that to in order to identify the “best” model, you may have to formulate and estimate a couple of models. Report the results of all the models. As before, use the data from January 2002 to December 2010 for the purpose of estimation. 4. Use the data from January 2011 to December 2012 for the purpose of figuring out which model is able to predict the number of new cars sold better. Which model fits the data better? Elaborate on the predictive ability of the three models.

AccountingQueen

(3)

Status NEW Posted 18 Aug 2017 05:08 AM My Price 10.00

Hel-----------lo -----------Sir-----------/Ma-----------dam----------- T-----------han-----------k y-----------ou -----------for----------- us-----------ing----------- ou-----------r w-----------ebs-----------ite----------- an-----------d a-----------cqu-----------isi-----------tio-----------n o-----------f m-----------y p-----------ost-----------ed -----------sol-----------uti-----------on.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age----------- I -----------wil-----------l

Not Rated(0)

• Buy Answer