Showing results for 
Search instead for 
Did you mean: 
Community Team Member
Community Team Member
Let's say we want a printout of our confidence interval for an entire sample (Note, if you're looking for a visual of a confidence interval over time, check out the post here!) The solution here requires Sisense for Cloud Data Teams' Python/R Integration as we'll be using R.
Notice that the function created in the R snippet takes in the following parameters for added customization:
  • data: a vector that contains all of the values of a sample (in this example, we took a column from the built in cars dataframe. Of course, you can easily have this be a column of your SQL output)
  • level: the width of the Confidence Interval. Default is set to 0.95 (95%)
  • test_type: whether we use the t distribution ('T') or a z/normal distribution ('Z') to calculate the confidence interval. We recommend verifying that your data is normally distributed before using the z distribution statistic.
# SQL output is imported as a dataframe variable called "df"
# Use Sisense for Cloud Data Teams to visualize a dataframe or show text by passing data to periscope.table() or periscope.text() respectively. Show an image by calling periscope.image() after your plot.

#As an exmaple, use the default Cars dataset and assign to df
df <- cars

confidence_interval <- function(data, level, test_type) {
  ci_level <- (level + 1)/2.0
  n <- length(data)
  stdev <- sd(data)
  mu <- mean(data)
  if (test_type == 'T') {
    error <- qt(ci_level,df=n-1)*stdev/sqrt(n)
  else {
    error <- qnorm(ci_level)*stdev/sqrt(n)
  lower <- round(mu - error,2)
  upper <- round(mu + error,2)
  return(paste(paste(level * 100,'%',sep = ''),'Confidence Interval:',lower,'to',upper, sep = ' '))

periscope.text(confidence_interval(df$dist, 0.95, 'Z'))
For the Python equivalent of this community post, check out the page here!
Found this useful? Let us know in the comments!
Version history
Last update:
‎02-05-2024 01:43 PM
Updated by:
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email [email protected]

Share this page: