![]() Is there an easy way to get excel to give me a y value for a given x value which doesn't require me to manually type out the formula it is providing?Īny help of information would be greatly appreciated. Additionally, select Trendline from the Chart Element That will instantly add a linear. And click on the ‘ + ’ sign or the Chart Element. To do so, we will follow these steps: To begin with, we need to select the chart. Navigate to Insert > Charts and select Scatter Chart. Here is the full formula typed out which may be helpful Would I type in 0.0000276452571251802x (where x is the cell with the required x value)? ![]() It's been a while since I did A level maths and I am drawing a blank on how to use this formula with the 'E' notation to get the full range of Y values from each X value at 0.5N intervals. I managed to get a trend line which sort of fits the offset data, which looks like the below image My offset is the shift in the testing setup which is again measured in X = load (N), Y = Compression displacement. My initial set is a sample being compressed, with the data being X = load (N), Y = Compression displacement. I have a data set which needs to be offset by another data set.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |