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
Posting as :
works at
You are currently posting as works at

20% a day is 20% a year unless you're compounding

like

Look at the units. If X unit is day, then M=0.2 implies 0.2 (units Y)/(days). It is not exactly 20%, it is instead 0.2 Y units per Day.

A 20% increase per day would not be linear growth which is what you modeled.

likesmart

Each day because X is one of 365.

like

That would be 20% per year. 20% per day implies that each day is 20% better than the last (day1=100 units, day 2=120 units, day 3=144 units,etc...). Although 20% per year is still misleading and implies exponential growth. It would be more accurate to word it something like 'production has increased by 20% over the past year'.

like

Related Posts

ZS hiring for multiple roles... DM in case of any referrals!

like

what are the tax implications when you withdraw from your espp? what are the necessary steps you have to take so you don’t get overtaxed?

like

Hey! I’m from Spain, and I’m thinking about find a job overseas, maybe in central america or southeast asia… I have experience in finance consulting… do you have any recommendation, contact or tip that could help me?

I don’t know if try to find a job first and move then, or move out first and find a job from there.

Thanks!

like

Now that Facebook is Meta, I thought I’d just pitch MANGA as the new FAANG…

like

Considering getting highlights and/or extensions for my wedding. Is it worth it? Or is it a bad idea to update your hair for the wedding?

like

What’s a super tough curveball question that someone has been asked before in a GSAP panel?

like

Will hcl provide relocation amount doj 20 jan?

like

Got On track (O) rating for JPMC year end review, can someone help me understand what can be the expected hike and bonus if any?
Is this a good or a bad rating?
Joined JPMC in April 2022

like

Which companies have PM roles that are more strategy focused than PO focused (e.g., focusing on overall product strategy and not leading a Dev team to deliver specific product features)?

like

Wanted to check with folks from Accenture here. Can someone explain the job code CN - Strategy - TC - TA - IT Strategy - 07?

I understand it's for capability network. But what do the abbreviations mean? Also is Accenture CN a good place to work?

like
like

How do you deal with anxiety before a big presentation? I really struggle with this and want to get better.

like

MSFT or AWS? As Tech Pre Sales and why?

like

How hard is it to pivot to a BDR/SDR role as a tech consultant from a boutique firm with 1-yr experience? I don’t have previous sales experience, except for my time at a call center which lasted for two months until covid hit. What should I be doing now to bridge this knowledge gap? Is there anyone willing to give a referral?

like

Hi everyone! I’m staring in an AE position to book demos with restaurants for their POS systems. How to prospect / have conversations and close the demos with them? I’m new to AE, used to be an interning SDR. Looking for tips and advice more towards the conversation factor. Thank you

like

How much package can I ask from
SAP labs for 3 YOE, developer
associate level, Skill SAP ABAP.
Current package 5.5 LPA.
SAP @

like

Would like to connect with someone working in Cognizant CTS as Oracle Ebs or Fusion/Cloud Consultant.

like

Hi Folks,

Want to get a better picture of pharma consulting in India and how do consulting firms approach clients and what are the kind of projects that we usually get

Happy to chat in DMs

Thanks for the help!

like

We are looking to hire a Manager/ Sr. Manager- Financial Projects in India, who will be working with MasTec Inc. (a Fortune 500 company) HQ.

The candidate should have Exp. in Technical accounting, accounting research, accounting consultation, resolving accounting issues, writing accounting memos, US GAAP exposure, qualification should be CA/ CPA with 7-9 years exp.

Working hours will be India afternoon shifts preferably.

DM me if any one is interested in the above said profile

like

Additional Posts in Excel Genius

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

like

Hello. Quick question about formatting. I have an excel sheet with bunch of negative numbers, but some are percentage values and some are dollar values. Is there a way to make all of them have a parenthesis for being negative while keeping them still percentage and dollar value separately or do I have to target them separately?

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?

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

Hi excel geniuses, how do I quickly copy info from one cell to blanks for same if. Semi below I have products and names, for the blank fields w same product how do I quickly copy for the rest of the blank cells?

Post Photo

Recently made a job switch and have been using a lot more excel. Any free resources to help build a solid foundation / fee based courses to help improve my skills?

like

Our Data is only showing when something has changed, is there any way to make excel fill in the values?

Post Photo
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

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

Anyone have an app or Excel spreadsheet they use to keep track of utilization? We just switched systems and our new system doesn’t give us a real time balance of our utilization rate (cont)

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)

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!

How long did it take you to become good at excel? Like fast?

like

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

like

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

Post Photo
likehelpful

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

like

Any book recommendations on excel modeling for real world business applications?

like

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

I’m helping my GF with excel and need help lol. She works at a hospital and is trying to make an excel schedule for doctors to reserve rooms. She wants drop downs for days of the week (column K) and also different drop down menus in column P for the reserved time slots.

Is it possible to do this with two sets of drop downs (days of week + time slots) and not use index match here? She could make 5 tables for each day of the week, but prefers one table that can be easily navigated by doctors.

Post Photo
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

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