alex
  • Member for 7 years, 4 months
  • Last seen more than a week ago
  • Durham, UK
How import Excel file from different folders
Accepted answer
2 votes

I am not certain whether your folder management is the best for what you want, but I can try to give you a working example that you can then modify to suit your needs. By no means does the code need ...

View answer
How to get an absolute value of Around?
2 votes

I don't know if this would be acceptable as an answer, for the sake of expediency (assuming you just want a quick answer!), here is what you could write to keep this working for you: abs[val_, lBound_,...

View answer
Fitting data to a Poisson distribution
2 votes

Although I do realise that it is a bit late, maybe I can contribute a bit more to this. I really do like ciao's method and I think it gave good points. Here I'd like to show you a potentially more in ...

View answer
How can I fit a function onto a histogram?
1 votes

A bit late in the game, If you want a more 'purist' approach, you could also use HistogramList to extract the points and then fit using an arbitrary function. SampleData = RandomVariate[...

View answer
make a single figure composed of several plot
1 votes

I would suggest two methods: Show[{ Plot[Cos[2 x], {x, 0, 4 \[Pi]}, PlotStyle -> Blue], Plot[Sin[x], {x, 0, 2 \[Pi]}, PlotStyle -> Red] }] or even more simply Plot[{Sin[x], Cos[x]}, {x, 0,...

View answer
How to generate randomly points that belong to the given range?
Accepted answer
1 votes

To give context for the reader, You create a circle and a square and by asking the intersection you generate regions, highlighted in red. The question is whether there is a way to extract an angle ...

View answer
Find the best fit with some conditions
1 votes

I am not certain why there is a hiccup with the fitting, generally both FindFit and NonlinearModelFit are quite reliable if you set your conditions right. I found that the issue resides with the "...

View answer
Having two or multiple plot legend lines next to a single string
1 votes

There doesn't seem to be a built-in method within LineLegend or any other legend function to allow multiple lines. It seems that the fastest way forward is to have this created via Graphics, and then ...

View answer
Selecting a range of dates from a database
0 votes

Although @Hans has provided the best answer so far, I'd like to show an alternative just in case people are interested. It is significantly slower for this particular case, but it works just as well: ...

View answer
Import variables from excel
0 votes

First things first, I'm certain you do not need a new expensive add-on. Excel files can be tricky as people often save their files with all sorts of different settings. When you import a file using ...

View answer