Recently, fixed mortgage rates have been at historical lows due to the housing slowdown. Data in the

Question:

Recently, fixed mortgage rates have been at historical lows due to the housing slowdown. Data in the Excel file mortgage rates.xlsx show the annual average 30-year fixed mortgage rate for 1994 to 2017, as reported by Freddie Mac.

a. Construct a graph showing the average December mortgage rate over time.

b. Forecast the average mortgage rate in 2018 using a trend projection.

c. Calculate the MAD for this forecast.

d. Check for the presence of positive auto-correlation.

e. What limitations do you foresee with this forecasting method projecting mortgage rates several years into the future?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For book-img-for-question

Business Statistics

ISBN: 9780134685267

3rd Edition

Authors: Robert A. Donnelly

See More Books

Question Posted: Nov 05, 2019 05:47 AM

See More Questions

For the data in the Excel file New Account Processing, perform chisquare tests for independence to determine if certification is independent of gender, and if certification is independent of having...
Due to the housing bubble, many houses are now selling for much less than their selling price just two to three years ago. There is evidence that homeowners with virtually identical houses tend to...
For the data in the Excel file Rins Gym, find the co-variances and correlations among height, weight, and BMI calculation.
A record company needs to produce 100 gold records at one or more of its three studios. the cost of producing x records at studio 1 is 10 x; the cost of producing y records at studio 2 is 2y 2 ; the...
What present amount, at 12% interest compounded annually, is equivalent to this series of payments: Year 1-$10,000, Year 2-$9,000, Year 3- $8,000, Year 4-$7,000, Year 5-$6,000? Solve using the...
Give a practical example where data logging is required and explain the practical requirements with regards to timing, memory type, and size.
In general, would management prefer a project with a short payback period or a long one? Why? LO.1
Carol Carpet manufactures broadloom carpet in seven processes: spinning, dyeing, plying, spooling, tufting, latexing, and shearing. In the Dyeing Department, direct materials (dye) are added at the...
Question 19 2 Points Denver, Inc. has operating income of $347.000, operating expenses of $262.000, and a net capital loss of $130.000. Derwer reports a net operating loss of $45,000. True False
Two forces are applied as shown to a hook support. Using trigonometry and knowing that the magnitude of P is 600 N, determine (a) The required angle Î± if the resultant R of the two...
Gold has long been a very popular investment choice during times of economic crisis. This has resulted in a significant increase in the price of gold per ounce in recent years. The Excel file gold...
In March 2018, Amazon passed Alphabet (Google's parent company) to become the world's second most valuable company measured by stock market capitalization. The development of the quarterly revenue by...
Define relevant costs. Why are historical costs irrelevant?
15.5 please help will give like if answers r correct Exercise 15-8 (Static) Sales-type lease with selling profit; lessor; calculate lease payments [LO15-3] Manufacturers Southern leased high-tech...
When my son was young, he had 8 different plastic dinosaurs to arrange. How many ways could he arrange his 8 dinos? He had favorite dinos, so placing them in proper order was very important. How many...
Process P1 init (mutEx); num = 0; loop1 = 0; while (loop1 < 3) wait (mutEx); num num + 1; signal (mutEX); loop1 loop1 + 1; Process P2 loop2 = 0; while (loop2 < 2) wait (mutEx); num num + 10;...
PROBLEM 3-5B Following is the chart of accounts of Smith Financial Services: Assets 111 Cash 113 Accounts Receivable 115 Supplies 117 Prepaid Insurance 124 Office Furniture Liabilities 221 Accounts...
4. Identify a service you could refer Casey to and write a referral for her (up to 300 words).
Write the vectors joining each pair of points i. In the form ai + bj ii. As a column vectors. a. (1, 4) to (3, 7) b. (1, 3) to (2, 4) c. (0, 0) to (3, 5) d. (3, 7) to (7, 3) e. (4, 2) to (0, 0) f....
State whether each of the following will increase or decrease the power of a one-way between-subjects ANOVA. (a) The effect size increases. (b) Mean square error decreases. (c) Mean square between...
Consider the following data from two independent samples. Construct a 90% confidence interval to estimate the difference in population means. =46 =10 n1 = 30 =53 = 12 n2 = 36
Pfizer would like to test the effectiveness of a new cholesterol medication it has recently developed. To test the effectiveness, the LDL cholesterol level of 12 randomly selected individuals was...
The new health care plan that the federal government recently implemented has caused people to become concerned that a shortage of primary care physicians, particularly in underserved rural areas,...
Palisade Creek Co. is a merchandising business that uses the perpetual inventory system. The account balances for Palisade Creek Co. as of May 1, 2019 (unless otherwise indicated), are as follows:...
1-When accounting for an acquisition, goodwill is the difference between what two things? 2- What factors should be considered when deciding whether an acquisition should be financed with cash or...
What is the main friction Fluidity aims to address? REAL STATE

Recently, fixed mortgage rates have been at historical lows due to the housing slowdown. Data in the

Question:

Step by Step Answer:

a b n 24 t 300 y 141 ty 1525 t 2 4900 c MAD 799724 03332 ...View the full answer

Business Statistics

Students also viewed these Mathematics questions