logo Hurry, Grab up to 30% discount on the entire course
Order Now logo

Ask This Question To Be Solved By Our ExpertsGet A+ Grade Solution Guaranteed

expert
Willard BoiceeManagement
(5/5)

559 Answers

Hire Me
expert
StatAnalytica ExpertScience
(5/5)

596 Answers

Hire Me
expert
Haneef MahomamadManagement
(5/5)

617 Answers

Hire Me
expert
William DewarrEngineering
(5/5)

924 Answers

Hire Me
Excel
(5/5)

When you open up the Excel file for this assignment, you will see the worksheet with the tab labeled

INSTRUCTIONS TO CANDIDATES
ANSWER ALL QUESTIONS

Task 1: Freezing Top Row and Explore Data Set 

1.1 : Familiarize Yourself with the Dataset

When you open up the Excel file for this assignment, you will see the worksheet with the tab labeled “Main Data Set” in the lower-left corner of the screen.  The data set provided is a set of select variables from the 2018 County Health Rankings for all counties in Oregon and nearly all counties in Idaho.  The MS Excel file containing this dataset is linked in the Mod 2 folder in the course site on Canvas.  Please download this file now, if you have not done so already.

 

 When you open the data set in Excel, you will see Row 1 consisting of headings, with Rows 2-80 containing county-specific data from Idaho and Oregon.  Columns A-P are populated with data, and you will need to populate Columns Q and R by calculating new variables by following the instructions provided below.  All data is for 2018.  

 

Below is a summary of the data included in Columns A-P: 

A. County FIPS Code.  This is a unique number assigned to each county in the United States by the U.S. Census Bureau.  

B. State.  The state in which the county is located.

C. County.  The name of the county.  

D. Population.  The population of the county in 2018.

E. % of population over the age of 65.  The percentage of county residents over the age of 65 in 2018.

F. % of residents living in rural areas.  The percentage of county residents living in  a rural area in 2018, which the U.S. Census Bureau defines as non-urban areas with fewer than 2,500 inhabitants.

G. Median household income.  The median  household income in the county in 2018.

H. Health costs per capita.  This is the average amount of total health expenditures per person in the county in 2018.

I. % of adults in fair/poor health.  This is the percentage of individuals who reported being in “fair” or “poor” health, age-adjusted.  As with many of these variables, this is based on surveys of a representative sample of county residents.

J. % of adult smokers. Percentage of adults who are current smokers.

K. % of adults who are physically inactive.  This is the percentage of adults age 20 and older reporting no leisure-time physical activity. 

L. % with access to exercise opportunities.  This is the percentage of the population with access to adequate exercise opportunities.

M. % with limited access to healthy food. Percentage of the population who are low-income and do not live close to a grocery store.

N. % of uninsured.  Percentage of population under the age of 65 who lack health insurance (both children and adults under age 65).

O. Number of primary care physicians.  Number of primary care physicians (MDs, DOs,) practicing in the county.

P. Number of other primary care providers.  Number of non-physician practitioners providing primary care, including physician assistants (PAs), nurse practitioners (NPs), and clinical nurse specialists.

 

(5/5)
Attachments:

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme

January
January
February
March
April
May
June
July
August
September
October
November
December
2025
1950
1951
1952
1953
1954
1955
1956
1957
1958
1959
1960
1961
1962
1963
1964
1965
1966
1967
1968
1969
1970
1971
1972
1973
1974
1975
1976
1977
1978
1979
1980
1981
1982
1983
1984
1985
1986
1987
1988
1989
1990
1991
1992
1993
1994
1995
1996
1997
1998
1999
2000
2001
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023
2024
2025
2026
2027
2028
2029
2030
2031
2032
2033
2034
2035
2036
2037
2038
2039
2040
2041
2042
2043
2044
2045
2046
2047
2048
2049
2050
SunMonTueWedThuFriSat
29
30
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
1
00:00
00:30
01:00
01:30
02:00
02:30
03:00
03:30
04:00
04:30
05:00
05:30
06:00
06:30
07:00
07:30
08:00
08:30
09:00
09:30
10:00
10:30
11:00
11:30
12:00
12:30
13:00
13:30
14:00
14:30
15:00
15:30
16:00
16:30
17:00
17:30
18:00
18:30
19:00
19:30
20:00
20:30
21:00
21:30
22:00
22:30
23:00
23:30