Question: Take this file as input: state_population.csv ( I cant upload the file so I took a picture of the numbers) Use the population

Take this file as input: state_population.csv ( I cant upload the file so I took a picture of the numbers)

Use the population field as the datapoint to select your sample.

Set the margin of error (.01, .05, .10)

Calculate the following summary statistics for the selected field:

Count, Min, Max, and Standard Deviation
Sample Size at 80%, 85%, 90%, 95%, 99% confidence using .01, .05, .10 margin of error respectively

Note use .5 standard deviation instead of the actual standard deviation to calculate the sample size

Create test data file(s) that contain the number of values specified by the sample size; however, these files must contain records that include max and min of the selected data point from the original data set.

Output test data files to the output directory called "sample_files_output"

Your program should output 15 different files using the naming convention

sample_data_confidenceInterval_marginError_recordCount.csv:
- For example (counts are accurate):
  1. sample_data_number_1.28_0.1_22.csv
  2. sample_data_number_1.28_0.01_51.csv
  3. sample_data_number_1.28_0.05_39.csv
  4. sample_data_number_1.44_0.1_25.csv
  5. sample_data_number_1.44_0.01_51.csv
  6. sample_data_number_1.44_0.05_41.csv
  7. sample_data_number_1.65_0.1_29.csv
  8. sample_data_number_1.65_0.01_51.csv
  9. sample_data_number_1.65_0.05_43.csv
  10. sample_data_number_1.96_0.1_33.csv
  11. sample_data_number_1.96_0.01_51.csv
  12. sample_data_number_1.96_0.05_45.csv
  13. sample_data_number_2.58_0.1_39.csv
  14. sample_data_number_2.58_0.01_51.csv
  15. sample_data_number_2.58_0.05_48.csv

state,pop Montana, 1041732.0 Oklahoma, 3918137.0 Delaware, 949495.0 Arizona, 6946685.0 Florida, 20598139.0 Alabama, 4864680.0 Utah, 2203366.0 Michigan, 9957488.0 North Carolina, 10155624.0 Virginia, 8413774.0 Rhode Island, 1056611.0 Vermont, 624977.0 Alaska, 736384.0 Kansas, 2908776.0 Wyoming, 581836.0 District of Columbia, 684498.0 Iowa, 3132499.0 Idaho, 1687809.0 New Hampshire, 1343622.0 New Jersey, 8881845.0 Maryland, 6003435.0 North Dakota, 752201.0 Hawaii, 1421954.0 South Dakota, 864289.0 Massachusetts, 6801779.0 Tennessee, 6651089.0 Illinois, 12821497.0 Kentucky, 4440204.0 Puerto Rico, 3386941.0 California, 39148760.0 Wisconsin, 5778394.0 Georgia, 10297484.0 Mississippi, 2988762.0 New Mexico,2092434.0 Oregon, 4081943.0 Minnesota, 5527358.0 Louisiana, 4663616.0 Connecticut, 3581504.0 New York, 19618453.0 Maine, 1332813.0 Pennsylvania, 12791181.0 Texas, 27885195.0 West Virginia, 1829054.0 Ohio, 11641879.0 Indiana, 6637426.0 Missouri, 6090062.0 Nevada, 2922849.0 Arkansas, 2990671.0 South Carolina, 4955925.0 Colorado, 5531141.0 Nebraska, 1904760.0 Washington, 7294336.0

Step by Step Solution

★★★★★

3.52 Rating (155 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Code Unix Terminal cat salespy usrlocalbinpython3 def main reading file with openboroughsalescsv as ... View full answer

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 Programming Questions!

Design a Java class that represents a cache with a fixed size. It should support operations like add, retrieve, and remove, and it should evict the least recently used item when it reaches capacity.

Examine the following program: class Exercise1 { public static void main (String[] args ) { int[] val = {0, 1, 2, 3}; sum = System.out.println( "Sum of all numbers = " + sum ); } } Complete the...

Give Correct ANSWERS Human-Computer Interaction (a) If you had been one of the original inventors of the WIMP interface, and engineers on the technical team had been sceptical about the advantages...

I know its a bit harsh but see if you can finish it in before tomorrow? thanks QUEENSLAND UNIVERSITY OF TECHNOLOGY QUT Business School School of Accountancy AYN416 Financial Accounting 1 Semester 2...

I have an accounting assignment need to be finished asap. QUEENSLAND UNIVERSITY OF TECHNOLOGY QUT Business School School of Accountancy AYN416 Financial Accounting 1 Semester 1 2017 Integrated...

Needing ANSWERS ASAP! Starting at pg 34 - Labeled Graded Project 06155200: Graded Project Instructions & Worksheets 1 Lesson 1: Business, Accounting, and You PROJECT GOAL The goal of this graded...

Problem 3 How does computing the amount paid in commissions to Metaphor agents in Problem 2 help an auditor verify the management assertion of completeness? Chapter 3 ACL Exercises and Problems...

package prog340; import javax.swing.*; import java.io.*; import java.util.*; import java.awt.*; import java.awt.event.*; /** ProgramA simply reads a file containing rows of space-separated Strings,...

Lysine, an essential amino acid in the human body, contains C, H, O, and N. In one experiment, the complete combustion of 2.175 g of lysine gave 3.94 g CO2 and 1.89 g H2O. In a separate experiment,...

NPV: According to the text, the NPV rule states that "An investment should be accepted if the NPV is positive and rejected if it is negative." What does an NPV of zero mean? If you were a...

Case Cal Temp Discuss the factors affecting audit quality; Discuss the different opinions on audit quality issues from researchers, practitioners, and regulators.

Describe a scenario in the field of Finance which could be modeled as a Binomial Distribution. (Word count around 150 words) (b) Seed crops such as wheat, maize, pumpkin are sensitive to moisture and...

Your plans to invest $200 million in two (2) projects. The first project you are contemplating is to a restaurant and sports bar and the second is to invest in a hardware store. The problem is that...

You are a famous musician and have 1,500,000 of wealth. You own a Stradivarius violin valued at 600, 000. During the year you travel a lot and estimate that there is a 5% chance that your violin is...

Lavage Rapide owns and operates a large automatic car wash facility near Montreal. The following table provides estimates concerning the company's costs: Fixed Cost per Month Cost per Car Washed...

You work for a major consumer research bureau that has been commissioned by 11 major UK companies to design, deliver and analyse the data collected from a telephone questionnaire. The purpose of this...

Visit the Internet gateway to the European Union website (http://europa.eu/) and click on the link in your own language. Discuss with a friend how you might use the data available via links from this...

The following secondary data have been obtained from the Park Trading Companys audited annual accounts: a. Which are the variables and which are the cases? b. Sketch a possible data matrix for these...

Should producers of software-based services, such as ATMs, be held liable for economic injuries suffered when their systems fail?

It has been said that there is no such thing as a sustainable competitive advantage. Do you agree? Why or why not?

What are some of the organizational, managerial, and social complementary assets that help make UPS ? s information systems so successful?