z-test using Excel
Round all calculated values to 2 decimal places.
Download this file for the homework assignment: Cheese.xls. To download this file in Internet Explorer, right-click on the link, left-click on Save Target As ...., left-click on Save, the file will download. When the download is completed, left-click on Close.
Open the file Cheese.xls in Microsoft Excel. To do this, start Excel, left-click on File > Open, locate and single left-click the file in the Open dialog box, and left-click Open.
For all problems, assume the population standard deviation is equal to the sample standard deviation!
For problems 4 & 5, assume the information in the spreadsheet represents the population of all cereals.
1. Ms. Wisconsin Cheesehead hypothesizes that all cheese has an average taste value of 20. With a = 0.05 and a two-tailed test of significance, do you agree with her or not? Explain your answer in complete sentences. State values and provide a well-labeled printout that supports your answer.
2. Mr. Jack Colby hypothesizes that all cheese has an average taste value of at least 30. With a = 0.10 and a two-tailed test of significance, do you agree with the statement that all cheese has an average taste value of at least 30? Explain your answer in complete sentences. State values and provide a well-labeled printout that supports your answer.
3. Using the same data file, consider the lactic acid column. Determine if this sample is drawn from the population (mean = 1.34) using a = 0.05 and a two-tailed test of significance. Explain your answer in complete sentences. State values and provide a well-labeled printout that supports your answer.
Download this file for the homework assignment: Cereal.xls. To download this file in Internet Explorer, right-click on the link, left-click on Save Target As ...., left-click on Save, the file will download. When the download is completed, left-click on Close.
Open the file Cereal.xls in Microsoft Excel. To do this, start Excel, left-click on File > Open, locate and single left-click the file in the Open dialog box, and left-click Open.
4. The spreadsheet Cereal.xls gives information about 77 different cereals. We are going to split the cereals into two groups in alphabetical order (the order they are in the spreadsheet). Sample A corresponds to the first 40 cereals and Sample B corresponds to the other 37 cereals. (The second sample starts with Kix.) Determine if the two samples sodium levels are different with a = 0.01 and a two-tailed test of significance. Explain your answer in complete sentences. State values and provide a well-labeled printout that supports your answer.
5. Using the two samples from (3), determine if Sample A has (on average) more sugar than Sample B. Use a = 0.05 and a one-tailed test of significance to determine your answer. Explain your answer in complete sentences. State values and provide a well-labeled printout that supports your answer.