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.

1. Calculate summary statistics for the data. Copy and paste the results.
2. 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.
3. 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.
4. 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?

1. Specify the null hypothesis and the alternative hypothesis. State whether you are using a one- or two-tailed test and explain your reasoning.
2. Determine the appropriate hypothesis test to this problem. Justify your answer.
3. Conduct calculations “by hand” to compute the critical value and p-value of the test. Determine your decision using two methods, the rejection region and the p-value approach.
4. Use StatTools to conduct the hypothesis test. Copy and paste the command and output generated by StatTools.
5. Communicate the results of the test in “plain English” including the meaning of the p-value.

Question 3

How often does work intrude during off hours? A survey of 1,000 office workers indicated that 53% of males and 41% of females had office intrusion while on vacation. Assume that the survey consisted of 500 males and 500 females. At the 0.05 level of significance, is there evidence of a difference in the proportion of males and females who experience office intrusions while on vacation?

1. Specify the null hypothesis and the alternative hypothesis. State whether you are using a one- or two-tailed test and explain your reasoning.
2. Determine the appropriate hypothesis test to this problem. Justify your answer
3. Conduct calculations “by hand” to compute the critical value and p-value of the test. Determine your decision using two methods, the rejection region and the p-value approach.
4. Use StatTools to conduct the hypothesis test. Copy and paste the command and output generated by StatTools.
5. Communicate the results of the test in “plain English” including the meaning of the p-value.