# Excel - AVERAGE Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

hiiiiii . please i need to find the mean (average) from my table
Solved by V. C. in 30 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
User 24/08/2018 - 07:28
hiiii
Excelchat Expert 24/08/2018 - 07:28
Hi
User 24/08/2018 - 07:28
User 24/08/2018 - 07:28
need help
Excelchat Expert 24/08/2018 - 07:28
Sure
Excelchat Expert 24/08/2018 - 07:28
Could you share the data?
Excelchat Expert 24/08/2018 - 07:28
For average, you could use formula, =average(c1:c4)
Excelchat Expert 24/08/2018 - 07:29
IF your data is in column C rows 1 to 4
User 24/08/2018 - 07:29
Excelchat Expert 24/08/2018 - 07:29
I inserted the sample formula in cell D4
User 24/08/2018 - 07:29
because its
User 24/08/2018 - 07:29
temperature
User 24/08/2018 - 07:29
and time
User 24/08/2018 - 07:30
yes
User 24/08/2018 - 07:30
i know i did that
User 24/08/2018 - 07:30
but
User 24/08/2018 - 07:30
Excelchat Expert 24/08/2018 - 07:31
I am not clear what is required
Excelchat Expert 24/08/2018 - 07:31
If you don't want average, what is the requirement here?
User 24/08/2018 - 07:32
i wan to find mean
User 24/08/2018 - 07:32
of the time and temp
User 24/08/2018 - 07:32
are u able to see a foldre
User 24/08/2018 - 07:32
?
Excelchat Expert 24/08/2018 - 07:33
what is foldre? DO you mean folder?
User 24/08/2018 - 07:33
oops
User 24/08/2018 - 07:33
yea typing mistakes
User 24/08/2018 - 07:33
sorry
Excelchat Expert 24/08/2018 - 07:33
No problem, I don't see any folder
Excelchat Expert 24/08/2018 - 07:34
I have just the excel you just shared
User 24/08/2018 - 07:34
oops
User 24/08/2018 - 07:34
ok
Excelchat Expert 24/08/2018 - 07:35
In the file, which sheet contains data?
User 24/08/2018 - 07:35
Excelchat Expert 24/08/2018 - 07:35
Is it sheet(0)
User 24/08/2018 - 07:35
this one
User 24/08/2018 - 07:35
no
User 24/08/2018 - 07:35
3
User 24/08/2018 - 07:35
Excelchat Expert 24/08/2018 - 07:36
I am on sheet 3
User 24/08/2018 - 07:36
me too
Excelchat Expert 24/08/2018 - 07:36
Could you be specific what you need to be done here?
User 24/08/2018 - 07:36
find mean?
User 24/08/2018 - 07:37
so my demonstrator
User 24/08/2018 - 07:37
for other tables she use average
Excelchat Expert 24/08/2018 - 07:37
You want to find of column A and B?
User 24/08/2018 - 07:37
yes
Excelchat Expert 24/08/2018 - 07:37
Average and Mean are same in excel
User 24/08/2018 - 07:37
mean for them
User 24/08/2018 - 07:38
ok
User 24/08/2018 - 07:38
but problem
User 24/08/2018 - 07:38
is temp and time
User 24/08/2018 - 07:38
do i still to use same formula
User 24/08/2018 - 07:38
?
User 24/08/2018 - 07:38
average
Excelchat Expert 24/08/2018 - 07:38
Yes
User 24/08/2018 - 07:39
my graph was up and down
User 24/08/2018 - 07:39
lemme try
User 24/08/2018 - 07:39
it again
Excelchat Expert 24/08/2018 - 07:39
Because those are numerical metrics
Excelchat Expert 24/08/2018 - 07:40
Here I implemented the formula
Excelchat Expert 24/08/2018 - 07:40
and highlighted those cells
Excelchat Expert 24/08/2018 - 07:42
Let me know if any modifications are required
User 24/08/2018 - 07:42
ok
User 24/08/2018 - 07:42
User 24/08/2018 - 07:42
stay
User 24/08/2018 - 07:42
User 24/08/2018 - 07:42
User 24/08/2018 - 07:42
graphs
Excelchat Expert 24/08/2018 - 07:42
I am here
User 24/08/2018 - 07:42
ok
Excelchat Expert 24/08/2018 - 07:43
This is a timed session... so i will be here untile the clock runs out
Excelchat Expert 24/08/2018 - 07:43
*until
User 24/08/2018 - 07:44
ok
User 24/08/2018 - 07:44
with
User 24/08/2018 - 07:45
the scatter
User 24/08/2018 - 07:45
graph
User 24/08/2018 - 07:45
am i able to use
User 24/08/2018 - 07:45
a error
User 24/08/2018 - 07:45
bars?
Excelchat Expert 24/08/2018 - 07:45
User 24/08/2018 - 07:45
for the graph
User 24/08/2018 - 07:46
or traind line
Excelchat Expert 24/08/2018 - 07:46
DO you mean that you want bar instead of scatter?
User 24/08/2018 - 07:46
nooo
Excelchat Expert 24/08/2018 - 07:46
Use can use any type of graph
Excelchat Expert 24/08/2018 - 07:46
And have a trend line also
User 24/08/2018 - 07:46
no i have inseart
User 24/08/2018 - 07:47
X AND Y scatter
User 24/08/2018 - 07:47
graph
User 24/08/2018 - 07:47
for my data
Excelchat Expert 24/08/2018 - 07:47
So you already have created scatter plot and wan to add trendline?
User 24/08/2018 - 07:47
but with plots can i use MORE ERROR BARS OPTIONS
User 24/08/2018 - 07:48
YES
Excelchat Expert 24/08/2018 - 07:48
So, right click on the graph
User 24/08/2018 - 07:48
is it ok to add line or bars
User 24/08/2018 - 07:48
which one is useful
Excelchat Expert 24/08/2018 - 07:48
Line would be better
Excelchat Expert 24/08/2018 - 07:49
If will show you the trend with time
User 24/08/2018 - 07:49
oh ok
Excelchat Expert 24/08/2018 - 07:49
So, right click on any one of the data point and then Add trendline
Excelchat Expert 24/08/2018 - 07:49
User 24/08/2018 - 07:51
i did
User 24/08/2018 - 07:51
but wasnt start from 0
User 24/08/2018 - 07:51
is it ok
User 24/08/2018 - 07:51
?
Excelchat Expert 24/08/2018 - 07:51
Yes
Excelchat Expert 24/08/2018 - 07:51
It depends on the data already in the chart
User 24/08/2018 - 07:51
User 24/08/2018 - 07:52
yes exactly
User 24/08/2018 - 07:52
its macbook
Excelchat Expert 24/08/2018 - 07:52
What do you mean?
Excelchat Expert 24/08/2018 - 07:52
Y R2
Excelchat Expert 24/08/2018 - 07:52
I am also on Macbook
Excelchat Expert 24/08/2018 - 07:52
Do you mean you want R2 fro the line?
User 24/08/2018 - 07:52
oh
User 24/08/2018 - 07:52
i get them
User 24/08/2018 - 07:53
thank oyu
Excelchat Expert 24/08/2018 - 07:53
you are welcome
Excelchat Expert 24/08/2018 - 07:53
User 24/08/2018 - 07:53
one question
User 24/08/2018 - 07:53
User 24/08/2018 - 07:53
and im going to leave u
Excelchat Expert 24/08/2018 - 07:53
sure
User 24/08/2018 - 07:54
with the column
User 24/08/2018 - 07:54
graph
User 24/08/2018 - 07:54
is it ok
User 24/08/2018 - 07:54
to use error bars
User 24/08/2018 - 07:54
User 24/08/2018 - 07:54
?
User 24/08/2018 - 07:54
Excelchat Expert 24/08/2018 - 07:55
User 24/08/2018 - 07:55
ok
User 24/08/2018 - 07:55
thank you
User 24/08/2018 - 07:55
so much for ur time
Excelchat Expert 24/08/2018 - 07:55
you are welcome
User 24/08/2018 - 07:55
is it this online always free?
Excelchat Expert 24/08/2018 - 07:55
No
User 24/08/2018 - 07:56
oops
User 24/08/2018 - 07:56
oops
Excelchat Expert 24/08/2018 - 07:56
I think you are charged as per session after the first free session
Excelchat Expert 24/08/2018 - 07:56
Also, please provide feedback after ending the session
User 24/08/2018 - 07:57
cool
User 24/08/2018 - 07:57
thank u
User 24/08/2018 - 07:57
so much
User 24/08/2018 - 07:57
have a great day
Excelchat Expert 24/08/2018 - 07:57
you too
User 24/08/2018 - 07:57
bye
Excelchat Expert 24/08/2018 - 07:57
bye
User 24/08/2018 - 07:57
;)

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.