ThisCalculator

Everyday

Linear Scale in Google Forms: How It Works

Updated · Standard formula, shown below

Average pace 5.00 min/km
Average speed
12.00 km/h
Result
Finish time
50 min
You entered
Distance
10 km
You entered

Linear scale in Google Forms is a question type that lets respondents rate something on a numbered scale, typically from 1 to 5 or 1 to 10, with optional labels at the low and high ends. You add it by clicking the “+” button, choosing “Linear scale” from the question type menu, and then setting the scale range and any endpoint labels. This article explains how the linear scale works, when to use it, how to set it up, and common pitfalls to avoid.

Formula

This calculator computes average pace and speed from a given finish time and distance. The formulas are:

Average pace (min/km) = Finish time (minutes) ÷ Distance (km)

Average speed (km/h) = Distance (km) ÷ (Finish time (minutes) ÷ 60)

Where:

  • Finish time (t) – total time taken, in minutes.
  • Distance (d) – total distance covered, in kilometers.
  • Average pace – minutes per kilometer (min/km).
  • Average speed – kilometers per hour (km/h).

Worked Example

Using the default values: finish time = 50 minutes, distance = 10 km.

Step 1: Calculate pace = 50 ÷ 10 = 5.0 min/km

Step 2: Calculate speed = 10 ÷ (50 ÷ 60) = 10 ÷ 0.8333 = 12.0 km/h

So the average pace is 5:00 per kilometer, and the average speed is 12.0 km/h.

When to Use a Linear Scale

Linear scale questions are ideal for measuring attitudes, satisfaction, frequency, or importance along a continuous spectrum. Common uses include:

  • Customer satisfaction surveys (1 = very dissatisfied, 5 = very satisfied)
  • Employee engagement or feedback forms
  • Event feedback (rate the venue, speakers, food)
  • Self-assessment (rate your confidence level)
  • Frequency questions (1 = never, 5 = always)

Because the scale is numeric, responses are easy to analyze quantitatively—you can compute averages, standard deviations, and trends over time. It works best when you want a quick, intuitive rating without forcing a binary yes/no answer.

How to Set Up a Linear Scale Question

To add a linear scale question in Google Forms:

  1. Open your form and click the “+” button to add a new question.
  2. Click the dropdown menu next to the question (default is “Multiple choice”) and select “Linear scale”.
  3. Enter your question text (e.g., “How satisfied are you with our service?”).
  4. Set the scale range: choose from 1–5, 1–7, or 1–10 (or 0–5, 0–10).
  5. Optionally, add labels for the low and high ends (e.g., “Not at all” and “Extremely”).
  6. Turn on “Required” if you want to force an answer.

You can also add a description under the question to clarify what the scale means, but the built-in labels are usually enough.

Choosing the Right Scale Length

The number of points on your scale affects the granularity of your data. Here are some guidelines:

  • 1–5 – Simple and quick, good for most satisfaction surveys. Easy to interpret but may not capture fine differences.
  • 1–7 – Offers more nuance; often used in academic or employee surveys to reduce central tendency bias.
  • 1–10 – Provides the most granularity, but respondents may find it harder to choose a precise number. Good for NPS-style questions (though NPS is typically 0–10).
  • 0–5 or 0–10 – Useful when zero can mean “none” or “not at all”, such as pain scales or likelihood ratings.

In general, odd-numbered scales (5, 7) allow a neutral midpoint, while even-numbered scales (4, 6) force a lean toward positive or negative. Choose based on whether you want to allow a neutral option.

Common Mistakes and Misconceptions

One common mistake is not labeling the endpoints. Without labels, respondents may interpret the numbers differently (e.g., is 1 good or bad?). Always add clear labels for the low and high ends.

Another mistake is using a linear scale for questions that aren’t really linear, like “Which color do you prefer?” – that should be a multiple choice or checkbox. Also, avoid making the scale too long (e.g., 1–20) because respondents lose patience and accuracy.

A related misconception is that linear scale results are always normally distributed. In practice, responses often cluster at the high end (positive skew) or show a bimodal pattern. Don’t assume a normal distribution; use appropriate statistical tests.

Analyzing Linear Scale Responses

Google Forms automatically aggregates responses into a bar chart showing the count for each number. You can also view individual responses in a spreadsheet (click the green “View in Sheets” icon).

For deeper analysis, you can calculate the mean, median, and mode of the responses. For example, if you have 10 responses: 5, 4, 5, 3, 5, 4, 5, 5, 4, 5, the mean is (5+4+5+3+5+4+5+5+4+5)/10 = 4.5, the median is 5, and the mode is 5. This tells you that most respondents are satisfied.

If you want to compare groups (e.g., male vs. female), you can use a t-test or ANOVA, but that requires exporting the data to a statistical tool.

Limitations and Alternatives

Linear scale has a few limitations. It assumes the intervals between numbers are equal (e.g., the difference between 2 and 3 is the same as between 4 and 5), which may not be true for subjective ratings. Also, it doesn’t capture the “why” behind a rating – you may want to add an open-ended follow-up question.

Alternatives include:

  • Multiple choice grid – for rating multiple items on the same scale.
  • Checkbox grid – for selecting multiple options per row.
  • Dropdown – for a compact list of options.
  • Short answer – for open-ended numeric input (e.g., “Enter your age”).
  • Rating question in Google Forms (if you use Google Workspace) – similar but with star icons.

For more advanced survey needs, consider tools like SurveyMonkey or Typeform, but for most simple rating tasks, linear scale is sufficient.

Frequently Asked Questions

Can I change the scale from 1-5 to 1-10 after creating the question?

Yes, you can edit the question at any time. Click the pencil icon to edit, then change the “Scale” dropdown to the desired range. Existing responses will remain, but the new scale applies to future responses.

How do I add labels like “Poor” and “Excellent” to the scale?

In the question editor, you’ll see two optional text fields: “Label (optional)” for the low end and “Label (optional)” for the high end. Type your labels there, and they will appear next to the numbers.

Can I make the linear scale question required?

Yes, toggle the “Required” switch at the bottom right of the question box. This forces respondents to select a number before submitting the form.

What is the difference between linear scale and multiple choice grid?

Linear scale asks one question with a single numeric rating. Multiple choice grid lets you ask multiple questions in a table format, each with the same set of answer choices (e.g., rate each feature on a 1-5 scale).

Can I use a linear scale for a question that isn’t numeric?

No, linear scale is specifically for numeric ratings. For non-numeric options, use multiple choice, checkboxes, or dropdowns.

How do I see the average rating in Google Forms?

Google Forms doesn’t show the average directly in the summary view. You need to open the response spreadsheet (click “View in Sheets”), then use the AVERAGE function on the column of responses.

Related

Formula used
in t | Finish time | min | 50 | 0
in d | Distance | km | 10 | 0
out pace | Average pace | min/km | t / d | 2
out speed | Average speed | km/h | d / (t / 60) | 2

Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work

Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.