Find the sample correlation coefficient for the data

Assignment Help Finance Basics

Reference no: EM133290542

Case: Treasury bills (T-bill) and inflation. When inflation is high, lenders require higher interest rates to make up for the loss of purchasing power of their money while it is loaned out.

The Excel file displays the return for six-month Treasury bills (annualized) and the rate of inflation as measured by the change in the government's Consumer Price Index in the same year. An inflation rate of 5% means that the same set of goods and services costs 5% more. The data cover 70 years, from 1952 to 2022.

Excel will be used to run Regression analysis for predicting T-bill return from inflation rate. α = 0.01

Provide Excel Output

Question 1. Indicate which variable is the dependent and which is the independent variable

Question 2. Using Excel, graph a scatterplot of the return on T-bill against the rate of inflation the same year.

Question 3. Find the sample correlation coefficient for the data. (Pearson correlation coefficient between T-bill, y and the rate of inflation, x).

Question 4. Give a brief description of the form, direction, and strength of the relationship between the inflation rate and the return on T-bill.

Question 5. What is the equation of the least-squares regression line for predicting T-bill return? What is the intercept (a) and slope (b) values of the regression formula, = a + bx for predicting T-bill return from the inflation rate? Write the formula replacing a and b by their respective numerical values.

Question 6. What is the predicted return on T-bill with 4.5% rate of inflation?

Question 7. What amount of the variance in T-bill (y) do the inflation rate (x) account for this sample? (R2 =?) Interpret the result in the context of the data.

Question 8. What is the unexplained variation in T-bill that is not related to the inflation rate?

Question 9. Write out the null and alternative hypotheses and conduct a hypothesis testing for the data. Do these data indicate there is a significant relationship between Treasury-bills and inflation rate? Test this relationship at 1% significance level. State the values used to help determine your answer. Briefly explain how you reach this conclusion.

Question 10. Would you conclude that inflation rate is a good predictor of Treasury-bills based upon this sample? What evidence do you have to support your conclusion?

Reference no: EM133290542

Questions Cloud

Why you think a certain country is cheaper : Why you think a certain country is cheaper or more expensive. What other factors may be involved in these high or low prices

How much would you pay for a firm : How much would you pay for a firm that generates $5 million in free cash flow a year under worst case scenario projections and is able to finance the debt

Describe the nature of primers dna or rna : Primers are required for DNA synthesis in cells and by people doing PCR or DNA sequencing. Describe the nature of such primers (DNA or RNA).

How long will it take the fund to earn : BA 581 University of Michigan how long will it take the Fund to earn its year-to-date result if interest rates remain unchanged in the future

Find the sample correlation coefficient for the data : FIN 330 University of Illinois, Chicago Find the sample correlation coefficient for the data. (Pearson correlation coefficient between T-bill, y and the rate

Discuss pathogen modes of transmission-acquisition : For each pathogen consider the modes of transmission/acquisition and risk factors for contracting the disease caused by each agent;

How you chose to guess the values you guessed : MA 577 Boston University write down which volatilities you guessed and what the prices of call options would be for those guesses. Explain how you chose

What type of study design is this : We then sent a series of 4 surveys to the adolescent(s) in that household quarterly from November 2022 to December 2023. In this statement, what type of study

What is his maximum credit for other dependents : ACCT 308 San Francisco State University Juan provided more than half of their support. His AGI is $195,000. What is his maximum credit for other dependents

User Account

All Pages