20190825203911excel_assignment_.xlsx - Problem 1 Problem 2 Problem 3 Condsider the following data set 23 27 Calculate average of the data= 29 Calculate

# 20190825203911excel_assignment_.xlsx - Problem 1 Problem 2...

This preview shows page 1 - 3 out of 8 pages.

Problem 1 Condsider the following data set. 23 27 Calculate average of the data= 28.428571429 29 Calculate standard deviation= 8.0799575671 25 Calculate median of the data = 27 20 Find maximum value= 45 30 Find minimum value= 20 45 Find sum of the squares of each data= 6049 Problem 2 Consider the following data set Y X 3.3 105 3.2 115 3.4 94 Find the value of the sum of the product of each pair of nu 3 93 2.8 78 2.9 79 2.7 67 2.6 62 Plot a scatter plot of X vs. Y here -----> 2.5 57 2.6 45 Draw a straight line on the scatter plot 2.2 55 that approximates the nature of the data 2 36 2.3 30 2.1 19 Problem 3 Copy the above X and Y data below. Sort X from low to high and Y from high to low. Find the sum of the squares of each value of X= Find the square of the sum of the values of Y=
Problem 4 Matrix 1 Matrix 2 1 2 5 3 4 A= 2 3 B= 8 9 4 5 7 Find C = A x B Write the matrix here C= Find inverse of Matrix C: Find determinant of Matrix C: Problem 5 write the column with header "New" where each number is the product of the first value of (the first number will be 3.3*105, next 3.3*115) Write the numb Y X

#### You've reached the end of your free preview.

Want to read all 8 pages?

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern