+ Reply to Thread
Results 1 to 3 of 3

Need help with Test for a difference between two proportions and a chi-square

  1. #1
    Registered User
    Join Date
    05-30-2021
    Location
    Toronto, Canada
    MS-Off Ver
    Microsoft 365
    Posts
    3

    Unhappy Need help with Test for a difference between two proportions and a chi-square

    Good Evening,

    I have recently started self learning excel and found the attached question and data file from a free source. But im unable to complete the 2 tests.

    Question:
    A marketing executive tested two incentives to see what percentage of customers would enroll in a new Web-based loyalty program. The customers were asked to log on to their accounts on the Web and provide some demographic and spending information. As an incentive, they were offered either nothing (No Offer), free flight insurance on their next flight (Free Insurance), or a free companion airline ticket (Free Flight). The customers were segmented according to their past year’s spending patterns as spending primarily in one of five areas: Travel, Entertainment, Dining, Household, or Balanced. The executive wanted to know whether the incentives resulted in different enrollment rate (Response). Specifically, she wanted to know how much higher the enrollment rate for the free flight was compared with the free insurance and whether it was statistically significant. She also wanted to see whether Spending Pattern was associated with Response. Using the data in the file ch 16_MCSP_Loyalty_Program, write up a report for the marketing executive using appropriate graphics, summary statistics, statistical tests, and confidence intervals.
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Need help with Test for a difference between two proportions and a chi-square

    Show us what you have done so far and explain your thoughts on how to approach this. It will not be a learning experience for you if we just solve it for you.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

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

    Re: Need help with Test for a difference between two proportions and a chi-square

    How much of your question is about Excel programming and how much is about the underlying statistics (choosing a distribution, performing the hypothesis test, etc.)? We are usually good at Excel programming, but we are not always knowledgeable about the underlying statistics.

    In your sample file, it appears that you found and executed one of the two sample t-test tools in the analysis toolpak. With no further explanation, it isn't clear to me what you need help with regarding the output.

    In the title of the post, you mention chi-square. The analysis toolpak does not appear to have a chi-square test tool, but Excel does have several worksheet function related to the chi-square distribution (see here under "statistical functions" https://support.microsoft.com/en-us/...rs=en-us&ad=us ). Look for CHI...() functions.

    As I said, we are not usually that good with statistics. If you will help us understand the statistical test you want to perform as well as the calculations that go into that test, we should be able to help you coax Excel into performing the calculations for that test.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. [SOLVED] Binomial Proportions: Two-Sample Test
    By Stan Brown in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-06-2005, 06:05 AM
  2. [SOLVED] Binomial Proportions: Two-Sample Test
    By PlugNChug in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 04:05 AM
  3. Binomial Proportions: Two-Sample Test
    By PlugNChug in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  4. [SOLVED] Binomial Proportions: Two-Sample Test
    By PlugNChug in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  5. Binomial Proportions: Two-Sample Test
    By PlugNChug in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  6. Binomial Proportions: Two-Sample Test
    By PlugNChug in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  7. Binomial Proportions: Two-Sample Test
    By PlugNChug in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-05-2005, 11:05 PM
  8. [SOLVED] Binomial Proportions: Two-Sample Test
    By PlugNChug in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-08-2005, 11:05 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