Course: ECON2040 (Quantitative economics) Prepare an Excel file describing T-bill (6-months) and Inflation rate (in percent) during 190-2020 using Table 12.1 and participation assignment 9. Then answ

Course: ECON2040 (Quantitative economics) Prepare an Excel file describing T-bill (6-months) and Inflation rate (in percent) during 190-2020 using Table 12.1 and participation assignment 9. Then answ
Participation Assignment 9 Worth: 5 points Review “ Treasury bills and inflat ion ” on page 585 – 586, and replicate exercise 12.8 – 12.10 and 12.31 using data 1980 – 2020. Prepare a excel file with three columns : year, t – bill percent, and inflation percent. Input 19 80 – 2017 data from Table 12.1 (page 585 , also attached end of the assignment ) and update the table with following information’s : Table 12.1 Return on Treasury bills and rate of inflation (continued) Year T – bill percent I nflation percent 1980 11.32 12.50 2018 1.75 1.9 2019 2.57 2.3 2020 1.59 1.4 Q1 (1 points) Prepare an excel file having 6 – months t – bill and inflation rate cov ering 1 980 – 2020. Look at the data using summary statistics table (report mean. M edian, std, min, max ) . Review th e 12.8 question and replicate same thing using the data from 1980 – 2020 . Inse rt your data as appendi x tables with your assignment. Q2 (1 points) Is there a relationship? Review the 12.9 question and replicate the same result s and interpret your finds using the data from 1980 – 2020 . Show the relationship using graph then comments. [Tips: summary table, scatter plot, and regression equation] Q3 (1 points) Estimating the slope. Review the 12. 10 question and replicate the same result s and interpret your finds using the data from 1980 – 2020 . Copy your regression output th e n comments . Q4. ( 2 points) Based on the regression output from Q3, answer the followings : a. The intercept ! ! in the regression model is meaningful in this example. Explain what ! ! represents . Why should we expec t ! ! to be greater than 0? Is there sufficient evidence that ! ! is greater than 0? b. F in d the sample correlation r . From r , calculate the t – statistic for testing correlati on . What are the degrees of freedom? Verify that your t – statistic for correlation calculated in part ( b ) has same value as the t for slope in the regression output on Q3. [Tips: Review Example 12.6 on page 588] . c. Those you are using 4 th edition; you can see next three pages p resented required information to solve this assignment.