Part 1: How to generate Random data with Excel

Generate Normal Distribution Ramdom Values

The following pictures show how to generate 1000 normal distribution data.
Step 1

Step 2

Step 3
Please to evaluation the distribution of the data

We have know what is the AR, ARMA model. There are relationships between ARCH and AR, GARCH and ARMA. If we know the relationshps among them, it will be very helpful for understanding what we do in this practice.

The ARCH model is appropriate when the error variance in a time series follows an autoregressive (AR) model; if an autoregressive moving average (ARMA) model is assumed for the error variance, the model is a generalized autoregressive conditional heteroskedasticity (GARCH) model.

Rainfall Modelling (W6)

Part1: Getting Gamma model parameters

• The instructions

  instructions

  1. Take the file called PoorakaMonthlyFit.xls. It contains a sheet that shows the fitting procedure using Likelihood to fit a Gamma Distribution to data for the 87 years for June for Pooraka. Try matching moments to see what you get for the parameters as well.
  2. You are to repeat this for May-September. Check out both the methods and apply to the other months. Then see about in each case.

• Setting Parameters

How to find Tools in Excel

Trend

Practice 1: Linear Regression

Part1: Simple Linear Regression

Click for Steps of Simple Linear Regression

Step 1: View the original data set

Step 2: Year subtract 1875 for starting from 0

Step 3: Select Analysis tool

Step 4: Select regression tools

Step 5: Setting parameter for regression

Step 6: Results and Visualization

More Details of the Parameters

Please refer here for more information of each parameters