3. Treasury bills (T-bill) and inflation. When inflation is high, lenders require higher interest rates to...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
3. 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 60 years, from 1958 to 2017. Excel will be used to run Regression analysis for predicting T-bill return from inflation rate. a = 0.05 (Round off each element from the output to three decimal places when reporting). Excel Output: 10 points a) Indicate which variable is the dependent and which is the independent variable. (2p) b) Using Excel, graph a scatterplot of the return on T-bill against the rate of inflation the same year. (3p) (Show scatterplot here) c) Find the sample correlation coefficient for the data. (Pearson correlation ficient between T-bill, y and the rate of inflation, x). (2p) d) Give a brief description of the form, direction, and strength of the relationship between the inflation rate and the return on T-bill. (2p) e) 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, 9 = a + bx for predicting T-bill return from the inflation rate? Write the formula replacing a and b by their respective numerical values. (5p) f) What is the predicted return on T-bill with 3% rate of inflation? (5p) g) 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. (3p . Name: h) What is the unexplained variation in T-bill that is not related to the inflation rate? (3p) i) 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 5% significance level. State the values used to help determine your answer. Briefly explain how you reach this conclusion. (5p) j) 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? (5p) 3. 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 60 years, from 1958 to 2017. Excel will be used to run Regression analysis for predicting T-bill return from inflation rate. a = 0.05 (Round off each element from the output to three decimal places when reporting). Excel Output: 10 points a) Indicate which variable is the dependent and which is the independent variable. (2p) b) Using Excel, graph a scatterplot of the return on T-bill against the rate of inflation the same year. (3p) (Show scatterplot here) c) Find the sample correlation coefficient for the data. (Pearson correlation ficient between T-bill, y and the rate of inflation, x). (2p) d) Give a brief description of the form, direction, and strength of the relationship between the inflation rate and the return on T-bill. (2p) e) 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, 9 = a + bx for predicting T-bill return from the inflation rate? Write the formula replacing a and b by their respective numerical values. (5p) f) What is the predicted return on T-bill with 3% rate of inflation? (5p) g) 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. (3p . Name: h) What is the unexplained variation in T-bill that is not related to the inflation rate? (3p) i) 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 5% significance level. State the values used to help determine your answer. Briefly explain how you reach this conclusion. (5p) j) 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? (5p)
Expert Answer:
Answer rating: 100% (QA)
a The independent variable is the rate of inflation and the dependent variable is the return for sixmonth Treasury bills b The scatterplot is shown below scatterplot c The sample correlation coefficie... View the full answer
Related Book For
Auditing and Assurance Services A Systematic Approach
ISBN: 978-0077732509
10th edition
Authors: William Messier Jr, Steven Glover, Douglas Prawitt
Posted Date:
Students also viewed these banking questions
-
Under what conditions is the loss of purchasing power on interest in the Fisher effect an important consideration?
-
Suppose the inflation rate in Canada, as measured by the CPI, has been averaging 3.5 percent in recent years. The most recent Bank of Canada announcement indicates that it expects 3-percent inflation...
-
A dependent variable is regressed on K independent variables, using n sets of sample observations. We denote SSE as the error sum of squares and R2 as the coefficient of determination for this...
-
How to get a good answer using data and analysis tools in jmp 1 uses the other variables to predict "passion." passion would need to be aggregated into high/low first, and then you can use logistic...
-
Blackford and Medford Publishing Company own the copyright on many top authors. In 2010, Blackford and Medford acquired the copyright on the literary works of Susan Monroe, an underground novelist in...
-
The Geneva Watch Corporation manufactures watches on a conveyor belt with six stations. One worker stands at each station and performs the following tasks: These six workers begin their workday at...
-
On December 31, 2020, Colgait Inc. had an installment sale receivable balance of \(\$ 90,000\) recognized on its financial statements, while the amount was not recognized for tax purposes. Colgait...
-
Churchill Co. uses a job order cost system. The following data summarize the operations related to production for November: a. Materials purchased on account, $ 528,000. b. Materials requisitioned, $...
-
Which one of the following 4 option combinations leads to a delta-neutral position? , which combination leads to the longest delta position? , which combination leads to the shortest delta...
-
Scenario: Suppose you are a risk management professional working for iManageRisk firm which is located in Melbourne. iManageRisk provides consulting services to firms such as airline companies and...
-
For the last year, Max Roller Pty Ltd has been exporting to Malaysia in order to supplement its declining Australian sales. Under the current arrangement, Max Roller sells 80,000 pairs of sunglasses...
-
Question 8 Firm X is an all-equity firm that has 250,000 shares of stock outstanding that trades at $35.00 per share. The company is borrowing $1.75 million at 5.75 percent interest to repurchase...
-
Problem 11-66 (Algo) Reciprocal Cost Allocation-Outsourcing a Service Department (LO 11-4, 5) Great Eastern Credit Union (GECU) has two operating departments (Branches and Electronic) and three...
-
1.Let's act as if your professor knows something about financial statement analysis and modeling and use his $475 intrinsic value price for Chipotle to recalculate the trailing price to earnings...
-
Selected current year-end financial statements of Cabot Corporation follow. (All sales were on credit; selected balance sheet amounts at December 31 of the prior year were inventory, $55,900; total...
-
An investment offers a total return of 14 percent over the coming year. Powell Arms thinks the total real return on this investment will be only 9 percent. What does Powell believe the inflation rate...
-
Revol Industries manufactures plastic bottles for the food industry. On average, Revol pays $76 per ton for its plastics. Revol's waste-disposal company has increased its waste-disposal charge to $57...
-
Namiki, CPA, is auditing the financial statements of Taylor Corporation for the year ended December 31, 2015. Namiki plans to complete the fieldwork and sign the auditor's report about March 10,...
-
Phung, CPA, has been engaged to audit the financial statements of Vernon Distributors, Inc., a continuing audit client, for the year ended September 30. After obtaining an understanding of Vernon's...
-
For each of the following cases, indicate why management and the auditors determined that the control deficiency was a material weakness. Case 1: In our assessment of the effectiveness of internal...
-
Utta Inc. allows each employee to earn 15 paid vacation days each year with full pay. Unused vacation time can be carried over to the next year. If not taken during the next year, unused vacation...
-
Bloy Company pays all salaried employees on a biweekly basis. Overtime pay, however, is paid in the following biweekly period. Bloy accrues salaries expense only at its December 31 year-end. Data...
-
Anne Taylor Company borrowed cash on August 1, 2020, and signed a \(\$ 33,300\) (face amount), one-year note payable, due on July 31, 2021. The accounting period of Anne Taylor ends December 31....
Study smarter with the SolutionInn App