Below You Are Given a Partial Excel Output Based on a Sample

question 22

Essay

Below you are given a partial Excel output based on a sample of 30 days of the price of a company's stock (y in dollars), the Dow Jones industrial average (x₁), and the stock price of the company's major competitor (x₂ in dollars).
a.Use the output shown above and write an equation that can be used to predict the price of the stock.
b.If the Dow Jones Industrial Average is 2650 and the price of the competitor is $45, what would you expect the price of the stock to be?
c.At $\alpha$ = 0.05, test to determine if the Dow Jones average is a significant variable.
d.At $\alpha$ = 0.05, test to determine if the stock price of the major competitor is a significant variable.

Analyze the effects of changing conditions such as interest rates and compounding frequencies on the growth of investments and the repayment of loans.

Understand the concept of the time value of money and its application in calculating present and future values of various financial instruments.

Differentiate between General Annuity and Annuity Due and understand their financial implications.

Calculate the future value and interest earned on investments with periodic contributions and compounding interest.

---

Definitions:

Phenol

An aromatic organic compound with the formula C6H5OH, used as an antiseptic and a raw material in the synthesis of plastics.

Molecular Formula

A notation used in chemistry to show the types and numbers of atoms combined in a single molecule of a chemical compound.

Solute Dissolves

The process by which a solute integrates into a solvent, forming a solution, typically at a molecular level.

Dissolution

The process by which a solid, liquid, or gas forms a solution in a solvent, essentially becoming incorporated into the solvent.