Search
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.

# Financial data analysis - Essay Example

Summary
Financial data Analysis PART I This part will involve regression analysis, to establish the nature of the relationship between WHEATSF and WHEATHD. For the purpose of this analysis, WHEATSF will be taken as the dependent variable and WHEATHD as the dependent variable…

## Extract of sampleFinancial data analysis

A clear linear relationship is not evident, which could be an indicator that WHEATHD is a poor predictor of WHEATSF. Figure 1: the plot of WHEATSF against WHEATHD Model R R Square Adjusted R Square Std. Error of the Estimate Change Statistics R Square Change F Change df1 df2 Sig. F Change 1 .421a .177 .174 27.2183 .177 53.344 1 248 .000 Table1: Model regression summary Table 1 above presents a summary of the regression summary. From this, adjusted R squared is 0.17, a figure that is very small indicating that the model is not very good in predicting the dependent variable as it is highly subject to chance rather than statistical relationship between the two variables. However, the p-value is less than 0.01, an indicator that the model is statistically significant, or rather we have enough evidence to assert that WHEATHD has some predictive power on WHEATSF. Coefficientsa Model Unstandardized Coefficients Standardized Coefficients t Sig. B Std. Error Beta 1 (Constant) 500.582 24.519 20.416 .000 WHEATHD(P) -.443 .061 -.421 -7.304 .000 Table 2: a. Dependent Variable: WHEATSF(P) Coefficientsa Model Unstandardized Coefficients Standardized Coefficients t Sig. B Std. Error Beta 1 (Constant) 532.035 17.694 30.069 .000 WHEATSF(P) -.400 .055 -.421 -7.304 .000 Table 3: a. ...
itable statistical technique to use, but I surmounted this by examining the expected outcome to decide on the best method (Hyndman and Koehler, 2006). PART II In this part, 1- 250 sample values are used to forecast the subsequent 11 values. Using excel to forecast In using excel spreadsheets to do the forecast, we highlight the raw data and insert the scatter plot. Then, we insert the trend line in the scatter plot and subsequently format it to include the trend line equation. The trend line equation is then used to substitute the values of x for the 11 series periods that are sampled for prediction. The following table shows the values of x and the substituted values y. Y=532.03-0.4x x Y (Forecasted) Actual 308.5 408.63 443 311.5 407.43 446.5 314.5 406.23 450 313.5 406.63 447 319.5 404.23 451.5 324.5 402.23 451.5 324.5 402.23 451.5 333.5 398.63 461.25 337.5 397.03 465.75 324.5 402.23 460.75 327.5 401.03 462.5 Sum 4436.53 4991.25 Figure 2: Excel scatter plot with the equation fitted in. Using eview The raw data for the prices are input in the software and a forecast generated automatically. The output, which is shown in figure 3, comes with a table with forecast errors already computed. The table alongside shows statistical arithmetic that is associated with this particular model, including a number of methods for calculating the forecasting errors. Figure 3: Forecast for 251 - 261 Sample Figure 4: graph before model 1forecast Figure 5: graph after model 1 forecast Forecast errors Forecast errors are the estimations of the probability that the results of the forecast deviates from the actual values. Fore example, looking at figures 4 and 5 of the first forecast model, it is clear how the forecast values differ slightly from the actual values. A number of errors that ... Read More
Cite this document
• APA
• MLA
• CHICAGO
(“Financial data analysis Essay Example | Topics and Well Written Essays - 1000 words”, n.d.)
(Financial Data Analysis Essay Example | Topics and Well Written Essays - 1000 Words)
https://studentshare.net/finance-accounting/85612-financial-data-analysis.
“Financial Data Analysis Essay Example | Topics and Well Written Essays - 1000 Words”, n.d. https://studentshare.net/finance-accounting/85612-financial-data-analysis.
Click to create a comment
CHECK THESE SAMPLES - THEY ALSO FIT YOUR TOPIC
Data Table Analysis
Also this company runs best food grocery stores located in California, provides wide range of exotic herbs and flavors, refreshing wines, wide variety seafood items and baked goods ( baked with European cooking style) etc. This paper analysis the various design elements of the data tables from the perspective of accounting, form an entity relationships diagram illustration using the existing data tables and suggests improvements for the data tables.
3 Pages(750 words)Essay
Longitudinal Data Analysis
The data selected for evaluating the relationship between educational qualifications and financial position individuals in Britain is extracted from the survey data collected through The British Household Panel Survey for a period of eleven years from 1991 to 2001. The dependent variable selected for the study is the financial position of individuals.
14 Pages(3500 words)Essay
Groupbased assignment for Financial data analysis
Another issue to be considered is selecting the companies for giving loans. Another crucial decision making is investments. Through this report we will bring such issues to light by computing some prime financial figures of two companies, namely DGSE COMPANIES INC and PUBLIC SERVICE ENTRP GRP INC.
10 Pages(2500 words)Essay
One of the problems when studying financial information analysis in the traditional way is that the exercise can seem to consist of nothing more than the application of various techniques to masses of accounting data....[O]ne of the key themes(of fi
This is particularly in environments where accounting is documented as a prime means of communicating and controlling the operations of an enterprise. In the business world Entrepreneurs
6 Pages(1500 words)Essay
Financial data analysis
Countries as well as companies, use the same tool to predict different things. Some companies like to predict their earnings in total, while some of them like to initiate certain things from the total (Borodovsky, M & Gogarten, P, 2010). Among a number of forecasting
4 Pages(1000 words)Essay
Financial data analysis
Using Excel function, a correlation analysis was conducted on the available data in order to find out how the two prices of wheat are correlated. In addition, the data analysis also identifies
4 Pages(1000 words)Essay
Data Analysis
However over the past few years the term has greatly expanded and has even moved towards the field of financeInvalid source specified.. A great deal of works has been conducted regarding
8 Pages(2000 words)Essay
Financial analysis of Zest Spa
The financial analysis of Zest Spa comprises profit projection for the current year for the three alternative choices along with analysis of net cash inflow using techniques such as net present value, internal rate of return,
10 Pages(2500 words)Essay
Financial Analysis
A financial plan does not only serve as an organization’s checklist of various actions, but is also used as a document that can be used to check the progress so as to see if a change of strategy is required. Financial
4 Pages(1000 words)Essay
FINANCIAL DATA ANALYSIS
Free cash flow model of valuation estimates value of a firm based on its fundamentals. The company is expected to pay its shareholders based on intrinsic value of the firm. In addition, this value is reflected by net present cash flow. It’s
3 Pages(750 words)Math Problem
Let us find you another Essay on topic Financial data analysis for FREE!
+16312120006