Two-sample hypothesis testingBe sure to read the instructions below before getting started. Instructions: Review the data file and answer the questions. Your answers should be submitted in the form of a Word document. The Word document should include any charts tables or graphs you create. You are also required to submit an Excel file or copy of hand calculations to support your answers. Question 1 A real estate agent has collected a random sample of 75 houses that were recently sold in a suburban community. She is particularly interested in comparing the appraised value and recent selling price of the houses in this particular market. The data are provided in the file Real_Estate.xlsx. a)Calculate summary statistics for the data. Copy and paste the results. b)What test is more appropriate (a two-sample test or a paired test) to assess whether there is evidence of a mean difference in the appraised values and selling prices? Explain your reasoning. c)Using this sample data test whether there is a statistically significant mean difference between the appraised values and selling prices of the houses sold in this suburban community. 1)Set up the appropriate null and alternative hypothesis for this situation. Specify whether this is a one-tailed test or a two-tailed test and explain your reasoning. 2)Use StatTools to conduct the test and compute the p-value for your test statistic. For which level of significance is it appropriate to conclude that no difference exists between these two values? Copy and paste the output generated by StatTools. d)Communicate the results of the test in plain English within the context of the problem. Question 2 A bank has the business objective of improving the process for servicing customers during the noon-to-1PM lunch period. To do so the waiting time (defined as the number of minutes that elapses from when the customer enters the line until he or she reaches the teller window) needs to be shortened to increase customer satisfaction. A random sample of customers at two different branches of the bank is selected and the waiting times are collected and stored in the file BankTimes.xlsx. Is there evidence that the mean waiting time in Branch 1 is less than in Branch 2?