Task 2
Analyze Data in a Spreadsheet
In this task, you will analyze the data in the workshee...
![Computers and Technology](/tpl/images/cats/informatica.png)
Computers and Technology, 16.12.2020 18:50, franstirlacci
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.
![answer](/tpl/images/cats/otvet.png)
Answers: 2
Other questions on the subject: Computers and Technology
![image](/tpl/images/cats/informatica.png)
![image](/tpl/images/cats/informatica.png)
![image](/tpl/images/cats/informatica.png)
Computers and Technology, 23.06.2019 19:30, wilkinsonei4069
Anul 2017 tocmai s-a încheiat, suntem trişti deoarece era număr prim, însă avem şi o veste bună, anul 2018 este produs de două numere prime, 2 şi 1009. dorel, un adevărat colecţionar de numere prime, şi-a pus întrebarea: “câte numere dintr-un interval [a, b] se pot scrie ca produs de două numere prime? “.
Answers: 1
![image](/tpl/images/cats/informatica.png)
Computers and Technology, 24.06.2019 01:00, cheycheybabygirl01
How can the temperature of a room be raised by 5degreesf?
Answers: 1
Do you know the correct answer?
Questions in other subjects:
![Konu](/tpl/images/cats/biologiya.png)
Biology, 08.03.2021 19:40
![Konu](/tpl/images/cats/mat.png)
![Konu](/tpl/images/cats/en.png)
English, 08.03.2021 19:40
![Konu](/tpl/images/cats/mat.png)
![Konu](/tpl/images/cats/ekonomika.png)
![Konu](/tpl/images/cats/mat.png)
![Konu](/tpl/images/cats/geografiya.png)
Geography, 08.03.2021 19:40
![Konu](/tpl/images/cats/ekonomika.png)
![Konu](/tpl/images/cats/mat.png)
Mathematics, 08.03.2021 19:40