How could color coding large data sets save data analysts

Assignment Help Management Theories

Reference no: EM133769227

Public Health Policy And Leadership

Excel Foundations Assignment Content
You work in your state's health department. Your manager wants your help in analyzing the local Covid transmission rates. She is hoping you can automate a spreadsheet so it can quickly highlight critical information for your department.

Create a spreadsheet that utilizes conditional formulas within Microsoft Excel spreadsheet to fulfill your manager's request by completing the following steps:

Access data on Covid transmission rates from the CDC website. This website lists the data in a spreadsheet format.
Open Microsoft Excel software
Create a new Microsoft Excel file named "MPH 570 Excel Assignment."
Create a new worksheet in your Microsoft Excel file and name it "Conditional Formatting."
Add Covid data for at least 10 counties in your state or a neighboring state that are close to your local area including the following:
County population
Covidinpatientbedutilization
Covid_hospital_admissions_per_100k
Covid_cases_per_100k
Covid-19_community_level
Create column titles that accurately describe each type of data you chose to include.
Automate color coding of the following data using conditional formatting in Microsoft Excel:
Color code all counties with high community risk level in orange.
Color code all counties with low community risk level in green.
Color code all counties with more than 100 Covid cases per 100,000 people in purple.
Color code all counties with more than 10 Covid hospitalizations per 100,000 people in red.

Within your Excel spreadsheet, write a 75- to 90-word response on the value of automating color coding of data. Consider the following questions:

How could color coding large data sets save data analysts time?
How can color coding large data sets help in communicating conclusions based on data?

Reference no: EM133769227

Questions Cloud

Teaching about common findings of osteoarthritis : A nurse is teaching about common findings of osteoarthritis to a group of older adults. Which of the following should be included?

What do you notice about the proportion : Briefly describe some reasons for the differences in the width of these age bands and What proportion of KG Countywas female in the year this data is from

Analysing and comparing the financial statements : analysing and comparing the financial statements, associated notes and relevant accounting standards within the annual reports of two Universities

Nurse leader role and function within organisation : In this section, you will construct a professional description of the nurse leader's role and function within an organization.

How could color coding large data sets save data analysts : How could color coding large data sets save data analysts time? How can color coding large data sets help in communicating conclusions based on data?

Discuss how africa fits into world or western history : Discuss how Africa fits into world or Western history. Compare and contrast the opinions of Europeans and Americans in relation to Africa and its people.

Populations are evaluated to distinguish subpopulations : The wellbeing and medical care needs of a populations are evaluated to distinguish subpopulations

Explain the differences between a pure project : Explain the differences between a pure project, a functional project, and a matrix project. List some advantages and disadvantages of each.

Describe how research findings may be important : Describe how research findings may be important for advanced nursing policies, practice, theories, and subsequent research. Explain the implications

User Account

All Pages