Microsoft Word - MBAF502_ProjectI II PROJECT II Course Name and Number: MBAF 502: Quantitative Reasoning & Analysis Project II: Regression Analyses and Forecasting Weight = 25% Due June 13, 2022, at...

1 answer below »
Word limit 1250. not copying tables and figures ( please self-made data ).Please use old project data (order no105805) intel and AMD past two years. Mention reference. Everything should be clear and details.


Microsoft Word - MBAF502_ProjectI II PROJECT II Course Name and Number: MBAF 502: Quantitative Reasoning & Analysis Project II: Regression Analyses and Forecasting Weight = 25% Due June 13, 2022, at 23:59 pm. DESCRIPTION DESCRIPTION In this assignment, students work further on the data extracted under Project I. Under Part 1 of this project by applying a linear regression analyses and forecasting. Main findings from the inferential statistics and predictive analyses will be used to make managerial decisions for the core issues under consideration.. PART 1: Time Serries Data and Forecasting INSTRUCTIONS Step 1: Install Excel onto your computer using your myucw.ca credentials. Excel Add-ins: Load Excel Analysis ToolPak for visual basic analytics and Solver, where necessary. Step 2: Download and install programing language Gretl (or a statistical tool of your preference); Gretl is available at http://gretl.sourceforge.net , GNU GPL licence, crossplatform. Step 3: Explain Stationarity Step 4: Data Noise: 4.1 Execute a unit root test to check whether variables in the dataset are non-stationary. 4.2 In the case of non-stationarity based on the unit root test, then detrend the variable which is not stationary using the differencing approach. 4.3 In the case of non-stationarity based on the unit root test, then detrend the variable which is not stationary using exponential smoothing or differencing. 4.4 Using the dataset, plot histograms of the key factors for all the period under consideration and describe how they evolve. 4.5 Forecasting: Use the linear trend equations for the factors under consideration to arrive at and display estimates for future time periods PART 2: Inferential Statistic- Regression Analyses Here you will perform regression analyses and hypotheses testing. Step 1. Identify the core research problems for analyses and propose the hypotheses that applies to the case under consideration. Notes For your analyses and report 1.1 What are the independent and dependent variables? 1.2 Correlation Analyses: Perform a correlation analysis for selected pair of variables of interest. Draw a scatter plot for each and interpret the results from the correlation coefficient by focusing on the sign, magnitude and statistical significance of the correlation coefficient. 1.3 Regress the dependent variable on the set of independent variables 1.4 Interpret the magnitude and direction of the coefficients, the statistical significance for each, and the goodness of fit (R2 ) of your regression output. 1.5 Cause- effect: Is there statistical evidence for the linear relationship between the variables of interest? 1.6 Find the coefficient of determination and interpret it. 1.7 What is the slope of the regression equation? What does it mean? 1.8 Include visual analytics for your regression analyses using graphs. Step 2. Write a 1000 to 1500 words report describing the results of linear regression forecast and correlation analysis. Step 3. Conclusion 3.1 Validity and Reliability: Write concluding remarks on the reliability, validity and consistency of your key findings in this project (apply a robustness check, where applicable). 3.2 Summaries the key findings from the analyses you performed in this project. 3.3 : Managerial Data-Driven Decision Making: Based on the analyses you observe, reflect on the core issue (s) in relation to the company/asset under consideration and draw implications out of this. Note: Please, provide a proper citation (both in-text citation and reference list) of any resource used in this work. Use APA Standard for the format of your final submission
Answered 3 days AfterJun 06, 2022

Answer To: Microsoft Word - MBAF502_ProjectI II PROJECT II Course Name and Number: MBAF 502: Quantitative...

Mohd answered on Jun 09 2022
82 Votes
Microsoft Word - MBAF502_ProjectI II
Explain Stationarity
Stationarity is the phenomenon when our time series data does not depend on time series. In the most natural sense, stationarity implies that the measurable properties of a cycle creating a period series don't change after some time. It doesn't imply that the series doesn't change after some time, simply that the manner in which it changes doesn't itself change over the long haul. The mathematical identical is in this way a direct capacity, maybe, and not a steady one; the worth of a straight capacity changes as ? develops, yet the manner in which it changes stays consistent — it has a steady slant; one worth that catches that pace of progress.
For what reason is this significant? In the first place, on the grounds that fixed cycles are more straightforward to dissect. Without a conventional definition for processes producing time series inform
ation (yet; they are called stochastic cycles and we will get to them in a second), it is now evident that fixed cycles are a sub-class of a more extensive group of potential models of the real world. This sub-class is a lot simpler to demonstrate and explore. The above casual definition additionally indicates that such cycles ought to be feasible to anticipate, as the manner in which they change is unsurprising.
The last explanation, consequently, for stationarity's significance is its omnipresence in time series examination, making the capacity to comprehend, identify and demonstrate it important for the utilization of numerous conspicuous apparatuses and methods in time series investigation. Without a doubt, for some cases including time series, you can find that you need to decide whether the information was created by a fixed cycle, and perhaps to change it so it has the properties of an example produced by such an interaction.
Data Noise:
Unit root test:
P value is greater than 0.05 which implies there is a stationarity in the data.
    Augmented Dickey-Fuller test for Close_intel
testing down from 6 lags, criterion AIC
sample size 504
unit-root null hypothesis: a = 1
test with constant
including 0 lags of (1-L)Close_intel
model: (1-L)y = b0 + (a-1)*y(-1) + e
estimated value of (a - 1): -0.0216778
test statistic: tau_c(1) = -2.27994
asymptotic p-value 0.1786
1st-order autocorrelation coeff. for e: -0.042
with constant and trend
including 0 lags of (1-L)Close_intel
model: (1-L)y = b0 + b1*t + (a-1)*y(-1) + e
estimated value of (a - 1): -0.0258278
test statistic: tau_ct(1) = -2.52172
asymptotic p-value 0.3175
1st-order autocorrelation coeff. for e: -0.041
Unit root test:
P value is greater than 0.05 which implies there is a stationarity in the data.
Augmented Dickey-Fuller test for Close_AMD
testing down from 64 lags, criterion AIC
sample size 504
unit-root null hypothesis: a = 1
test with constant
including 0 lags of (1-L)Close_AMD
model: (1-L)y = b0 + (a-1)*y(-1) + e
estimated value of (a - 1): -0.0118239
test statistic: tau_c(1) = -1.96841
asymptotic p-value 0.3011
1st-order autocorrelation coeff. for e: -0.056
with constant and trend
including 0 lags of (1-L)Close_AMD
model: (1-L)y = b0 + b1*t + (a-1)*y(-1) + e
estimated value of (a - 1): -0.0189328
test statistic: tau_ct(1) = -2.09058
asymptotic p-value 0.5505
1st-order autocorrelation coeff. for e: -0.
Histograms:
Forecasting: Using the linear trend equations for the factors under consideration to arrive at and display estimates for future time periods
Model 6: ARMA, using observations 2020-05-18:2022-04-22 (T = 505)
Dependent variable: Close_intel
Standard errors based on Hessian
    
    Coefficient
    Std. Error
    z
    p-value
    
    const
    53.1814
    2.38429
    22.30
    <0.0001
    ***
    phi_1
    0.980822
    0.00885941
    110.7
    <0.0001
    ***
    theta_1
    −0.0416817
    0.0445246
    −0.9361
    0.3492
    
    Mean dependent var
     53.39149
    
    S.D. dependent var
     5.531841
    Mean of innovations
    −0.024877
    
    S.D. of innovations
     1.175047
    R-squared
     0.954811
    
    Adjusted R-squared
     0.954721
    Log-likelihood
    −799.6189
    
    Akaike criterion
     1607.238
    Schwarz criterion
     1624.136
    
    Hannan-Quinn
     1613.866
    
    
    Real
    Imaginary
    Modulus
    Frequency
    AR
    
    
    
    
    
    
    Root 1
    1.0196
    0.0000
    1.0196
    0.0000
    MA
    
    
    
    
    
    
    Root 1
    23.9914
    0.0000
    23.9914
    0.0000
PART 2: Inferential Statistic- Regression Analyses
Here you will perform regression analyses and hypotheses testing.
Step 1. Identify the core research problems for analyses and propose the hypotheses that applies to the case under consideration. Notes For your analyses and report
We want to identify and estimate the relationship between intel close price and AMD close price over the period of two year. We have considered Intel Close price as dependent variable or response variable and AMD Close price as independent variable or explanatory variable. We have also considered year as explanatory variable. First, we have run correlation analysis to identify the relationship between intel close price and AMD close price. We have evaluated hypothesis evaluate our assumptions.
Null Hypothesis: There is no association between intel close price and AMD close price.
Alternative Hypothesis: There is a association between intel close price and AMD close price.
As we can see from correlation analysis output, p-value=0.0873 and at 10 percent significance level null hypothesis will be rejected and alternative hypothesis will be accepted. The correlation coefficient between intel close price and AMD close price is negative and moderate, which implies increase in one will cause decrease in other. AMD close price has negative influence over the intel close price. Increase in intel price will cause decrease in AMD close price.
.
Correlation coefficients, using the observations 2020-05-18 - 2022-04-22
5% critical value (two-tailed) = 0.0873 for n = 505
    Close_intel
    Close_AMD
    
    1.0000
    -0.4175
    Close_intel
    
    1.0000
    Close_AMD
    
    
    
We have plot scatter plot between Intel close price and AMD close price. The r square value is 0.1743 which implies 17.43 percent variability in Intel close price can explain with this model. We have negative beta coefficient of -0.0965, which implies increase in one dollar AMD price will cause 0.0965-dollar decrease in intel price. The intercept value is 62.534.
1.1 Regress the dependent variable on the set of independent variables
    SUMMARY OUTPUT
    
    
    
    
    
    
    
    
    
    
    
    
    
    Regression Statistics
    
    
    
    
    
    Multiple R
    0.423209919
    
    
    
    
    
    R Square
    0.179106635
    
    
    
    
    
    Adjusted R Square
    0.175836144
    
    
    
    
    
    Standard Error
    5.021997045
    
    
    
    
    
    Observations
    505
    
    
    
    
    
    
    
    
    
    
    
    
    ANOVA
    
    
    
    
    
    
     
    df
    SS
    MS
    F
    Significance F
    
    Regression
    2
    2762.368117
    1381.184
    54.76444004
    3.06177E-22
    
    Residual
    502
    12660.66807
    25.22045
    
    
    
    Total
    504
    15423.03619
     
     
     
    
    
    
    
    
    
    
    
     
    Coefficients
    Standard Error
    t Stat
    P-value
    Lower 95%
    Upper 95%
    Intercept
    -1269.977442
    778.2572579
    -1.63182
    0.103344069
    -2799.020134
    259.0652507
    Year
    0.65987294
    0.385400407
    1.712175
    0.087481999
    -0.097323565
    1.417069445
    Close_AMD
    -0.107098227
    0.011216119
    -9.5486
    5.76771E-20
    -0.129134545
    -0.08506191
As we can see from regression output, F(2,502)=54.76 | P value<<<0.05. Hence our model is statistically significant to predict the intel close price. We have also added year as independent variable. At five percent significance level year is statistically insignificant P value > 0.05.
Hypothesis testing for predictors:
Null Hypothesis: Beta coefficient is not different from zero
Alternative hypothesis: Beta coefficient is different from zero.
The adjusted r square value is 0.1758 which implies 17.58 percent variability in Intel close price can explain with this model. We have negative beta coefficient of -0.1070, which implies increase in one dollar AMD price will cause 0.1070-dollar decrease in intel price. The intercept value is 1269.977.
Boxplot of intel close price shows, there is no outliers in intel close price. Outliers adversely affects the regression model performance.
.
Conclusion:
As we can see from correlation analysis output, p-value=0.0873 and at 10 percent significance level null hypothesis will be rejected and alternative hypothesis will be accepted. If we lower the significance level then the variables are not significantly correlated. Model significance and validity depends upon the defined significance level.
We have negative beta coefficient of -0.1070, which implies increase in one dollar AMD price will cause 0.1070-dollar decrease in intel price. The intercept value is 1269.977. There are no outliers in intel close price. Outliers adversely affects the regression model performance. We can collect more data to build more accurate model. Also there are many forecast model available for forecast.
Close_intel    y = -0.0965x + 62.534
R² =...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here