Question

give the syntax and example of any 3 statistical functions in excel spreadsheet

Answer 1

Answer:

This chapter gives an overview of some very useful statistical functions in Excel.

Average. To calculate the average of a group of numbers, use the AVERAGE function. ...

Averageif. To average cells based on one criteria, use the AVERAGEIF function. ...

Median. ...

Mode. ...

Standard Deviation. ...

Min. ...