1. A random sample was selected of 10 banks from Baltimore and 10 banks from Tampa,...

 

Transcribed Image Text:

1. A random sample was selected of 10 banks from Baltimore and 10 banks from Tampa, and their 30-year mortgage rates are provided in the Excel file "Dataset for Assignment 4 Question 1". A). Is there evidence of a difference in the variances of 30-year mortgage rates between the two cities? (Please make sure you declare the hypotheses. Remember that the null hypothesis and alternative hypothesis are always opposite to each other, and the alternative hypothesis is what you are seeking to find evidence to support) B). Assume that the population 30-year mortgage rates are normally distributed. Based on your answer to question 1.a, which t-test (Excel template) should you use to analyze the difference in the means of 30-year mortgage rates between the two cities? Why? C). At the 0.05 level of significance, is there evidence of a difference in the means of 30-year mortgage rates between the two cities? (Please make sure you declare the hypotheses. Remember that the null hypothesis and alternative hypothesis are always opposite to each other, and the alternative hypothesis is what you are seeking to find evidence to support) 30-Year Bank Mortgage Rates Baltimore Tampa 3.63 3.75 3.74 3.88 3.75 4.38 3.63 3.88 3.89 4 3.62 3.63 3.75 3.75 3.75 3.74 3.75 3.75 3.87 3.87 1. A random sample was selected of 10 banks from Baltimore and 10 banks from Tampa, and their 30-year mortgage rates are provided in the Excel file "Dataset for Assignment 4 Question 1". A). Is there evidence of a difference in the variances of 30-year mortgage rates between the two cities? (Please make sure you declare the hypotheses. Remember that the null hypothesis and alternative hypothesis are always opposite to each other, and the alternative hypothesis is what you are seeking to find evidence to support) B). Assume that the population 30-year mortgage rates are normally distributed. Based on your answer to question 1.a, which t-test (Excel template) should you use to analyze the difference in the means of 30-year mortgage rates between the two cities? Why? C). At the 0.05 level of significance, is there evidence of a difference in the means of 30-year mortgage rates between the two cities? (Please make sure you declare the hypotheses. Remember that the null hypothesis and alternative hypothesis are always opposite to each other, and the alternative hypothesis is what you are seeking to find evidence to support) 30-Year Bank Mortgage Rates Baltimore Tampa 3.63 3.75 3.74 3.88 3.75 4.38 3.63 3.88 3.89 4 3.62 3.63 3.75 3.75 3.75 3.74 3.75 3.75 3.87 3.87

Answer rating: 100% (QA)

A To determine if there is evidence of a difference in the variances of 30year mortgage rates betwee... View the full answer