Google's stock (GOOG) was tracked for 10 days, showing closing prices of 1,108.35; 1,132.5; 1,145.18; 1,129.33; 1,091.75; 1,102.85; 1,120.13; 1,127.46; 1,130.66; 1,110.45. Calculate the coefficient of variation of
Inverse Normal Distribution
The method used for finding the corresponding z-critical value in a normal distribution using the known probability is said to be an inverse normal distribution. The inverse normal distribution is a continuous probability distribution with a family of two parameters.
Mean, Median, Mode
It is a descriptive summary of a data set. It can be defined by using some of the measures. The central tendencies do not provide information regarding individual data from the dataset. However, they give a summary of the data set. The central tendency or measure of central tendency is a central or typical value for a probability distribution.
Z-Scores
A z-score is a unit of measurement used in statistics to describe the position of a raw score in terms of its distance from the mean, measured with reference to standard deviation from the mean. Z-scores are useful in statistics because they allow comparison between two scores that belong to different normal distributions.
Google's stock (GOOG) was tracked for 10 days, showing closing prices of 1,108.35; 1,132.5; 1,145.18; 1,129.33; 1,091.75; 1,102.85; 1,120.13; 1,127.46; 1,130.66; 1,110.45. Calculate the coefficient of variation of the dataset.
Obtain the coefficient of variation.
The coefficient of variation is obtained below as follows:
The formula to obtain the Coefficient of variation is,
Use EXCEL Procedure for mean and standard deviation for the given samples.
Follow the instruction to obtain the values of mean and SD:
- Open EXCEL
- Go to Data>Data Analysis.
- Choose Descriptive Statistics.
- Enter the input range as $A$1:$A$11.
- Check the Labels in the first row.
- Check the option Summary statistics
- Click OK.
EXCEL output:
From the EXCEL output, the value of mean is 1119.866 and the standard deviation is 16.21236
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 3 images
