#### Details of this Paper

##### Page 1 of 5 BUSA 3060 Quantitative Management...

**Description**

Solution

**Question**

Page 1 of 5 BUSA 3060 Quantitative Management Final Exam (Fall 2010) This exam is open-book, open-notes. The due time is at 11:59am (at NOON) EST on Saturday of Dec. 4th, 2010. No late submission is allowed. Please note: 1. The answers MUST be your own work, there is ZERO tolerance on any kind of violation of the policy of academic integrity. Please come to the instructor only, should you have any question on exam materials. 2. Please read each question carefully. In answering, please show your detailed analysis and calculations in a well-structured and clear way. Please show in details your steps of solving the problems, list essential calculations, hypotheses, etc. Relevant (and ONLY relevant) Minitab outputs, in supporting your analysis and arguments, should be copied and pasted into the Word file of your exam report. Partial points will be deducted if you do not show your steps in solving the problems. 3. Please submit online in GeorgiaVIEW system, through link in ?Final Exam? folder, your answers in ONLY ONE file, in MS Office Word format. 4. Please check your file before submitting online, make sure it?s in the completeness and bears no error codes and virus, and it?s in a readable format (you can print one hard copy at home to see whether it meets the requirements). 5. Do not forget put your full name on the first page. 6. For calculation, please use precision level at least three digits after the decimal point. 7. Use ?=0.05 level of significance, if you need to conduct hypothesis test, regression analysis, etc 8. The last two questions are bonus questions, offering additional bonus points above the 100 regular score points. It?s up to you for working on that or not. But my suggestion is at least give it a try, because they are very easy. Page 3 of 5 Exam Materials: Suppose an entry level financial analyst wants to use regression models to analyze and predict the daily closing price of Microsoft stock traded in the market. To begin with the task, he was given a dataset (stockprices.MTW dataset, downloadable from GeorgiaVIEW, source: Yahoo) which contains ten years? historical closing prices of stocks of Microsoft, GE and FORD, based on one colleague?s suggestion that big companies such as GE and FORD are important influencing customers of Microsoft, therefore, the analyst need to decide whether or not should she/he include either GE or FORD or both stocks? prices into the model. In addition, it is argued that the performance of Microsoft?s business is situated under the macroeconomic conditions. As indicators of the whole economy, U.S. Treasury Bill rates and S&P500 index values (here assuming these are good indicators, although theoretically S&P500 should not be used as independent variable here, which we ignore in favor of modeling purposes) over the ten years are collected into the dataset. For constructing an effective regression model for daily closing prices of Microsoft stock, please complete the following tasks: (a). Obtain a scatterplot matrix of the five variables, based on the plot, discuss which variable is most linearly correlated with the dependent variable of MSFT. (10 points) (b). Using stepwise regression method, identify the best simple regression model for predicting the dependent variable. Write down your model in the format of , interpret the meaning of regression coefficient ?1. Also discuss the significance of the model. (20 points) ???++=XY10 [Note: in Minitab, for carrying out stepwise regression analysis, you must specify the significance level to be 0.05. Besides, for significance discussion, you must use appropriate statistical terms and statistics, and you can use formal hypothesis test]. Page 4 of 5 (c). Based on stepwise regression analysis output, identify the best regression model fitting the data given. In so doing, write down your best (multiple) regression model. And discuss what does the partial regression coefficient ?1 mean [Note: you must explicitly explain its meaning based on the case and model estimate, please do not simply copy the definition of partial regression coefficient here] in your model. (20 points) (d). Please discuss the overall significance of the model in (c) and the significance of each independent variable, show your reasoning. (20 points) [Note: you must use appropriate statistical terms and statistics to support your discussion, also you can use formal hypothesis tests for the discussion here.] (e). What is the R2 of your best model, please interpret its meaning. (10 points) (f). Obtain predictions of the historical closing prices of MSFT stock, based on your best fitting model in (c), and plot them with the real observed values in an overlay plot figure to show a graphical presentation of your model performance. (10 points) (g). Using appropriate statistics, please discuss whether there exists severe multicollinearity problem in your best model in (c). (10 points)Page 5 of 5 Bonus Questions (h). Assuming the analyst is asked to provide an estimate (point estimate) for tomorrow?s Microsoft stock closing price, and assume based on reports of the Fed and other researchers, tomorrow?s T-bill rate will be 1.0, S&P500 will be 1000, GE?s stock closing price will be at $28 per share, and closing price of FORD?s stock will be at $8 per share, what would be the estimate based on the best fitting model? (10 points) (i). Test the opinion/suggestion from the colleague that the performance of big company customers will have a positive influence on Microsoft?s business. In so doing, conduct a formal hypothesis test. You MUST list hypotheses, test statistic(s), p-value(s) and other important and essential steps in obtaining statistical inferences. (10 points) Attachment added,Willing to pay $100

Paper#13521 | Written in 18-Jul-2015

Price :*$25*