Use the following data to construct a scatter graph and

Reference no: EM13611651

Investment analysts generally believe the interest rate on bonds is inversely related to the prime interest rate for loans; that is, bonds perform well when lending rates are down and perform poorly when interest rates are up. Can the bond rate be predicted by the prime interest rate?

Use the following data to construct a scatter graph and then fit a regression line to the data. Report the regression formula and the r-squared value from the chart (right click on the line, select "Add Trendline" and select options to show these metrics).

Bond Rate: 5%, 12, 9, 15, and 7. Prime Interest Rate: 16%, 6, 8, 4, and 7.

Please answer the following Question:

1-) Can the bond rate be predicted by the prime interest rate?

2-) Using the data to construct a scatter graph and then fit a regression line to the data

3-) Report the regression formula and the r-squared value from the chart.

Please explain in detail to received 5 stars rating plus bonus.

Reference no: EM13611651

Questions Cloud

What is the propeller rotation rate in rpm what is the : a wind turbine of the 3-bladed propeller type having 50 efficiency generates 2 mwe when the wind speed is 14 ms. the

Tyco is a conglomerate organization that had 36 billion : tyco is a conglomerate organization that had 36 billion inrevenue. in a court trial it was alleged that the ceo of

A proton is located at the origin and a second proton is : a proton is located at the origin and a second proton is located on the x-axis at x 6.18 fm 1 fm 10-15 m.a calculate

Calculate the change that occurred in cash during the month : calculate the change that occurred in cash during the month. you may assume that the change in each balance sheet

Use the following data to construct a scatter graph and : investment analysts generally believe the interest rate on bonds is inversely related to the prime interest rate for

Q1 the following hazards were identified during an : q1 the following hazards were identified during an inspection of a chemical laboratoryi. burns from hot plates and

Afterward there are two objects one of which is a 6000 u : a 3.000 u 1 u 931.5 mevc2 object moving to the right through a laboratory at 0.8c collides with a 4.000 u object

Determine the length of the net force vector in inches and : draw an accurate sketch of the vector addition of the two known forces. use a protractor to draw the forces in the

Statement of financial position general purpose of the : general purpose of the statement of financial position. explain the terms asset liability and equity as defined by the

User Account

All Pages