Small Business Credit Survey: Expected Increase in Revenue: Employer Firms (SBCSS9B0V0FRB) | FRED | St. Louis Fed
- Rows
- 10
- Columns
- 2
- Data range
- 2016-01-01 to 2025-01-01
Graph and download economic data for Small Business Credit Survey: Expected Increase in Revenue: Employer Firms (SBCSS9B0V0FRB) from 2016 to 2025 about small business, business sentiment, employer firms, revenue, and USA.
AI analysis
Data Analysis: Small Business Credit Survey — Expected Increase in Revenue (Employer Firms)
1. Dataset Overview and Value
This series (SBCSS9B0V0FRB) is sourced from the Federal Reserve's Small Business Credit Survey (SBCS), a well-regarded annual survey conducted in partnership with all twelve regional Federal Reserve Banks, and distributed via FRED (fred.stlouisfed.org). The data captures the percentage or index of employer firms expecting revenue increases, spanning 2016–2025 as an annual series (10 observations, roughly one per year). Because it comes from FRED's API, the data is authoritative and updated on FRED's regular refresh cycle, though as an annual survey-based metric it will lag more frequently-updated indicators. Its value for correlation studies lies in tracking small-business sentiment/expectations over nearly a decade, including the pre-pandemic, COVID-shock, and recovery/inflation periods — making it useful for studying how small firms' revenue expectations relate to macroeconomic conditions.
2. Data Quality Observations
Data quality is notably clean for what's available: zero null cells across both columns, and the join key (observationdate) has 10 distinct values matching the 10 total rows — no duplicate dates are apparent. Duplicate-row computation is marked as pending (Phase D recompute against Parquet), so that check isn't yet finalized, but there's no structural indication of duplication given the 1:1 distinct-to-row ratio on the date key. The main quality caveat isn't nulls or duplicates but sparsity of observations — only 10 annual data points is a small sample size, which limits statistical power for robust correlation or regression analysis and increases sensitivity to outliers or single-year anomalies (e.g., a pandemic-year reading).
3. Key Column Distributions
The value column (SBCSS9B0V0FRB) ranges from 41 to 72 (a 31-point spread) with a mean of 60.9 and median of 58.5, indicating a slight right-skew in central tendency terms, though the skewness statistic itself is -0.668, suggesting a left (negative) skew — likely driven by one or more low-value years (possibly 2020 or 2021) pulling the distribution down. The interquartile range (Q1=56.25, Q3=69) is fairly tight relative to the full min/max range, meaning most years cluster in the mid-50s to high-60s, with the extremes (41 and values near 72) acting as outliers relative to that core cluster. With only 7 distinct values across 10 rows, there are likely 2-3 repeated values, suggesting some years had identical or rounded-equal readings — worth verifying against raw source data.
4. Recommended Join Keys
observationdate is the clear and only viable join key — it's a clean date field with zero nulls and full distinct coverage. Since this is annual data, correlation partners should be resampled or aggregated to annual frequency (e.g., averaging monthly/quarterly series within each calendar year) before joining on year, or joined on year-only truncation (extracting YYYY from observationdate) if partner datasets use fiscal-year or mid-year dates.
5. Suggested Pairings for Correlation Analysis
Good candidates include other SBCS series (e.g., expected employment growth, credit application/approval rates, or firm profitability outlook) to build a fuller small-business sentiment picture; macroeconomic indicators like GDP growth, small business optimism indices (NFIB), consumer confidence, and Federal Reserve senior loan officer survey (SLOOS) data on lending standards; and credit/financial conditions series such as bank lending rates to small firms or business loan delinquency rates. Given the annual cadence and 2016-2025 span, pairing with inflation (CPI) and interest rate (Fed Funds) annual averages could reveal how monetary policy tightening cycles correlate with small-firm revenue expectations — particularly interesting around the 2022-2023 rate-hike period.
Columns
- observation_date (date)
- SBCSS9B0V0FRB (integer)