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

Reference no: EM132280829

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.

Write a Review

 
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd