Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Document Format ( 1 attachment)

Word file Icon
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

Recommended Textbook for

Human Resource Management

Authors: Robert L. Mathis, John H. Jackson

13th Edition

053845315X, 978-0538453158

More Books

Students also viewed these Finance questions

Question

Show that if A is any m n matrix, then Im A = A and AIn = A.

Answered: 1 week ago

Question

1. Describe qualitative research and its assumptions.

Answered: 1 week ago