I’m trying to go back to the basics. How do you guys structure thoughts around identifying the correlation between 2 variables? A basic example: the number of steps I take in a day and the hours of sleep I got that night.

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

Set your y variable (dependent) = x variables (independent) * (interaction effects ie. was it a sunny day ) and then calculate the associated p values to the response or dependent variable.

like

How about a scatter plot with a fitted line and R-squared added as a descriptive statistic? That should give you enough for correlation of two variables.

like

Related Posts

Capgemini has sent me mail saying that I have been selected and within 10 days I will be getting offer letter..and they also asked me to share all the documents..after that no one contacted for HR discussion as well.. ..why they do like that?

How much can one expect to make in Florida vs California in the Chiropractic profession right out of school?

like

I’m sorry to hear about the Digital Nexus lay offs

like

“The realization that you can meet someone and it can just feel easy and not like work is amazing” —Rupam, Indian Matchmaking

likeuplifting

Hey All, I am looking for book recommendations for my dad who just retired as a partner after 33 years at his firm. Any ideas you can provide would be greatly appreciated.

like

If I’m above the Roth income limit, can I do back door Roth for my Roth IRA and mega back door Roth for my Roth 401k? And does back door Roth count against contribution limit for mega back door?

like

Looking for feedback. What are your thoughts on when asked to provide a case study or project plan as a part of the interview process? I know BCD Travel and other start-ups make these kinds of request.

like

Can someone send me the invite for Accounting fishbowl?

like

I’m the PM for a product that uses both iOS and Android as mobile platforms. From a planning perspective, do you track the platforms in different epics or do you create stories for both mobile operating systems in the same epic for the feature being built?

like

Im going to join PWC INDIA Kolkata branch soon. Please someone tell me some pros ans cons that your are facing.

What about the WELCOME KIT,is there any or its for sde only??

like

Hii All,

I need referrals for Email marketing or PHP WordPress developer Role. Having experience of 4.5 Years.

Thanks in advance 😊

like

Looking for recruiting resources/organizations that host webinars or conferences!

like

When you drop off the kiddo at daycare and your 3 year old tells you “bye have fun sitting at home” 🤦🏾‍♂️ Guess I need to start wearing work clothes so he thinks I actually work

likefunny

I’m trying to move to SG from the US. What industries should I target for best pay / work life balance? Considering consulting, fintech, crypto, energy (renewable/ storage)

Kroll Employees, how is the workload, travel and overall experience in their Expert Services department? Need some honest feedback

like

Billing question - Do you have clients pay an outstanding balance within 30 days of sending out your account or earlier? I’ve heard some firms require clients to pay as soon as the account is rendered (ie. within 5 business days) but not sure if clients actually do that in reality and you end up chasing them? Any creative ideas are welcome!

like

How is work culture in S&P Global platts segment for Software Engineer II role?
And weekends may not be on Saturday and Sunday?

I think I’ve seen a thread on this before but don’t know how to find it… what are seniors at PWC making in M&A tax for HCOL

like

WTF does this mean?

Post Photo
likefunny

Additional Posts in Excel Genius

Hey Geniuses! I apologize in advance if this question has been asked before, I'm new here and just trying to learn as much as i can. Does anyone know a great source to learn Macros for beginners. I would like to create one for work. I appreciate it

like

How do you all prepare for excel/financial modeling tests? Every firm is different, so I imagine there are multiple effective ways to get ready.

likehelpful

Is there a way to consolidate non numerical data from multiple excel sheets into one master sheet?

like

Is Macabacus or any other add-in actually worth it for Excel & PPT? In LMM - MM M&A roles.

likehelpful

What's the F4 analogy in Office 365?

like

Why when I refresh a query, the table where the query is loaded to just gets duplicate rows? Same with the pivot table that feeds off of that query?

like

Excel Fact Of The Day:

An apostrophe before a cell value forces Excel to interpret the value as text. (Continued on next post).

like

A lot of the work at my new employer is quite redundant and can be automated via macros. What are some of the best resources to learn vba?

like

Can I write a macro that will fill out a table of information based on cells that have comments on them? For example, if G12 has a comment, I want to pull text from that comment + data in A12.

like

At my old firms when I would be using excel and modeling using the font schemes (blue, green, black for hardcode, link, and formula) I could use the “control shift ;” to shift through the schemes. My new firm doesn’t do this. Does anyone know why the shortcut would be different and how I can add it back?

like

Need some help. Is there a fax function (Filter) so that if I want my subtotals to show a number but nothing below it to report. One expansion of a row the subtotals show but no numbers below it.

like

Is there a way to simultaneously merge spreadsheets (or workbooks) and decide which columns/rows to update without a third party tool?

like

Any recommend courses (coursera, edx, etc.) people would recommend for user with intermediate experience with excel?

like

Best pdf to excel converter?

like

Last cell question. Some of my simple models are massive in file size because every tab has a last cell of ~XFD65. But I’m not using anything past ~U100. Continued.

like

Hi! I have knowledge of pivot tables, vlook ups. But I'm rusty on if statements and would like more knowledge on excel formulas. I'm looking for excel classes to take online. Any suggestions?

like

What are your top Excel ninja tricks? Ones that few people know...

like

What is y'all's preferred clipping tool? One of my former companies had a great simple program that was only like $50 and worth every penny.
Snipping Tool just ain't cuttin' it (lol pun intended).

like

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

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

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