Statistical analysis of experimental results

[Brook23]

Hello,

I performed mechanical testing of composite panels and have the results with me.

What parameters/criterion establish the correctness,reliability(for application in extracting relevant properties) and credibility of the experimental results for use in actual calculations ?

Do mean,standard deviation & Coefficient of variation suffice to establish the above premise?

[FDibbins]

HI, welcome to the forum

This is not really an excel question, it relates more to statistical analysis, I suggest that you google statistical analysis

[MrShorty]

I would suggest that your question is less of an Excel question and more of a statistics question. I'm not sure if we have anyone here on this forum who is enough of a statistician to provide a complete answer.

Mean and standard deviation are kind of the "standard" measures of central tendency and variability, and they form the basis of much of descriptive statistics and hypothesis testing. By themselves, they are probably not sufficient, but they will likely be a significant part of establishing your premises.

I would argue that the answers to the generic questions you have asked constitute a significant portion of an intro to stats course. Since I dont' want to recreate a stats course here in this thread, I would suggest that you visit some "intro to statistics" type texts and sites. This one http://www.real-statistics.com/descriptive-statistics/ is interesting because he specifically explains statistical analyses in Excel.
This one http://stattrek.com/tutorials/ap-sta...-tutorial.aspx is geared towards US high school/secondary school students.

[Brook23]

Okie..

The method requires me to determine the degree of linearity in the force-deflection results and for that a method is outlined.i.e..to find the maximum offset from the force-deflection curve..

how to perform this in Excel 2007,given the force-deflection data points...?

screen shot of the method is attached...determination of non-linearity offset.png

[Brook23]

thank you Mrshorty for your kind guidance...

[MrShorty]

I can't determine just from the image all of the details that go into the specified method.

I would guess that the first step will be some kind of linear regression step. In Excel, the best starting place (after you understand the basic concepts of linear regression) is to become familiar with the LINEST() function https://support.office.com/en-us/art...rs=en-US&ad=US

Once you have the desired linear regression calculated, then it looks like you need to compute "displacement", "linearized displacement", and "toe correction" quantities (it is not clear to me what these values represent or how they should be calculated). Once you have these quantities, the "% offset" should be fairly straightforward to calculate.