Task 1 of 6
In F1, calculate the standard deviation of sales.
Lesson theory
An ice cream stand on the beach boardwalk analyzes its summer: how sales depend on the heat, whether a new freezer will pay off, and what price per serving brings in the profit it needs.
Tip: in NPV, the year-0 investment isn't discounted. Add it to the result separately: =NPV(rate, years 1…n)+year 0.
Practice is part of Pro
The live spreadsheet, task checking and .xlsx files in all 170 lessons. Your progress is saved in this browser; sync across devices is coming soon.