CU Boulder MATH 2510 - Introduction to Statistics 1 Activity 4 - Due Friday, August 4 For the final activity, you will again design your own calculator in Excel. This time, the calculator will be for the various results related to correlation and regression covered in Chapter 9 of the textbook. As with Activity 3, you will only need to submit an Microsoft Excel workbook (.xlsx) file. No additional written responses are required. Precisely which 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. 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?” 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, August 4. Documents of any other format or submitted in any place other than the D2L Dropbox will not be accepted for grading. 1. The user will enter the following: • A list of (explanatory) x-variable values. Allow for a list of up to 40 values • A list of corresponding (response) y-variable values. Allow for a list of up to 40 values • An alpha value for a hypothesis test for the population correlation coefficient ρ (rho) • A level of confidence for a prediction interval for y • An x-value for a prediction interval for y 2. Your calculator must generate (at least) the following results: • The scatterplot for the (x, y) pairs • The correlation coefficient • The coefficient of determination • The critical value for the hypothesis test for ρ (or both critical values) • The standardized test statistic for the hypothesis test for ρ • The P-value for the hypothesis test for ρ • The outcome for the hypothesis test for ρ (as in “Reject the null hypothesis” or ”Fail to reject the null hypothesis”, where the null hypothesis is always ρ = 0, in accordance with the textbook) • The slope and the intercept of the regression line • The standard error of estimate for the regression line • The critical value for the prediction interval for y • The predicted value, ˆy, for the given x-value • The lower and upper bounds for the prediction interval for y 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. To start, here is an image of a sample design. Again, you can design your calculator however you like, as long as it meets the requirements previously described. (The data used is from Chapter 9 of the textbook, starting in Example 4 on page 474 and referenced again in Sections 9.2 and 9.3.) 2. The functions listed below (and scatterplots) will operate perfectly well even when empty cells are referenced. So, for example, although the image of the sample shown above consists of only 10 data pairs, the formulas reference the entire 40-cell range provided for data. As long as the cells are empty (and not filled with “0” or blank spaces), the functions should generate accurate results. If you are using functions other than those listed below, then you may encounter errors when blank cells are referenced. 3. Although some results may be generated from built-in Excel functions others may need to be calculated directly by arithmetic formulas provided in the textbook. 4. Remember that for linear regression, the degrees of freedom to use with the Student’s t-distribution is n − 2, where n is the number of data pairs. CU Boulder MATH 2510 - Introduction to Statistics 3 5. Here is a list of potentially useful built-in Excel functions for this activity. (Because previous activities should have built up your Excel knowledge and experience, only the function name will be given here.) Again, the use of any of these functions is NOT required. It is merely a list of functions that you may find helpful. • CORREL • SLOPE • INTERCEPT • STEXY • SUM and SUMSQ • COUNT • AVERAGE • SQRT • FORECAST • T.DIST or T.DIST.2T • T.INV or T.INV.2T

AccountingQueen

(3)

Status NEW Posted 13 Aug 2017 04:08 PM My Price 10.00

Hel-----------lo -----------Sir-----------/Ma-----------dam----------- T-----------han-----------k y-----------ou -----------for----------- us-----------ing----------- ou-----------r w-----------ebs-----------ite----------- an-----------d a-----------cqu-----------isi-----------tio-----------n o-----------f m-----------y p-----------ost-----------ed -----------sol-----------uti-----------on.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age----------- I -----------wil-----------l

Not Rated(0)

• Buy Answer