Your employer, Apricot Computers, Inc., is interested in locating a new manufacturing facility in North Carolina. For easier access to their markets along the East coast and in the Atlanta area Apricot would like to locate the facility in the vicinity of Interstate 85.

Since Apricot is also interested in the educational level of the local workforce in the locations under consideration, you are told to obtain an estimate of the proportion p of the population over age 25 with a bachelors degree in each of several counties in the vicinity of Interstate 85, and present your results to the Apricot CEO.

To enhance your presentation to the CEO, you would like to show a plot of your estimates on a map of North Carolina. The data that you collected for 12 North Carolina counties in the vicinity of I85 is in this Excel file: BA Degrees . You can quickly plot this data on a Google map as follows:

In the BA Degrees Excel file copy cells A1:D13
Click Make Map to open a Google map making website.
At the Make Maps website opened in step 2, click in the field below "Paste your location data below to map it:" and paste the data from cells A1:D13.
Click the "Map Now" button.
In the resulting window fill in the Title and Description fields (put whatever you want for the tile and description; brief is better).
Enter your email address.
Click the "Save Map" button.
A link to the map will be sent to your email. Click the link in the email to view the map.
The map will have "balloon" markers showing the location of the counties. Click a balloon to see the name and proportion of adults over age 25 with a BA degree for that county.

Question 1. A major trucking company is located in Danville, Virginia, just across the state line with North Carolina. Simply by looking at the map, which county for which you have an estimated proportion is closest to Danville?

ForsythGuilford AlamanceDurhamOrange

A community college in Statesville, NC will offer technical training to Apricot employees at a reduced cost. The Apricot CEO would like a 95% confidence interval for p, the proportion of the population over the age of 25 with a bachelors degree, in the county closest to Statesville, NC.