A mortgage specialist would like to analyze the average mortgagerates for Atlanta, Georgia. He collects data on the annualpercentage rates (APR in %) for 30-year fixed loans as shown in thefollowing table. If he is willing to assume that these rates arerandomly drawn from a normally distributed population, can heconclude that the mean mortgage rate for the population exceeds4.45%? Test the hypothesis at a 1% level of significance. (You mayfind it useful to reference the appropriate table: z table or ttable) Financial Institution APR G Squared Financial 4.025 % BestPossible Mortgage 4.840 Hersch Financial Group 4.785 TotalMortgages Services 4.850 Wells Fargo 4.465 Quicken Loans 4.705Amerisave 4.305 Source: MSN Money.com; data retrieved October 1,2010. Click here for the Excel Data File a. Select the null and thealternative hypotheses. H0: µ ≥ 4.45; HA: µ < 4.45 H0: µ ≤ 4.45;HA: µ > 4.45 H0: μ = 4.45; HA: μ ≠ 4.45 b. Calculate the valueof the test statistic. (Round intermediate calculations to at least4 decimal places and final answer to 2 decimal places.) c. Find thep-value. 0.05 p-value < 0.10 0.025 p-value < 0.05 0.01p-value < 0.025 p-value 0.10 p-value < 0.01 d. What is theconclusion? Do not reject H0 since the p-value is smaller thansignificance level. Do not reject H0 since the p-value is greaterthan significance level. Reject H0 since the p-value is smallerthan significance level. Reject H0 since the p-value is greaterthan significance level. e. Make an inference at α = 0.010. Themean mortgage rate equals 4.45%. The mean mortgage rate does notequal 4.45%. The mean mortgage rate does not exceed 4.45%. The meanmortgage rate exceeds 4.45%. A mortgage specialist would like toanalyze the average mortgage rates for Atlanta, Georgia. Hecollects data on the annual percentage rates (APR in %) for 30-yearfixed loans as shown in the following table. If he is willing toassume that these rates are randomly drawn from a normallydistributed population, can he conclude that the mean mortgage ratefor the population exceeds 4.45%? Test the hypothesis at a 1% levelof significance. (You may find it useful to reference theappropriate table: z table or t table) Financial Institution APR GSquared Financial 4.025 % Best Possible Mortgage 4.840 HerschFinancial Group 4.785 Total Mortgages Services 4.850 Wells Fargo4.465 Quicken Loans 4.705 Amerisave 4.305 Source: MSN Money.com;data retrieved October 1, 2010. Click here for the Excel Data Filea. Select the null and the alternative hypotheses. H0: µ ≥ 4.45;HA: µ < 4.45 H0: µ ≤ 4.45; HA: µ > 4.45 H0: μ = 4.45; HA: μ ≠4.45 b. Calculate the value of the test statistic. (Roundintermediate calculations to at least 4 decimal places and finalanswer to 2 decimal places.) c. Find the p-value. 0.05 p-value <0.10 0.025 p-value < 0.05 0.01 p-value < 0.025 p-value 0.10p-value < 0.01 d. What is the conclusion? Do not reject H0 sincethe p-value is smaller than significance level. Do not reject H0since the p-value is greater than significance level. Reject H0since the p-value is smaller than significance level. Reject H0since the p-value is greater than significance level. e. Make aninference at α = 0.010. The mean mortgage rate equals 4.45%. Themean mortgage rate does not equal 4.45%. The mean mortgage ratedoes not exceed 4.45%. The mean mortgage rate exceeds 4.45%.