Chapter 4.10, Problem 1DQ

Please conduct a step by step of these statistical tests on separate sheets of Microsoft Excel. If the calculations in Microsoft Excel are incorrect, the null and alternative hypotheses, as well as the conclusions drawn from them, will be meaningless and will not receive any points.  The data for the following questions is provided in Microsoft Excel file on 4 separate sheets. Please conduct these statistical tests on separate sheets of Microsoft Excel. If the calculations in Microsoft Excel are incorrect, the null and alternative hypotheses, as well as the conclusions drawn from them, will be meaningless and will not receive any points.   1. One Sample T-Test: Determine whether the average satisfaction rating of customers for a product is significantly different from a hypothetical mean of 75.  (Hints: The null can be about maintaining status-quo or no difference; If your alternative hypothesis is non-directional (e.g., μ≠75), you should use the two-tailed p-value from excel file to…

Use the definite integral to find the area between the x-axis and f(x) over the indicated interval. Check first to see if the graph crosses the x-axis in the given interval. 3. f(x) = 4x; [-5,3]

Use the definite integral to find the area between the x-axis and f(x) over the indicated interval. Check first to see if the graph crosses the x-axis in the given interval. f(x)=3e-4; [3,3]