See the attached Excel spreadsheet and 2 files which may be of assistance in determining the Mean. The spreadsheet contains the amount of fluid ounces of each of the 40 paint cans.
NOTE: Please use an Excel spreadsheet for response. Please do not just provide the answers but show in complete detail how you arrived at the answers, step-by-step, from the beginning to the end of the solution.
1. Excel spreadsheet - Confidence Interval for the Population - Mean Volume
2. Procedure for Excel confidence interval for µ based on raw data and Ï? know
3. A Worksheet for constructing a Confidenct Interval: Mean Volume
A Complete, Neat and Step-by-step Solution is provided in the attached file.