“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

What are the mean and median Next 12 Months PE Ratios of the group?
Expert_777

Solved by A. S. in 28 mins

Worksheet Q30-31
What are the mean and median Next 12 Months PE Ratios of the group?

Solved by E. D. in 14 mins

Which of the following will calculate the mean value of a series of numbers stored between the cells A5 to A20 inclusive? Tick all that apply
=average($a$5:a20)
=AVERAGE(A1:A20)-AVERAGE(A1:A4)
=MEAN(A5:A20)
=AVERAGE(A5:A20)
=AVERAGE(A8:A20,A5,A6)
=SUM(A5:A20)/COUNT(A5:A20)

Solved by X. C. in 29 mins

Hi there
I am trying to combine 4 different matrix into one bigger matrix. We use them as rosters and want an all encompassing roster with all store and staff in the one.
Can I send you what I have so you can see what I mean? We just want it to pre populate across or be copied and correlated into the 5th table - we will be using the other tables to visually roster but sending out the combined table to staff and don't want to have to double handle the work.

Solved by T. Q. in 26 mins

Hello,
I was wondering if it were possible to do calculations with the following format:
yyyy-mm-dd hh:mm:ss.sss
what I have to do is calculate the mean time between several timestamps. This is usually a matter of seconds.

Solved by I. L. in 15 mins

An automatic machine in a manufacturing process is operating properly if the lengths of an important subcomponent are normally distributed, with mean μ = 115 cm and standard deviation σ = 5.7 cm.

Solved by C. A. in 12 mins

Hi when I try and refresh my data input i receive a message saying Pivot Table field name is not valid when I try and change the data source it won't accept the whole range only 5 lines of it not 700! I am sorry I am not sure what you mean by the file?

Solved by A. C. in 24 mins

I have rows for hundreds of individuals with several columns of factors. Some patients may have two rows of data whereas others may have ten rows for each factor. How to find the average calculation formula for each individual without having to manually do a calculation for each individual

Solved by A. U. in 16 mins

Making a spreadsheet for statistics. Collumns include X (data entries), mean, Xi - mean, Variance, etc.
Problem is that collumns like Xi - mean are making values in cells that should have no value, because no value was entered in the same row in the data entry collumn. It's basically assuming I want a zero there, when I haven't even entered a value. Which in turn is messing up collumns like variance, when I don't use all rows of the data entry. (I made it go to 30 for flexibility of different questions).
I am struggling to make it fluent so that, say in a question I only need to enter 12 data points, and the remaining 18 cells I made for flexibility don't have zero values in them when I haven't even entered anything in them.
In my document attached I have given an example of 3 data points. Collumns like variance are taking data from the other 27 data points when I haven't entered anything in them!
Also, when nothing is entered I am getting #DIV/0! which is another pointless annoyance!
Thank you for reading!

Solved by A. J. in 28 mins

I have some data in the first sheet and i need the out put to be arranged accordingly in the second sheet . I mean the data is clubbed data, i need the output in the second sheet as getting separated accordingly.

Solved by F. A. in 17 mins