Question: Rig River, Inc., a major Alaskan fish processor is attempting to determine the weight of salmon in the northwest Green River. A random sample of

Rig River, Inc., a major Alaskan fish processor is attempting to determine the weight of salmon in the northwest Green River. A random sample of salmon was obtained and weighted. The data are stored in the data file labeled Bigfish. a. Use Excel's Data Analysis to get the descriptive statistics, including a 95\% confidence interval. b. Use Excel printout in part a to construct a 95\% confidence interval for the population mean weight. Show your work. c. Use Excel printout in part a to test if there is a strong evidence to conclude that the population mean weight for the fish is less than 55. Use the p-value approach and =0.05. d. Use Excel printout in part a to test if there is a strong evidence to conclude that the population mean weight for the fish is different from 55. Use the p-value approach and =0.05. Rig River, Inc., a major Alaskan fish processor is attempting to determine the weight of salmon in the northwest Green River. A random sample of salmon was obtained and weighted. The data are stored in the data file labeled Bigfish. a. Use Excel's Data Analysis to get the descriptive statistics, including a 95\% confidence interval. b. Use Excel printout in part a to construct a 95\% confidence interval for the population mean weight. Show your work. c. Use Excel printout in part a to test if there is a strong evidence to conclude that the population mean weight for the fish is less than 55. Use the p-value approach and =0.05. d. Use Excel printout in part a to test if there is a strong evidence to conclude that the population mean weight for the fish is different from 55. Use the p-value approach and =0.05
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
