Got it, let's tackle these two Excel tasks one by one—super common scenarios, so I'll break them down with clear steps and formulas:

Depending on what kind of sequence you need, there are two straightforward methods:

Method 1: Quick drag for arithmetic sequences #

• Enter your starting value (e.g., 10 in cell A1) and the next value in the sequence (e.g., 11 in A2) to define the step size.
• Select both cells, then hover over the bottom-right corner of the selection until you see a black cross (the fill handle).
• Drag the fill handle down or right until you reach your target end value (27). If Excel stops early, click the "Fill Options" icon that pops up and select Fill Series.

Method 2: Precise sequence setup (for custom steps or fixed ranges) #

• Enter your start value (A1 = 10) and end value (say, A5 = 27) in the range you want to fill.
• Select the entire range (A1:A5).
• Go to the Home tab → Editing group → click Fill → choose Series.
• In the dialog box:
  • Select Columns (or Rows, depending on your range orientation)
  • Choose Arithmetic Sequence
  • Leave the "Step value" blank if you want Excel to auto-calculate it (for A1:A5, it’ll be (27-10)/(5-1) = 4.25), or enter a custom step if needed.
• Hit OK and the sequence fills automatically.

First, let’s clarify: "stepwise average" usually refers to the average of all values in the sequence between your two numbers (often integers, but we can handle custom steps too).

For integer steps (10, 11, 12, ..., 27) #

You have two easy options:

1. Quick math shortcut: For any arithmetic sequence, the average is simply (first value + last value) / 2. Here, that’s (10 + 27)/2 = 18.5—no formula needed if you just want the number.
2. Excel formula: Calculate it directly in a cell with:

   =AVERAGE(ROW(INDIRECT("10:27")))
   

   • INDIRECT("10:27") creates a reference to rows 10 through 27, ROW() extracts those row numbers as your sequence values, and AVERAGE() computes the mean. Note: In older Excel versions, press Ctrl+Shift+Enter to run this as an array formula; modern Excel accepts it with just Enter.

For custom step sizes (e.g., step = 2: 10,12,14,...,26,27) #

Use the SEQUENCE function to generate the sequence first, then average it:

=AVERAGE(SEQUENCE(ROUNDUP((27-10)/2,0),,10,2))

• Breakdown:
  • (27-10)/2 calculates how many steps are needed; ROUNDUP() ensures we include the final value even if it doesn’t land exactly on the step.
  • The SEQUENCE parameters are: number of values, number of columns (default 1), start value, step size.
  • AVERAGE() then computes the mean of the generated sequence.

内容的提问来源于stack exchange，提问作者Ryan Jacques