- Видео 309
- Просмотров 1 300 754
Linda Williams
США
Добавлен 3 янв 2011
Are you a student struggling with Statistics, Accounting or Finance? Then YOU are the reason I created this Channel.
I am a professor of Business Administration and although I primarily teach Business Statistics and Analytics, I enjoy teaching both Accounting and Finance every semester. I am credentialed to teach all three subjects. After years of watching my students struggle with the concepts and applications in quantitative business courses, I decided this was the way I could help the most students quickest!
Please enjoy and I appreciate any and all feedback!
I am a professor of Business Administration and although I primarily teach Business Statistics and Analytics, I enjoy teaching both Accounting and Finance every semester. I am credentialed to teach all three subjects. After years of watching my students struggle with the concepts and applications in quantitative business courses, I decided this was the way I could help the most students quickest!
Please enjoy and I appreciate any and all feedback!
BUS227: Formatting Constraints for Linear Programming Project
BUS227: Formatting Constraints for Linear Programming Project
Просмотров: 137
Видео
Linear Programming: Optimization with Excel Solver
Просмотров 10214 дней назад
This video demonstrates how to set up and run a simple LP optimization problem using Excel Solver
Managerial Accounting: Factory Overhead with Multiple Departments
Просмотров 1021 день назад
This video demonstrates how to calculate the amount of factory overhead to be applied to a product using Departmental Overhead Rates. The example shows the calculation of the Departmental rate and applies it to three different products.
Process Costing: Equivalent Units of Production (FIFO)
Просмотров 821 день назад
This video demonstrates calculating EUP or Equivalent Units of Production for Direct Materials and Conversion under a process costing system.
Exponential Distribution using Minitab
Просмотров 17Месяц назад
This video explains the basics of the Exponential Distribution and then works an example problem using Minitab.
Managerial Accounting: Cost of Goods Manufactured and Cost of Goods Sold
Просмотров 33Месяц назад
This video walks through creating a Statement of Cost of Goods Manufactured (COGM) and then calculate the Cost of Goods Sold (COGS). The video uses Excel and simple cell references in order to perform the calculations.
Myrtle Williams RIV 5
Просмотров 112 месяца назад
Myrtle "The Turtle" Williams Rally Intermediate Virtual Course #5
BUS227 Monte Carlo Simulation Help
Просмотров 704 месяца назад
This video shows you how to generate the random numbers needed to run the Monte Carlo Simulation for Project #3
Financial Accounting: Adjusting Entries
Просмотров 314 месяца назад
This video gives an over view of the 5 most common types of adjusting entries made at the end of the accounting period.
Logistic Regression Using Excel Solver
Просмотров 3,4 тыс.5 месяцев назад
This video shows how to perform a Logistic Regression using the Excel Solver Add-in instead of the Data Mining toolpak.
Regression Analysis: Confidence and Prediction Intervals using Excel
Просмотров 2195 месяцев назад
Regression Analysis: Confidence and Prediction Intervals using Excel
Recipe for a Simple Linear Regression Model
Просмотров 806 месяцев назад
This video explains the Simple Linear Regression Equation and demonstrates how we can predict a value for Y based on a value of X.
Hypothesis Testing: Paired t Test using Excel
Просмотров 2116 месяцев назад
This video demonstrates how to conduct a hypothesis test for the difference between paired data in a "before" and "after" experiment using Excel.
2 Sample T Test with Unequal Variances using Excel
Просмотров 1636 месяцев назад
This video demonstrates the testing of the difference between the Means of 2 samples where the variances are UNEQUAL. We will use a 2-sample t test for the difference in the Means.
Constructing a Heat Map in Tableau
Просмотров 1296 месяцев назад
This video demonstrates how to create a Heat Map using Tableau.
Creating a Stacked Column Chart in Tableau
Просмотров 1046 месяцев назад
Creating a Stacked Column Chart in Tableau
How to Create a Scatterplot in Tableau
Просмотров 1716 месяцев назад
How to Create a Scatterplot in Tableau
Create a Simple Categorical Scatterplot in Tableau
Просмотров 1766 месяцев назад
Create a Simple Categorical Scatterplot in Tableau
Using "Show Me" to create a Histogram in Tableau
Просмотров 3276 месяцев назад
Using "Show Me" to create a Histogram in Tableau
Frequency Distribution and Histogram in Excel
Просмотров 3516 месяцев назад
Frequency Distribution and Histogram in Excel
Scatterplots with Categorical Variables in Excel
Просмотров 1,5 тыс.6 месяцев назад
Scatterplots with Categorical Variables in Excel
Contingency Table and Stacked Column Chart Excel
Просмотров 2366 месяцев назад
Contingency Table and Stacked Column Chart Excel
Hypergeometric Distributions on Minitab
Просмотров 6110 месяцев назад
Hypergeometric Distributions on Minitab
Financial Accounting: Adjusting for Prepaid Expenses
Просмотров 27011 месяцев назад
Financial Accounting: Adjusting for Prepaid Expenses
Financial Accounting: LIFO FIFO and WEIGHTED AVERAGE Inventory Methods
Просмотров 147Год назад
Financial Accounting: LIFO FIFO and WEIGHTED AVERAGE Inventory Methods
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
Prof, you are one of the most underrated tutors in RUclips, 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!
I'm glad you found this helpful!
Thank you.
Life saver, I was so confused on the spreadsheet! Thank you!! 😁
I'm glad that this was helpful!
Thanks ❤
Thank you so much for this articulated explanation 😀
thank you so much, about to ace my statistics class!!!
Thank you. It was indeed painless and even pain-relieving.
I'm glad that it helped!
fantastic video!! well explained and very concise. saved me a long night of struggling to learn R haha
That's the whole reason I made this video - finding a way to do this WITHOUT R! Glad this helped
hey, thanks for effort you put into this, i have a question, why did you use a natural log function in the likelihood!
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.
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.
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??
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.
I'm glad it helped. Using Excel for this is a little clunky, but it gets the job done! Good luck with your studies
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
bless you soul
I'm glad this helped!
Thank you, I’m taking managerial accounting and I was having so much trouble comprehending when doing homework.
who woulda thunk 10 years later this video would save me 1 hour before my submission deadline. thanks :)
I'm glad to know that I'm still helping all these years later.
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.
THANKS! This is a great time saver and appreciate the hint.
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. :)
🌷 'Promo SM'
this helped me with my home work thank youuuuuuuu
I'm so glad it helped!
lets go, youre GOATED LADY
This video was super helpful, thank you!!
Thank you!!!
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.
Do you have your calculator set to BGN? I am also set at 5 decimal places. Try that and hopefully it will work.
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.
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.
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!!!
Thank you Professor
I'm glad that it helped!
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?
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.
Can you explain why it's .50?
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.
Thank you so much.
I'm glad that it helped!
Thank you so much! I needed this for my final
Yes! EXACTLY what I was looking for. Great short insightful video. Keep up the great work!
Literal life saver!
Glad that it helped!
Hi, just a quick question. Are we referring to the whole population or to a sample? Is it correct to call this sampling distribution?
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.
@@lsw278 thank you very much. It's clear now
Is is the RFR = to Risk Premium? If not what is RP?
RFR is the "Risk Free Rate" and "RP" is the Risk Premium
respect saved my midterm
Awesome! So glad it helped.
THANKS ALOT
Glad it helped!
Hi Linda. Is it possible that you could quickly help me? :) At 5:05 in the video you choose Display Descriptive Statistics and only C1 and C3 shows up in the list. In my assignment I need the C2-T to show up as well, in a use of a boxplot. Why isn't the non-numerical cell showing up and how do I fix this? Thank you
So, if your column is showing as C2-T then Minitab has formatted that entire column as TEXT. That's why the column name has the -T in it. It may be that you typed a non-text character somewhere in your data or Minitab may just be having a bad day. But, what we can't do is create a Box Plot with non-numeric data. This is because Minitab needs to be able to calculate Median, Q1, Q2 and Q3 to create the plot. You can resolve this by starting over in another empty column and re-enter your data. You can also highlight the column and then go to Data>Change Data Type and select "Automatic Numeric" Which approach you take just depends on how many observations you have. I hope this helps! If you data is non-numeric (qualitative data), then you will need to use something other than a box plot to display the distribution of your data. I hope this helps!
@@lsw278 Thanks a lot, I appreciate it :)
TSYM! i completely forgot to take the areas of a normal distribution curve
Glad that this helped!
Thank you, Professor Williams
Glad it helped!
this was perfect to answer my question while doing my online/distance learning Statistics! Thank you! This is the part of online learning I find challenging….what to do when I have a question. I really appreciate you providing an answer when I needed it!
Statistics can be tough if you can't "see" how it works so I am glad this helped.
You're the GOAT, Linda
Hi, where I can get the emulator?
Contact HP. They offered it to educators for a while and they may still have it available. It plugs into a USB port. Very handy.
Why do we make the par value negative?
We have to make either the PV or FV a negative, so it's easier to make the Par Value of the Bond a negative so that we don't get an Error on the BAII
This was extremely helpful, thank you so much!!!
You are welcome and I'm glad that it helped.
Thank you soooo much for this video!!! really helped me understand how to the find the standard deviation!!!
Thank you!!! I cant even stress how grateful I am for this. This helped way more than cengage did!
I'm glad that this was helpful!
That’s slow way, you can just fill in CF sheet, then calculate NPV and bring it to the desired year.
I agree. This video mimics the steps shown in the textbook I use, so I went with this approach. I will get another video on this posted that shows the quicker way of arriving at this.
This was incredibly helpful and I cannot thank you enough!! I was really struggling and scratching my head on where to start and this cleared up so many questions. Thank you so so much!!!!!!
I'm glad that it helped!