Task 2 Analyze Data in a Spreadsheet
In this task, you will analyze the data in the worksheet you created in Task 1.
Open the worksheet. Look at the data for a few minutes and determine how you can analyze the data in a meaningful way.

Use at least three of these math functions in your spreadsheet program to analyze the data: SUM, AVERAGE, MAX, MIN, COUNT.

For example, suppose the data is the time you spent, in minutes, on each exercise session for the past month. You have your worksheet data for each day of the month, split into four weeks. Your exercise days will contain data in the respective rows along the data column, and the other rows in the data column will be blank.

These are some ways you could analyze the data using math functions in your spreadsheet program.

Use the SUM function to find your total exercise time for the month.
Use the AVERAGE function to find your average exercise time per session for the month.
Use the MAX function to find out on which day of the month you had your longest exercise session.
Use the MIN function to find out on which day of the month you had your shortest exercise session.
Use the COUNT function to find the number of exercise sessions you completed for the month.
Once you’re done, save your worksheet using an appropriate file name that contains the words “Data Analysis Task.” Submit the file through the Drop Box to your teacher for grading.
In the table below,

note down the math functions you used,
specify the cells that contain each function, and
explain the purpose and result of applying each function in the context of the data set.