# calculate the expected return

Learning Goal: I’m working on a data analytics discussion question and need an explanation and answer to help me learn.Chapter 5 Textbook problems # 25, 27, 29, 63
(“bivariate distribution” is the joint distribution)In problem #25, the joint distribution should be interpreted as:X503040Y800.2005000.5060000.3In problem #27 part d, solve for the covariance without using the information on Var(X+Y) (use the method taught in class)In problem #63, the covariance of -12.4 is in the unit %2.Using Excel, generate the graphs on slides 20, 22, 23, 24 of “lecture 4.pptx”. For this question you have to set up a spreadsheet that will allow you to plot the graphs I showed in the lecture. You have all the input parameters needed in the slides (slide 17). For example, for the graph on slide 20 you have to plot the expected return (formula on slide 19) vs. fraction f. Create a column for values of f from 0 to 1, and in the next column you calculate the expected return, then you plot the 2nd column vs the first. For example, the formula for the expected rate of return is E[W] = E[rate_boeing] * f + E[rate_GM] * (1-f) = 9.1 * f + 12.1 * (1-f). Then you have to plot that quantity vs. f when f varies from 0 to 1.
Requirements: 4 problems

Pages (275 words)
Standard price: \$0.00
Client Reviews
4.9
Sitejabber
4.6
Trustpilot
4.8
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Money Back