Skip to main content

Reporting Survey Data Using Maps

 In a previous post, I reported the value of reporting polling data using averages of many polls for the leading candidates. I mentioned that national polls are interesting but the US chooses a president based on the electoral college.

Because the electors are chosen by states, it makes sense to predict winners by observing how the population of a state is likely to vote and thereby decide how many electors "won" by a candidate. This assumes an elector does not go rogue and vote for their preferred candidate.

This map can of course change with every new poll, but has the potential for a more accurate prediction than charts of national polls.

The chart map video is from NBC News.

How do you create map charts?

Microsoft Excel has you covered-- see Create a Map chart in Excel.

  In Excel, you will find the map option labeled Geography under the Data tab.


You can download examples with several map charts from Microsoft.

Learn more about surveys in Creating Surveys available on AMAZON












Comments

Popular posts from this blog

Academic Self-Efficacy Scale ASE

  Overview The  Academic Self-Efficacy Scale is an application of Self-Efficacy Theory   to examine the relationship between self-efficacy and academic performance using 8-items rated on a 7-point scale. The work of Chemers et al. (2001) has been widely cited. Format The 8-items are rated on a 7-point Likert-type scale ranging from 1 = Very Untrue to 7 = Very True. Sample Items 2. I know how to take notes. 6. I usually do very well in school and at academic tasks.   Reliability, Validity, and Other Research notes In the article describing the development and use of the ASE, the authors observed: “As predicted, academic self-efficacy was significantly and directly related to academic expectations and academic performance.” (Chemers et al., 2001, p. 61)   Sutton et al. (2011) reported Cronbach's alpha of .83 in their study of academic self-esteem and personal strengths. ASE was highly positively correlated with ACT scores (.24) and GPA (.39)....

Rotterdam Emotional Intelligence Scale (REIS)

  Scale name: Rotterdam Emotional Intelligence Scale (REIS) Scales overview : The Rotterdam Emotional Intelligence Scale (REIS) is a 28-item measure of emotional intelligence having four subscales. Authors: Pekaar, Keri A., Bakker, Arnold B., van der Linden, Dimitri, & Born, Marise Ph. Response Type: All items are rated on a 5-point Likert type scale ranging from 1 (totally disagree to 5 (totally agree). Subscales = 4   Following are the four subscales with a sample item. Self-focused emotion appraisal( 1. I always know how I feel.) Other-focused emotion appraisal ( 8. I am aware of the emotions of the people around me.) Self-focused emotion regulation ( 15. I am in control of my own emotions.) Other-focused emotion regulation ( 22. I can make someone else feel differently.)   Reliability and Validity “The results indicate that the REIS follows a four-factorial structure and can be reliably measured with 28 items. The REIS was strongly correl...

Spiritual Bypass Scale (SBS-13)

  Assessment name:   Spiritual Bypass Scale-13 (SBS-13) Scale overview: To assess the observed spiritual bypassing phenomenon, Fox et al. (2017) developed the 13 item Spiritual Bypass Scale . Authors: Fox, Cashwell, and Picciotto    [ Read more about Spiritual Bypassing in Psychotherapy] Response Type: The 13 items are rated on a four-point scale of agreement. Scale items Data analyses from two ethnically diverse US adult samples supported two factors (Psychological Avoidance, PA; Spiritualizing, SP). PA example: When I am in pain, I believe God will deliver me from it SP example: When someone I know is in trouble, I believe it is because they have done something wrong spiritually.   Psychometric properties Cronbach’salphas: Total scale = .85, PA = .82; Sp = .75. The total SBS score was associated with the ASPIRES subscales except for connectedness. PA was associated with depression and SP with stress and anxiety (DASS-21). The over...