PROVIDE THE EXCEL LINK BELOW (DO IT IN EXCEL NO SCREENSHOTS OF EXCEL)

Problem 1 Quality Ratings of Airports. The International Air Transport Association surveys business travelers to develop quality ratings for transatlantic gateway airports. The maximum possible rating is 10. Suppose a simple random sample of 50 business travelers is selected and each traveler is asked to provide a rating for the Miami International Airport. The ratings obtained from the sample of 50 business travelers follow. Develop a 95% confidence interval estimate of the population mean rating for Miami. http://tavana.us/rutgers/assignments/CH89-Assignment-Problem1-Data.xlsx 6 4 6 8 7 7 6 3 3 8 10 4 8 7 8 7 5 9 5 8 4 3 8 5 5 4 4 4 8 4 5 6 2 5 9 9 8 4 8 9 9 5 9 7 8 3 10 8 9 6

Problem 2 Telemedicine. Health insurers are beginning to offer telemedicine services online that replace the common office visit. Wellpoint provides a video service that allows subscribers to connect with a physician online and receive prescribed treatments (Bloomberg Businessweek). Wellpoint claims that users of its LiveHealth Online service saved a significant amount of money on a typical visit. The data shown below ($), for a sample of 20 online doctor visits, are consistent with the savings per visit reported by Wellpoint. Assuming the population is roughly symmetric, construct a 95% confidence interval for the mean savings for a televisit to the doctor as opposed to an office visit. http://tavana.us/rutgers/assignments/CH89-Assignment-Problem2-Data.xlsx 92 105 56 76 93 78 53 34 83 49 48 74 93 82 40 55 40 96 73 100

Problem 3 Federal Tax Returns. According to the IRS, individuals filing federal income tax returns prior to March 31 received an average refund of $1056 in 2018.Consider the population of "last-minute" filers who mail their tax return during the last five days of the income tax period (typically April 10 to April 15). a. A researcher suggests that a reason individuals wait until the last five days is that on average these individuals receive lower refunds than do early filers. Develop appropriate hypotheses such that rejection of H0 will support the researcher's contention. b. For a sample of 400 individuals who filed a tax return between April 10 and 15, the sample mean refund was $910. Based on prior experience a population standard deviation of =$1600 may be assumed. What is the p-value? c. At =.05, what is your conclusion? d. Repeat the preceding hypothesis test using the critical value approach.

Problem 4 Cost of Telephone Surveys. Fowle Marketing Research, Inc., bases charges to a client on the assumption that telephone surveys can be completed in a mean time of 15 minutes or less. If a longer mean survey time is necessary, a premium rate is charged. A sample of 35 surveys provided the survey times shown in the file Fowle. Based upon past studies, the population standard deviation is assumed known with = 4 minutes. Is the premium rate justified?

a. Formulate the null and alternative hypotheses for this application.

b. Compute the value of the test statistic.

c. What is the p-value?

d. At =.01, what is your conclusion? http://tavana.us/rutgers/assignments/CH89-Assignment-Problem4-Data.xlsx 17 11 12 23 20 23 15 16 23 22 18 23 25 14 12 12 20 18 12 19 11 11 20 21 11 18 14 13 13 19 16 10 22 18 23