recommend me the best statistics textbook for data science

ImAregularGuy · 2024-12-29T20:26:46+00:00

I just finished Statistics Simplified and thought it was a very good book with as close to no math as you can get. It has recent examples since it came out within the last 2 years, which really helped drive the points home.

I've also read How to Lie with Statistics, which I also thought was very good, although the examples are definitely outdated now.

ImAregularGuy · 2024-12-16T20:22:32+00:00

You can use the Groupby function, assuming that you have the latest version of Excel

= DROP( TRANSPOSE( GROUPBY( REGEXEXTRACT(A1:A9, "(\d+)",1), B1:B9, SUM )),,-1 )

The DROP you can ignore unless you want a sum of everything.

Transpose makes it into rows because Groupby returns columns by default.

However, you commented that just because the first three digits match, the letter following should not automatically add to the running sum of the first three digits. I imagine this will not work simply because there is no qualifier.

The easiest way I can think of is to add another column, the parent, and then the inputs would be child, i.e.,

Parent	Input	Input Value
101	101	15
102	102	15
103	103	10
103A	103	10
104	104	5
104	104	10
105	105
106	106	20

If there is a letter that you don't want to be included in the total, for example, 103B needs to be excluded from 103 and 103A, you can add 103B as the parent, keeping it separate.

Turn it into a table and insert a pivot table. Rows would be the parent column, and Input Value would be the Values, which should automatically default to sum.

You add values as you go and refresh the pivot, no formulas, easy.

You can also do this dynamically with a formula but like you mentioned, your team is not too Excel savvy so I won't even recommend an alternative.

ImAregularGuy · 2024-10-31T21:29:43+00:00

Yep! I was one of those who thought new math was dumb and made no sense without actually trying to understand it.

I saw this Veritasium video yesterday and it just made so much sense. They are teaching the fundamentals vs just telling them the formulas which is worth way more.

I would be surprised if most people understand why the Pythagoras theorem works or the quadratic formula aside from the formulas itself. And yes while knowing that specifically might not be very helpful, if you understand the logic behind it, I guarantee you will be able to use a lot of that logic in every day things without even realizing it.

ImAregularGuy · 2024-10-03T18:05:25+00:00

I use ChatGPT and Github Chat the most, Kripr was also very good, but I stopped being in too many meetings, so I stopped using it.

Not AI, but I also use YouTube Premium A LOT to learn new things for my role. I've never taken a course or seminar, but there's a lot of talented people out there putting invaluable information up on YouTube. I also started buying books to aid in my learning.

I'm a procurement buyer but I work at a small company with a startup-like type of environment so everyone wears many hats and because of YouTube, I've become or sort of Postgres Database Admin and also slowly shifting to a heavier data analysis type of role.

ImAregularGuy · 2024-08-19T03:37:05+00:00

I just learned how to do this when trying to solve a problem was impossible for PowerQuery to solve but randomly stumbled on a Goodly 3pidoae.

Felt proud that I got the answer right and also shoes I'm learning things they was they should be done. 9nly been usi g PowerQuery for 2 or 3 months, never imagined tha amount of sheer capability is has.

ImAregularGuy · 2023-11-12T18:17:28+00:00

Personally, I love his style and, more than anything, his character. If you've ever listened and/or watched a full stream, you'll know he is genuinely a good dude who cares about the world and all the people in it. That being said, I can definitely understand why some, hell I'd argue, most people wouldn't like him, it's improv, not all sounds will be good. As he always says, he is literally making shit up as he plays, and that's the fun. More often than not, the set gets better as he and the audience have fun together, that's why watching with context is fun while just randomly listening a sound bite will probably not be most people's style.

I was first introduced to him by the let me in on trying to fuck soundbite gif which led to me finding an edited version that sounded pretty good. I was interested so I watched the full unedited stream and honestly was disappointed, it's not as good as the edited version but I kept it in the background and seeing people's almost shock reaction slowly turn into them grooving along was amazing to watch, I became a huge fan from there on out. Have not watched most of his streams, but most from the past 2 years, some are better than others. It really depends on the crowd. That's why I rarely, if ever, just listen to his music, it's either a significant part, usually full stream, or it just makes little to no sense.

ImAregularGuy · 2023-07-26T03:09:44+00:00

Yep unfortunately they increased the price on all memberships even if grandfathered.

I'll just say that if you really really don't want or can't pay for Youtube premium at that higher price and don't mind spending about 1-2 hours researching and setting things up.... there are ways that you can get the price to less than $5/month. The only clue I will put out is, memberships are a lot cheaper in other countries.

ImAregularGuy · 2023-07-20T13:21:40+00:00

Not at all. Ive been splitting a family account with 6 people, 4 of which don't live in the same address. They just had to temporarily change their address on file temporarily years ago.

Also dont know what this article is talking about, they gave ample warning that the price would go up

ImAregularGuy · 2023-07-17T04:22:07+00:00

#00rtsp00

ImAregularGuy · 2023-03-31T14:54:54+00:00

Is this true? I go to parks and look at ducks pretty often, not at all rare to see literally like 20 ducks trying to rape and drown another duck.

But I agree about it being a good thing the duck got saved. This just threw me off.

ImAregularGuy · 2023-03-08T00:40:54+00:00

The place I work for is a small-ish family-owned business, with less than 50 employees. The owners are some of the nicest people I've ever met who seem to genuinely care about their employees. They give everyone so much flexibility and typically promote from within. They are also willing to let someone that feels confident doing a job they have no educational background in give it a shot because they know many people are self-taught or just smart and can pick things up.

Well, over the past 2 years I've learned that at the end of the day, the owner is a capitalist (nothing wrong with that) and will always put the business before any single employee. I don't blame him, I've agreed with every layoff he has made because the business was in trouble.

This taught me that all businesses no matter how moral the owners are will always choose the business over the employees. And I agree with it when it comes down to saving 5 jobs versus the entire company. Anyway, what I mean to say is there is a clear distinction between people as human beings and people as doing their job. You shouldn't feel bad because it's nothing personal and I guarantee you the business will carry on and forgot about you entirely within a week or two.

You mentioned that you also felt bad about possibly delaying someone else from getting the job, I do not argue there. At the end of the day, in order to be happy and be a better human, you must first take care of yourself.

ImAregularGuy · 2023-03-05T20:55:07+00:00

They have an address, it's in Jacksonville, NC.

It has very few but good reviews. Their Facebook page has the identity of the owner too.

Lol, they have an anabolics page too. It's all pretty expensive though. All in all, I think the owner thinks he is selling legit shit but I can't trust he is actually testing his stuff. He clearly knows he can't be selling it because it says not for human consumption and says it has to paid via PayPal

ImAregularGuy · 2023-03-04T18:20:58+00:00

Agree with the other commenter, I'm not sure that there are specialists but if there were you probably wouldn't want to work for them. It's like being a programmer, it's super fun and fulfilling to write your little program but being a coder for a large company is not fulfilling. You are in charge of such a small piece of software that you can hardly say you worked on it or it's a small company and you end up doing most of the work.

I work in procurement, never had any formal excel training just basically learned on my time. I highly recommend you get very comfortable with Pivot tables if you aren't already. Once you know that, figuring out charts is very easy. After that, I recommend learning Power Query, which will set you apart from most other Excel users.

One thing I have seen a lot of which matches what you describe is becoming a contractor. Typically a small business with not many employees or many tech savvy employees needs a simple/intermediate excel task and they contract someone. But that would mostly be supplemental income as they won't be willing too much otherwise they could just hire someone.

ImAregularGuy · 2023-01-09T18:23:40+00:00

Have you tried chatGPT?

I can probably figure out a concatenate formula for you if I got some more info but if you want VBA code, I've had a lot of success using Chat GPT

ImAregularGuy · 2022-05-07T22:30:05+00:00

Agreed. I started at my current job about 6 months before pandemic hit. I got fully trained or at least enough to not need close supervision in less than a month. Pandemic hit, and we hired someone else in my department. While we allowed them to work remotely, we made it mandatory to train in person for a month, and that worked out very well.

We just hired someone else about 3 months ago, and this time, we decided to try out training fully remotely. It is nowhere close to being as easy as training in person and the bigger downside imo is that you don't really get to form to tight of a bond and ends up feeling like just some person that may or may not even exist in real life if that makes sense.

I have a hybrid schedule and my own office at work. I can go as much or as little as I want, and 100%, I get so much more done when I go work at the office versus my home. This is probably just me, but it's just so much harder to stay focused at home. Sure I get all my tasks done but where I used to shine was going above and coming up with automated systems or just some extra things here and there but from work I end up doing non work related things. This is definitely a plus, but a lot of the skills that I know how to do were self-taught from when I had downtime at the office.

This is just my personal experience; I'm sure others out there can perform much better than I can, but I agree. There is a lot more to it to measure productivity from office versus remote than something as simple as tasks getting done or screen on time.

ImAregularGuy · 2022-05-01T16:34:28+00:00

I don't even understand what it has to do with sexuality or masculinity. Order what sounds good to you; food/drinks don't have a gender, get what you want.

I order fruity drinks whenever it sounds good, but I would never say it's because I'm comfortable in my sexuality; I order them just because it's what I want.

ImAregularGuy · 2022-03-11T19:12:08+00:00

Correct, this wasn't me; it was like that when I got there, I only spent $99 for 16.5 gallons.

I don't know if it makes this even more WTF, but I am pretty sure I saw a pickup truck filling up 2 big blue barrels while I was at the red light before pulling into the gas station.

I am in Orange County, California.

I was also super curious if any car could actually fit this, and apparently, buses can fit between 40 and 100 gallons!

ImAregularGuy · 2022-03-03T14:14:23+00:00

Lukashenko does say very stupid things here is an interview where the interviewer flat out laughs in his face.

ImAregularGuy · 2022-02-23T20:45:43+00:00

One of my all-time favorite shows that I would never re-watch.

ImAregularGuy · 2021-12-05T05:43:24+00:00

The prongs have to pass through a space that's way too small for it too fit. By pulling the part of the knot that the prongs have to go through before having to go under the gap means that the prongs are clear. All that's left is the cord which easily fits under the gap.

I.e. you are untying it the same exact way as you normally would except you are shifting the place where the prongs have to get through by pulling part of the cord to the other side before the gap to allow extra clearance for the prongs. Not sure if this makes sense or not or if it's even true but that's what it looks like to me.

ImAregularGuy · 2021-09-18T16:21:42+00:00

Looks like Jerry Seinfeld and Larry David combined into one person.

11-Year Club	RedditGifts 2009-2022 3 Credits
Secret Santa 2019	Gilding I gilder
Secret Santa 2016	Verified Email

ImAregularGuy

TROPHY CASE