AutoSave OFF A A . CGP ... w- Assignment10 - Read-Only - Saved to my Mac Home Insert Draw Design Layout References Mailings Review N ? Tell me Share Comments A A Aa Ap EVEEVENT AaBbCcDdEe AaBbCcDdEe AaBbCcDc AaBbCcDdEE AaBb( AaBbCcDdEE Paste BI U vab X X|ADVA v Normal No Spacing Heading 1 Heading 2 Title Subtitle Styles Dictate Editor Pane * Read Only To save a copy of this document, click Duplicate. Duplicate Chapter 10 Two-Sample Tests Instructions: . Please follow the 6 steps of Hypothesis Testing. . Make sure you declare the hypotheses in the first step. Note that the null hypothesis and alternative hypothesis are always opposite to each other, and alternative hypothesis is what you need to prove with evidence. Correct answers with no calculation process or Excel screenshot will result in zero credit. 1. Is there a difference in the 30-year mortgage rate between different cities? A random sample of 10 banks is selected from Baltimore is selected and the mortgage rates are: 3.63%, 3.75%, 3.74%, 3.88%, 3.75%, 4.38%, 3.63%, 3.88%, 3.88%, and 4.00%. A random sample of 10 banks is selected from Tampa is selected and the mortgage rates are: 3.62%, 3.63%, 3.75%, 3.75%, 3.75%, 3.74%, 3.75%, 3.75%, 3.87%, and 3.87%. a) Assume that the population mortgage rates are normally distributed, and the variances are assumed to be equal. At the 0.05 level of significance, is there evidence of a difference in the means of 30-year mortgage rates in the two cities? Hint: use Excel PooledVariance-T-Test.xIsx.| b) Is there evidence of a difference in the variances of 30-year mortgage rates in the two cities? Hint: use Excel Two Variances-F-Test.xIsx. 2. Multiple myeloma, or blood plasma cancer, is characterized by increased blood vessel formulation in the bone marrow that is a predictive factor in survival. One treatment approach used for multiple myeloma is stem cell transplantation with the patient's own stem cells. The measurements were taken immediately prior to the stem cell transplant and at the time the complete response was determined. At the 0.05 level of significance, is there evidence that the mean bone marrow microvessel density is higher before the stem cell transplant than after the stem cell transplant? Hint: use PairedMean-T- Test.xlsx. Patient Before After 158 284 189 214 202 101 353 227 416 290 426 176 441 290 Microsoft Word 3 APR 29 S 4 P w Pa