MIS445 Decisions Based on Confidence Interval & Real Dataset Project In this CT assignment, we will examine a real dataset and make appropriate decisions b

MIS445 Decisions Based on Confidence Interval & Real Dataset Project In this CT assignment, we will examine a real dataset and make appropriate decisions based on confidence interval.

Download the dataset MORTGAGE30US.xls (linked under Module 4: Critical Thinking on the modules page). This dataset contains 30-year fixed rate mortgage weekly averages from 1/7/2010 to 8/16/2018. Put your dataset into in the myfolders/MIS445 on your computer. 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. Clearly label the questions and answers. Submit the Word file in Canvas. 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 Adjuste
Frequency: Weekly, Ending Thursday
observation_date
MORTGAGE30US
2010-01-07
2010-01-14
2010-01-21
2010-01-28
2010-02-04
2010-02-11
2010-02-18
2010-02-25
2010-03-04
2010-03-11
2010-03-18
2010-03-25
2010-04-01
2010-04-08
2010-04-15
2010-04-22
2010-04-29
2010-05-06
2010-05-13
2010-05-20
2010-05-27
2010-06-03
2010-06-10
2010-06-17
2010-06-24
2010-07-01
2010-07-08
2010-07-15
2010-07-22
2010-07-29
2010-08-05
2010-08-12
2010-08-19
2010-08-26
2010-09-02
2010-09-09
2010-09-16
2010-09-23
2010-09-30
2010-10-07
2010-10-14
5.09
5.06
4.99
4.98
5.01
4.97
4.93
5.05
4.97
4.95
4.96
4.99
5.08
5.21
5.07
5.07
5.06
5.00
4.93
4.84
4.78
4.79
4.72
4.75
4.69
4.58
4.57
4.57
4.56
4.54
4.49
4.44
4.42
4.36
4.32
4.35
4.37
4.37
4.32
4.27
4.19
2010-10-21
2010-10-28
2010-11-04
2010-11-11
2010-11-18
2010-11-24
2010-12-02
2010-12-09
2010-12-16
2010-12-23
2010-12-30
2011-01-06
2011-01-13
2011-01-20
2011-01-27
2011-02-03
2011-02-10
2011-02-17
2011-02-24
2011-03-03
2011-03-10
2011-03-17
2011-03-24
2011-03-31
2011-04-07
2011-04-14
2011-04-21
2011-04-28
2011-05-05
2011-05-12
2011-05-19
2011-05-26
2011-06-02
2011-06-09
2011-06-16
2011-06-23
2011-06-30
2011-07-07
2011-07-14
2011-07-21
2011-07-28
2011-08-04
2011-08-11
2011-08-18
2011-08-25
2011-09-01
2011-09-08
2011-09-15
2011-09-22
2011-09-29
2011-10-06
2011-10-13
4.21
4.23
4.24
4.17
4.39
4.40
4.46
4.61
4.83
4.81
4.86
4.77
4.71
4.74
4.80
4.81
5.05
5.00
4.95
4.87
4.88
4.76
4.81
4.86
4.87
4.91
4.80
4.78
4.71
4.63
4.61
4.60
4.55
4.49
4.50
4.50
4.51
4.60
4.51
4.52
4.55
4.39
4.32
4.15
4.22
4.22
4.12
4.09
4.09
4.01
3.94
4.12
2011-10-20
2011-10-27
2011-11-03
2011-11-10
2011-11-17
2011-11-23
2011-12-01
2011-12-08
2011-12-15
2011-12-22
2011-12-29
2012-01-05
2012-01-12
2012-01-19
2012-01-26
2012-02-02
2012-02-09
2012-02-16
2012-02-23
2012-03-01
2012-03-08
2012-03-15
2012-03-22
2012-03-29
2012-04-05
2012-04-12
2012-04-19
2012-04-26
2012-05-03
2012-05-10
2012-05-17
2012-05-24
2012-05-31
2012-06-07
2012-06-14
2012-06-21
2012-06-28
2012-07-05
2012-07-12
2012-07-19
2012-07-26
2012-08-02
2012-08-09
2012-08-16
2012-08-23
2012-08-30
2012-09-06
2012-09-13
2012-09-20
2012-09-27
2012-10-04
2012-10-11
4.11
4.10
4.00
3.99
4.00
3.98
4.00
3.99
3.94
3.91
3.95
3.91
3.89
3.88
3.98
3.87
3.87
3.87
3.95
3.90
3.88
3.92
4.08
3.99
3.98
3.88
3.90
3.88
3.84
3.83
3.79
3.78
3.75
3.67
3.71
3.66
3.66
3.62
3.56
3.53
3.49
3.55
3.59
3.62
3.66
3.59
3.55
3.55
3.49
3.40
3.36
3.39
2012-10-18
2012-10-25
2012-11-01
2012-11-08
2012-11-15
2012-11-21
2012-11-29
2012-12-06
2012-12-13
2012-12-20
2012-12-27
2013-01-03
2013-01-10
2013-01-17
2013-01-24
2013-01-31
2013-02-07
2013-02-14
2013-02-21
2013-02-28
2013-03-07
2013-03-14
2013-03-21
2013-03-28
2013-04-04
2013-04-11
2013-04-18
2013-04-25
2013-05-02
2013-05-09
2013-05-16
2013-05-23
2013-05-30
2013-06-06
2013-06-13
2013-06-20
2013-06-27
2013-07-03
2013-07-11
2013-07-18
2013-07-25
2013-08-01
2013-08-08
2013-08-15
2013-08-22
2013-08-29
2013-09-05
2013-09-12
2013-09-19
2013-09-26
2013-10-03
2013-10-10
3.37
3.41
3.39
3.40
3.34
3.31
3.32
3.34
3.32
3.37
3.35
3.34
3.40
3.38
3.42
3.53
3.53
3.53
3.56
3.51
3.52
3.63
3.54
3.57
3.54
3.43
3.41
3.40
3.35
3.42
3.51
3.59
3.81
3.91
3.98
3.93
4.46
4.29
4.51
4.37
4.31
4.39
4.40
4.40
4.58
4.51
4.57
4.57
4.50
4.32
4.22
4.23
2013-10-17
2013-10-24
2013-10-31
2013-11-07
2013-11-14
2013-11-21
2013-11-27
2013-12-05
2013-12-12
2013-12-19
2013-12-26
2014-01-02
2014-01-09
2014-01-16
2014-01-23
2014-01-30
2014-02-06
2014-02-13
2014-02-20
2014-02-27
2014-03-06
2014-03-13
2014-03-20
2014-03-27
2014-04-03
2014-04-10
2014-04-17
2014-04-24
2014-05-01
2014-05-08
2014-05-15
2014-05-22
2014-05-29
2014-06-05
2014-06-12
2014-06-19
2014-06-26
2014-07-03
2014-07-10
2014-07-17
2014-07-24
2014-07-31
2014-08-07
2014-08-14
2014-08-21
2014-08-28
2014-09-04
2014-09-11
2014-09-18
2014-09-25
2014-10-02
2014-10-09
4.28
4.13
4.10
4.16
4.35
4.22
4.29
4.46
4.42
4.47
4.48
4.53
4.51
4.41
4.39
4.32
4.23
4.28
4.33
4.37
4.28
4.37
4.32
4.40
4.41
4.34
4.27
4.33
4.29
4.21
4.20
4.14
4.12
4.14
4.20
4.17
4.14
4.12
4.15
4.13
4.13
4.12
4.14
4.12
4.10
4.10
4.10
4.12
4.23
4.20
4.19
4.12
2014-10-16
2014-10-23
2014-10-30
2014-11-06
2014-11-13
2014-11-20
2014-11-26
2014-12-04
2014-12-11
2014-12-18
2014-12-24
2014-12-31
2015-01-08
2015-01-15
2015-01-22
2015-01-29
2015-02-05
2015-02-12
2015-02-19
2015-02-26
2015-03-05
2015-03-12
2015-03-19
2015-03-26
2015-04-02
2015-04-09
2015-04-16
2015-04-23
2015-04-30
2015-05-07
2015-05-14
2015-05-21
2015-05-28
2015-06-04
2015-06-11
2015-06-18
2015-06-25
2015-07-02
2015-07-09
2015-07-16
2015-07-23
2015-07-30
2015-08-06
2015-08-13
2015-08-20
2015-08-27
2015-09-03
2015-09-10
2015-09-17
2015-09-24
2015-10-01
2015-10-08
3.97
3.92
3.98
4.02
4.01
3.99
3.97
3.89
3.93
3.80
3.83
3.87
3.73
3.66
3.63
3.66
3.59
3.69
3.76
3.80
3.75
3.86
3.78
3.69
3.70
3.66
3.67
3.65
3.68
3.80
3.85
3.84
3.87
3.87
4.04
4.00
4.02
4.08
4.04
4.09
4.04
3.98
3.91
3.94
3.93
3.84
3.89
3.90
3.91
3.86
3.85
3.76
2015-10-15
2015-10-22
2015-10-29
2015-11-05
2015-11-12
2015-11-19
2015-11-25
2015-12-03
2015-12-10
2015-12-17
2015-12-24
2015-12-31
2016-01-07
2016-01-14
2016-01-21
2016-01-28
2016-02-04
2016-02-11
2016-02-18
2016-02-25
2016-03-03
2016-03-10
2016-03-17
2016-03-24
2016-03-31
2016-04-07
2016-04-14
2016-04-21
2016-04-28
2016-05-05
2016-05-12
2016-05-19
2016-05-26
2016-06-02
2016-06-09
2016-06-16
2016-06-23
2016-06-30
2016-07-07
2016-07-14
2016-07-21
2016-07-28
2016-08-04
2016-08-11
2016-08-18
2016-08-25
2016-09-01
2016-09-08
2016-09-15
2016-09-22
2016-09-29
2016-10-06
3.82
3.79
3.76
3.87
3.98
3.97
3.95
3.93
3.95
3.97
3.96
4.01
3.97
3.92
3.81
3.79
3.72
3.65
3.65
3.62
3.64
3.68
3.73
3.71
3.71
3.59
3.58
3.59
3.66
3.61
3.57
3.58
3.64
3.66
3.60
3.54
3.56
3.48
3.41
3.42
3.45
3.48
3.43
3.45
3.43
3.43
3.46
3.44
3.50
3.48
3.42
3.42
2016-10-13
2016-10-20
2016-10-27
2016-11-03
2016-11-10
2016-11-17
2016-11-23
2016-12-01
2016-12-08
2016-12-15
2016-12-22
2016-12-29
2017-01-05
2017-01-12
2017-01-19
2017-01-26
2017-02-02
2017-02-09
2017-02-16
2017-02-23
2017-03-02
2017-03-09
2017-03-16
2017-03-23
2017-03-30
2017-04-06
2017-04-13
2017-04-20
2017-04-27
2017-05-04
2017-05-11
2017-05-18
2017-05-25
2017-06-01
2017-06-08
2017-06-15
2017-06-22
2017-06-29
2017-07-06
2017-07-13
2017-07-20
2017-07-27
2017-08-03
2017-08-10
2017-08-17
2017-08-24
2017-08-31
2017-09-07
2017-09-14
2017-09-21
2017-09-28
2017-10-05
3.47
3.52
3.47
3.54
3.57
3.94
4.03
4.08
4.13
4.16
4.30
4.32
4.20
4.12
4.09
4.19
4.19
4.17
4.15
4.16
4.10
4.21
4.30
4.23
4.14
4.10
4.08
3.97
4.03
4.02
4.05
4.02
3.95
3.94
3.89
3.91
3.90
3.88
3.96
4.03
3.96
3.92
3.93
3.90
3.89
3.86
3.82
3.78
3.78
3.83
3.83
3.85
2017-10-12
2017-10-19
2017-10-26
2017-11-02
2017-11-09
2017-11-16
2017-11-22
2017-11-30
2017-12-07
2017-12-14
2017-12-21
2017-12-28
2018-01-04
2018-01-11
2018-01-18
2018-01-25
2018-02-01
2018-02-08
2018-02-15
2018-02-22
2018-03-01
2018-03-08
2018-03-15
2018-03-22
2018-03-29
2018-04-05
2018-04-12
2018-04-19
2018-04-26
2018-05-03
2018-05-10
2018-05-17
2018-05-24
2018-05-31
2018-06-07
2018-06-14
2018-06-21
2018-06-28
2018-07-05
2018-07-12
2018-07-19
2018-07-26
2018-08-02
2018-08-09
2018-08-16
3.91
3.88
3.94
3.94
3.90
3.95
3.92
3.90
3.94
3.93
3.94
3.99
3.95
3.99
4.04
4.15
4.22
4.32
4.38
4.40
4.43
4.46
4.44
4.45
4.44
4.40
4.42
4.47
4.58
4.55
4.55
4.61
4.66
4.56
4.54
4.62
4.57
4.55
4.52
4.53
4.52
4.54
4.60
4.59
4.53
ent, Weekly, Not Seasonally Adjusted

Purchase answer to see full
attachment