
Volatility Calculation

Quiz
•
Mathematics
•
Professional Development
•
Medium
kanhu bhuyan
Used 1+ times
FREE Resource
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the first step to calculate volatility using Excel?
Calculate the average
Calculate the deviation
Calculate the square root of variance
Download the historical closing prices
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function in Excel is used to calculate the standard deviation of daily returns?
AVERAGE
SUM
STDEV
LN
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the approximate equation to calculate daily returns?
Return = (Ending Price / Beginning Price) - 1
Return = LN (Ending Price / Beginning Price)
Return = SQRT (Ending Price / Beginning Price)
Return = (Ending Price - Beginning Price) / Beginning Price
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How can you download historical closing prices from NSE India website?
Click on historical data and select the search option
Click on download file in CSV format
Fill in the required details and hit 'Get Data'
All of the above
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of calculating standard deviation manually in the previous chapter?
To show the mechanics behind the calculation
To demonstrate the use of Excel functions
To compare with NSE's calculation
To calculate annual volatility
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the daily volatility of WIPRO calculated using Excel?
0.0147%
1.47%
23.33%
25.5%
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How can you calculate the daily log returns of WIPRO in Excel?
Use the function SQRT
Use the function SUM
Use the function LN
Use the function AVERAGE
Create a free account and access millions of resources
Similar Resources on Wayground
15 questions
Levels of Measurement Quiz

Quiz
•
Professional Development
15 questions
Theoretical Limits in Math

Quiz
•
Professional Development
11 questions
Profit & Loss

Quiz
•
Professional Development
15 questions
Mathematics in Daily Life Quiz

Quiz
•
Professional Development
20 questions
SAAS_Money 2

Quiz
•
Professional Development
15 questions
Basic percents grade 7

Quiz
•
Professional Development
12 questions
Math revision for final

Quiz
•
4th Grade - Professio...
12 questions
Volume and prisms

Quiz
•
2nd Grade - Professio...
Popular Resources on Wayground
10 questions
Video Games

Quiz
•
6th - 12th Grade
20 questions
Brand Labels

Quiz
•
5th - 12th Grade
15 questions
Core 4 of Customer Service - Student Edition

Quiz
•
6th - 8th Grade
15 questions
What is Bullying?- Bullying Lesson Series 6-12

Lesson
•
11th Grade
25 questions
Multiplication Facts

Quiz
•
5th Grade
15 questions
Subtracting Integers

Quiz
•
7th Grade
22 questions
Adding Integers

Quiz
•
6th Grade
10 questions
Exploring Digital Citizenship Essentials

Interactive video
•
6th - 10th Grade