Chapter 12, Problem 9CQQ

Could you please answer this question using excel. For 1a) I got 84.75 and for part 1b) I got 85.33 and was wondering if you could check if my answers were correct. Thanks

What is one sample T-test? Give an example of business application of this test? What is Two-Sample T-Test. Give an example of business application of this test? .What is paired T-test. Give an example of business application of this test? What is one way ANOVA test. Give an example of business application of this test? 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 make a decision about rejecting or not rejecting null. If alternative is directional (e.g., μ < 75), you should use the lower-tailed p-value. For alternative hypothesis μ > 75, you should use the upper-tailed p-value.)   H0 =   H1=   Conclusion: The p value from one sample t-test is _______. Since the two-tailed p-value…

Using the accompanying Accounting Professionals data to answer the following questions.   a. Find and interpret a 90​% confidence interval for the mean years of service. b. Find and interpret a 90​% confidence interval for the proportion of employees who have a graduate degree.    view the Accounting Professionals data. Employee    Years of Service    Graduate Degree?1    26    Y2    8    N3    10    N4    6    N5    23    N6    5    N7    8    Y8    5    N9    26    N10    14    Y11    10    N12    8    Y13    7    Y14    27    N15    16    Y16    17    N17    21    N18    9    Y19    9    N20    9    N     Question content area bottom Part 1 a. A 90​% confidence interval for the mean years of service is   ​(Use ascending order. Round to two decimal places as​ needed.)