**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.*