My job often has me conducting analyses where we try to identify if product launch A has had an impact on B (cannibalization analyses) but super often they are inconclusive. I feel I need statistics / rudimentary data science here. Any idea what to study?

like
Posting as :
works at
You are currently posting as works at

Ooohhh this is so good

So, first things first, you can't prove a negative in statistics (in life as well), so whenever you're trying to ascertain a relationship between two phenomena, you need to analyse it by trying to prove that there is NO RELATIONSHIP, and by failing to prove that, comes to the conclusion that there is indeed a relationship.

There are TONS of tools to do with, going from simple Pearson's correlation (the common, linear one) to multi-variable anslysis; and some of those (luckily) are built-in on excel (or can be built somewhat easily).

So, in short, if you want to BE ABLE TO RUN "BASIC" analysis, I'd recommend looking at the basics of those tools who are applied "in the industry" - A/B tests, basic correlation/covariance; and if you need, you can move to F or Z-statistic tests (ANOVA/MANOVA, z-tests).

If you really wanna learn about it (take to the next level, but reaaally the next level) you need to study inferential statistics - it's a wonderful tool, but there are soooo many ways to fuck it up (the clever Hans effect - the Horse who could perform arithmetic calculations - being the funniest)

likehelpful

P.s.: sorry if it was too long, but there's so much to this topic

If you need statistics/data science then an excel forum isn't your best bet

like

Depends on what you mean by large, and why would statistics/data science be applied only for 1 MM+ databases?

Also knowing excel doesn't mean you don't know the other tools

Look up A/B testing calculators, so many online for basic A/B tests with 1 metric (response rate for example). To your point, if they are inconclusive, even if a statistical test says that the impact is statistically significant, if you can’t easily observe an impact, I would question if it’s strategically significant and worth investing time and resources into.

like

Things like t tests can be easily built in excel so that might be the next step if you want to do something more complicated or more flexible.

What an amazing answer victor. Thank you so much! I will look into all of these things. I’ve never even heard of inferential stats but it sounds exactly what I was looking for

like

An analytical crowd, though!

Alteryx

When you know, you know

like

Related Posts

For the parents with babies - is anyone finding formula in stock? We give my daughter enfamil nutramigen and cannot find it anywhere. Looked at CVS, Wegmans, Target, Harris Teeter. Even pediatrician didn’t have samples.

like

Does this debate remind anyone of an agency meeting, where people just talk over each other?

likefunny

Hi Team,

Need one suggestion, I have two below offers:
1. Hitachi Vantara (37LPA including 8%variable + 2.5L joining bonus)
2. Hashedin by deloite (37LPA) but it's around 36km for from my room.

Please suggest who one can I joined W. R. T. Work life balance.

Eoy:8 years
Designation : Technical lead.

like

What are some 1-2 year experience roles at MAANG companies?

like

Can anyone refer me to ETL tester role in product based company?

Anyone here from Citi? I need referral.

like

Trying to get a second job does anyone know how this works. It says part time but the schedules looks full time some help please. Thanks

Post Photo
like

Hi! I’m a young professional with less than 2 years experience, started a new job 1.5 months ago. I’m having quite some difficulties on balancing out my response time to tasks. While I act incredibly fast if not immediately with some, I sometimes take 1-2 weeks with couple of hours worthy ones. Sometimes I ignore, procrastinate or simply other more urgent things come up to increase the delay. Also I work with 3 managers in my team which doesn’t help with expectations nor guidance. Any tips pls?

like

What are your best tools for self-motivation at work? There are days when it takes a huge amount of effort for me to get started and in the groove and I'm looking for ways to make work days easier.

like

Can wife claim husbands PAN for HRA? Flat is in the name of husband

like

Opinions on BagYork(dot)com? It shows great deals on most branded items and is a verified merchant on Pinterest but I’m worried if it’s legit

like

I made the switch to in house and omg it’s so slow. I knew it’d be a bit slower than agency but I accomplish less in a month than I used to in a day. Is this how all in house jobs are or has anyone found a faster pace in house gig?

like

Why is it that those in IB can’t get an MBA and return to IB the way people from other industries have returned post-MBA?

like

I need some advice. I’m the Director for a women’s only RTF. Everyone on site is my direct report, with the exception of the therapists (they report to the Clinical Director). The clinical director is not usually on site, since we have multiple locations, and she is the CD for the entire company. One of the therapists has been a manipulative snake since she started here last December. This is her first job after college and she just turned 23. See comments for more info…

like

Is Capgemini is providing any joining bonus. If yes mean how much we can ask for c1 level

like

What's the approximate base salary for internal audit advisory manager?

like

If i do 1 year post graduation diploma certificate course from canada (online or offline) and at the same time I do a full time job in canada of 40 hours/week (may be few months diffrence but they will be overlaping). Can I put both of them in PR application?

like

Where to go with kids and grandparents during cold season in Chicago or Northshore? Moved to Northshore recently with 2 kids and parents visiting soon.
1. Restaurant recommendations.
2. Play areas.

like

Any leads for good headhunters ir recruiters? I am looking for full time
in the LA area- Thanks!

like

Additional Posts in Excel Genius

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

like

Anybody use a personal computer for work? How's your experience been, any horror stories/watch-outs?

like

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

like

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

like

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

like

Does 2-finger touchpad scroll not work on Excel sheets anymore? I used to be able to swipe quickly on my laptop's touchpad to navigate sheets but now it doesn't work. Based on the handful of posts I've read online about it, the problem seems unresolved. Has anyone dealt with the same issue and fixed it?

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

helpful

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?

like

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

like

Anyone know what these badges are?

Post Photo
likefunny

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

like

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

likefunny

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

like

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

like

What’s the symbol that you can type in a cell so you can input a text, but that text would not appear in the spreadsheet? I want to describe the formula without using a text box, which uses more space.

The equivalent of this is in SQL, you can use the apostrophe in the beginning of and end of a text. That text will not affect the function of the query, but that text can be seen if you proofread the query.

like

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

like

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal