Question: Reconsider Example 6.13, but use the Data Analysis tool to undertake the analysis. Data from Example 6.13 In this example we will use the F

Reconsider Example 6.13, but use the Data Analysis tool to undertake the analysis.


Data from Example 6.13

In this example we will use the F test to check if the two population variances in Example 6.7 can be considered equal with a 95% confidence.


Data from Example 6.7

A certain product of organic beans are packed in tins and sold by two local shops. The local authority have received complaints from customers that the amount of beans within the tins sold by the shop are different. To test this statistically two small random samples were collected from both shops. Conduct a two sample t-test for the population mean (independent samples, equal variance) to test this hypothesis.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Figure 631 illustrates the application of the Excel Analysis ToolPak ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Business Statistics Using Excel Questions!