Questions tagged [sql]

SQL (Structured Query Language) is a special-purpose programming language designed for managing data held in a relational database management system (RDBMS).

6 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
4
votes
1answer
83 views

Electoral college simulation using SQL Server

As I'm sure will be apparent to most here, I'm not a statistician or a programmer, but one of my hobbies is politics. I've created a (very simple) USA electoral college simulation, seen below. The ...
1
vote
1answer
53 views

Weekly sales for different start dates automate report

I’m trying to develop a report with customer sales behaviour each time a new product is Launched. The columns in the report would be : sales in time t (the time product was launched ) , sales in time ...
1
vote
0answers
2k views

How to aggregate multiple Z-scores

Is there a way to aggregate multiple Z-scores to get a single Z-score that corresponds to the probability that no null hypotheses are rejected? Backstory: We have a tool that has some error E that ...
1
vote
0answers
1k views

generate frequency distribution from database

In a MySQL database there's a table with a single numeric value column. I want to plot the distribution of these values as a bar chart/histogram with the following ...
1
vote
0answers
109 views

A/B/C testing evaluation over time ans across groups

I'm needing to validate an inherited testing project correct use of confidence testing. Direct mail creatives are being evaluated at month end over a 90 day campaign cycle for several unique customer ...
0
votes
0answers
98 views

How does LOESS work in STL Decomposition Algorithm?

I am trying to write a SQL program to calculate STL Decomposition of monthly time series data. In going through the algorithm in the original paper, inner loop step 2 has the detrended series grouped ...