I need help with a homework lab that consists of four parts and an attachment that will have templates to go along with the questions below. In the Excel attachment there are two tabs that can be disregarded, I believe they are STD Normal and Normal EX. Thank you Part 1. Normal Distributions and Birth Weights in America (Insert your answers to the 5 questions on Birth Weights here. See Birth Weights worksheet from the Week6Lab.xls file. Copy-and-paste the Excel commands and/or Normal Probability Distributions you use to answer Questions 2a, 3a and 4a. You do not need to copy-and-paste anything for the other questions; you must provide your answers, however Part 2. Age Distribution in the United States (Insert your answers to the 6 questions on Age Distribution here. See the Age Dist worksheet from the Week6Lab.xls file. That worksheet has the data entered for you, as well as some of the required work. Part 3. Finding z- and t-scores for Confidence Intervals 1. Using Excel, find the z-score that corresponds to the following Confidence Levels: a. 80% b. 85% c. 92% d. 97% 2. Using Excel, find the t-score that corresponds to the following Confidence Levels and Sample Sizes: a. 95% with n = 25 b. 96% with n = 15 c. 97% with n = 21 d. 91% with n = 10 3. Suppose we wish to estimate the population mean using a confidence interval. When is it appropriate to use a z-score? When is it appropriate to use a t-score? (Answer the above questions. See the worksheet Conf Intervals from the Week6Lab.xls file for examples on finding z- and t-scores. You will find the above questions also posted inside that worksheet. You do not need to copy-and-paste anything from Excel here. Part 4. Bob?s Candies 1. Find the sample mean and sample standard deviation of the amount citizens spend per year. 2. When finding a confidence interval for the true mean spent of ALL citizens, should we use a z-score or a t-score? Why? 3. Find the z/t-values (as appropriate) for a 95% confidence interval and a 92% confidence interval. 4. Find a 95% and a 92% confidence interval for the true mean amount that citizens spend per year. 5. What do you think the lowest possible mean amount spent per year is? Why? 6. Do you think Bob has a good customer base for his new business? Explain. (See the worksheet Candy Business from the Week6Lab.xls file for a complete description of Bob?s situation. You will find the above questions also posted inside the worksheet. You do not need to copy-and-paste anything from Excel here.,I am having trouble locating the attachment, can you please clarify?,Is there any way we can set up a certain date and time where I will be able to access you with questions I may have? I had military training out of town and am having a hard time catching up with my Stats course. I already tried getting tutoring on campus but the student/instructor ratio is ridiculous. Please let me know. Thank you.
Paper#13325 | Written in 18-Jul-2015Price : $25