Details of this Paper

ECONOMICS Two Problems

Description

solution


Question

Question;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 data11.5;11.6;11.8;11.8;The data will keep changing, do not worry. Answer the following BASED ON THE EXCEL OUTPUT12.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 data3;3.2;1.9;4;1.2;0.7;The data will keep changing, do not worry. Answer the following BASED ON THE EXCEL OUTPUT5;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

 

Paper#57575 | Written in 18-Jul-2015

Price : $25
SiteLock