Statistics – Cheap Research Essays

Statistics

Collect data (Monthly data from Jan 2010 to Dec 2014) about the stock price of 3 multi-national companies (operating in the common sector in different markets for example, Ford, Geely, and Tata Motors). The 3 companies must operate in the same industry but in different countries. Use Yahoo Finance to obtain the data and use the closing stock price.
What you have to do?
Forecast the stock price using Moving Average, Exponential Smoothing, and Naïve methods. Select the method that leads to the lowest Mean Absolute Deviation (MAD), Mean Square Error (MSE), and Mean Absolute Percent Error (MAPE). You must perform each forecasting method and then determine the MAD, the MSE, and the MAPE for each method. You must do this for each company. Make analyses of the factors that might influence why the chosen companies forecasts are different by relating the trends to socio-economic or global market factors that are relevant and supported by the business press.
Include the following sections into the project report:
INTRODUCTION – Explain the basics of the forecasting and purposes of the project
FORECASTING METHODS – Explain Moving Average, Exponential Smoothing, and Naïve Methods one by one.
DATA – Show the data collected in a table for all the 3 companies
DATA ANALYSIS – Show all the 3 companies’ forecast prices and errors of all the 3 methods in three tables. If possible include charts for comparative analyses.
DISCUSSION – Discuss the findings of your analyses and explain the probable socio-economic or global factors that influence differences in the companies’ forecasts. In addition, discuss the usefulness of the project findings on formulating organizational plans.
Format you have to follow: Font size 12; Times New Roman; 1.5 line spacing.
Please show all data in excel file and upload it when completed. Show each company in a separate sheet.