Need help with a data set.

[johnessy]

Im a content creator and im busy working with months of data and trying to find patterns in my data that i can make actionable decisions on. I have hit a huge hurdle i believe though please bear with me while i try to explain.

So i am looking at things like VIEWS and REACH. Now for me to work out my Click Through Rate i would / my Views by Reach and turn this into a percentage thats all good!

But when i have a video that has 100,000 Views and 200,000 Reach and also a video that has 10,000 and 20,000 Reach both of these return 50%.

I need to work out a way to know that the CTR on the 100K video has a bigger prominence of sorts if that makes any sense. I cant make any decisions on this type of data as it can be skewed is there a way i can work this out ?

 

[BigBeachBanana]

You can conduct hypothesis testing: Comparing Two Independent Population Proportions. Where your population is REACH, and the number of success is VIEW.

10.4: Comparing Two Independent Population Proportions

Comparing two proportions, like comparing two means, is common. If two estimated proportions are different, it may be due to a difference in the populations or it may be due to chance. A hypothesis …

stats.libretexts.org