Resolved: In the Climate_Amsterdam example, how did we get a as -6.64 and b as 1.67?
I downloaded the spreadsheet for the Climate_Amsterdam example and noticed that a has a value of -6.64 and b has the value of 1.67
Can you please share how these values were derived based on the data in the Climate_Amsterdam spreadsheet?
Hi Navin,
These are the steps in Excel:
1.) Create the scatter plot based on the data
2.) In the "Chart elements", tick the Trendline box
3.) Mark the trendline, right click -> Click "Format Trendline..."
4.) In the Trendline Options, Tick the box "Display Equation on chart" box
You should now be able to see the equation, with the a and b.
I hope this helps.
Based on the instructions provided, i did create a scatter plot and followed the steps as mentioned above but I am getting a different result. Please see the attached screenshot.

sorry. I figured out my issue. I was charting the x-axis and y-axis incorrectly.
Thanks.
Great, I am glad to see that you fixed it. Enjoy the rest of the course!
Sorry, just one more question wrt the same use case. I noticed that the graph which i generated (below) is a little different than the one provided in the daily temperature chart tab. Not sure why?
Thanks in advance for your inputs!

This must be due to the format of your axes.