Lab_Practice_5

# Lab_Practice_5 - contains likely trier income(\$K and the...

This preview shows page 1. Sign up to view the full content.

_________________________________________________________________________________________________ BUSI 410 – Lab Practice #5 Due 3/17/2010 This lab practice is intended to provide you with some practice using Excel to do statistical inference. Before you start on the lab practice, make sure your copy of Crystal Ball is still working. You will need it for our lab session on March 17. Then download the following Excel files from Blackboard: Excel3.1 Bottled Water Demand.xls, Excel3.5 Pampers Segment Income.xls, and Excel3.6 Pampers Segment Income.xls. Then follow the instructions for Excel Exercises 3.1, 3.2, 3.5 and 3.6 on pp. 59 to 61 and 69 to 71 in your textbook. Before doing the exercises, please make sure to correct the typos on these pages using the corrections file available on Blackboard. In addition, on page 69 replace “column A contains unlikely trier income (\$K) and the second column B contains likely trier income (\$K)” with “column B
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: contains likely trier income (\$K) and the second column C contains un likely trier income (\$K). On the same page, also replace values in A with values in C . Plan to print out and hand in the following: a) For Exercise 3.1 hand in only the mean, standard deviation, standard error, t and p values, appropriately labeled. Do not include a printout of the data! b) For Exercise 3.2, again hand in only the labeled results: Margin of error, 95% lower and 95% upper. c) For Exercise 3.5, again hand in only the labeled result: p value. d) For Exercise 3.6, again hand in only the labeled results: Mean and standard deviation for each segment, segment mean difference, standard error, approximate margin of error, 95% lower and 95% upper. You should be able to get all your results on a single sheet of paper. As with previous lab practice assignments, this is an individual assignment. Each of you should plan to hand in his/her own paper....
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online