Calculate Descriptive statistics of logarithmic returns such as Mean, Median, Minimum, Maximum, Standard deviation, Skewness, Kurtosis of AUD, USD, CNY, JPY and EUR. probability plot of USD, CNY, JPY and EUR returns. I have an excel sheet don't know how to upload it along with the question. As it is giving the option to upload images only. However, have emailed to bartebly email. TitleA$1=USDTrade-weighted Index May 1970 = 100AS1=CNYA$1=JPYA$1=EURADescriptionFrequency|ТуреAUD/USD Exchange Rate; Australian Dollar Trade-weighted Index AUD/CNY Exchange Rate AUDIJPY Exchange Rate AUDIEUR Exchange Rate ADailyDailyDailyDailyDailyDIndicativeIndicativeIndicativeIndicativeIndicativeInUnitsUSDIndexCNYJPYEURKWM/ReutersPublication date 10-May-2021SourceRBARBARBARBA10-May-2021FXRJY10-May-202110-May-202110-May-2021Series IDEXRUSDFXRTWIFXRCRFXREURF.20-Feb-20190.716361.004.815579.370.631421-Feb-20190.716261.004.795279.350.631022-Feb-20190.709360.504.773678.580.625725-Feb-20190.714460.804.777679.060.630026-Feb-20190.715960.904.795079.330.630327-Feb-20190.718361.004.807279.440.631428-Feb-20190.714660.704.774579.230.628101-Mar-20190.709360.404.751079.210.623604-Mar-20190.709560.504.746879.440.624305-Mar-20190.707660.404.742979.180.624506-Mar-20190.703560.104.724178.630.622607-Mar-20190.704960.204.729978.730.623608-Mar-20190.700960.004.711077.970.625911-Mar-20190.704460.204.735378.280.627012-Mar-20190.706960.304.745978.710.628213-Mar-20190.705560.204.734078.520.625214-Mar-20190.705960.204.737478.780.623715-Mar-20190.708160.504.758179.090.625618-Mar-20190.711560.604.776479.350.627619-Mar-20190.710560.504.771679.060.626220-Mar-20190.707560.304.749978.950.623621-Mar-20190.714560.604.774178.950.625322-Mar-20190.710660.504.764678.720.624525-Mar-20190.707960.304.752877.850.626626-Mar-20190.712260.604.778278.380.629627-Mar-20190.710160.604.768678.540.630828-Mar-20190.709760.604.775978.190.630629-Mar-20190.708760.504.765978.490.631001-Apr-201902-Apr-201903-Apr-201904-Apr-201905-Apr-201908-Apr-20190.712160.804.775579.060.63390.708060.504.758278.840.63200.710660.704.769379.130.63320.711160.704.774879.220.63250.712560.904.785979.590.63460.709460.704.767179.050.6318 TitleA$1=USDTrade-weighted Index May 1970 = 100A$1=CNYA$1=JPYA$1=EURDescriptionFrequencyТуреAUD/USD Exchange Rate; Australian Dollar Trade-weighted Index AUD/CNY Exchange Rate AUDIJPY Exchange Rate AUD/EUR Exchange RateDailyDailyDailyDailyDailyIndicativeIndicativeIndicativeIndicativeIndicativeUnitsUSDIndexCNYJPYEURWM/ReutersPublication date 10-May-2021SourceRBARBARBARBA10-May-2021FXRTWI10-May-2021FXRCR10-May-2021FXRJY10-May-2021Series IDFXRUSDFXREUR08-Apr-20190.709460.704.767179.050.631809-Apr-201910-Apr-201911-Apr-201912-Apr-201915-Apr-201916-Apr-201917-Apr-201918-Apr-201923-Apr-201924-Apr-201926-Apr-201929-Аpr-201930-Apr-201901-May-201902-May-201903-May-201906-May-201907-May-201908-May-201909-May-201910-May-201913-Мay-201914-May-201915-May-201916-May-201917-May-201920-Мay-201921-Мay-201922-Мay-201923-May-201924-May-201927-May-20190.713661.004.791679.450.63350.714461.004.797179.420.63420.716361.204.809279.570.63490.713261.004.793279.730.63190.716861.204.807880.220.63390.714761.104.795680.000.63220.720061.504.819880.640.63650.718361.404.807980.360.63560.712161.004.782079.710.63300.703960.404.731578.720.62760.702560.404.729878.460.63060.705660.604.748578.760.63240.703960.504.744278.500.62970.705460.604.750878.640.62880.702060.304.727978.320.62650.699860.104.713178.020.62640.698960.104.739477.420.62450.703460.504.767477.820.62710.702360.404.754377.290.62680.697660.104.746776.690.62300.699560.204.759876.760.62300.697660.204.782176.550.62120.695560.104.780776.260.61890.693260.004.766576.040.61830.691459.8059.704.755975.690.61680.68814.752875.440.61590.692060.104.782976.220.62050.687859.704.750275.770.61670.687559.804.752875.930.61650.687659.804.753775.840.61670.688859.804.761275.500.61590.693760.004.780275.950.618828-Mav-20190.692960.104.785275.900.6194

Using Excel, Enter the data as given below, Series ID USD AUD CNY JPY EUR…

Answered: Calculate Descriptive statistics of…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Concept explainers

Question

Calculate Descriptive statistics of logarithmic returns such as Mean, Median, Minimum, Maximum, Standard deviation, Skewness, Kurtosis of AUD, USD, CNY, JPY and EUR.

probability plot of USD, CNY, JPY and EUR returns.

I have an excel sheet don't know how to upload it along with the question. As it is giving the option to upload images only. However, have emailed to bartebly email.

Title
A$1=USD
Trade-weighted Index May 1970 = 100
AS1=CNY
A$1=JPY
A$1=EUR
A
Description
Frequency
|Туре
AUD/USD Exchange Rate; Australian Dollar Trade-weighted Index AUD/CNY Exchange Rate AUDIJPY Exchange Rate AUDIEUR Exchange Rate A
Daily
Daily
Daily
Daily
Daily
D
Indicative
Indicative
Indicative
Indicative
Indicative
In
Units
USD
Index
CNY
JPY
EUR
K
WM/Reuters
Publication date 10-May-2021
Source
RBA
RBA
RBA
RBA
10-May-2021
FXRJY
10-May-2021
10-May-2021
10-May-2021
Series ID
EXRUSD
FXRTWI
FXRCR
FXREUR
F.
20-Feb-2019
0.7163
61.00
4.8155
79.37
0.6314
21-Feb-2019
0.7162
61.00
4.7952
79.35
0.6310
22-Feb-2019
0.7093
60.50
4.7736
78.58
0.6257
25-Feb-2019
0.7144
60.80
4.7776
79.06
0.6300
26-Feb-2019
0.7159
60.90
4.7950
79.33
0.6303
27-Feb-2019
0.7183
61.00
4.8072
79.44
0.6314
28-Feb-2019
0.7146
60.70
4.7745
79.23
0.6281
01-Mar-2019
0.7093
60.40
4.7510
79.21
0.6236
04-Mar-2019
0.7095
60.50
4.7468
79.44
0.6243
05-Mar-2019
0.7076
60.40
4.7429
79.18
0.6245
06-Mar-2019
0.7035
60.10
4.7241
78.63
0.6226
07-Mar-2019
0.7049
60.20
4.7299
78.73
0.6236
08-Mar-2019
0.7009
60.00
4.7110
77.97
0.6259
11-Mar-2019
0.7044
60.20
4.7353
78.28
0.6270
12-Mar-2019
0.7069
60.30
4.7459
78.71
0.6282
13-Mar-2019
0.7055
60.20
4.7340
78.52
0.6252
14-Mar-2019
0.7059
60.20
4.7374
78.78
0.6237
15-Mar-2019
0.7081
60.50
4.7581
79.09
0.6256
18-Mar-2019
0.7115
60.60
4.7764
79.35
0.6276
19-Mar-2019
0.7105
60.50
4.7716
79.06
0.6262
20-Mar-2019
0.7075
60.30
4.7499
78.95
0.6236
21-Mar-2019
0.7145
60.60
4.7741
78.95
0.6253
22-Mar-2019
0.7106
60.50
4.7646
78.72
0.6245
25-Mar-2019
0.7079
60.30
4.7528
77.85
0.6266
26-Mar-2019
0.7122
60.60
4.7782
78.38
0.6296
27-Mar-2019
0.7101
60.60
4.7686
78.54
0.6308
28-Mar-2019
0.7097
60.60
4.7759
78.19
0.6306
29-Mar-2019
0.7087
60.50
4.7659
78.49
0.6310
01-Apr-2019
02-Apr-2019
03-Apr-2019
04-Apr-2019
05-Apr-2019
08-Apr-2019
0.7121
60.80
4.7755
79.06
0.6339
0.7080
60.50
4.7582
78.84
0.6320
0.7106
60.70
4.7693
79.13
0.6332
0.7111
60.70
4.7748
79.22
0.6325
0.7125
60.90
4.7859
79.59
0.6346
0.7094
60.70
4.7671
79.05
0.6318

Title
A$1=USD
Trade-weighted Index May 1970 = 100
A$1=CNY
A$1=JPY
A$1=EUR
Description
Frequency
Туре
AUD/USD Exchange Rate; Australian Dollar Trade-weighted Index AUD/CNY Exchange Rate AUDIJPY Exchange Rate AUD/EUR Exchange Rate
Daily
Daily
Daily
Daily
Daily
Indicative
Indicative
Indicative
Indicative
Indicative
Units
USD
Index
CNY
JPY
EUR
WM/Reuters
Publication date 10-May-2021
Source
RBA
RBA
RBA
RBA
10-May-2021
FXRTWI
10-May-2021
FXRCR
10-May-2021
FXRJY
10-May-2021
Series ID
FXRUSD
FXREUR
08-Apr-2019
0.7094
60.70
4.7671
79.05
0.6318
09-Apr-2019
10-Apr-2019
11-Apr-2019
12-Apr-2019
15-Apr-2019
16-Apr-2019
17-Apr-2019
18-Apr-2019
23-Apr-2019
24-Apr-2019
26-Apr-2019
29-Аpr-2019
30-Apr-2019
01-May-2019
02-May-2019
03-May-2019
06-May-2019
07-May-2019
08-May-2019
09-May-2019
10-May-2019
13-Мay-2019
14-May-2019
15-May-2019
16-May-2019
17-May-2019
20-Мay-2019
21-Мay-2019
22-Мay-2019
23-May-2019
24-May-2019
27-May-2019
0.7136
61.00
4.7916
79.45
0.6335
0.7144
61.00
4.7971
79.42
0.6342
0.7163
61.20
4.8092
79.57
0.6349
0.7132
61.00
4.7932
79.73
0.6319
0.7168
61.20
4.8078
80.22
0.6339
0.7147
61.10
4.7956
80.00
0.6322
0.7200
61.50
4.8198
80.64
0.6365
0.7183
61.40
4.8079
80.36
0.6356
0.7121
61.00
4.7820
79.71
0.6330
0.7039
60.40
4.7315
78.72
0.6276
0.7025
60.40
4.7298
78.46
0.6306
0.7056
60.60
4.7485
78.76
0.6324
0.7039
60.50
4.7442
78.50
0.6297
0.7054
60.60
4.7508
78.64
0.6288
0.7020
60.30
4.7279
78.32
0.6265
0.6998
60.10
4.7131
78.02
0.6264
0.6989
60.10
4.7394
77.42
0.6245
0.7034
60.50
4.7674
77.82
0.6271
0.7023
60.40
4.7543
77.29
0.6268
0.6976
60.10
4.7467
76.69
0.6230
0.6995
60.20
4.7598
76.76
0.6230
0.6976
60.20
4.7821
76.55
0.6212
0.6955
60.10
4.7807
76.26
0.6189
0.6932
60.00
4.7665
76.04
0.6183
0.6914
59.80
59.70
4.7559
75.69
0.6168
0.6881
4.7528
75.44
0.6159
0.6920
60.10
4.7829
76.22
0.6205
0.6878
59.70
4.7502
75.77
0.6167
0.6875
59.80
4.7528
75.93
0.6165
0.6876
59.80
4.7537
75.84
0.6167
0.6888
59.80
4.7612
75.50
0.6159
0.6937
60.00
4.7802
75.95
0.6188
28-Mav-2019
0.6929
60.10
4.7852
75.90
0.6194

Definition Definition Middle value of a data set. The median divides a data set into two halves, and it also called the 50th percentile. The median is much less affected by outliers and skewed data than the mean. If the number of elements in a dataset is odd, then the middlemost element of the data arranged in ascending or descending order is the median. If the number of elements in the dataset is even, the average of the two central elements of the arranged data is the median of the set. For example, if a dataset has five items—12, 13, 21, 27, 31—the median is the third item in ascending order, or 21. If a dataset has six items—12, 13, 21, 27, 31, 33—the median is the average of the third (21) and fourth (27) items. It is calculated as follows: (21 + 27) / 2 = 24.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 4 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

$Point Estimation, Limit Theorems, Approximations, and Bounds$

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.