Question
SAS. Business Analytics. In this CT assignment, we will examine a real dataset and make appropriate decisions based on confidence interval. Download the dataset MORTGAGE30US.xls
SAS. Business Analytics. In this CT assignment, we will examine a real dataset and make appropriate decisions based on confidence interval. Download the dataset MORTGAGE30US.xls (attached). This dataset contains 30-year fixed rate mortgage weekly averages from 1/7/2010 to 8/16/2018. Then complete the following steps and questions: -Using SAS, produce an appropriate graphical summary of the dataset. Why did you choose this graph? Explain. -Using SAS, compute the mean, standard deviation, and a five-number summary of the dataset. Describe the center and spread. -Using SAS, construct a 95% confidence interval for the mean weekly averages. Interpret this confidence interval. -A mortgage broker claims that the mean rate will be higher than 4.60% in the following week. Based on the confidence interval, is this a reasonable claim? Explain. Take the screenshots of the SAS output and paste them into a Word document along your answers to the questions above.
FRED Graph Observations | |||||
Federal Reserve Economic Data | |||||
Link: https://fred.stlouisfed.org | |||||
Help: https://fred.stlouisfed.org/help-faq | |||||
Economic Research Division | |||||
Federal Reserve Bank of St. Louis | |||||
MORTGAGE30US | 30-Year Fixed Rate Mortgage Average in the United States, Percent, Weekly, Not Seasonally Adjusted | ||||
Frequency: Weekly, Ending Thursday | |||||
observation_date | MORTGAGE30US | ||||
2010-01-07 | 5.09 | ||||
2010-01-14 | 5.06 | ||||
2010-01-21 | 4.99 | ||||
2010-01-28 | 4.98 | ||||
2010-02-04 | 5.01 | ||||
2010-02-11 | 4.97 | ||||
2010-02-18 | 4.93 | ||||
2010-02-25 | 5.05 | ||||
2010-03-04 | 4.97 | ||||
2010-03-11 | 4.95 | ||||
2010-03-18 | 4.96 | ||||
2010-03-25 | 4.99 | ||||
2010-04-01 | 5.08 | ||||
2010-04-08 | 5.21 | ||||
2010-04-15 | 5.07 | ||||
2010-04-22 | 5.07 | ||||
2010-04-29 | 5.06 | ||||
2010-05-06 | 5.00 | ||||
2010-05-13 | 4.93 | ||||
2010-05-20 | 4.84 | ||||
2010-05-27 | 4.78 | ||||
2010-06-03 | 4.79 | ||||
2010-06-10 | 4.72 | ||||
2010-06-17 | 4.75 | ||||
2010-06-24 | 4.69 | ||||
2010-07-01 | 4.58 | ||||
2010-07-08 | 4.57 | ||||
2010-07-15 | 4.57 | ||||
2010-07-22 | 4.56 | ||||
2010-07-29 | 4.54 | ||||
2010-08-05 | 4.49 | ||||
2010-08-12 | 4.44 | ||||
2010-08-19 | 4.42 | ||||
2010-08-26 | 4.36 | ||||
2010-09-02 | 4.32 | ||||
2010-09-09 | 4.35 | ||||
2010-09-16 | 4.37 | ||||
2010-09-23 | 4.37 | ||||
2010-09-30 | 4.32 | ||||
2010-10-07 | 4.27 | ||||
2010-10-14 | 4.19 | ||||
2010-10-21 | 4.21 | ||||
2010-10-28 | 4.23 | ||||
2010-11-04 | 4.24 | ||||
2010-11-11 | 4.17 | ||||
2010-11-18 | 4.39 | ||||
2010-11-24 | 4.40 | ||||
2010-12-02 | 4.46 | ||||
2010-12-09 | 4.61 | ||||
2010-12-16 | 4.83 | ||||
2010-12-23 | 4.81 | ||||
2010-12-30 | 4.86 | ||||
2011-01-06 | 4.77 | ||||
2011-01-13 | 4.71 | ||||
2011-01-20 | 4.74 | ||||
2011-01-27 | 4.80 | ||||
2011-02-03 | 4.81 | ||||
2011-02-10 | 5.05 |
Step by Step Solution
3.53 Rating (153 Votes )
There are 3 Steps involved in it
Step: 1
A Bar graph presentation for mortgage weekly averages from 172010 to 81620...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Document Format ( 1 attachment)
627e36fae89b0_101164.docx
120 KBs Word File
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started