Enable contrast version

Tutor profile: Isaiah A.

Inactive
Isaiah A.
Excel expert, Finance, Stats, instructor with 7 years experience
Tutor Satisfaction Guarantee

Questions

Subject: Microsoft Excel

TutorMe
Question:

Describe how you would go about solving a linear optimization problem in Excel using solver

Inactive
Isaiah A.
Answer:

There are 3 components to a linear programming problem: Decision variables - what we're determining the quantities of (changing cells) Objective function - how decision variables affect value we're optimizing (min, max, or value of). Example: we could be maximizing profits, minimizing distances, and more. Constraints - how resources are used by decision variables (how far we can stretch resources). Step 1: In Excel, enter blank cells for decision variables, and write formulas to tie them into the constraints as well as the objective function. Step 2: Open solver. Go to the Data tab -> Data Analysis -> Solver. Step 3: - Point Excel to where objective function's formula is in the "Set Objective" line, then choose Max, Min, or Value of (depending on what the goal is). - Highlight decision variable cells as the Variable Cells - Lastly add each constraint and click solve! (Check to make sure the answer makes sense; it's a good way to catch mistakes).

Subject: Corporate Finance

TutorMe
Question:

Suppose that, on average, stock prices tend to overreact to an unexpected decline in company earnings: the company’s stock drops significantly on the announcement date; then, over the next few weeks, it “bounces back” somewhat, finally ending up lower than the price before the announcement. Describe an investment strategy that “beats the market” in this setting.

Inactive
Isaiah A.
Answer:

Purchase shares immediately after a firm makes a negative announcement then sell a few weeks later. On average, you’ll capture the bounce–back. However, you should note that prices won't fall as far on the announcement if many other investors employ this same strategy. In that case, the excess profits will disappear.

Subject: Statistics

TutorMe
Question:

A poll surveyed the public if they believed that a certain public official possessed honesty and integrity. 518 adults were surveyed and 233, or 0.45 of them answered yes. From this, can we conclude that only a minority (less than half) of the population answered yes?

Inactive
Isaiah A.
Answer:

Step 1. Determine the null and alternative hypotheses. Null hypothesis: There is no clear winning opinion on this issue; the proportions who would answer yes or no are each 0.50. Alternative hypothesis: Fewer than 0.50, or 50%, of the population would answer yes to this question. Step 2. Collect and summarize data into a test statistic. Sample proportion is: 233/518 = 0.45. Standard deviation = sqrt [(0.50 × (1 – 0.50)) / 518] = 0.022. Test statistic: z = (0.45 – 0.50)/0.022 = –2.27 Step 3. Determine the p-value. The alternative hypothesis was one-sided, therefore the p-value would be the portion of the bell-shaped curve to the left of -2.27. Looking on the Unit Normal table, this gives us a value of 0.0116. Step 4. Make a decision. The p-value of 0.0116 is less than 0.05, so we conclude that the proportion of people polled who believed this public official to be honest was significantly less than a majority.

Contact tutor

Send a message explaining your
needs and Isaiah will reply soon.
Contact Isaiah

Request lesson

Ready now? Request a lesson.
Start Lesson

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
Made in California by Zovio
© 2013 - 2021 TutorMe, LLC
High Contrast Mode
On
Off