ECONOMICS Two Problems

ABC Bottling Co. obtained two samples as shown below

This Month (oz)	Last Month (oz)
11.6	11.6
13.5	13.6	2 points	Use the appropriate Excel Add-In and paste the output in the yellow box below the data
11.5	11.6
11.8	11.8	The data will keep changing, do not worry. Answer the following BASED ON THE EXCEL OUTPUT
12.5	12.5
12	12	1 point	Based on the Excel output, what is the p-value that is used to determine whether the volume content has increased since last month?
12	12
11	11.1			<--Enter p-value
12	12.2
12.9	13.1	2 points	Based on the p-value, alpha = .05, would you conclude that the volume content has increased since last month?
13	13
12.3	12.3			<--Type 'yes' or 'no'
12.8	13
11.1	11.1
12.2	12.3
11.5
11.9
12
12
12
11

A sample of 40 Georgia households reported their milk consumption during January and February of this year:

Household	January (Gallon)	February (Gallon)
1	0.6	3.5
2	2.2	1.3	2 points	Use the appropriate Excel Add-In and paste the output in the yellow box below the data
3	3.2	1.9
4	1.2	0.7	The data will keep changing, do not worry. Answer the following BASED ON THE EXCEL OUTPUT
5	2	1.5
6	2.4	1.7	1 point	Based on the Excel output, what is the p-value that is used to determine whether the volume content has CHANGED between January and February?
7	1.5	3
8	0.2	2.8			<--Enter p-value
9	1.8	1.2
10	1.2	1.2	2 points	Based on the p-value, alpha = .05, would you conclude that the Georgia household milk consumption has CHANGED between January and February?
11	2	1.7
12	1.1	3			<--Type 'yes' or 'no'
13	1.7	1.6
14	2.9	0.8
15	3.3	1.8
16	1.1	2.3
17	1.6	2
18	3.4	1.6
19	2.1	1.5
20	2	3
21	1.9	2.3
22	1.3	2.6
23	2.2	2.2
24	2.4	1.7
25	0.5	2
26	1.6	2.9
27	3.2	1.9
28	1.6	2
29	1.5	1.9
30	1.3	1.7
31	2.2	2.1
32	1.4	2.1
33	2	1.4
34	2.4	0.4
35	1	1.9
36	1.9	1.8
37	1.2	2
38	1.1	1.3
39	1	1.8
40	2.6	1.1

ECONOMICS Two Problems Solution

NOT RATED

Purchase the answer to view it