Need Help Analyzing P Values

    Hi Excel Gurus -


    forum.ozgrid.com/index.php?attachment/62919/


    Please see excel file above. I am trying to analyze data in 2 different sets for a marketing exercise.


    Columns A-F is the first step where I am trying to determine which mode of marketing works the best - Direct Media or Social. I wanted to ensure the scores did not happen by chance so ran a test and have the p values in Column D. Column F was a function that includes conditional formatting and if it is highlighted in red I do not use either mode because they are not significant. Am I interpreting this correctly? Is there another function I can use to do this automatically?


    Scores are on a scale of 1-99 where 1 is the best score and 99 is the worst.


    Columns I - W is the 2nd step where I am trying to determine which customer preferences I want to advertise with (Music, sports movies). I also ran a t test and got P values in column M-O. My conditional formatting and functions are in Column U-W. What I really want to know at the end of the day is what preference do these personas have? I'm not sure how to interpret this using the P values...can someone help with a function that will show this?

    Re: Need Help Analyzing P Values


    What do the various numbers represent? Are the averages or raw data? Usually a p-value is calculated after running some test (perhaps a t-test) on a sample of values and then tiny p-values indicate some underlying value either is not zero or something unusual happened in the data. I'm surprised by your data where it appears there is a p-value for each row. How were they calculated?

    Quote

    If it is highlighted in red I do not use either mode because they are not significant.


    No, in general if there was not a significant result it would make little difference which one you used.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login