Myrtle Williams RIV 5
3:26
7 ай бұрын
Constructing a Heat Map in Tableau
3:44
Creating a Bubble Plot in Tableau
4:48
Create a Heat Map in Excel
5:16
11 ай бұрын
2 Variable Line Chart in Excel
3:23
Bubble Plots with Excel
4:36
11 ай бұрын
Scatterplots using Excel
3:09
11 ай бұрын
Пікірлер
@MarioRuscovici
@MarioRuscovici Ай бұрын
I really enjoyed this video , because each step in calculating coefficients is clear as a bell. However, there is no calculations of the p values for each variable, or the significance of the regression as a whole
@atienzavlogs378
@atienzavlogs378 Ай бұрын
Thank you! Question: how do I find the p-value of the beta coefficients after the fact?
@agpera
@agpera Ай бұрын
BRAVO! Well done, Professor! This definitely helped! The statistics textbook I am using (Statistics for Managers by Levine, Stephan, and Szabat) expects you to know how to construct the prediction interval, even though it fails to provide any crucial details.
@lsw278
@lsw278 Ай бұрын
I'm glad it helped! I made this video because the textbook I use lacks the details needed to construct these intervals. Apparently this is a common flaw in stats texts. Good luck with your studies :)
@akanimagerman7301
@akanimagerman7301 Ай бұрын
Aah thank you so much!
@lsw278
@lsw278 Ай бұрын
Glad this was helpful!
@RubenHernandez-hv2zo
@RubenHernandez-hv2zo 2 ай бұрын
I needed this!!!!!!!!!
@negativecreep8066
@negativecreep8066 2 ай бұрын
You are fantastic. I was stuck on this for so long and you had the only video that gave me the correct answer. Thank you! 🙏🏻
@lsw278
@lsw278 2 ай бұрын
Thanks so much and I am glad that it was helpful!
@acer-star
@acer-star 2 ай бұрын
beautiful
@iss_megga
@iss_megga 2 ай бұрын
how do i know that this is poisson because its almost simillar to binomial distribution
@lsw278
@lsw278 2 ай бұрын
Great question. Poisson Distributions are not based on a sample size (n) whereas one of the requirements of the Binomial is that we have n independent Trials. Also, the Poisson looks for occurrences that occur over an interval - time, distance, length, days, hours etc. Finally, in a Poisson Distribution, instead of having P (probability of success) we are given the Mean (or Lambda) and that average remains fixed across all observations. I hope this helps!
@iss_megga
@iss_megga 2 ай бұрын
@@lsw278 thank you
@virginiarosales4312
@virginiarosales4312 3 ай бұрын
Thank you
@lsw278
@lsw278 3 ай бұрын
I'm glad this helped.
@ajamesmcdermott
@ajamesmcdermott 4 ай бұрын
I can never understand why some of these lectures and videos at University and youtube want to glorify a fictictous person, mostly female, with these financial problems and answers. It never happens in realty. Finance businesses don't look at that scenario that way.
@helentinglin8431
@helentinglin8431 4 ай бұрын
Thanks
@josephmubiana6245
@josephmubiana6245 4 ай бұрын
What if you have 12 games to be played, how can you generate the possible slips using permutation in excel.
@lsw278
@lsw278 4 ай бұрын
Thanks for the question. In Permutations, always use the number from which to choose as the n. In your case, this would be 12 if you have 12 games to be played. Then for the r, think of that as how many are "required" meaning how many are you looking for. This would give you 12Pr. I hope this helps.
@mikenyc1589
@mikenyc1589 5 ай бұрын
Great video....looking for this for years.....One Question: If you run SOLVER 2 times in a row on the same project....What does those "B" values turn into? Thx
@BNT05
@BNT05 5 ай бұрын
Prof, you are one of the most underrated tutors in KZbin, yet your clips are crystal clear and I am learning a lot from them! I hope, many will come to realise this eventually. Big 'like' from me here...always and thank you!
@lsw278
@lsw278 5 ай бұрын
I'm glad you found this helpful!
@j0zdesigns
@j0zdesigns 5 ай бұрын
Thank you.
@andrealhs16
@andrealhs16 5 ай бұрын
Life saver, I was so confused on the spreadsheet! Thank you!! 😁
@lsw278
@lsw278 5 ай бұрын
I'm glad that this was helpful!
@MuthuTechTalks
@MuthuTechTalks 6 ай бұрын
Thanks ❤
@Wenerrix
@Wenerrix 7 ай бұрын
Thank you so much for this articulated explanation 😀
@simonriley4375
@simonriley4375 8 ай бұрын
thank you so much, about to ace my statistics class!!!
@escribidormadrid3463
@escribidormadrid3463 8 ай бұрын
Thank you. It was indeed painless and even pain-relieving.
@lsw278
@lsw278 8 ай бұрын
I'm glad that it helped!
@heyhey6333
@heyhey6333 8 ай бұрын
fantastic video!! well explained and very concise. saved me a long night of struggling to learn R haha
@lsw278
@lsw278 8 ай бұрын
That's the whole reason I made this video - finding a way to do this WITHOUT R! Glad this helped
@ElMakk_Med
@ElMakk_Med 8 ай бұрын
hey, thanks for effort you put into this, i have a question, why did you use a natural log function in the likelihood!
@lsw278
@lsw278 8 ай бұрын
Great question! (Sorry for the long answer, but it's an important component of this approach to regression). In logistic regression, the natural log function is used in the likelihood because of its properties that make it well-suited for modeling probabilities. The logit function, which is the natural log of the odds ratio, converts the probability of success to a linear function of the predictors. It also converts the probability of success to a linear function of the predictors. This linear relationship between the log odds and the predictors is convenient for modeling with linear regression techniques.
@tiagomarques1053
@tiagomarques1053 9 ай бұрын
the first 150k that are transfered out to Materials (150) and converion costs(150), doesnt that mean we transfered 300? Thank you for your help.
@SumanthShenoy-nz4mf
@SumanthShenoy-nz4mf 9 ай бұрын
Is this corect? Isnt the inflation premium= nominal rate- inflation?? Correct me if I am wrong, by what I understand from the above video the answer we get here is nothing but current inflation right??
@keynote8274
@keynote8274 9 ай бұрын
Hey there Linda. I hope you're well. I am currently studying for my postgraduate qualification in data analytics and this video helped me out so much. Thank you for taking the time and effort to upload this and I hope you continue with these videos.
@lsw278
@lsw278 9 ай бұрын
I'm glad it helped. Using Excel for this is a little clunky, but it gets the job done! Good luck with your studies
@kiwifrenchie6036
@kiwifrenchie6036 9 ай бұрын
How are you professor and really helpful with your video. Would you mind sharing a video about how to pick and remember which test to use when dealing with different scenarios. Like sometimes we use t test sometime z Also, for this video as example, why do we set Ho as greater than 5lbs rather than H1? I don’t know which phrase to set as H0 because p is low H0 must go, so it would affect the results if I set the wrong conclusion
@micahzimmerman4015
@micahzimmerman4015 9 ай бұрын
bless you soul
@lsw278
@lsw278 9 ай бұрын
I'm glad this helped!
@felix5847-q5o
@felix5847-q5o 9 ай бұрын
Thank you, I’m taking managerial accounting and I was having so much trouble comprehending when doing homework.
@joecity4real
@joecity4real 9 ай бұрын
who woulda thunk 10 years later this video would save me 1 hour before my submission deadline. thanks :)
@lsw278
@lsw278 9 ай бұрын
I'm glad to know that I'm still helping all these years later.
@h.s.3883
@h.s.3883 9 ай бұрын
Rather than writing the number down at 3:41, you can store the number by hitting "Sto" (store) & any number between 1-9. To recall the stored number, hit "RCL" (recall) then the number you want to recall.
@lsw278
@lsw278 9 ай бұрын
THANKS! This is a great time saver and appreciate the hint.
@Darkhearts
@Darkhearts 10 ай бұрын
Thank you so much for this, currently taking this course and was confused on where this information was coming from as the spreadsheet was empty for most part. Now I have detailed sheet with automated math etc. :)
@madalynkatie6965
@madalynkatie6965 10 ай бұрын
🌷 'Promo SM'
@KiwiPastels
@KiwiPastels 10 ай бұрын
this helped me with my home work thank youuuuuuuu
@lsw278
@lsw278 10 ай бұрын
I'm so glad it helped!
@gensor5146
@gensor5146 11 ай бұрын
lets go, youre GOATED LADY
@krachlavitch
@krachlavitch 11 ай бұрын
This video was super helpful, thank you!!
@Usernametaken1987
@Usernametaken1987 11 ай бұрын
Thank you!!!
@ObBenKenobi
@ObBenKenobi 11 ай бұрын
Hello, I am coming up with a completely different answer than then one you are getting. I have cleared the calculator but I keep getting 1569.47 compared to your 1798.87. Is there something wrong with my calculator? I have followed the exact same way you have done it but again am not getting the same answer as you. Thanks.
@lsw278
@lsw278 11 ай бұрын
Do you have your calculator set to BGN? I am also set at 5 decimal places. Try that and hopefully it will work.
@mertkr7559
@mertkr7559 11 ай бұрын
we don't know whether the population is normally distributed. How can you be sure that sample is randomly distributed by using only one sample with size 36? Shouldn't we use more than one sample with size 36. Because CLT is valid for sample mean not the sample itself.
@lsw278
@lsw278 11 ай бұрын
Valid point. The Standard Error of the Mean (SEM) is used when constructing a Confidence Interval (CI) for the Population Mean because it provides an estimate of the variability or precision of the sample mean as an estimator of the population mean. When we take a sample from a population to estimate the population mean, there is inherent variability due to random sampling. So, when constructing a Confidence Interval for the Population Mean, we use the SEM to determine the margin of error around the sample mean. The larger the sample size, the smaller the SEM, At a n=36, we meet the large sample size requirement of the CLT (n=> 30), but if we want our CI to be more precise, we would take a larger sample, if possible. I hope this helps.
@tonylopez8222
@tonylopez8222 11 ай бұрын
This is Amazing! I am currently doing this and you helped me a lot than the book or really the assignments did for me. I would love it if you went over the other comprehensive problems. I am afraid that I will not be able to understand the future assignments. Thank You!!!
@DianaRojas-h8n
@DianaRojas-h8n Жыл бұрын
Thank you Professor
@lsw278
@lsw278 Жыл бұрын
I'm glad that it helped!
@TaylorTremaine
@TaylorTremaine Жыл бұрын
I'm so confused about the 1.96 part. When I look at my z-score table, a score of 1.96 is associated with .9750. Additionally, working backwards, the closest there is to .4750 is (-.07). What am Imissing?
@lsw278
@lsw278 Жыл бұрын
You are using a cumulative table that shows the total area to the left or right of a point on the curve. So, the table is saying that 97.50% of the data falls to the left of a Z Score of 1.96. This leaves 1-.9750 = 0.025 or 2.5% of the data to the right of that Z Score. If you have a 2 tailed test at alpha = .05, then that .05 is divided by 2. This means that +1.96 and -1.96 are the Z Critical Values for a two-tailed test at alpha = .05.
@sierraholmes19
@sierraholmes19 Жыл бұрын
Can you explain why it's .50?
@lsw278
@lsw278 Жыл бұрын
Because given normal distribution, 50% of the data falls to the right of the mean (center of the distribution) and 50% falls to the left.
@navk1000
@navk1000 Жыл бұрын
Thank you so much.
@lsw278
@lsw278 Жыл бұрын
I'm glad that it helped!
@abigailmonterroso1921
@abigailmonterroso1921 Жыл бұрын
Thank you so much! I needed this for my final
@QueenCityFilmsComm
@QueenCityFilmsComm Жыл бұрын
Yes! EXACTLY what I was looking for. Great short insightful video. Keep up the great work!
@XyRedD3ATHxxw
@XyRedD3ATHxxw Жыл бұрын
Literal life saver!
@lsw278
@lsw278 Жыл бұрын
Glad that it helped!
@datascience1274
@datascience1274 Жыл бұрын
Hi, just a quick question. Are we referring to the whole population or to a sample? Is it correct to call this sampling distribution?
@lsw278
@lsw278 Жыл бұрын
This is NOT a sampling distribution. The Poisson Distribution is a discrete variable probability distribution. Although Lambda (Mean) is derived from a sample, the value of Lambda then applies to all occurrences of the event. So, if we know that Lambda is = 4 customers per hours, then it will remain 4 per hour for an infinite number of trials. This will remain true until something significantly changes in the population and we establish a new value of Lambda. I hope this helps.
@datascience1274
@datascience1274 Жыл бұрын
@@lsw278 thank you very much. It's clear now
@AnonymousanonymousA
@AnonymousanonymousA Жыл бұрын
Is is the RFR = to Risk Premium? If not what is RP?
@lsw278
@lsw278 Жыл бұрын
RFR is the "Risk Free Rate" and "RP" is the Risk Premium
@zfc264
@zfc264 Жыл бұрын
respect saved my midterm
@lsw278
@lsw278 Жыл бұрын
Awesome! So glad it helped.
@celianavaro
@celianavaro Жыл бұрын
THANKS ALOT
@lsw278
@lsw278 Жыл бұрын
Glad it helped!