Search results: correlation

• 

  Scatter Plot Matrix in Excel (12x12 panels) with Correlation Matrix

  Excel template to build a Scatterplot Matrix—with up to 12 variables—in one chart for ease of analysis and formatting.

  data visualizationgraphsexcelcorrelationstatistics

  1,733Discussadd_shopping_cart

  $25.00

  by Hicham Bou Habib
• 

  Financial correlations model (2024 version)

  Calculate the static or rolling correlation coefficient between any two variables, based on price or return, for optimal asset allocation or research purposes.

  standard deviationindexcorrelationpricereturn

  578Discussadd_shopping_cart

  free

  by Domenico Cristarella
• 

  Measuring and Modeling Seasonality

  A set of very practical tools to analyse seasonal fluctuations

  analysisplanningforecastdashboardsvariances

  988Discussadd_shopping_cart

  $25.00

  by Andrei Okhlopkov
• 

  Descriptive statistics for grouped (weighted) data

  Calculating key statistics measures (average, median, standard deviation, skewness etc.) for grouped or weighted data

  standard deviationexcelcorrelationstatisticsmedian

  2,036Discussadd_shopping_cart

  free

  by Andrei Okhlopkov
• 

  Portfolio Variance Model

  A simple model to learn and play with portfolio variance in Excel

  matrixriskfinancevarianceportfolio

  1,818Discussadd_shopping_cart

  free

  by Risk Prep
• 

  Monte Carlo Analysis (without macros) Excel Model

  This post explains how to run full Monte Carlo analysis in Excel without macros

  excelcorrelationfinancialmodelingstatisticssimulation

  6,1206add_shopping_cart

  free

  by Andrei Okhlopkov
• 

  Dynamic Scatterplot in Excel

  Excel template to build a dynamic scatterplot along with the statistical model and the 6-Plot charts needed for assessment of the fit of regression analysis.

  data visualizationgraphsexcelcorrelationstatistics

  458Discussadd_shopping_cart

  $10.00

  by Hicham Bou Habib
• 

  Optimal Portfolio - Markowitz Efficient Frontier (With Short Selling Option) Excel Model

  Use this tool uses Efficient Market Hypothesis to determine the optimized portfolio allocation.

  diversificationmarkowitzefficent market hypothesisportfolio theory

  1,5381add_shopping_cart

  $5.00

  by Kenton Parrott, CFA, MBA
• 

  Turn Overheads into Insight: Absorption Costing Model

  A great tool for any manufacturer of goods. Produce per-unit costing and periodic pricing / volume analysis.

  accountingsensitivity analysiscost accountingmanufacturingcost per unit

  344Discussadd_shopping_cart

  $40.00

  by Jason Varner
• 

  Statistical Analysis Excel Dashboard - Full version

  Unlock powerful insights with this all-in-one statistical dashboard—ideal for researchers, analysts, and decision-makers seeking clarity from complex data.

  dashboardexcelstatisticsdata analysisfree demo

  400Discussadd_shopping_cart

  $25.00

  by Giorgi Tetrauli
• 

  The 3-Statement Financial Model: A 10-Year Model

  A 3-Statement Model is used by Analysts to forecast and financially represent the projected performance of a business.

  valuationcorporate financefinancial modellingexcelmodelinvestmentanalysis

  29Discusslibrary_add

  free

  by Dennis Onyango
• 

  Download Financial Market Time Series Data

  Download and align Open, High, Low, Close and Volume stock and index data for multiple symbols and time frequencies.

  riskfinancial marketsreturndownloadstock prices

  1,3812add_shopping_cart

  free

  by Business Spreadsheets
• 

  Bowman's Strategy Clock Template

  A pricing & marketing strategy framework template to position products & services and determine appropriate strategies.

  differentiationpricingmarketing strategypricing strategystrategic management

  2,108Discussadd_shopping_cart

  free

  by Tim Demoures
• 

  Portfolio Optimization Excel Model with Harry Markowitz's Modern Portfolio Theory

  Find the efficient frontier of optimal portfolios, the Capital Allocation Line, tangent portfolio and more

  investmentpersonal financewealth managementoptimizationportfolio

  8,4657add_shopping_cart

  $5.00

  by Jhett Koo
• 

  CEQ Method Valuation Model

  Valuation by the CEQ Method based on Discrete Scenario Cash Flow Forecast

  financevaluationcash flowsbetaprivate equity

  4,7711add_shopping_cart

  free

  by Kevin Hanley
• 

  Monte Carlo Simulation Excel Template

  This model aims to predict probable outcomes by running numerous simulations.

  predictionmonte carloexcel templatemonte carlo simulationpredicting results

  5,0352add_shopping_cart

  $5.00

  by Alberto Scappini
• Your Best Practice

  Have a Best Practice to share?

  Publish your Best Practice
  Learn more about digital publishing

keyboard_arrow_downShow more