Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started