CU Boulder MATH 2510 - Introduction to Statistics 1 Activity 3 - Due Friday, July 21 This activity again requires that you complete some computations in Excel. However, in this activity YOU will be both the designer and programmer of the Excel datasheet. Further, you will only need to submit an Microsoft Excel workbook (.xlsx) file. No additional written responses are required. In summary, you are required to build two separate Hypothesis Test Calculators in Excel. Precisely what Excel functions you use, what intermediate calculations you may decide to perform, and what layout you choose to collect information and present results is up to you. However, in order to be functional, your calculator must make sense to a user other than you AND your calculator must be robust to handle any data for any kind of hypothesis test for a single population mean. Your Excel workbook will be graded based on two considerations: \"Is your calculator design user-friendly enough to be understood by the instructor?\" and \"Does your calculator generate the correct results when different values are entered into the calculator?\" Each calculator will be subjected to three sets of test data. You are welcome to discuss this activity with other students, but please make sure that you have designed your own calculator. Exact duplicates of Excel workbooks will be considered a violation of the Honor Code. Submit the completed Excel workbook to the D2L Dropbox for this activity no later than 11pm (MT) on Friday, July 21. Documents of any other format or submitted in any place other than the D2L Dropbox will not be accepted for grading. 1. Hypothesis Test for a Population Mean () when the Population Standard Deviation () Is Known For this calculator, the user will need to enter the following. The The The The The null hypothesis population mean value known population standard deviation value alpha value of the hypothesis test mean of the random sample selected size of the random sample selected 2. Hypothesis Test for a Population Mean () when the Population Standard Deviation () Is UNKnown For this calculator, the user will need to enter the following. The The The The The null hypothesis population mean value alpha value of the hypothesis test mean of the random sample selected standard deviation of the random sample selected size of the random sample selected 3. In both cases, the results must include the following. The The The The value of the standardized test statistic P -value for the test statistic critical values for the rejection region result of \"Reject\"- or \"Fail to reject\"- the null hypothesis If you would like some further suggestions and hints, please read on. Otherwise, BEGIN. CU Boulder MATH 2510 - Introduction to Statistics 2 SOME TIPS AND SUGGESTIONS 1. Note that although there are built-in function in Excel called Z.TEST and T.TEST, they refer to arrays of data. When only the sample statistics are provide (and not the sample data itself), then these functions cannot be used directly. 2. The standardized test statistic can be calculated by arithmetic formula from the book. Once you have the values of x , , or s, and n in your Excel datasheet, simply use cell references and enter the relevant arithmetic formula. 3. The P -value can be computed using the NORM.DIST or the T.DIST function once the standardized test statistic has been determined. See below for more information on these functions. 4. The critical value(s) can be computed using the NORM.INV or the T.INV function. See below for more information on these functions. 5. The result of \"Reject the null hypothesis\" or \"Fail to reject the null hypothesis\" can be programmed with the IF function. Once the P -value is determined, you can program a formula to say \"IF P , THEN reject the null hypothesis, ELSE fail to reject the null hypothesis\". See below for more information on the IF function. 6. If you are struggling to come up with design ideas: Here is a snapshot of a calculator when the direction of the tail of the test is actually entered (as \"Left\