Cross-tabulate posted order means
Enter one formula in G5. Use only Posted rows. Sort regions and channels ascending. Return an empty-text corner, channel headings, one mean-units row per region, a final Total column and a final Total row. Calculate each intersection and each total from its own original posted observations. A missing region/channel combination is empty text; a posted zero is numeric zero. If no row is Posted, return No posted records.
The answer cells begin blank. Enter a reusable formula and check it against the published practice datasets. Hints and the solution are available when you choose them.
Practice stays on this device. No worksheet data is uploaded.
A checkpoint records a fresh check of every dataset. This attempt tracks built-in hints, solutions, steps and worked examples; it does not establish independent authorship.
Help recorded: none of these built-in aids opened.
Make the formula your own.
View task requirements
Enter one formula in G5. Use only Posted rows. Sort regions and channels ascending. Return an empty-text corner, channel headings, one mean-units row per region, a final Total column and a final Total row. Calculate each intersection and each total from its own original posted observations. A missing region/channel combination is empty text; a posted zero is numeric zero. If no row is Posted, return No posted records.
No account. No upload. Just try it.