What Is a Scatter Chart Analysis in Appraisal?

When you’re building and defending sales comparison adjustments, a simple visual can be very helpful. Scatter charts are one of the most effective ways to see whether a suspected relationship in your market actually exists, how strong it is, and where it breaks down.  

Used well, they help you move beyond “rules of thumb” and ground your appraisal adjustments in observable market behavior. 

Scatter charts are the fastest way to calculate and document adjusted pairs. If you’ve ever wrestled with paired sales in thin or noisy markets, scatter charts can be your best early signal: Do buyers in this neighborhood really pay more for extra GLA? Is that second full bath worth what you think it is? Is price growth steady month-to-month, or just headline noise?  

Below, we’ll break down what scatter chart analysis is, how to set it up, how to interpret results, and how to use those insights to support your adjustments. 

And if you’re ready to take the next step—moving from ad‑hoc techniques to a consistent, defensible adjustment framework—enroll in McKissock’s new CE course, A Paradigm Shift in Real Estate Appraisal Adjustments. 

What Is a Scatter Chart in Appraisal Terms? 

A scatter chart is a simple graph that shows how two variables move together—one on the horizontal axis (X), and one on the vertical axis (Y). According to The Appraisal of Real Estate, 15^th Edition, “Paired data and grouped data are variants of sensitivity analysis,” and scatter charts provide the visual framework for this analysis.  

In residential appraisal, the Y-axis (vertical) always represents adjusted sale price in dollars when used for appraisal grid adjustments—this is your dependent variable. The X-axis (horizontal) represents the element of comparison you’re analyzing—the independent variable.  

Typical pairs include: 

• Gross Living Area (X) vs. Adjusted Sale Price (Y) 
• Sale Date (X) vs. Adjusted Sale Price (Y) 
• Bedroom Count (X) vs. Adjusted Sale Price (Y) 
• Bathroom Count (X) vs. Adjusted Sale Price (Y) 
• Lot Size in Acres (X) vs. Adjusted Sale Price (Y) 
• Age (X) vs. Adjusted Sale Price (Y) 

Each closed sale is a dot. Patterns (or the lack of them) tell you whether the market recognizes value differences for that characteristic, and how consistently. 

Why Use Scatter Charts? 

• Quick visual validation: See if a relationship exists before you commit to a methodology. 
• Outlier detection: Spot oddball sales (e.g., distressed, unusually renovated, mismeasured) that could skew your analysis. 
• Direction and shape: Understand whether the relationship is linear, diminishing, stepwise, or effectively flat. 
• Communication: Screenshots and brief captions make your workfile and narrative more persuasive for underwriters and reviewers. 

How to Set up a Scatter Chart for Adjustments 

Follow a clean, repeatable process so your results can be explained and defended. 

1. Define your pool and make preliminary adjustments 

Start with the tightest possible competitive set for your subject—same neighborhood or market segment, similar age and quality, similar site size, and sale dates within a relevant market window. Avoid mixing fundamentally different segments (e.g., entry-level ranches with luxury new construction), which can blur or distort the relationship you’re trying to measure. 

2. Choose your X and Y 

Select the attribute you’re evaluating as the X (independent) variable—common choices include GLA, bathroom count, or closing month. Then use adjusted sale price in dollars as your Y (dependent) variable. This is the standard for scatter charts used in appraisal grid adjustments.  

3. Clean the data 

Remove known non–arm’s-length or distressed sales that don’t reflect typical buyer behavior in your market. Where applicable and supported, adjust sale prices for obvious concessions, market conditions, and other transactional factors, so your Y variable (adjusted sale price) aligns with market norms. At a minimum, flag potential outliers so they don’t silently drive your analysis; decide deliberately whether to retain or exclude them and document your rationale. 

4. Visualize 

Create the scatter chart in your preferred tool—Excel, Google Sheets, or specialized software like Solomon Sensitivity Analysis—and ensure axes and units are labeled. If the relationship appears roughly linear, add a trendline and display the equation and R² (coefficient of determination) to contextualize strength—not to dictate conclusions. If the pattern looks curved or stepwise, don’t force a straight line; consider a curve fit, a simple transformation (e.g., logs), or binning the data into logical ranges that match market behavior. 

Note on sample size: While single variable regression typically requires 30 or more data points to overcome variation in the broader market, sensitivity analysis within a sales comparison grid operates differently. Because you’re working with carefully selected comparable sales that have already been adjusted for most value-influencing factors, smaller sample sizes are both appropriate and effective for extracting individual adjustments. You’re isolating specific remaining differences between properties that are already highly similar. 

5. Interpret 

Assess direction (does the slope align with expectations?), magnitude (what change in value corresponds to a one‑unit change in the attribute near the subject’s range?), and strength (is the pattern tight or diffuse, and how should that influence your weight on the result?).  

Understanding R² (coefficient of determination): This measurement ranges from 0 to 1 and shows the percentage of variation in your dependent variable (adjusted sale price) that is explained by changes in your independent variable. For example, an R² of 0.81 means 81% of price variation can be explained by the characteristic you’re analyzing. Higher R² values indicate stronger relationships. Note: With only two data points, R² is meaningless because two points always form a perfect line.  

Look for breakpoints that signal diminishing returns, plateaus, or threshold effects, and use those observations to tailor the adjustment to the subject rather than applying a one‑size‑fits‑all rate. 

Three Common Scatter Chart Use Cases 

GLA vs. Adjusted Sale Price: Analyzing Size Contribution 

Plot GLA (X) against adjusted sale price (Y) to understand how living area affects value in your market. When other elements of comparison have been adjusted properly, the scatter chart will isolate the effect of GLA differences on value.  

How to use it: 

• Create a scatter chart with GLA on the X-axis and adjusted sale price on the Y-axis 
• If the pattern is linear, the trendline will show you the marginal contribution per square foot. 
• If the pattern curves, this reveals diminishing returns—each additional square foot contributes less value than the one before. 
• Estimate a reasonable marginal contribution for the subject’s size range, not a single number for all sizes.  
• Support your final GLA adjustment with a brief explanation: “Based on a scatter chart of 12 adjusted competitive sales, marginal GLA contribution near 1,900–2,200 SF is approximately $X per SF. The R² of 0.76 indicates that 76% of the remaining price variation is explained by size differences after other adjustments have been applied.

Supplemental view: You may also create a secondary chart plotting GLA (X) vs. Price Per Square Foot (Y) to visualize diminishing returns more clearly. This supplemental view can help explain why larger homes don’t necessarily command proportionally higher prices per square foot. 

Keep the math simple in your narrative; the workfile can contain the technicals. 

Sale Date vs. Adjusted Sale Price: Time Adjustments with Less Guesswork 

Plot closing month (X) against adjusted sale price (Y) for a narrowly similar set of properties. Even with a small dataset, a scatter chart can reveal whether the market trend is flat, rising steadily, or bouncing around. 

How to use it: 

• Fit a linear trendline if the dots don’t show obvious cycles; report the monthly change (e.g., +0.6% per month). 
• If the trend is volatile or driven by a few outliers, state that the time trend is weak or unstable and down‑weight it in the adjustment rationale. 
• Consider segmenting by sub-neighborhood if trends differ across micro-markets. 
• Remember to account for seasonality and short-term shocks that could push you toward misleading conclusions. 

Here’s a simple way to communicate the result: 

“A scatter chart of 18 sales over the past 12 months indicates a stable upward trend of approximately 0.5–0.7% per month in this submarket. A 4-month time difference is supported by a time adjustment of ~2–3%.” 

Bathroom Count vs. Adjusted Sale Price: Stepwise Contribution 

For bathroom count, you’ll often see a step pattern rather than a smooth line—buyers pay a jump from 1 to 2 baths, a smaller jump to 2.5, and possibly little to no jump beyond 3 in modest homes. 

How to use it: 

• Plot bath count (X) vs. Adjusted sale price (Y) within a tight comp set to avoid confounding factors. 
• When the sales comparison grid has been completed to the extent that there is only one difference between two comparables (bathroom count), the value of the difference can be shown clearly in the scatter chart 
• You may use separate color coding for condition or quality tiers to ensure the observed steps aren’t actually quality differences. 
• Derive a conservative range for the incremental contribution and reconcile with paired sales (when available) for a tighter support narrative. 

Bringing It Back to the Sales Grid 

Scatter charts don’t replace judgment; they focus it. Here’s how to tie the picture to a defensible adjustment: 

• Document: Screenshot the plot with labeled axes, date range, and filters used. 
• Quantify: Note the trendline slope (or step difference) that applies nearest the subject’s characteristics. 
• Reconcile: Cross-check against a few targeted paired sales. If the paired sales support a similar magnitude, say so. If they differ, explain why and weight accordingly. 
• Apply: Use the supported figure in your grid and reference the analysis in your addendum. 

Common Mistakes to Avoid 

Avoid mixing fundamentally different market segments just to boost your sample size; this creates a noisy cloud of points that hides real relationships. Instead, keep your cohort tight and comparable.  

Likewise, don’t force a straight trendline onto a pattern that’s clearly curved or stepwise—GLA often shows diminishing returns—so consider a curve fit, a simple transformation, or logical bins.  

Also account for seasonality and short‑term shocks when plotting time trends; overlooking them can push you toward misleading conclusions. 

Using zero values or non-numerical data: Scatter charts cannot process zeros, letters, or non-numerical values on the X-axis. Convert qualitative characteristics to numerical rankings before charting.  

Remember that scatter charts work best when analyzing adjusted sale prices after transactional and obvious physical adjustments have been made. This isolates the specific variable you’re studying.  

Don’t rely on scatter plots alone—corroborate your findings with paired sales, sensitivity checks, and market intelligence before you finalize adjustments. 

Compliance and Communication Tips 

Be transparent about scope by briefly explaining your data pool, filters, and why this method fits the subject and assignment.  

Keep the analysis reproducible so a reviewer using the same filters will see a similar pattern and follow your reasoning.  

Finally, ensure your narrative matches the grid by stating not only what the adjustment is, but why it’s credible for this market segment and this specific subject. 

Level up Your Appraisal Adjustments Beyond Paired Sales 

If paired sales are leaving you stuck—or if you want a tighter, more consistent way to justify your numbers—consider building your adjustment process on a practical framework designed for real appraisals and real environments.  

A Paradigm Shift in Real Estate Appraisal Adjustments is a self-paced online course built for appraisers who want to transform their reports from “serviceable” to “solid under scrutiny.”