he data on sheet #2 represents data various economic factors. We want to use a subset of...

he data on sheet #2 represents data various economic factors. We want to use a subset of the remaining variables to predict Interest Rates on US Treasury Bonds (Interest). Construct a table of correlations and chose the two variables that have the strongest correlation to Interest and build a multiple regression model from those variables. Write your regression equation, value, and the meaning of each variable used. State the overall hypothesis test for your model

CRUDE	FOREIGN	DJIA	GNP	PURCHASE	CONSUMER	INTEREST
10.9	31	974.9000244	1718	1.756999969	234.3999939	7.61
12	35	894.5999756	1918	1.649000049	263.7999878	7.42
12.5	42	820.2000122	2164	1.531999946	308.2999878	8.41
17.7	54	844.4000244	2418	1.379999995	347.5	9.439999
28.1	83	891.4000244	2732	1.215000033	349.3999939	11.46
35.6	109	932.9000244	3053	1.09800005	366.6000061	13.91
31.8	125	884.4000244	3166	1.034999967	381.1000061	13
29	137	1190.300049	3406	1	430.3999939	11.11
28.6	165	1178.5	3772	0.961000025	511.7999878	12.44
26.8	185	1328.199951	4015	0.927999973	592.4000244	10.62
14.6	209	1792.800049	4240	0.912999988	646.0999756	7.68
17.9	244	2276	4527	0.879999995	685.5	8.38

Expert Solution

For the given data , the correlation table is shown below:

	CRUDE	FOREIGN	DJIA	GNP	PURCHASE	CONSUMER	INTEREST
CRUDE	1
FOREIGN	0.304276	1
DJIA	-0.14611	0.861947	1
GNP	0.374804	0.991314	0.806587	1
PURCHASE	-0.61967	-0.91289	-0.60792	-0.95052	1
CONSUMER	0.152951	0.973337	0.883626	0.969579	-0.85455	1
INTEREST	0.969381	0.152756	-0.30097	0.227549	-0.48812	0.003861	1

The two variables that have the strongest correlation to Interest are CRUDE & PURCHASE.

Therefore the multiple regression analysis summary using this variable is given below:

SUMMARY OUTPUT

Regression Statistics
Multiple R	0.979934
R Square	0.960271
Adjusted R Square	0.951442
Standard Error	0.501724
Observations	12

ANOVA
	df	SS	MS	F	Significance F
Regression	2	54.75873	27.37936	108.7661	4.97E-07
Residual	9	2.265542	0.251727
Total	11	57.02427

	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
Intercept	2.259987	1.126809	2.005653	0.075858	-0.28903	4.809005	-0.28903	4.809005
CRUDE	0.282557	0.022094	12.78899	4.47E-07	0.232577	0.332537	0.232577	0.332537
PURCHASE	1.348011	0.624444	2.158737	0.059189	-0.06458	2.760602	-0.06458	2.760602

The regression equation is,

The increase a CRUDE by a unit will increase the Interest by 0.282557 units ,when other variable remain constant.

The increase a PURCHASE by a unit will increase the Interest by 1.348011 units ,when other variable remain constant.

For overall hypothesis test,

The p-value of F is quite small which is 0.000000497 . so we have sufficient evidence to reject the null hypothesis .

Hence the at lest of the the slope parameter is not equal to zero.

orchestra answered 3 years ago

Using the Framingham Data Subset: Question 01 What inferential test do we use to investigate an...

Using the Framingham Data Subset: Question 01 What inferential test do we use to investigate an association between two categorical variables? Question 02 Use the test you identified in #1 above to test for independence between GENDER and CHD (use alpha = .05). What are your null and alternative hypotheses? What are your test statistic and corresponding distribution? Write your answer here. What are your degrees of freedom? Calculate your test statistic. Write your answer here. What is your decision?...

If we want to divide Asia into economic systems (economic groups), what is the best division,...

If we want to divide Asia into economic systems (economic groups), what is the best division, for example (East Asia, the Gulf, etc.) I hope for help ؟ What is the best division?

Use the data given in the table to answer the following questions. The data represents the...

Use the data given in the table to answer the following questions. The data represents the average number of miles that a salesperson travels in a day verses the number of sales made each month. Miles, x 24 32 75 41 76 107 32 46 112 Sales, y 76 58 190 112 141 235 24 147 188 (a) What is the value of the correlation coefficient for this set of data? Round to 3 decimal places. (b) What is the...

Suppose that we are interested in factors influencing young children’s attention to television. Specifically, we want...

Suppose that we are interested in factors influencing young children’s attention to television. Specifically, we want to test the amount of attention that children pay to television depends upon the degree of their understanding of the programming. We randomly sample 50 young children and have them watch a 60-minute program judged “easy” to understand, and have another random sample of 40 young children watch a 60-minute program judged “difficult” to understand. On average, children who watched the easy program attended...

Use the chart of data below to answer the following questions. This data represents enrollment for...

Use the chart of data below to answer the following questions. This data represents enrollment for the Fall semesters 2013 – 2017 years. Part a: Is being part time dependent upon gender? Part b: Is the probability of being a male student enrolled (or female) dependent upon year? Part c: Create a probability tree, with the appropriate probabilities using the data from the table. Assume the tree is showing the PT or FT probabilities given the gender of the student....

Let b be a parameter we want to estimate. We collect the data, and calculate an...

Let b be a parameter we want to estimate. We collect the data, and calculate an estimator for b using the data. What does it mean for this estimator to be unbiased? choose one correct answer. 1. The variance of the estimator decays to zero as we collect more and more data in the calculation. 2. The covariance between b and the estimator equals zero. 3. Th estimator becomes closer and closer to b as we collect more and more...

If we want to assess changes in the real economic activity in an economy, why do...

If we want to assess changes in the real economic activity in an economy, why do we use changes in real GDP for finding an answer, instead of changes in nominal GDP?

There is no doubt we all have some strategies or techniques we use when we want...

There is no doubt we all have some strategies or techniques we use when we want to persuade others. There is something you want...or something you want someone to do. Maybe you're trying to change someone's opinion or the way they think. What is your preferred technique or strategy? Why does it work for you? Will it work in a formal persuasive speech? You already use persuasive techniques...let's talk about them.

Compare and contrast the use of various economic models to explain the role of economics in...

Compare and contrast the use of various economic models to explain the role of economics in healthcare and how the concept of the market equilibrium works in healthcare.

A manager is working in a Telecom company, what legal-political and economic factors he needs to...

A manager is working in a Telecom company, what legal-political and economic factors he needs to be aware of, in managing globally?

Question