logarithmic

Hello everyone! I have a database in Google Sheets of materials (leather, steel, etc..) that have different modifiers (100%, 70%, etc...). This creates a curve that interpolates between the points. My issue is that in Master!D:D I wrote the following formula: =IF(E3<0...

I am trying to determine the equation that best approximates the values in this table for converting raw scores in bridge to IMPs. <tbody> Up To IMPs Up To IMPs Up To IMPs 10 0 420 9 1740 17 40 1 490 10 1990 18 80 2 590 11 2240 19 120 3 740 12 2490 20 160 4 890 13 2990...

Hi Would anyone solve my problem? I would like to create in excel a graph for which the y-axis is on a double logarithmic scale, while the x-axis is one-time logarithmated. Below is an example of a chart that I would like to write in excel...

Hi, I have produced an x-y scatter chart from the following two columns of data. <tbody> åkDt hours Comp. Strength (N/mm²) </tbody> <tbody> 11.36 6.2 16.31 12.9 25.18 18.4 29.36 24.4 38.21 30.5 88.41 41.4 349.29 63.6 </tbody> The X scale is formatted to Logarithmic Base 10...

Good morning, I have a sheet that has pivot charts connected to an analysis tab. The analysis tab converts qualitative data (<10) to numbers which are then charted on a Log-10 scale. Every time I refresh or use the Timeline slicer, the "Negative or Zero Values Cannot Be Plotted on a Logarithmic...

BLUF: Are the logarithmic basis (not the base) and the min value independent variables when graphing logarithmically in Excel? Details: I would like to graph vibration amplitudes, which are displayed logarithmically on both the x and y axes. I know how to change the axes to display...

I have a 2 sets of logarithmic values, of which I want to find the average. Would using the arithmetic average be correct, or is it more complex than that? Please, help me with some guidance. Forgot to mention: the second set is shorter, but if extended no values woud have been recorded.

Good afternoon all Can anybody please help me translate the formula below into Excel speak: Answer = 10 log[10^(X1/10)+10^(X2/10)+10^(X3/10)] Where X1, X2 & X3 are my data entry points. I have tried it as the following but the answer is not what I expect...

Hi, I have a dataset which is widely distributed. A log chart can display the pos values fine, but I need the same treatment for neg values also which obviously rules out log. My values for example range from -5 to +5 for both axes. There are a lot of data points in the 0 to .03 range and -.03...

Hi! I would like to plot a graph with both the x and y axes in log scale; however, I currently can only make the y axis a log scale by clicking the axis options. How do I make both axes into a log scale? Thank you!

Hi all, I got my problem to fit into a screenshot that shows 2 examples of a logarithmic curve working in Excel charts (upper and lower left) and the third that has driven me to complete madness (upper right). The description of the issue is explained in the picture below. Thanks in advance...

I have created a chart in excel in which I have created a logarithmic trendline. I am wanting to find out what the Y values of the trendline are. In other words, I have my current Y values that generated the trendline, but I want to know what the Y values of the actual trendline are. If I was...

Hi, I've been struggling with a graph I'm doing for a lab report, and I've been unable to find a solution online. I have two series, each with separate y-axes (linear) and both plotted on a logarithmic x-axis with the same x-axis values for both series. I expected the points on both series to...

I am trying to modify a spreadsheet so that we can plug the slope off of a log regression equation into a formula, however, I cannot figure out how excel is calculating slope. The given formula is y=-0.098ln(x)-0.3401. My max and min data points are (69,0.375758) and (585,0.157576) and the...