Thank you so much for this brilliant video. I have a little problem though, I am not able to update the chart with a new data afterwards. Do I have to go through this process everytime?
Note: 4:52 "I know R is 10". He is talking about the number of counting runs. Excel would do that calculation for you with COUNTIF(E4:E34, 1) because each 1 in column E counts as a new run.
can you please show any reference in support of the method of your first VIF calculation formula. I have found two different results using the two formulas and everyone supports the later one (with R square).
Thumbs down. Chart uses monthly data, not index data. Create a chart that shows MONTHS along horizontal axis; not an indexed value representing a month. For example, there seems to be a spike in index 24; but what MONTH/YEAR was that spike? What if data is shown by Year, with several sub-groups of data representing sales of 4 or 5 different products. Suppose your data shows 15 years with these 4-5 products and you want to see a representative line across the 15 years for each product? This would be useful. Your video, as is, is good for showing how to dress a chart; but you get the thumbs down for not showing how the chart shows the data itself.