Reference no: EM131008435
VBA Programming homework:
1. A cosine can be approximated by the following infinite series:
cosx=1-(x2/2!)+(x4/4!)-(x6/6!)+...
Write a function that will calculate this for any x and y number of terms. If y > 85 or y is not a positive integer, return an error.
X
|
Y
|
Cos( x)
|
MyCosine (x,y)
|
Approximation error
|
0.31831
|
9
|
|
|
|
0.95493
|
9.5
|
|
|
|
1.27324
|
37
|
|
|
|
1.591549
|
65
|
|
|
|
2.228169
|
88
|
|
|
|
2. A hybrid linked note is an instrument that provides investors fixed income and equity market. It is structured by combining a return that is 75% equity and 25% fixed income. The investment pays the greater of the par value, $1,000, or the price times the 75% percentage increase in the S&P 500 plus 25% the return on the Barclays US Aggregate Index.
Write 2 functions (hlnPayoff, hlnReturn). The first, hlnPayoff, calculates the security payoff at maturity. The second, hlnReturn, calculates the annualized return assuming continuous compounding. The function hlnReturn should call the payoff function.
Price
|
Years
|
SP5000
|
SP5001
|
Barclay US Agg0
|
Barclay US Agg1
|
Payoff
|
Return
|
953
|
1
|
1783
|
1995
|
1810
|
1887
|
|
|
914
|
2
|
1298
|
1498
|
1909
|
1942
|
|
|
811
|
5
|
1288
|
1568
|
1710
|
1887
|
|
|
733
|
8
|
1335
|
1270
|
1612
|
1923
|
|
|
What are some extraneous variables
: Describe how you might design an experiment to determine whether this phenomenon is true for your city. What is the response variable? What are some extraneous variables and how does your design control for them?
|
Research new network observation tools
: Research new network observation tools that use enhanced techniques, such as virtual machine-based code execution, to detect unwanted network traffic (e.g., botnet activity or malware activity that is not detectable by traditional Anti-virus techniqu..
|
Problem regarding the fuel economy
: A company with a large fleet of cars hopes to keep gasoline costs down and sets a goal of attaining a fleet average of at least 26 miles per gallon. To see if the goal is being met, they check the gasoline usage for 50 company trips chosen at rand..
|
How to control their impulses recognize feelings of others
: Some students took part in a program beginning in elementary school in which teachers showed children how to control their impulses, recognize the feelings of others, and get what they want without aggressive behavior. Others did not participate i..
|
Vba programming homework
: VBA Programming homework: 1. A cosine can be approximated by the following infinite series: cosx=1-(x2/2!)+(x4/4!)-(x6/6!)+...
|
Write appropriate hypotheses
: The average age of online consumers a few years ago was 23.3 years. As older individuals gain con- fidence with the Internet, it is believed that the average age has increased. We would like to test this belief.
|
Footnote disclosures that would be necessary
: Manner of reporting the change under current generally accepted accounting principles including a discussion, where applicable, of how amounts are computed.
|
Null hypothesis of increased sleepwalking
: The manufacturer of a new sleeping pill suspects that it may increase the risk of sleepwalking, which could be dangerous. A test of the drug fails to reject the null hypothesis of increased sleepwalking when tested at alpha = .01.
|
How many mechanics would be at the counter
: How many mechanics would be at the counter, including being served and what probability that a mechanic would have to wait for service?
|