Once you understand descriptive statistics and can calculate statistical measures by hand, the ability to use spreadsheet formulas to assist with these calculations saves a lot of time and energy. Those who use statistics in the workforce for decision making, predictions, etc. will tell you that it is very important to understand descriptive statistics and be able to calculate statistical measures by hand, but it is even more important to understand the results and apply them to scenarios.

Case study: You are the owner of "Poptastic". For the past 12 months, to help supplement your family's income, you have sold premium, homemade popsicles from your food truck on the weekends in your hometown of Key West, FL. You want to take a close look at your monthly revenues for the year (rounded to the nearest dollar):

January	February	March	April	May	June	July	August	September	October	November	December
$2,380	$2,850	$3,190	$3,440	$4,220	$4,770	$5,380	$4,730	$3,960	$3,640	$3,350	$2,700

In this project, you will use spreadsheet formulas (via Microsoft Excel or Google Sheets) to find the following for your monthly revenues (watch the Kaltura demo video in our Week 6 Checklist announcement to see how to do these calculations on an example set of data in Excel):

1. Mean
2. Median
3. Mode
4. Range
5. Standard deviation

You will also create the following visuals with your data:

1. Vertical bar graph (please, no horizontal bar graphs)
2. Line graph

Once you understand descriptive statistics and can calculate statistical measures by hand, the ability to use spreadsheet formulas to assist with these calculations saves a lot of time and energy. Those who use statistics in the workforce for decision making, predictions, etc. will tell you that it is very important to understand descriptive statistics and be able to calculate statistical measures by hand, but it is even more important to understand the results and apply them to scenarios.

Case study: You are the owner of "Poptastic". For the past 12 months, to help supplement your family's income, you have sold premium, homemade popsicles from your food truck on the weekends in your hometown of Key West, FL. You want to take a close look at your monthly revenues for the year (rounded to the nearest dollar):

January	February	March	April	May	June	July	August	September	October	November	December
$2,380	$2,850	$3,190	$3,440	$4,220	$4,770	$5,380	$4,730	$3,960	$3,640	$3,350	$2,700

In this project, you will use spreadsheet formulas (via Microsoft Excel or Google Sheets) to find the following for your monthly revenues (watch the Kaltura demo video in our Week 6 Checklist announcement to see how to do these calculations on an example set of data in Excel):

1. Mean
2. Median
3. Mode
4. Range
5. Standard deviation

You will also create the following visuals with your data:

1. Vertical bar graph (please, no horizontal bar graphs)
2. Line graph

Once you understand descriptive statistics and can calculate statistical measures by hand, the ability to use spreadsheet formulas to assist with these calculations saves a lot of time and energy. Those who use statistics in the workforce for decision making, predictions, etc. will tell you that it is very important to understand descriptive statistics and be able to calculate statistical measures by hand, but it is even more important to understand the results and apply them to scenarios.

Case study: You are the owner of "Poptastic". For the past 12 months, to help supplement your family's income, you have sold premium, homemade popsicles from your food truck on the weekends in your hometown of Key West, FL. You want to take a close look at your monthly revenues for the year (rounded to the nearest dollar):

January	February	March	April	May	June	July	August	September	October	November	December
$2,380	$2,850	$3,190	$3,440	$4,220	$4,770	$5,380	$4,730	$3,960	$3,640	$3,350	$2,700

In this project, you will use spreadsheet formulas (via Microsoft Excel or Google Sheets) to find the following for your monthly revenues (watch the Kaltura demo video in our Week 6 Checklist announcement to see how to do these calculations on an example set of data in Excel):

1. Mean
2. Median
3. Mode
4. Range
5. Standard deviation

You will also create the following visuals with your data:

1. Vertical bar graph (please, no horizontal bar graphs)
2. Line graph

Once you understand descriptive statistics and can calculate statistical measures by hand, the ability to use spreadsheet formulas to assist with these calculations saves a lot of time and energy. Those who use statistics in the workforce for decision making, predictions, etc. will tell you that it is very important to understand descriptive statistics and be able to calculate statistical measures by hand, but it is even more important to understand the results and apply them to scenarios.

Case study: You are the owner of "Poptastic". For the past 12 months, to help supplement your family's income, you have sold premium, homemade popsicles from your food truck on the weekends in your hometown of Key West, FL. You want to take a close look at your monthly revenues for the year (rounded to the nearest dollar):

January	February	March	April	May	June	July	August	September	October	November	December
$2,380	$2,850	$3,190	$3,440	$4,220	$4,770	$5,380	$4,730	$3,960	$3,640	$3,350	$2,700

In this project, you will use spreadsheet formulas (via Microsoft Excel or Google Sheets) to find the following for your monthly revenues (watch the Kaltura demo video in our Week 6 Checklist announcement to see how to do these calculations on an example set of data in Excel):

1. Mean
2. Median
3. Mode
4. Range
5. Standard deviation

You will also create the following visuals with your data:

1. Vertical bar graph (please, no horizontal bar graphs)
2. Line graph