### Produce an appropriate graphical summary of the dataset

Assignment Help Applied Statistics
##### Reference no: EM132280829

Assignment Requirements -

In this CT assignment, we will examine a real dataset and make appropriate decisions based on confidence interval.

Download the dataset MORTGAGE30US.xls. 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:

a. Using SAS, produce an appropriate graphical summary of the dataset. Why did you choose this graph? Explain.

b. Using SAS, compute the mean, standard deviation, and a five-number summary of the dataset. Describe the center and spread.

c. Using SAS, construct a 95% confidence interval for the mean weekly averages. Interpret this confidence interval.

d. 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.

There are some stages that need to be completed to perform a test:

1) Write down the null hypothesis and the alternative hypothesis;

2) Set the significance level α; the common choices for α are 0.05, 0.01 or 0.1; in general, α is indicated in the text of the problem, but if it is missing, then it is considered to be α=0.05.

3) Find the p-value;

4) Compare the p-value with the significance level: if the p-value is greater than the significance level, then we fail to reject the null hypothesis; if the p-value is less than the significance level, then we reject the null hypothesis.

5) State the conclusion in non-technical terms.

Attachment:- Assignment Files.rar

#### What is the probability that a randomly selected man

What is the probability that a randomly selected man who wears a size 12 shoe Has a height outside the range 71 inches to 76 inches,  Is 74 inches or taller and

#### Provide a statistical overview of the data provided in excel

STAT 6003: Statistics for Financial Decisions. Analysis of sales and country data, forecasting of sales figures until 2020. Provide a statistical overview of the data provided

#### Predictable relationship between verbal skills

A researcher would like to know whether there is a consistent, predictable relationship between verbal skills and math skills for high school students. A sample of 200 student

#### Write a report about the results

Write a report about the results, distilling down the results in a way that would be understandable to someone who does not know statistics. Clear explanations and interpret

#### Find the probability

The capacity of an elevator is 8 people or 1232 pounds. The capacity will be exceeded if 8 people have weights with a mean greater than 1232/8=154 pounds. Suppose the people h

#### Kelloggs cereal company regularly tests its production line

Kellogg's cereal company regularly tests its production line to ensure the accuracy of the loading mechanisms.  From a population of cereal boxes marked "12 ounces," a random

#### What is correlation define hypothesis testing using minitab

What is correlation? Define the purpose along with Hypothesis Statement using Minitab. What is Regression Perform samples sign tests, Mann Whitney test, Mood's Median Test, Va

#### What is the probability of winning a low

Question 1What is the probability of winning a low, even, red, black, odd, or high bet in the game of American roulette? What is the probability of winning a bet placed on any

### Reviews

#### len2280829

4/11/2019 11:02:57 PM

Instructions: The assignment and instructor provided guide at in the attached word document. The excel dataset is also attached. I have already put in my screenshots from the code commands from SAS Studio into the word document. Requesting quote to interpret some of the output based on the assignment requirements around the right kind of graph to use, the center and spread, and the confidence interval. 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. Use the mean and the median to interpret the center. Use the standard deviation to interpret the spread. Please write your conclusion corresponding to a hypothesis test in technical and non-technical terms. I want to see both forms.