{"id":517,"date":"2024-04-09T01:17:29","date_gmt":"2024-04-09T05:17:29","guid":{"rendered":"https:\/\/pressbooks.bccampus.ca\/1130sandbox\/?post_type=chapter&p=517"},"modified":"2024-04-09T01:50:36","modified_gmt":"2024-04-09T05:50:36","slug":"excel-formulas","status":"publish","type":"chapter","link":"https:\/\/pressbooks.bccampus.ca\/1130sandbox\/chapter\/excel-formulas\/","title":{"raw":"Excel Formulas","rendered":"Excel Formulas"},"content":{"raw":"
\r\n

<\/code><\/strong><\/p>\r\n\r\n

Excel<\/strong> Commands<\/strong><\/h2>\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

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

\r\n

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

\r\n

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

\r\n

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

\r\n

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

\r\n

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

\r\n

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

\r\n

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

\r\n

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

\r\n

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

\r\n

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

\r\n

Answer (with Notes)<\/strong><\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

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

\r\n

$20,000<\/p>\r\n<\/td>\r\n

\r\n

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

\r\n

=MAX(A2:A8)-MIN(A2:A8)<\/p>\r\n<\/td>\r\n

\r\n

$25,000<\/p>\r\n<\/td>\r\n

\r\n

Finds the range<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

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

\r\n

$25,000<\/p>\r\n<\/td>\r\n

\r\n

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

\r\n

=STDEV.P(A2:A8)<\/p>\r\n<\/td>\r\n

\r\n

$8,539.13<\/p>\r\n<\/td>\r\n

\r\n

Finds the population standard deviation<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

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

\r\n

$30,000<\/p>\r\n<\/td>\r\n

\r\n

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

\r\n

=STDEV.S(A2:A8)<\/p>\r\n<\/td>\r\n

\r\n

$9,354.14<\/p>\r\n<\/td>\r\n

\r\n

Finds the sample standard deviation<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

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

\r\n

$35,000<\/p>\r\n<\/td>\r\n

\r\n

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

\r\n

=VAR.P(A2:A8)<\/p>\r\n<\/td>\r\n

\r\n

72,916,667<\/p>\r\n<\/td>\r\n

\r\n

Finds the population variance<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

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

\r\n

$40,000<\/p>\r\n<\/td>\r\n

\r\n

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

\r\n

=VAR.S(A2:A8)<\/p>\r\n<\/td>\r\n

\r\n

87,500,000<\/p>\r\n<\/td>\r\n

\r\n

Finds the sample variance<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

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

\r\n

$45,000<\/p>\r\n<\/td>\r\n

\r\n

Coefficient of Variation (Population)<\/p>\r\n<\/td>\r\n

\r\n

=VAR.P(A2:A8) \/AVERAGE(A2:A8)<\/p>\r\n<\/td>\r\n

\r\n

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

\r\n

Finds the population coefficient of variation<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

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

\r\n

\u00a0 $50,000<\/p>\r\n<\/td>\r\n

\r\n

Coefficient of Variation (Sample)<\/p>\r\n<\/td>\r\n

\r\n

=VAR.S(A2:A8) \/AVERAGE(A2:A8)<\/p>\r\n<\/td>\r\n

\r\n

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

\r\n

Finds the sample coefficient of variation<\/p>\r\n<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\nClick here to download the Excel spreadsheet shown in the above table<\/a>\r\n\r\n<\/div>\r\n

Computing<\/strong>\u00a0Coefficient of Variation<\/span><\/h2>\r\n