Assignment 7 No1 Confidence interval - proportion 95% confidence level 0.518550725 proportion 3450 n 1.960 z 0.017 margin of error 0.502 lower confidence limit 0.535 upper confidence limit No2 Confidence interval - mean 99% confidence level 23.95 mean 2.55 std. dev. 0.189 lower confidence limit 0.211 upper confidence limit No10 Confidence interval - mean 99% confidence level 15.3 mean 8.5 std. dev. 463 n 2.576 z 1.018 margin of error 14.282 lower confidence limit 16.318 upper confidence limit [...]
This is a 3 total page assignment assignment two is the Correlation ASSIGNMENT 1 The WORD file contains five problems. The EXCEL file contains the data you will use to solve the problems. You will use this file to submit your work. *** each question has its own tab in the Excel file. For each problem: Find the regression coefficient (r) Find the regression equation Use the regression equation for each of the problems to answer the last two parts of the questions. ASSIGNMENT 2 For each group of data, please do the following: a. Calculate r, by using the =CORREL command in Excel b. Graph the relationship and give the regression equation of each. ASSIGNMENT 3 Complete the assignment (PDF file below). You will use the Excel Calculator to answer a variety of questions that will have you constructing confidence intervals for parameters and determining minimum sample sizes.