Enable contrast version

# Tutor profile: Philip L.

Philip L.
Bachelor's in Finance, Current Budget Analyst for the State of California

## Questions

### Subject:Microsoft Excel

TutorMe
Question:

Calculate Average, Variance, and St. Dev. for WDC using Historical Data Analysis Make sure to use the full step by step calculation process for Variance You can use build in =average(…) function to find average ---- Calculate Average, Variance, and St. Dev. for WDC using Scenario Analysis Scenario Probability E ( R ) Average Variance Boom 0.1 22% 0.022 0.0021609 Growth 0.5 12% 0.06 0.0011045 Slow Down 0.3 2% 0.006 0.0008427 Recession 0.1 -15% -0.015 0.0049729 Average 7.30% Variance 0.00908100 STDev 9.53% ---- Use the following historical data to analyze 2-security portfolio. Create 'drop down' menu and use LOOKUP command so you can choose any 2 securities for the analysis. Construct Opportunity Set Table. Identify Optimal Risky Portfolio. Create Opportunity Set Graph with Opportunity Set, each one of the two securities labeled, and Capital Asset Line on it. -----

Philip L.

Date WDC Variance 1/1/2018 -2.18% 0.000941092 12/1/2017 12.58% 0.01366589 11/1/2017 0.85% 1.43244E-07 10/1/2017 -11.66% 0.015746991 9/1/2017 3.91% 0.000911969 8/1/2017 -2.12% 0.000903577 7/1/2017 3.70% 0.000791408 6/1/2017 -3.40% 0.001839863 5/1/2017 -1.62% 0.000629306 4/1/2017 1.11% 5.01851E-06 3/1/2017 8.60% 0.005945901 Average 0.89% Variance= 0.04138116 Standard Dev 20.34% ---- Scenario Probability E ( R ) Average Variance Boom 0.1 22% 0.022 0.0021609 Growth 0.5 12% 0.06 0.0011045 Slow Down 0.3 2% 0.006 0.0008427 Recession 0.1 -15% -0.015 0.0049729 Average 7.30% Variance 0.00908100 STDev 9.53% --- Column # 1 2 3 4 5 6 Returns Row # 'Drop Down' Menu Portfolio Opportunity Set Date WDC AAPL WFC VZ BIIB PG PCG CVX 1 Date AAPL WFC Sharpe Ratio W1 W2 R ( P ) Var (P) St. Dev. (P) 2/1/2018 -2.18% 6.38% -11.20% -10.70% -16.91% -8.36% -3.16% -10.71% 2 2/1/2018 6.38% -11.20% 0.4110 1.0 0.0 2.80% 0.0040799 6.39% 1/1/2018 12.58% -1.06% 8.42% 2.15% 9.18% -6.03% -5.35% 0.13% 3 1/1/2018 -1.06% 8.42% 0.4409 0.9 0.1 2.62% 0.0030903 5.56% 12/1/2017 0.85% -1.17% 8.19% 4.01% -1.12% 2.10% -17.35% 6.20% 4 12/1/2017 -1.17% 8.19% 0.4719 0.8 0.2 2.45% 0.0023273 4.82% 11/1/2017 -11.66% 1.66% 0.59% 7.58% 3.37% 5.01% -6.11% 2.67% 5 11/1/2017 1.66% 0.59% 0.4968 0.7 0.3 2.27% 0.0017907 4.23% 10/1/2017 3.91% 9.68% 1.80% -3.27% -0.47% -5.10% -14.49% -1.37% 6 10/1/2017 9.68% 1.80% 0.5011 0.6 0.4 2.10% 0.0014806 3.85% 9/1/2017 -2.12% -5.66% 8.77% 3.17% -1.09% -1.40% -3.25% 10.28% 7 9/1/2017 -5.66% 8.77% 0.4693 0.5 0.5 1.93% 0.0013969 3.74% 8/1/2017 3.70% 10.27% -5.32% 0.41% 9.31% 2.39% 3.97% -1.44% 8 8/1/2017 10.27% -5.32% 0.4026 0.4 0.6 1.75% 0.0015397 3.92% 7/1/2017 -3.40% 3.27% -2.65% 8.37% 6.72% 4.21% 2.80% 4.66% 9 7/1/2017 3.27% -2.65% 0.3217 0.3 0.7 1.58% 0.0019090 4.37% 6/1/2017 -1.62% -5.33% 9.11% -4.25% 9.52% -1.07% -2.94% 1.85% 10 6/1/2017 -5.33% 9.11% 0.2460 0.2 0.8 1.40% 0.0025048 5.00% 5/1/2017 1.11% 6.34% -5.01% 2.80% -8.64% 1.64% 1.98% -3.02% 11 5/1/2017 6.34% -5.01% 0.1833 0.1 0.9 1.23% 0.0033270 5.77% 4/1/2017 8.60% -0.01% -3.27% -5.83% -0.81% -2.80% 1.78% -0.62% 12 4/1/2017 -0.01% -3.27% 0.1335 0.0 1.0 1.06% 0.0043757 6.61% 3/1/2017 7.35% 5.32% -3.18% -1.77% -5.26% -1.34% -0.58% -3.65% 13 3/1/2017 5.32% -3.18% 2/1/2017 -3.57% 12.89% 2.75% 2.35% 4.10% 4.79% 7.85% 1.03% 14 2/1/2017 12.89% 2.75% ORP 0.5011 0.6 0.4 2.10% 0.00148057 3.85% 1/1/2017 18.18% 4.77% 2.21% -8.19% -3.66% 4.19% 2.67% -5.40% 15 1/1/2017 4.77% 2.21% 12/1/2016 6.74% 5.33% 5.01% 6.97% -2.14% 1.96% 3.35% 6.56% 16 12/1/2016 5.33% 5.01% 11/1/2016 8.93% -2.66% 15.02% 4.93% 4.96% -4.27% -5.34% 6.50% 17 11/1/2016 -2.66% 15.02% 10/1/2016 0.81% 0.43% 3.91% -7.46% -10.49% -3.29% 2.35% 1.78% 18 10/1/2016 0.43% 3.91% 9/1/2016 25.28% 7.13% -12.13% -0.67% 2.42% 2.79% -1.24% 3.40% 19 9/1/2016 7.13% -12.13% 8/1/2016 -1.77% 1.81% 5.90% -4.61% 5.42% 2.81% -3.13% -1.85% 20 8/1/2016 1.81% 5.90% 7/1/2016 1.68% 9.01% 1.35% -0.77% 19.89% 1.09% 0.81% -2.24% 21 7/1/2016 9.01% 1.35% 6/1/2016 1.55% -3.68% -5.97% 9.71% -16.54% 4.48% 6.39% 4.89% 22 6/1/2016 -3.68% -5.97% 5/1/2016 13.87% 6.53% 1.48% 0.98% 5.36% 1.98% 3.23% -1.15% 23 5/1/2016 6.53% 1.48% 4/1/2016 -12.58% -13.99% 3.35% -5.81% 5.64% -2.66% -1.78% 7.11% 24 4/1/2016 -13.99% 3.35% 3/1/2016 8.52% 13.33% 3.87% 6.60% 0.35% 2.52% 5.27% 15.78% 25 3/1/2016 13.33% 3.87% 2/1/2016 -9.27% -0.67% -6.59% 2.77% -5.00% -0.86% 3.31% -3.50% 26 2/1/2016 -0.67% -6.59% Summary Statistics AAPL WFC Average 2.80% 1.06% Variance 0.0040799 0.0043757 St. Dev. 6.39% 6.61% Covariance -0.001434 Rf 0.173% 0 In general formulas I'm familiar with: Vlookup, IF statements, some macros, pivot tables, speeding up efficiency using formulas, Statistical Analysis formulas, tables, graphs, etc.

### Subject:English

TutorMe
Question:

Compare and contrast the poems ""God's Grandeur" and "i thank You God for most this amazing".

Philip L.

### Subject:Algebra

TutorMe
Question:

Find f(a), f(a+h), and the difference quotient (f(a+h)-f(a))/h, where h ≠ 0. f(X) = 8-9x f (a) = ? f (a+h) = ? (f(a+h) - f(a))/h = ?

Philip L.

f (a) = 8-9(a) = -9a+8 *multiplied -9 * a On the step above, "a" must be plugged in for "x" to get f(a). ------------------------------------------------------------------------------------------------------ f (a+h) = 8-9(a+h) = 8 - 9a - 9h * Used the distributive property to distribute the -9 to a and h = -9a - 9h + 8 *reordered for clarity On the steps above, a+h must be plugged in for x to get f(a+h). ------------------------------------------------------------------------------------------------------ (f(a+h) - f(a))/h = ? Given that we've already solved a+h and f(a), we can plug in our existing answers into the difference quotient formula. ((-9a - 9h + 8) - (-9a + 8))/h (-9a - 9h + 8) + 9a - 8) / h * distributed negative sign over -9a + 8 ((-9a + 9a) - 9h + (8 - 8))/h *simplify like terms -9h/h *divide h/h -9 is the answer.

## FAQs

What is a lesson?
A lesson is virtual lesson space on our platform where you and a tutor can communicate. You'll have the option to communicate using video/audio as well as text chat. You can also upload documents, edit papers in real time and use our cutting-edge virtual whiteboard.
How do I begin a lesson?
If the tutor is currently online, you can click the "Start Lesson" button above. If they are offline, you can always send them a message to schedule a lesson.
Who are TutorMe tutors?
Many of our tutors are current college students or recent graduates of top-tier universities like MIT, Harvard and USC. TutorMe has thousands of top-quality tutors available to work with you.
BEST IN CLASS SINCE 2015
TutorMe homepage