MSN, NURSING EXCELL

profileKofi

Assignment: 

Read these following 2  attached instructions:

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

  • 5 years ago
  • 10
Answer(1)

Purchase the answer to view it

blurred-text
  • attachment
    summarytot_scores.PNG
  • attachment
    PivotTableAgeGroupbyRace.PNG
  • attachment
    PivotTableEducationLevelbyWorkSetting.PNG
  • attachment
    BarriersCodebookStudent1.xlsx
  • attachment
    summaryYrs_Rnscores.PNG
  • attachment
    BarChart_Q-Mode.PNG
  • attachment
    treemap.PNG
  • attachment
    sunburstchart.PNG
  • attachment
    scatterchart.PNG
  • attachment
    linechart.PNG
  • attachment
    funnelchart.PNG
  • attachment
    doughnutchart.PNG
  • attachment
    bubblechart.PNG
  • attachment
    PivotTableEducationLevelbyWorkSetting1.PNG
  • attachment
    summaryYrs_Rnscores1.PNG
  • attachment
    summarytot_scores1.PNG
  • attachment
    PivotTableAgeGroupbyRace1.PNG
  • attachment
    areachart.PNG
  • attachment
    BarChart_Q-Mode1.PNG
  • attachment
    columnchart.PNG