+ Reply to Thread
Results 1 to 8 of 8

Help testing statistical significance with percentages

  1. #1
    Registered User
    Join Date
    06-17-2020
    Location
    Canada
    MS-Off Ver
    2019
    Posts
    27

    Exclamation Help testing statistical significance with percentages

    I've never taken stats, so i'm a bit lost.

    I'm looking to stat test my survey results to understand if there's any meaningful differences between how males and females feel about a particular brand.

    I have the sample size for each gender, and their % score, but i'm looking for a quick way to check if the two percentages are stat sig at a 95% confidence level.

    I know excel has the analysis toolpak, but i can't seem to get any to work properly with just the values i have.

    Any help would be appreciated!!
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: Help testing statistical significance with percentages

    I'm not sure any of us on here is sufficiently expert in statistics to give a definitive answer on how to perform your analysis. If you've never taken stats, I would recommend starting with some basic information on hypothesis testing and then branch out into the different hypothesis tests.

    This might be as good a place as any to start: https://stattrek.com/hypothesis-test...s-testing.aspx Be sure to spend enough time with this so you understand null and alternate hypotheses, type I and type II errors, and so on.
    Continue through stattrek's lessons, and when you get to lesson 3 (https://stattrek.com/hypothesis-test...px?tutorial=ap ), there are links to several examples -- including a "difference between proportions" test example, that includes examples based on how men and women respond differently to medication that could provide a good model to follow in your analysis.

    Once you have a reasonable understanding of the statistics and an analysis plan you are comfortable with, note that Excel has several built in functions and tools that can help with hypothesis testing. Functions like NORMDIST(), NORMINV(), ZTEST() might be useful for calculating Z scores and P values if you decide to perform your analysis based on the z (normal) distribution. Other functions related to other distributions and tests can be found here under "statistical functions" https://support.microsoft.com/en-us/...rs=en-us&ad=us

    We are usually pretty good at programming things into Excel, but we don't always know your specific field. If you will spend some time understanding the statistics, then help us understand the details of the statistical test you wish to perform, we should be able to help you program that test into Excel.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: Help testing statistical significance with percentages

    Exactly what are the numbers a percentage of??
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  4. #4
    Registered User
    Join Date
    06-17-2020
    Location
    Canada
    MS-Off Ver
    2019
    Posts
    27

    Re: Help testing statistical significance with percentages

    its the % of ppl who like KIA (the car brand).

    so

    Affinity --> % of ppl who like the KIA brand
    Awareness --> % of ppl who are aware of the KIA brand
    Consideration --> % of ppl who consider purchasing the KIA brand
    Familiarity --> % of ppl who are familiar w/ the KIA brand
    Purchase Intent --> % of ppl who would purchase the KIA brand

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: Help testing statistical significance with percentages

    So, it is a simple binary choice.. "DO you like XXX Yes or No"?

  6. #6
    Registered User
    Join Date
    06-17-2020
    Location
    Canada
    MS-Off Ver
    2019
    Posts
    27

    Re: Help testing statistical significance with percentages

    each question is based on a likhert scale

    for affinity, the options are love, like, neutral, dislike, hate
    for awareness, extremely aware, very aware, slightly aware, somewhat unaware, extremely unaware

    etc.

    the percentages are based on the top-2 box choice. so for affinity, that percentage is those two chose love & like. For awareness, it's those who chose extremely & very aware.

    i found a tool (https://epitools.ausvet.com.au/ztesttwo) that does 2 sample z-test based on proportions looking at 1-tail, so i've been using that, but not sure if its the right approach

  7. #7
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: Help testing statistical significance with percentages

    As near as I can tell, that calculator is using the same sequence of calculations in the stattrek lesson that I pointed you to earlier (https://stattrek.com/hypothesis-test...px?tutorial=ap ). If you decide that is the right approach (or maybe just one of many possible right approaches), the formulas given by stattrek could be entered into Excel.

    As for deciding if this is a valid approach, that is more of a statistics question that I'm not sure if we can answer for you. Your problem seems similar to the examples given for this kind of hypothesis test, but I also know that there can be other considerations.

  8. #8
    Registered User
    Join Date
    06-17-2020
    Location
    Canada
    MS-Off Ver
    2019
    Posts
    27

    Re: Help testing statistical significance with percentages

    Appreciate the help

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Statistical Significance
    By scruz9 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-05-2017, 01:25 PM
  2. Statistical significance from percentage
    By LostSoLost in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-25-2014, 12:24 PM
  3. Replies: 1
    Last Post: 11-26-2013, 11:55 AM
  4. [SOLVED] determining statistical significance
    By koochandkai in forum Excel General
    Replies: 6
    Last Post: 06-22-2012, 04:50 PM
  5. Statistical Significance
    By Tiresidedown in forum Excel General
    Replies: 0
    Last Post: 01-15-2010, 02:19 AM
  6. Statistical Significance of Two Tests
    By kdegross in forum Excel General
    Replies: 0
    Last Post: 11-10-2009, 03:30 PM
  7. Calculating Statistical Significance
    By andrewc in forum Excel General
    Replies: 1
    Last Post: 06-09-2008, 10:23 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1