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.

Answers: 2

Show answers

Another question on Computers and Technology

Computers and Technology, 22.06.2019 10:30

What can tanya do now to start preparing for the college and scholarship application process? think about her grades, activities in which she can get involved, possible part-time jobs at which she can work, and standardized tests she can take. (10 points) apex

Answers: 2

Answer

Computers and Technology, 23.06.2019 00:40

Consider the following statements: struct nametype{string first; string last; }; struct coursetype{string name; int callnum; int credits; char grade; }; struct studenttype{nametype name; double gpa; coursetype course; }; studenttype student; studenttype classlist[100]; coursetype course; nametype name; mark the following statements as valid or invalid. if a statement is invalid, explain why.a.) student.course.callnum = "csc230"; b.) cin > > student.name; c.) classlist[0] = name; d.) classlist[1].gpa = 3.45; e.) name = classlist[15].name; f.) student.name = name; g.) cout < < classlist[10] < < endl; h.) for (int j = 0; j < 100; j++)classlist[j].name = name; i.) classlist.course.credits = 3; j.) course = studenttype.course;

Answers: 1

Answer

Computers and Technology, 23.06.2019 20:30

What are some settings you can control when formatting columns?

Answers: 1

Answer

Computers and Technology, 23.06.2019 21:20

For positive constants a and b, the force between two atoms in a molecule is given f(r) = −a r2 + b r3 , where r > 0 is the distance between the atoms. note: a and b are upper case letters. (a) find f '(r) = (b) find the critical point for f(r). r = (c) find f ''(r) = (d) find the value of r so that f ''(r) = 0.

Answers: 1

Answer

You know the right answer?

Task 2 Analyze Data in a Spreadsheet
In this task, you will analyze the data in the workshee...

Questions