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
please
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
[Uploaded an Excel file]
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
[Uploaded an Excel file]
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
[Uploaded an Excel file]
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
please
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
[Uploaded an Excel file]
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
yes please
User
24/08/2018 - 07:42
stay
User
24/08/2018 - 07:42
ill ask you
User
24/08/2018 - 07:42
about
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
I did not follow what you said about the scatter
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
This would add the trendline
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
how to add Y R2
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
Does this solve your problem?
User
24/08/2018 - 07:53
one question
User
24/08/2018 - 07:53
please
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
adding error bars
User
24/08/2018 - 07:54
?
User
24/08/2018 - 07:54
instead of line
Excelchat Expert
24/08/2018 - 07:55
yes you can add
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.
