{"id":131,"date":"2023-05-05T12:48:46","date_gmt":"2023-05-05T16:48:46","guid":{"rendered":"https:\/\/pressbooks.bccampus.ca\/businessanalytics\/chapter\/descriptive-statistics-in-excel\/"},"modified":"2024-01-12T18:18:54","modified_gmt":"2024-01-12T23:18:54","slug":"descriptive-statistics-in-excel","status":"publish","type":"chapter","link":"https:\/\/pressbooks.bccampus.ca\/businessanalytics\/chapter\/descriptive-statistics-in-excel\/","title":{"raw":"Descriptive Statistics in Excel","rendered":"Descriptive Statistics in Excel"},"content":{"raw":"Below is a list of some of the formulae that makes Excel a good start to analysis.\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
\r\n

Name<\/strong><\/p>\r\n<\/td>\r\n

\r\n

Symbol<\/strong><\/p>\r\n<\/td>\r\n

\r\n

Command<\/strong><\/p>\r\n<\/td>\r\n

\r\n

Notes<\/strong><\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

Mean<\/p>\r\n<\/td>\r\n

\r\n

\u03bc or x\u0305<\/em><\/p>\r\n<\/td>\r\n

\r\n

=AVERAGE(B2:B5)<\/p>\r\n<\/td>\r\n

\r\n

<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

Median<\/p>\r\n<\/td>\r\n

\r\n

x\u0303<\/em><\/p>\r\n<\/td>\r\n

\r\n

=MEDIAN(B2:B5)<\/p>\r\n<\/td>\r\n

\r\n

<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

Mode<\/p>\r\n<\/td>\r\n

\r\n

M<\/em><\/p>\r\n<\/td>\r\n

\r\n

=MODE(B2:B5)<\/p>\r\n<\/td>\r\n

\r\n

Only returns one value!<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

Standard Deviation<\/p>\r\n<\/td>\r\n

\r\n

s<\/em><\/p>\r\n<\/td>\r\n

\r\n

=STDEV.S(B2:B5)<\/p>\r\n<\/td>\r\n

\r\n

Sample only<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

Standard Deviation<\/p>\r\n<\/td>\r\n

\r\n

\u03c3<\/em><\/p>\r\n<\/td>\r\n

\r\n

=STDEV.P(B2:B5)<\/p>\r\n<\/td>\r\n

\r\n

Population, we rarely use this<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

Range<\/p>\r\n<\/td>\r\n

\r\n

R<\/em><\/p>\r\n<\/td>\r\n

\r\n

=MAX(B2:B5) \u2013 MIN(B2:B5)<\/p>\r\n<\/td>\r\n

\r\n

<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

Maximum<\/p>\r\n<\/td>\r\n

\r\n

<\/p>\r\n<\/td>\r\n

\r\n

=MAX(B2:B5)<\/p>\r\n<\/td>\r\n

\r\n

<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

Minimum<\/p>\r\n<\/td>\r\n

\r\n

<\/p>\r\n<\/td>\r\n

\r\n

=MIN(B2:B5)<\/p>\r\n<\/td>\r\n

\r\n

<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

Count<\/p>\r\n<\/td>\r\n

\r\n

N or n<\/em><\/p>\r\n<\/td>\r\n

\r\n

=COUNT(B2:B5)<\/p>\r\n<\/td>\r\n

\r\n

<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

Sample Skew<\/p>\r\n<\/td>\r\n

\r\n

<\/p>\r\n<\/td>\r\n

\r\n

=SKEW(B2:B5)<\/p>\r\n<\/td>\r\n

\r\n

Population: SKEW.P()<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

Kurtosis<\/p>\r\n<\/td>\r\n

\r\n

<\/p>\r\n<\/td>\r\n

\r\n

=KURT(B2:B5)<\/p>\r\n<\/td>\r\n

\r\n

<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

Percentile<\/p>\r\n<\/td>\r\n

\r\n

Pn<\/span><\/p>\r\n<\/td>\r\n

\r\n

=PERCENTILE(B2:B5, 0.36)<\/p>\r\n<\/td>\r\n

\r\n

For<\/p>\r\n\r\n

P36<\/span><\/div><\/td>\r\n<\/tr>\r\n
\r\n

Quartile<\/p>\r\n<\/td>\r\n

\r\n

Qn<\/span><\/p>\r\n<\/td>\r\n

\r\n

=QUARTILE(B2:B5, 3)<\/p>\r\n<\/td>\r\n

\r\n

For<\/p>\r\n\r\n

Q3<\/span><\/div><\/td>\r\n<\/tr>\r\n
\r\n

Correlation<\/p>\r\n<\/td>\r\n

\r\n

r<\/em><\/p>\r\n<\/td>\r\n

\r\n

=CORREL(B2:B5,C2:C5)<\/p>\r\n<\/td>\r\n

\r\n

Or PEARSON()<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

Covariance<\/p>\r\n<\/td>\r\n

\r\n

cov<\/em>(X,Y)<\/em><\/p>\r\n<\/td>\r\n

\r\n

=COVARIANCE.S(B2:B5,C2:C5)<\/p>\r\n<\/td>\r\n

\r\n

Sample data!<\/p>\r\n<\/td>\r\n<\/tr>\r\n

<\/td>\r\n<\/td>\r\n<\/td>\r\n<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<\/div>","rendered":"

Below is a list of some of the formulae that makes Excel a good start to analysis.<\/p>\n

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\n

Name<\/strong><\/p>\n<\/td>\n

\n

Symbol<\/strong><\/p>\n<\/td>\n

\n

Command<\/strong><\/p>\n<\/td>\n

\n

Notes<\/strong><\/p>\n<\/td>\n<\/tr>\n

\n

Mean<\/p>\n<\/td>\n

\n

\u03bc or x\u0305<\/em><\/p>\n<\/td>\n

\n

=AVERAGE(B2:B5)<\/p>\n<\/td>\n

\n

\n<\/td>\n<\/tr>\n

\n

Median<\/p>\n<\/td>\n

\n

x\u0303<\/em><\/p>\n<\/td>\n

\n

=MEDIAN(B2:B5)<\/p>\n<\/td>\n

\n

\n<\/td>\n<\/tr>\n

\n

Mode<\/p>\n<\/td>\n

\n

M<\/em><\/p>\n<\/td>\n

\n

=MODE(B2:B5)<\/p>\n<\/td>\n

\n

Only returns one value!<\/p>\n<\/td>\n<\/tr>\n

\n

Standard Deviation<\/p>\n<\/td>\n

\n

s<\/em><\/p>\n<\/td>\n

\n

=STDEV.S(B2:B5)<\/p>\n<\/td>\n

\n

Sample only<\/p>\n<\/td>\n<\/tr>\n

\n

Standard Deviation<\/p>\n<\/td>\n

\n

\u03c3<\/em><\/p>\n<\/td>\n

\n

=STDEV.P(B2:B5)<\/p>\n<\/td>\n

\n

Population, we rarely use this<\/p>\n<\/td>\n<\/tr>\n

\n

Range<\/p>\n<\/td>\n

\n

R<\/em><\/p>\n<\/td>\n

\n

=MAX(B2:B5) \u2013 MIN(B2:B5)<\/p>\n<\/td>\n

\n

\n<\/td>\n<\/tr>\n

\n

Maximum<\/p>\n<\/td>\n

\n

\n<\/td>\n

\n

=MAX(B2:B5)<\/p>\n<\/td>\n

\n

\n<\/td>\n<\/tr>\n

\n

Minimum<\/p>\n<\/td>\n

\n

\n<\/td>\n

\n

=MIN(B2:B5)<\/p>\n<\/td>\n

\n

\n<\/td>\n<\/tr>\n

\n

Count<\/p>\n<\/td>\n

\n

N or n<\/em><\/p>\n<\/td>\n

\n

=COUNT(B2:B5)<\/p>\n<\/td>\n

\n

\n<\/td>\n<\/tr>\n

\n

Sample Skew<\/p>\n<\/td>\n

\n

\n<\/td>\n

\n

=SKEW(B2:B5)<\/p>\n<\/td>\n

\n

Population: SKEW.P()<\/p>\n<\/td>\n<\/tr>\n

\n

Kurtosis<\/p>\n<\/td>\n

\n

\n<\/td>\n

\n

=KURT(B2:B5)<\/p>\n<\/td>\n

\n

\n<\/td>\n<\/tr>\n

\n

Percentile<\/p>\n<\/td>\n

\n

Pn<\/span><\/p>\n<\/td>\n

\n

=PERCENTILE(B2:B5, 0.36)<\/p>\n<\/td>\n

\n

For<\/p>\n

P36<\/span><\/div>\n<\/td>\n<\/tr>\n
\n

Quartile<\/p>\n<\/td>\n

\n

Qn<\/span><\/p>\n<\/td>\n

\n

=QUARTILE(B2:B5, 3)<\/p>\n<\/td>\n

\n

For<\/p>\n

Q3<\/span><\/div>\n<\/td>\n<\/tr>\n
\n

Correlation<\/p>\n<\/td>\n

\n

r<\/em><\/p>\n<\/td>\n

\n

=CORREL(B2:B5,C2:C5)<\/p>\n<\/td>\n

\n

Or PEARSON()<\/p>\n<\/td>\n<\/tr>\n

\n

Covariance<\/p>\n<\/td>\n

\n

cov<\/em>(X,Y)<\/em><\/p>\n<\/td>\n

\n

=COVARIANCE.S(B2:B5,C2:C5)<\/p>\n<\/td>\n

\n

Sample data!<\/p>\n<\/td>\n<\/tr>\n

<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n","protected":false},"author":883,"menu_order":7,"template":"","meta":{"pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-131","chapter","type-chapter","status-publish","hentry"],"part":154,"_links":{"self":[{"href":"https:\/\/pressbooks.bccampus.ca\/businessanalytics\/wp-json\/pressbooks\/v2\/chapters\/131","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pressbooks.bccampus.ca\/businessanalytics\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/pressbooks.bccampus.ca\/businessanalytics\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/pressbooks.bccampus.ca\/businessanalytics\/wp-json\/wp\/v2\/users\/883"}],"version-history":[{"count":2,"href":"https:\/\/pressbooks.bccampus.ca\/businessanalytics\/wp-json\/pressbooks\/v2\/chapters\/131\/revisions"}],"predecessor-version":[{"id":375,"href":"https:\/\/pressbooks.bccampus.ca\/businessanalytics\/wp-json\/pressbooks\/v2\/chapters\/131\/revisions\/375"}],"part":[{"href":"https:\/\/pressbooks.bccampus.ca\/businessanalytics\/wp-json\/pressbooks\/v2\/parts\/154"}],"metadata":[{"href":"https:\/\/pressbooks.bccampus.ca\/businessanalytics\/wp-json\/pressbooks\/v2\/chapters\/131\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/pressbooks.bccampus.ca\/businessanalytics\/wp-json\/wp\/v2\/media?parent=131"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/pressbooks.bccampus.ca\/businessanalytics\/wp-json\/pressbooks\/v2\/chapter-type?post=131"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/pressbooks.bccampus.ca\/businessanalytics\/wp-json\/wp\/v2\/contributor?post=131"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/pressbooks.bccampus.ca\/businessanalytics\/wp-json\/wp\/v2\/license?post=131"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}