Hi, this is the 5th time i am submitting this question and am unsure why it is being rejected as it does not go against the honor code. TripleABond.xlsx. The corporate triple A bond interest rates for 12 consecutive monthsare given in the file.a. Construct a time series plot. What type of pattern exists in the data?b. Develop 3-month and 4-month averages for this data. Does the 3-month or 4-month moving average provide the better forecasts based on MSE? Explain.c. What is the moving average forecast for the next month?4. Consider the following time series:QuarterYear 1Year 2Year 371686224941515853788172a. Construct a time-series plot. What type of pattern exists in the data? Is there anindication of a seasonal pattern?b. Use multiple linear regression model with dummy variables as follows to developan equation to account for seasonal effects in the data. Qtr1 = 1 if quarter 1, 0 else; Qtr2= 1 if quarter 2, 0 else; Qtr3 = 1 if quarter 3, 0 else.c. Compute the quarterly forecasts for next year.

Name: Hi, this is the 5th time i am submitting this question and am unsure w
Uploaded: 2024-03-20T06:38:44.000Z
Channel: Bartleby
Description: Hi, this is the 5th time i am submitting this question and am unsure why it is being rejected as it does not go against the honor code. TripleABond.xlsx. The corporate triple A bond interest rates for 12 consecutive monthsare given in the file.a. Con