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

Answer rating: 100% (QA)

A Bar graph presentation for mortgage weekly averages from 172010 to 81620... View the full answer