  
    Regression
> Linear
  > Simple
    > Y = f( X )
    > Excel 
      > Data Structure
        A = X, B = Y, Row 1 = Headers
      > Data Operation
        Excel > Data > Data Analysis > Regression
        > Input Y Range = B1:B100
        > Input X Range = A1:A100
        > Lebels = Yes
        > Confidence Level = 95 % = Default
        > New Worksheet Ply = "Regr-Lin-Simp-Output"
        > Residuals
          > Residuals               = Yes
            Residual Plots          = Yes
            Standardized Residuals  = Yes
            Line Fit Plots          = Yes
        > Normal Probability
          > Normal Probabilty Plots = Yes


            
  

  
    2026-03-06
C_US_USD_CME-COMEX_Fut_GC
Stats_90d
  

  
    Daily Returns
> Histogram
> Box-Plot (Approximately aligned to x-axis of histogram)
  

  
    y = Move  = Open to Close = Close - Open
x = Range = Low  to High  = High  - Low
y     = f( x      )
yMove = f( xRange )

> Scatter Plot
> yBox, yHist (aligned to y-axis of scatter plot)
> xBox, xHist (aligned to x-axis of scatter plot)

Contact