Hi Ahmed, the data was totally made up for purposes of this video and didn't come from an actual experiment. I think I generated it in Excel using =norminv(rand(), [function goes here], [desired amount of data fluctuation goes here]). For example, let's imagine I wanted to create fake data where y = 0.1x^2 + 2. But I want the data to simulate uncertainty / random errors in my measurements. Let's imagine my x values are in column A, and my y values will be calculated in column B. In the cell B1, I'd type: =NORMINV(RAND(), 0.1*A1^2 + 2, 3)
I calculated the log of each value using a formula. In Excel, the formula you use to calculate the log of a value is: =log(...) In place of the ..., you click on the cell you want to take the log of.
This is just awesome, man. Deserve much more views than 1.7k (2 sig.fig.) now.
Haha! I'm really glad it was helpful. Thanks for the comment!
Still laughing at this sig fig joke a year later!!
@@danielm9463 hahaha you have an exceptional memory!
This is damn helpful. Thank you!!!
Do you know if this still applies for the 2025 syllabus
I don't, unfortunately
Hello Sir, Firstly I liked the video so much and secondly if you could tell me the experiment itself that you took this data from ?
Hi Ahmed, the data was totally made up for purposes of this video and didn't come from an actual experiment. I think I generated it in Excel using =norminv(rand(), [function goes here], [desired amount of data fluctuation goes here]). For example, let's imagine I wanted to create fake data where y = 0.1x^2 + 2. But I want the data to simulate uncertainty / random errors in my measurements. Let's imagine my x values are in column A, and my y values will be calculated in column B. In the cell B1, I'd type:
=NORMINV(RAND(), 0.1*A1^2 + 2, 3)
Daniel M Thank you so much Sir
Hey, how did you create the log table?
I calculated the log of each value using a formula. In Excel, the formula you use to calculate the log of a value is: =log(...) In place of the ..., you click on the cell you want to take the log of.