Barrier Data Visualization & Barriers Data Analysis

Barrier Data Visualization & Barriers Data Analysis

Follow the instructions to create assignments 1 to 12 by using the attached Barriers Codebook (Student). Xlsx as your template

Take screenshots of all the 12 and put in your portfolio.

Note: Submit the main graphs/charts in addition to the screenshots

1. “Summary Yrs_RN” worksheet

2. “Summary Tot_Scores” worksheet

3. “Summary Demographic” worksheet

4. “Summary Responses” worksheet

5. “Pivot Table Education Level by Work Setting”

6. “Pivot Table Age Group by Race”

7. “Bar Chart on the Mode” on all questions on the “Barriers Survey”

8. “Pie Chart of Age Group”

9. “Sunburst Chart” of Sex

10. “Column Chart” of Education Level

11. “Funnel Chart” of Race

12. “Treemap Chart” of Work Setting

For this activity, you are going to analyze hypothetical data from a Barriers to Research Utilization by Nurses survey using descriptive statistics. This data has been provided for you, and step-by-step instructions on doing the analysis in excel are provided below.

BACKGROUND

When collecting online survey data, the responses are generally textual data. Look at the Data_Raw worksheet to see the survey results. This raw data must be converted to numerical data for analysis.

To accomplish this, a Codebook is created that contains the data and metadata (the information for each variable with coding instructions). For this activity, the Barriers Codebook has already been created for you. Review the Metadata worksheet to see an overview of the variables in this survey (column A), variable type (column B), level of measurement (column C), coding instructions (Response Categories, column D), and the original Survey Question (column E).

Look to see how the data have been numerically coded for you on the Data_Coded worksheet. This was done by copying the Data_Raw worksheet, then using Find and Replace to code the responses numerically using the MetaData worksheet information. For example, in column D (Race), White was replaced with 1, African American was replaced with 2, Asian was replaced with 3 and Other was replaced with 4.

Now the original data has been coded, you want to retain the coded data to preserve it for additional analyses or if errors are made.

Note: These instructions use right-click to access the right-click menu. If unsure how to right-click on your computer, reach out to Student Success Center, IT services, or your course instructor. For example, Ctrl/click acts as a right-click on a Mac.

Barrier Data Visualization & Barriers Data Analysis

CREATE YOUR OWN DATA FILE COPY

This is where the real fun starts for this activity!

You will first copy the Data-Coded worksheet to a working file that you can use for this activity.

Desktop Excel	Web Excel
Copy the Data_Coded worksheet by right-clicking on the Data_Coded worksheet, selecting Move or Copy (see below) and checking the Create a Copy box.	Copy the Data_Coded worksheet by right-clicking on the Data_Coded worksheet, selecting Duplicate (see below).

Rename this copied worksheet Desc_Stats by right-clicking on the tab of the copied worksheet and selecting Rename and typing the new name.

Right-click again, choose Tab Color, and choose a different color than red (red is a reminder to not use these worksheets).

Next, click on the Desc_Stats worksheet and write a formula to total the scores on the Barriers Survey for each participant. The variable you will use for this is the Tot_Scores continuous variable in column AK. In column AK1, type the heading Tot_Scores. Next, enter this formula into cell AK2: =Sum(H2:AJ2) directly in the cell or the formula bar at the top, as shown. This formula will sum all the cells in Row 2 from Column H through Column AJ, which include all the “Q” items on the survey.

Make sure you see the formula bar displayed in this screenshot. If it is not there, click on the Formulas menu and check Show Formulas.