Retail Trade Index by Region - RS Data Analysis watermarked preview
Data Analysis & Visualization · Statistical Charts

Retail Trade Index by Region - RS Data Analysis

Track retail commerce index trends across Rio Grande do Sul regions from raw government data.

This template organizes raw data from the Rio Grande do Sul State Treasury (Secretaria da Fazenda do RS) to analyze retail trade indices across different regions. It structures monthly index data from January 1999 to June 2003, broken down by Porto Alegre (POA), Metropolitan Region (RMPA), Non-Metropolitan Region (RNMPA), and the overall RS state level.

Ideal for economists, regional analysts, and government researchers studying historical retail trends and regional economic performance. The template removes the burden of manual data organization, allowing focus on trend analysis and regional comparisons.

What's inside

  • Multi-region index comparison (POA, RMPA, RNMPA, RS)
  • Monthly time-series data organization
  • 5-year historical dataset (1999-2003)
  • Government source data integration
  • Regional breakdown structure
#retail-index#regional-analysis#economic-data#time-series#government-data#RS-Brazil

Download this template

.xlsx · 1 sheet · included with lifetime access

Download

More in Data Analysis & Visualization

Bimodal Distribution Simulation & Analysis previewData Analysis & Visualization

Bimodal Distribution Simulation & Analysis

Simulate bimodal distributions with 6 states and 500 replications; calculate averages for statistical analysis.

  • Configurable number of states (6 default)
  • 500 replications for robust sampling
  • AVERAGE calculation across replicates
advanced.xlsx
Box Plot Statistical Visualization Template previewData Analysis & Visualization

Box Plot Statistical Visualization Template

Create professional box plots to analyze data distribution, identify outliers, and compare statistical ranges visually.

  • Multiple box plot layouts (standard and shifted variants)
  • Automatic quartile and median calculation
  • Data shift capability for comparative analysis
intermediate.xlsx
Bubble Chart previewData Analysis & Visualization

Bubble Chart

Create multi-dimensional bubble charts to visualize relationships between three variables at once.

  • Pre-formatted bubble chart framework
  • Customizable data axes and bubble sizing
  • Color-coded categories
intermediate.xlsx
Bubble Chart Letter previewData Analysis & Visualization

Bubble Chart Letter

Create professional bubble charts to visualize three-dimensional data relationships clearly.

  • Pre-built bubble chart template
  • Three-variable data mapping
  • Professional formatting ready for presentations
beginner.xlsx