Student Activity: Using MS Excel Directions: Study the following situation and do the task. Then answer the following questions or supply the missing information. Submission: Upload the MS EXCEL sheet with the completed interpretation of results. Mr. Santiago's company sells bottled coconut juice. He claims that a bottle contains 500 ml of such juice. A consumer group wanted to know if his claim is true. They took six random samples of 10 such bottles and obtained the capacity, in ml, of each bottle. The result is shown as follows: Sample 1 Sample 2 Sample 3 Sample 4 Sample 5 Sample 6 500 500 497 501 502 496 498 500 497 495 497 497 497 495 502 500 497 496 503 494 496 497 499 495 499 498 497 497 496 497 497 500 497 500 497 497 497 500 497 500 497 500 497 500 497 495 499 500 497 500 497 497 500 496 495 497 495 497 500 497 Assuming that the measurements were carefully obtained and that the only kind of error present is the sampling error, what is the point estimate of the population mean? For this activity, we will use the EXCEL Program. A sample of the worksheet is shown as follows. Here are the steps: 1. Encode the data in the cells proceeding from cell A1 to cell A10. 2. Select the data. 3. Click the insert function fx. The Insert Function Dialog Box will appear. 4. In the insert function dialog box, click the arrow to select a category. A drop window will appear. In this window, click Statistical. 5. In the insert function dialog box, there is another window labelled select a function. Click AVERAGE. At the bottom of the box, click OK. 6. Another dialog box will appear. This is the Function Arguments box. There are two smaller windows in the box labeled Number 1 and Number 2. In the window Number 1, write A1:A10. The computer reads the numbers encoded in Column A Row 1, Column A Row 2, and so on to Column A Row 10. 7. Copy the Formula result in the dialog box. For the encoded data of Sample 1, the result is 498. Then, click OK. 8. Repeat the procedure for the other samples. 9. Compute the mean of the means also called the overall means. This is the point estimate of the population mean μμ. Interpretation of results: Complete the following statements: The computed mean ____________ based on the sample is ( equal to, slightly less than, slightly more than) the claimed value of 500 ml. Now, based on the sample result, what action (e.g. patronage of the product) would you make?
Student Activity: Using MS Excel
Directions: Study the following situation and do the task. Then answer the following questions or supply the missing information.
Submission: Upload the MS EXCEL sheet with the completed interpretation of results.
Mr. Santiago's company sells bottled coconut juice. He claims that a bottle contains 500 ml of such juice. A consumer group wanted to know if his claim is true. They took six random samples of 10 such bottles and obtained the capacity, in ml, of each bottle. The result is shown as follows:
Assuming that the measurements were carefully obtained and that the only kind of error present is the sampling error, what is the point estimate of the population mean? |
For this activity, we will use the EXCEL Program. A sample of the worksheet is shown as follows.
Here are the steps:
1. Encode the data in the cells proceeding from cell A1 to cell A10.
2. Select the data.
3. Click the insert
4. In the insert function dialog box, click the arrow to select a category. A drop window will appear. In this window, click Statistical.
5. In the insert function dialog box, there is another window labelled select a function. Click AVERAGE. At the bottom of the box, click OK.
6. Another dialog box will appear. This is the Function Arguments box. There are two smaller windows in the box labeled Number 1 and Number 2. In the window Number 1, write A1:A10. The computer reads the numbers encoded in Column A Row 1, Column A Row 2, and so on to Column A Row 10.
7. Copy the Formula result in the dialog box. For the encoded data of Sample 1, the result is 498. Then, click OK.
8. Repeat the procedure for the other samples.
9. Compute the mean of the means also called the overall means. This is the point estimate of the population mean μμ.
Interpretation of results:
Complete the following statements:
The computed mean ____________ based on the sample is ( equal to, slightly less than, slightly more than) the claimed value of 500 ml. Now, based on the sample result, what action (e.g. patronage of the product) would you make? _________________________________________________________________________________________________________ |
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![MATLAB: An Introduction with Applications](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
![Probability and Statistics for Engineering and th…](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
![Statistics for The Behavioral Sciences (MindTap C…](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
![MATLAB: An Introduction with Applications](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
![Probability and Statistics for Engineering and th…](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
![Statistics for The Behavioral Sciences (MindTap C…](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
![Elementary Statistics: Picturing the World (7th E…](https://www.bartleby.com/isbn_cover_images/9780134683416/9780134683416_smallCoverImage.gif)
![The Basic Practice of Statistics](https://www.bartleby.com/isbn_cover_images/9781319042578/9781319042578_smallCoverImage.gif)
![Introduction to the Practice of Statistics](https://www.bartleby.com/isbn_cover_images/9781319013387/9781319013387_smallCoverImage.gif)