Get instant live Excel expert help with AVERAGE Function

Context: Reading and Spelling age score sheet (eg. a student takes a test and it tells them what their 'reading age' is- 14.03 would be 14 years and 3 months). Ideal Outcome: Need to calculate progress for each student + average progress for each year group. Issue: Formula to convert years and months (eg. 15 years and 4 months 15.04) to months (eg 184 months) works in columns J and K (converting columns C and D) but does not work in columns N and O (converting columns F and G) - ie N2 should be 12.7 in months, which would be 12 x 12 + 7, which would be 151, but formula says 214?

Using the Data on the RAW DATA tab, please illustrate to an audience the following: A) The relationship between CALLS ANSWERED, CALLS HANDLED, and AVERAGE HANDLE TIME B) The relationships between AVERAGE TALK TIME and % AUX TIME C) Create a template that allows the user to enter in LOGIN IDs only to populate the agent's names and the 5 data points above in (A) and (B) and anything else you believe is pertinent.

Hi, I want to to create an excel file with a number of sheets for tracking the attendance and activities of my students, every sheet for one month. In every sheet, I get the average of my students marks in that month in a column. Now I want to get the average of the averages in another sheet, however, it doesn't show the average. I would really appreciate if you could help me! Thanks

How do I set my "Sum" function and disable "Average" of numbers in a column??

Excel keeps switching to Average rather than Sum in my column of numbers

Column A shows the number of times a particular article was shared online Column B shows the number of words that the article had. The question is - Were pieces over 1,000 words (num_words) shared more, on average (total_shares)?

COLUMN A shows number of times an article has been shared on social media COLUMN B shows the number of words in the article The question - Were pieces over 1,000 words (num_words) shared more, on average (total_shares)? How do I use excel averageif function in answering this

average of list of numbers that are in the sheet

I'm dealing with an advanced excel pivot table problem. Please help me assign the following structure to the pivot table: The rows should have the first level of the variable referred to if the student belongs to a rural area or an urban area and as a second level if a family of more than 3 people belongs or not. The first column should answer if it is more common for a student to belong to a house with more than 3 inhabitants in a rural area compared to an urban area (As an example, it should show that 72.27% of students from urban areas belong to households with more than 3 inhabitants). The second column must show if the students' final grade (variable G3) is the same for households with more or less than 3 inhabitants, disaggregated by rural and urban area (As an example, it must show that the final average of the students who come from home with 3 or less students and who live in urban areas is 10.90).

Hi there, I am looking for help with a formula. Unfortunately I cannot share much of the document so I have deleted some of the values. I have left one column that I am using for the sake of example because I realize that the formula I use will be the same for each row of the table I want to fill in. There are two tables on this sheet. My goal is to fill in the top one using the values from the bottom one (considering that it will be filled in). I want to use the average function to calculate the average quarterly revenue. Thus far, I have done this by using this formula as an example: =AVERAGE(H92:H94)-AVERAGE(H80:H82) This formula takes the average of one quarter and finds the difference from the same quarter a year previously. I do not know how to extend this across columns, so I have had to input each value manually in each column. Can you please provide assistance?