Please help me find solutions to the following questions. In Essentials of Modern Business Statistics (page 619), please review the case problem for "Case 3: TourisTopia Travel." (https://www.dropbox.com/s/9s2vahcrn5b8b5d/TourisTopia.xlsx?dl=0) Please complete the Managerial Report at the end of the case. I need help for write up your analysis of the problem in a Word file but be sure to copy and paste the test output results from Excel and paste it into your Word file as part of your analysis.

Background of the case

Purpose of the statistical test

Results of the statistical test (with output)

Interpretation and conclusions of the statistical test with an explanation for why unequal variances was assumed and why a two-tailed test was used, rather than a one-tailed test. Consider the likelihood of either a Type I or Type II error with your justification.

Your recommendations of the findings, including need for additional research

The report should be in easy-to understand language that a general audience will understand. Your attached Excel worksheet will provide the detailed analysis (either in a separate file or as an appendix), but your report should be for a non-statistical audience. Please don't assume that they will understand the terms or their meanings. That is the value-added benefit of your report. For example, rather than tell management the t-test results for them to interpret, you would report either (a) one group performed significantly better than the other or (b) there was not statistical difference between the two groups with any differences due to random variations. Then you would suggest how the findings might be applied to the problem at hand.

The goal for your report is to quickly and efficiently inform management a topline report of findings and their implications with your questions, concerns, and recommendations.

Five randomly selected students took a math aptitude test before they began their statistics course. In the table below, the x, column shows scores on the aptitude test. Similarly, the y, column shows statistics grades. Student Xi Vi 95 85 85 95 80 70 70 65 5 60 70 Assume the statistics grade y and math aptitude test x has a linear relationship of the form: y = bo + bix Please (a) Estimate the variance of residual error. (b) Estimate the R of the fitted model. (c) Perform significance test for the slope b1. (d) Comment on the model you fit.Find a linear (regression) equation with following data. X y Ans.: y = ( ) + ( * X 10 12 25 20 For x = 50, find y= 30 22 40 26 45 30 2 Test the claim that the population of Freshman college students has a mean grade point average, GPA, lower than 2.00. Sample statistics include size = 24, mean = 1.95, and standard deviation = 0.70. Use a type I error = 0.01. TEST HYPOTHESIS, including the TEST STATISTICS, CRITICALIs the number of games won by a major league baseball team in a season related to the team's batting average? Data from 14 teams were collected and the summary statistics yield [ = 1.134. yx = 3.642, 2 - 93.110. >. =.948622, and S'xy = 295.54 Assume $1 = 455 27 and