Barrier Data Visualization & Barriers Data Analysis Barrier Data Visualization & Barriers Data Analysis Follow the instructions to create assignments 1 to 12 by

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.




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




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.

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
The price is based on these factors:
Academic level
Number of pages
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more
Open chat
Hello. Can we help you?