EXCEL Proficiency

EXCEL Proficiency Check Assignment -- First Day attend Instructions: Download the file. Save it on your course directory (create an EXCEL files sub Problem 1 Condsider the following data set. 23 27 Calculate average of the data= 29 Calculate standard deviation= 25 Calculate median of the data = 20 Find maximum value= 30 Find minimum value= 45 Find sum of the squares of each data= Problem 2 Consider the following data set Y X 3.3 105 346.5 3.2 115 368 3.4 94 319.6 Find the value of the sum of the product of ea 3 93 279 2.8 78 218.4 Find the sum of the squares of each value of X 2.9 79 229.1 Find the sum of the squares of each value of Y 2.7 67 180.9 2.6 62 161.2 Plot a scatter plot of X vs. Y here -----> 2.5 57 142.5 2.6 45 117 Draw a straight line on the scatter plot 2.2 55 121 that approximates the nature of the dat 2 36 72 2.3 30 69 2.1 19 39.9 Problem 3 Copy the above X and Y data below. Sort X from low to high and Y from high to Y X 3.4 115 3.3 105 3.2 94 3 93 2.9 79 2.8 78 2.7 67 2.6 62 Answer the questions below. Save the completed file and upload via assignmen

2.6 57 2.5 55 2.3 45 2.2 36 2.1 30 2 19 Problem 4 Matrix 1 -12 8 5 0 -2 15 Find Matrix 3= Matrix1 X Matrix2 Write the matrix here 19 44 -15 -14 Find inverse of Matrix 3: -0.03553299 -0.1116751269 0.038071066 0.0482233503 Problem 5 write the column with header "New" where each number is the product of the (the first number will be 3.3*105, next 3.3*115) Y X New 3.3 105 346.5 3.2 115 368 3.4 94 319.6 3 93 279 2.8 78 218.4 2.9 79 229.1 2.7 67 180.9 2.6 62 161.2 2.5 57 142.5 2.6 45 117 2.2 55 121 2 36 72 2.3 30 69 2.1 19 39.9

Matrix 2 -2 1 0 7 -1 0 e first value of Y (3.3) and the respective values of X Write the numbers by creating the first one and then clicking and dragging

3.2 3.4 3.6