Examlex

Solved

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

question 64

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 (x1), and the stock price of the company's major competitor (x2 in dollars).
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<sub>1</sub>), and the stock price of the company's major competitor (x<sub>2</sub> 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 <font face= symbol ></font> = 0.05, test to determine if the Dow Jones average is a significant variable. d.At <font face= symbol ></font> = 0.05, test to determine if the stock price of the major competitor is a significant variable.
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 = 0.05, test to determine if the Dow Jones average is a significant variable.
d.At = 0.05, test to determine if the stock price of the major competitor is a significant variable.


Definitions:

Functionalism

A theoretical framework in sociology and anthropology that views society as a complex system whose parts work together to promote solidarity and stability.

Dynamic System

A system characterized by constant change, activity, or progress, often used in reference to complex systems with various interdependent factors and variables.

Interrelated Parts

Components that are connected or related in such a way that changes in one part affect the others.

Proletariat

The class of wage-earners in a capitalist society, who, lacking substantial control over the means of production, sell their labor to live.

Related Questions