Help with creating distribution of ROI

[Mando]

Hi everyone and thank you for you time. I would like to create a similiar histogram like this one below

My first Problem is that my ROI values are not in percentage. I calculated my ROI as follows : Sales-Budget/Budget. So my result is a whole number.

Honestly, I am just completely stuck.
My lowest ROI value is -99.99224 and my highest is 1182504.3520. In total I have 1640 observations.

I just don't know how to plot this nicely on the graph.

I always get only two stripes. Also, I have watched many videos and manage to do it in the tutorials but with my data I do not get along unfortunately.

Many thanks

[nirgrahamuk]

@Mando

Sales-Budget/Budget

So...
Sales - 1
?
Perhaps use brackets ?

[fredoxvii]

To add clarification on brackets:

(Sales-Budget)/Budget
#or
(Sales/Budget) - 1

[nirgrahamuk]

Hi!

To help us help you, could you please prepare a reproducible example (reprex) illustrating your issue? Please have a look at this guide, to see how to create one:

FAQ: How to do a minimal reproducible example ( reprex ) for beginners

A minimal reproducible example consists of the following items: A minimal dataset, necessary to reproduce the issue The minimal runnable code necessary to reproduce the issue, which can be run on the given dataset, and including the necessary information on the used packages. Let's quickly go over each one of these with examples: Minimal Dataset (Sample Data) You need to provide a data frame that is small enough to be (reasonably) pasted on a post, but big enough to reproduce your issue. Let's say, as an example, that you are working with the iris data frame head(iris) #> Sepal.Length Sepal.Width Petal.Length Petal.Width Species #> 1 5.1 3.5 1.4 0.…

[Mando]

I don´t really know how to reproduce a example dataset where the error or my problem does occure.
My variable got 1640 obervations.

• Mean of 8
• Std Dev 292
• Min -0.9999
• Median -0.1063
• Max 11,825

[nirgrahamuk]

1640 isn't so many. I'd be surprised if you couldn't share them all. (If you needed to)

Though if you got to the point of writing graphing code (which you should share), perhaps that involved summarising your data? In which case the summarised data is probably relatively small, and is a good candidate for sharing.