The tutor gives an example of using Excel’s Goal Seek. Example: Solve lnx + 15= 0.25x Solution: Select a cell (let’s imagine e3), then name it X (or whatever name you prefer. See how to name a cell in my …
Spreadsheets: how to use Excel to solve an equation Read more »
The tutor shows the seriessum() function, found on both Excel and LibreOffice Calc. A geometric series has the form Sn = cr0 + cr1 + … + crn-1 An example is 3 + 3*4 + 3*42 + … + 3*45 …
Spreadsheets: Excel and LibreOffice Calc: the sum of a geometric series Read more »
The tutor shows the log() function on Excel and LibreOffice Calc. Pretty much every scientific calculator has log and ln keys, with the log base 10, the ln base e. What if you need log base 5, for instance? Of …
The tutor shares a nice function that seems to work the same in Excel or LibreOffice Calc. The frequency() function tells, from an array of values and another of categories, the frequency in each category. A potential use is to …
Statistics: Spreadsheets: the frequency() function Read more »
The tutor shows how to get a graph and equation for data using LibreOffice Calc, in six easy steps. Let’s imagine your x-data is in a1:a5, your y-data, b1:b5. Select the range a1:b5. Click the Chart icon, which looks like …
Spreadsheets: LibreOffice Calc: how to get a graph and equation from data Read more »
The tutor shares quick, easy way to get a graph and equation from Excel, 2007 version. Let’s imagine your x data is in range a1:a10, your y-data, b1:b10. Select a1:b10, then click Insert, then the Scatter icon. Then, in the …
Excel: How to make a graph from data and get an equation, 4 easy steps Read more »
The tutor explains the difference between power and exponential curves. According to Excel, a power equation has the form y=axb whereas an exponential equation has the form y=aekx Example: I tried both options on the following data: x y 0.5 …
Spreadsheets: regression curves: power vs exponential Read more »
The tutor shows how to use the logest() function to get an exponential curve from data. Excel’s logest() function returns parameters for the equation y=bm^x, according to data fed for x and y values. Let’s imagine the data is as …
The tutor shows how to get a best-fit line using Excel or LibreOffice Calc. Let’s imagine you want a best fit line of form y=mx + b for the following data: x y 0 3 2 5 6 10 8 …
Spreadsheets: linear regression in four easy steps on Excel or LibreOffice Calc Read more »
The tutor mentions Excel’s convenient conversion utility. I used to wonder, casually, what a nautical mile is compared to an ordinary mile. Not anymore: today I discovered Excel’s convert() formula, which is among the Engineering ones in More Functions, in …