Question description
1. Prepare an Excel® spreadsheet containing the following:Column 1 – selected state countiesColumn 2 – population 2010Columns 3 and beyond – values of selected variablesCalculate the state’s mean and standard deviation for your selected variables. (state of Georgia) Construct a frequency table and histogram for your selected variables.Calculate the mode and median for your selected variables. 2. Prepare a Word document in which you explain normality of the distribution and assess the importance. These are the two things that needs to be submitted.Excel® spreadsheet with calculations and graphicsWord document (2-3 pages) with results in table, graphs, and explanationHere is the website for the food atlas spreadsheet that has to be used. http://www.ers.usda.gov/data-products/food-environment-atlas/about-the-atlas.aspx#.U4tAg5SwJ_cCompare your selected state’s information from the above work with the data for the United States (USA) using percentages. Select a hypothesis testing method to determine whether the difference between state and USA data is significant or not. Explain your methods of selection.Determine the confidence intervals for significance levels of 0.05 and 0.1.You need to submitExcel® spreadsheet with calculationsWord document (2-3 pages) with results in table, and explanation
Our Key Guarantees
- ✓ 100% Plagiarism-Free
- ✓ On-Time Delivery
- ✓ Student-Friendly Pricing
- ✓ Human-Written Papers
- ✓ Free Revisions (14 days)
- ✓ 24/7 Live Support