Data Collection and Descriptive Statistics of the Walt Disney Company _phase II _group project_MBAF

.pdf

School

University Canada West *

*We aren’t endorsed by this school

Course

502

Subject

Economics

Date

Apr 26, 2024

Type

pdf

Pages

11

Uploaded by JusticeIceBaboon53 on coursehero.com

1 Data Collection and Descriptive Statistics of the Walt Disney Company Phase - 3 University Canada West MBAF 502: Quantitative Reasoning and Analysis S-37 March 25, 2024 5.1 What method was used for forecasting? Linear regression analysis was used to forecast the stock price of Walt Disney and Ne:lix companies. The technique of regression analysis allows us to examine the rela@onship or correla@on between the dependent variable (stock costs), and the independent variable (@me period with days and months). The linear trend obtained by regression analysis allows us to assess the nature of the rela@onship between two variables and predict future values. The main indicators in forecasting using regression analysis are the strength, direction and reliability (validity) of the relationship. The strength of the relationship is determined by the absolute value of correlation varies from 0 to 1 (Pearson correlation coefficient). The direction of
2 the relationship is determined by the sign of the correlation coefficient: a positive coefficient - the relationship is direct; a negative coefficient - the relationship is inversed. Reliability of the relationship is determined by the p-level of statistical significance (the smaller the p-level, the higher the statistical significance or reliability of the relationship). 5.2 What were the forecast results? The results of the forecast were the predicted values of the companies' shares for three months - December 2023, January 2024 and February 2024 in Canadian dollars. 5.3 How did the forecast results agree with the actual historical data? 5.6 Were the correlations statistically significant? The forecast values differ from the actual values in both companies, and for the Walt Disney Company, the difference is very significant. The forecast values of Walt Disney's stock price. Table 1 Summary Output Walt Disney
3 The forecast of Walt Disney Company's stock value should be considered unreliable because the correlation between the forecast and actual values of prices is low at 0.48 (figure 1). Figure 1 y = -0.1517x + 94.083 R² = 0.481 $80 $81 $81 $82 $82 $83 $85 $90 $95 $100 $105 $110 $115 Predicted price Actual price Scatterplot Actual/Predicted Walt Disney
4 The correlation or R square between the share price and time (day and month) is weak and is only 0.55 (table 1). According to the figure 2, a linear dynamic in the direction of decrease in the value of shares over time. The stock value has been gradually decreasing since the beginning of 2023, but from the 7 th of November the stock values increased. This upward spike in value was not included by linear regression in the accounting, continuing the downward trend line to lower value (figure 2). Figure 2 Figure 3
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help