②? = average (A 1+A2+A3)=2 10? It represents the "sum" re-average of three regions A 1+A2+A3.
Functions are default (programming operations, how to calculate those parameters), and the equal sign is automatically generated. Enter "=" to create a formula, which can be used for simple arithmetic operation or mixed operation with reference to functions. =AVERAGE(A 1+A2+A3) is to find "sum" first, so there is only one parameter to find the average, and the number of data is n, which is the sum. "
③? = average (? A 1，A2，A3)=70？ The three references A 1, A2 and A3 are commas and are joint operators. There are actually three parameters in the column, and n is 3. Merging multiple references into one reference is equivalent to one reference A 1: A3, and n is 3. In the three parameters of Average (a10: a1,A 12: A 13, A 14: A 15), combine them.
= SUM(a 1:A3)/AVERAGE(a 1+A2+A3)= 1
= SUM(a 1:A3)/AVERAGE(a 1，A2，A3)=3
④ = average (a10: a1,A 12:A 13, A 14:A 15)=70.