Decision Science | NMIMS Assignment Help April 2023 Question
1. Based on the following data develop the forecasting model (adopt Exponential Smoothing Technique) by considering the following alpha levels. α = 0.2, 0.4, 0.6, 0.8. Write your conclusion after calculations of Errors (MAD and MSE only). Forecast FTAs (foreign tourist arrival) for the year 2018. Data: The following data shows the Foreign Tourist Arrival in the India from 1991 to 2017
2. Calculate the Correlations for the following pairs of variables and write your Conclusion.
- In Migration of Persons from other states (Census of India) & Total MSMEs
- In Migration of Persons from other states (Census of India) & Active Companies
- In Migration of Persons from other states (Census of India) & 2017-18 GSDP – CURRENT PRICES (` in Crore)
- Total MSMEs & Active Companies
Note: Use MS EXCEL, SPSS, SAS etc. for the calculations.
3. a. Summarized the following data by calculating the mean and standard deviation.
Note: You are advisable to use EXCEL. You are supposed to Copy the numbers (final calculations) from EXCEL and paste them into your word document.
Data Source: Ministry of agriculture and farmers’ welfare.
3. b. Write about the general pattern (here, time series component) across the given years using an appropriate graph. Note: You may use EXCEL, Tableau, Power BI Etc. for creating Graph