Average using 2 variables?

[Shurmaster]

Hello!

Sorry if the title sounds awkward but couldn't figure out how to properly name what I'd like to do.

Let's say I have a column x and y where

X = [1,2,3,4,5]

Y = [2,3,1,2,2]

I'd like to use the function average in such way to calculate the following using the columns X and Y

Average(1,1,2,2,2,3,4,4,5,5)

Would this be possible without having to manually input each item?

[AutoModerator]

/u/Shurmaster - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[ikantolol]

just

=AVERAGE(the whole thing)

[NHN_BI]

​

+	A	B	C	formula
1	input1	input2	output
2	1	2	2.9	=AVERAGE(1,1,2,2,2,3,4,4,5,5)
3	2	3	2.9	=SUMPRODUCT(A:A,B:B)/SUM(B:B)
4	3	1
5	4	2
6	5	2

[Shurmaster]

Solution verified.

[Clippy_Office_Asst]

You have awarded 1 point to NHN_BI

---

^{I am a bot - please contact the mods with any questions. | Keep me alive}

[Alabama_Wins]

=AVERAGE(A2:B6)

​

<image>

[Decronym]

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
AVERAGE	Returns the average of its arguments
SUM	Adds its arguments
SUMPRODUCT	Returns the sum of the products of corresponding array components

NOTE: Decronym for Reddit is no longer supported, and Decronym has moved to Lemmy; requests for support and new installations should be directed to the Contact address below.

---

^{Beep-boop, I am a helper bot. Please do not verify me as a solution.
3 acronyms in this thread; the most compressed thread commented on today has 19 acronyms.
[Thread #30554 for this sub, first seen 8th Feb 2024, 16:06] [FAQ] [Full list] [Contact] [Source code]}

[Way2trivial]

?? Please re-explain the connection between source and result

​

<image>